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

Bigcommerce entirely responsive design application, BigCommerce entirely re...

BigCommerce entirely responsive design application I am in search of a programmer who can implement my Mockups on my BigCommerce shop. Requirement a) You write clean code wit

Html headers, These are used to indicate the headings of sections or sub-se...

These are used to indicate the headings of sections or sub-sections in document. Based on the desired size of the text, any of six obtainable levels ( to ) of h

Need help interactive weather map using weather data api, Create Interactiv...

Create Interactive Weather Map using Weather Data API Looking for an experienced web developer to create an interactive weather map of the US using the Aeris API. Desired Ski

Want expert help in wordpress plugin development, Want expert help in Wordp...

Want expert help in Wordpress Plugin Development for Easy Digital Downloads We are utilizing a plugin called Easy Digital Downloads to allow clients to choose from selected file

Review business needs and completed designs, SEO skills are of paramount im...

SEO skills are of paramount important and expertise in HTML, CSS, Wordpress are critical. Our designs will be provided, we simply require a team to help code the site and employ th

Finalize migration joomla old to new, Finalize migration Joomla 1.5 to 2.5 ...

Finalize migration Joomla 1.5 to 2.5 I want developer to do migration of couple of component from joomla 1.5 to 2.5. The migration is by now beginning on local server. The

I want adjustment in my wordpress site, I want adjustment in my wordpress s...

I want adjustment in my wordpress site I want to adjust as well as some modifications of my website. I want the job done within short deadline. Desired Skills are MySQL Admin

I need a three page website, I need a three page website I have a homepa...

I need a three page website I have a homepage as well as two internal page designs ready in fireworks. I want these three pages online by the weekend. More work if we discover a

Mail status, i m sending mails from my server via email panel made by me. i...

i m sending mails from my server via email panel made by me. i want to get its delivery status .... how to make it

Want a programmer to help update our website, Need a programmer to help upd...

Need a programmer to help update our website. Long-term work available I have an independent that worked on my website as well as has done a great job up until now. He has lost

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