Authenticate the name and password, PHP Web Programming

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

Posted Date: 3/29/2013 6:01:31 AM | Location : United States







Related Discussions:- Authenticate the name and password, Assignment Help, Ask Question on Authenticate the name and password, Get Answer, Expert's Help, Authenticate the name and password Discussions

Write discussion on Authenticate the name and password
Your posts are moderated
Related Questions
These are those where the content of the web page based on user input. Thus interaction with the user is needed in order to display the web page. For instance, consider a web page

Website Designing Want to revamp an existing website Job description- Need to change the look of an existing website therefore that it can have greater hits Web developmen

Shopify Theme Changes I fundamentally have an existing responsive Shopify theme that works fine. Nevertheless I would like to tweak the look (layout) of it. Some things are v

We need a Web Development assignment Update also Refresh Acumed Patches Job description- 1> A full refresh of graphics 2> Better navigation through the pages 3> Comp

You can choose and move a layout table to other areas in a document. However, you cannot move a layout table so that it overlaps another. After that you will move the table you

Google apps engine Content summary function enhancement Project Scope- a) Develop in Google App Engine (GAE) b) Develop with python c) Comply our system design d) Us

Looking for NetFlow Web Application Developer I am seeking a programmer who can write a web-based front end for nfcapd /NFDUMP. I am alert that Nfsen is available (the recommend

GeoIP2 installation assistance Can someone help us implement Geoip2 on website? We consume GeoIPlite working as we speak, we at present want to update it. Desired Skills a

I am looking for a good programmer to work with my graphic design/illustrator on my team to actively blend animation with gameplay and create a fun, simple and easy, 2d iPhone gam

We need a PHP Cron Management Script We have a web application that runs a number of crons for each account. We presently use a service called Webcron to manage these crons howe