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 need web scrapers written, I Need web scrapers WRITTEN I have five sit...

I Need web scrapers WRITTEN I have five sites (very simple) whose web scrapers I need written ASAP. I am seeking for someone who can start IMMEDIATELY as well as work on this fo

Wordpress developer who can install the flix theme, We are required a Wordp...

We are required a Wordpress developer who can install the Flix theme for Buddypress. The project will include setting up categories, any plug-in that are required, and style the th

Looking for serious php developers, I am required to hire a PHP Programmer ...

I am required to hire a PHP Programmer Looking for serious php developers who are available today. Skills required: MVC, eCommerce, MySQL, PHP, Shopping Carts

Redesign to travel website, Redesign to Travel Website - Design, SEO, Ease ...

Redesign to Travel Website - Design, SEO, Ease of Use Project Description: We are seeking a dedicated programming team to improve a travel website. To provide upgrades to the

Formatting tags, Now let us look at some more tags which can be used to for...

Now let us look at some more tags which can be used to format text. These are all given in the example illustrated in Figure  XYZ&l

Need help to create amazon affiliat store, Amazon Affiliat Store I need ...

Amazon Affiliat Store I need your services to build me an Amazon Affiliate Webstore (for Health as well as Personal Care Products). Script must import inventory from amazon. Int

I need speedometer and tachometer, We need to get working Speedometer and T...

We need to get working Speedometer and Tachometer for a car in latest Cryengine Sandbox. You will find how to make it using existing features of Sandbox, or make your own. Ca

Looking for a facebook app developer to build facebook, Facebook app develo...

Facebook app developer Looking for a Facebook app developer to build Facebook Application but with some additional features and add-ons. The app developer wants experience in

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

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