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 help for website design and development, I need help for Website Des...

I need help for Website Design and Development Required Looking for a talented and experienced designer and developer for a new website. The site is a combination of social netw

Authorization table and authorized address, The number of emails  to a give...

The number of emails  to a given email address is updated each time an email is sent.  A request for a given address should be rejected unless the address is in the Authorization t

I need help in project development, I need help in Project development - Pl...

I need help in Project development - Planning, Design, Development We want a company for 3 tasks 1) brainstorming as well as improving our website plan. (Mainly our income so

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

Move the layout table, You can choose and move a layout table to other area...

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

Want someone who can create wordpress plugin, Wordpress plugin Want some...

Wordpress plugin Want someone who can create (or modify existing) WP plugin to act like Desired Skills are PHP, WordPress

I need help in designing a website, I need help in designing a website I...

I need help in designing a website I want a website for tourism that make people book from my website. I will merely get commission from the website from the adverts the website

Can someone help us implement geoip2 on our website, GeoIP2 installation as...

GeoIP2 installation assistance Can someone help us implement Geoip2 on our website? We have GeoIPlite working as we speak. We now need to update it. Desired Skills are PHP

Duplicate of bitcoin and crypto currency exchange, Duplicate of Bitcoin / C...

Duplicate of Bitcoin / Crypto Currency Exchange Duplicate of popular European Bitcoin crypto currency exchange. Will deliver URL via PMB. Must be control panel driven and set

I want a help in moodle modification, I want a help in Moodle modification ...

I want a help in Moodle modification I need modifications to Moodle to permit for many schools to use the same software, however no school may see each other's teachers or stude

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