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

Use the radio buttons in web page, Working with Radio Buttons funct...

Working with Radio Buttons function calculate(form) { if(form.elements

Distributed course registration system, Webservice Implementation of the Di...

Webservice Implementation of the Distributed Course Registration System In this assignment, you are going to implement the Distributed Course Registration System (DCRS) from Assig

We need a front end developer for responsive site, We need a Front End Deve...

We need a Front End Developer for responsive site In search of a front end developer to put together a responsive template (using Zurb Foundation or alternative) for a modern, s

Prepare a few custom post types, Looking to prepare a few custom post types...

Looking to prepare a few custom post types, approval processes, user registration types reports/analytics in a custom WordPress application. It's not a rapid job, there's quite

Need help in dashboard application development, Dashboard application We...

Dashboard application We're seeking to create a dashboard tracking application from various feeds job requires bit of research as well as knowledge of API's plus of course super

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.

We are need of an expert drupal developer, We are need of an expert Drupal ...

We are need of an expert Drupal Developer Immediate want for developer to finish getting our site ready for public display, working out some bugs as well as getting our site fun

Develop wiconstellation web site, Project Description: Develop a dynamic...

Project Description: Develop a dynamic corporate WEB site with administration panel, requirement collaboration, product definition, Q&A, user management. Skills required are

I want help in api integration, I want help in API Integration The ecomm...

I want help in API Integration The ecommerce platform we use has an API as layed out and we have some third paries we would like to incorporate starting with invitebox.com. More

E-commerce platform on website app, E-Commerce platform on website App H...

E-Commerce platform on website App Hello creative web developers as well as programmers. I am observing to create a new fashion / website / platform, I want it to be connecte

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