Authenticate the name and password, PHP Web Programming

Assignment Help:

Keep a list of allowed reporters and their passwords in a database table Authentication.  Define and populate the table beforehand manually using the phpMyAdmin interface to MySQL (or a command line interface if you like.) You can assume the reporter name is to be the primary key for the table.  The authentication information should have nothing to do with your UCID or MySQL passwords and name.  The table looks as follows with the appropriate data types for the columns.  The contents are NOT encrypted.

Authentication (for incident reports)

reporter_name

reporter_password

joe456

zebra

james777

checker

The PHP script should test the reporter name and password submitted from the form using a simple PHP or-die construction that queries the database for a matching reporter and password.  An SQL select command can be used but the returned data should not be accessed.  Just look up in the IT202 manual or on the online PHP manual how to tell if a select returned any rows.  If the select is defined appropriately, that will tell you if the reporter name and password were valid.   The password should not be encrypted by the browser, the script or in the database.

Caveat:

PHP:    When testing strings for equality in PHP, do not use = where you should use == (a pair of equal signs).  The PHP symbol = is for assignment statements; it is not used to compare strings; use the == equality operator for string comparison.

SQL:   When testing strings for equality in SQL, use = symbol, not the == used in PHP


Related Discussions:- Authenticate the name and password

I am seeking some software to be written to permit, Venue Bookings Manager ...

Venue Bookings Manager EoI I am seeking some software to be written to permit me to take, and manage bookings for an athletics track. This will be related in to an existing webs

We need a reasonably simple documentation website, We need a reasonably sim...

We need a reasonably simple documentation website The website will be hosted on a Microsoft SharePoint for in-company use only. The determination of this website is to create

Prestashop custom url rewrite, Prestashop Custom URL rewrite- repost I w...

Prestashop Custom URL rewrite- repost I would like somewhat to automatically create custom URLs in my shop for guest wishlists using the wishlist owner's names I presently am us

Database, how to inset image into database

how to inset image into database

Web site project, Throughout the term you will be designing and creating a ...

Throughout the term you will be designing and creating a web site that you will submit during the final week of the course. The weekly assignments will help you develop the skills

I need help in erp/manufacturing website, I need help in ERP/Manufacturing ...

I need help in ERP/Manufacturing Website Seeking an internal-use ERP/Manufacturing Website developed for use at a Paper Mill. Modules/areas would comprising Customers, Sales Ord

Need help for magento vendor portal site, Need help for Magento vendor port...

Need help for Magento vendor portal site (market place) I do like to ask you if you could help to launch the Magento market place site by Unirgy Magento extension. We have set

Packet switching, End systems are linked together through communication lin...

End systems are linked together through communication links. There are several types of communication links that are made of distinct types of physical media, by including fiber op

Need help in developing a child admission form, Child Admission Form Our...

Child Admission Form Our company runs premium athletic clubs and spas. In each facility, there is a large child care facility. In order for our members to utilize this both chil

Make a page with a form which can be submitted on our phpbb, Make a page wi...

Make a page with a form which can be submitted on our Phpbb forum We consists a website with a Phpbb forum on it and we want to have a page created on the forum where people tha

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd