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

Magento ecommerce convertion to order and pay later for site, Magento ecomm...

Magento ecommerce convertion to order and pay later for website I have a magento multistore set up with a total of ten websites. All ten websites are configured now as ecommerce

I desire help in wordpress developer, I need help in WordPress Developer ...

I need help in WordPress Developer I am in search of a long term WordPress developer We will begin with a trial project. You have to develop a WordPress theme from scratch.

Protection against suspicious data, Input values embedded in SQL statements...

Input values embedded in SQL statements should be screened for inappropriate characters that can form the basis so-called SQL Injection attacks, a type of security attack that may

Draw layout cells in a table, Now insert layout cells into which you will a...

Now insert layout cells into which you will add text regarding travel locations. 1. In the Objects panel, click on the Draw Layout Cell icon & move the pointer to the layout tab

Set cell properties, Cell height finds out the height of the space in a cel...

Cell height finds out the height of the space in a cell row. Notice the space about the Compass logo. You desire to remove the extra space amongst the logo and navigation buttons.

I want an experienced html and css developer, HTML / CSS Developer for Joom...

HTML / CSS Developer for Joomla Based Site I want an experienced HTML/CSS developer to develop HTML/CSS from PSD designs for a Joomla based site for a mobile focused company.

I need help in phpbb modifications for course type forum, PHPBB modificatio...

PHPBB modifications (course type forum) I desire to make a different view/organization of the viewForum.php for my phpBB site. To support this change certain changes desires

Need web developer/programmer for unique lead gen website, Seeking Web Deve...

Seeking Web Developer/Programmer for unique lead gen website a) Potential customers come to website and post services they need b) Providers make offers to post c) Both cu

Need help in drupal commerce payments and checkout solutions, Drupal commer...

Drupal commerce payments/checkout solutions A current Drupal commerce website using PayPal as the payment method. Want to combine check out by amazon and sagepay which signifies

Looking for a good programmer to work with my graphic design, I am looking ...

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

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