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 want wp estore theme experienced developer, WP Estore Theme Experienced D...

WP Estore Theme Experienced Developer Required Keep work on wordpress estore theme website required. Should have previous proven experience with wp estore theme. Probabili

Hosting, How to host php website

How to host php website

Wordpress plugin configuration as well as customizations, Wordpress Plugin ...

Wordpress Plugin Configuration as well as Customizations I want help configuring a plugin correctly (Social Review Engine Plugin) in my Wordpress site. The plugin is previously

We need a website expert for website template, We need a Website expert ...

We need a Website expert We have a website template We want to have an English version and add our own content in English and ftp to a server Desired Skills are MySQL Admi

We need help in google maps page modification required, We need help in Goo...

We need help in Google Maps Page Modification Required I want a modification to a Google Maps Page. When the page returns the location address I need the user to be able to c

What is post and get methods, Which will execute faster POST or GET method?...

Which will execute faster POST or GET method? GET minaly transfer data to the server using URL while POST transfer data using form collection that is added to the request by th

The front end developer drupal 7 with an mssql backend, The front end devel...

The front end developer Drupal 7 with an MSSQL backend to finish prototype We are a social technology start up led by two pioneers in the social technology business in Los Angel

I want a script to extract web data, Script to extract web data I want a...

Script to extract web data I want a script with two functionalities: - Excerpt specific text data from web sites - Find particulars of these data using Google Location ser

I need small cakephp project, I need Small CakePHP project Project Descr...

I need Small CakePHP project Project Description: I have an existing system built on CakePHP which requires some updates and development as well as some bug fixing. It is a u

Looking for a developer to build a ratings or review website, Looking for a...

Looking for a Developer to Build a Ratings/Review Website The impartial is to create a professor/teacher rating website that offers more transparency then what is currently avai

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