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

.curl, Hello, I need help with php, using curl I''m working on a mini proj...

Hello, I need help with php, using curl I''m working on a mini project private social network in my college so i need someone to help me how to use curl to login to remote site,

Explain desirable stylistic points, (a) When designing an interactive web ...

(a) When designing an interactive web site, explain five desirable stylistic points. (b) Discuss the advantages and disadvantages of showing stock levels on a commercial site.

Php script, Use your imagination, but the report should include all the sub...

Use your imagination, but the report should include all the submitted information, except the password, and generated information from the database too. A routine response might b

Design and create a web site, Design and create a Web site on any topic tha...

Design and create a Web site on any topic that is of interest to you.Zip all the files that you use for your Web site and submit the zip file. Your Web site MUST have the

Onload and onunload event handlers, onLoad & onUnload are mainly utilized f...

onLoad & onUnload are mainly utilized for popups that appear while the user enters or leaves the page. Another significant use is in combination along with cookies which should be

Ios developer to update our app and create website, iOS Developer to Update...

iOS Developer to Update our App and Create Responsive Website Note: We don't have an IT person on staff. The company that will undertake this project needs to have the ability t

We are in need of front end web developer and designer, We are in need of F...

We are in need of Front End Web Developer and Designer In search of someone who can convert my PSD files to HTML, HTML5, PHP. Who understands as well as works on websites, la

We are seeking of joomla template conversion, We are seeking of Joomla Temp...

We are seeking of Joomla Template Conversion I need to convert the template into Joomla format. The deliverables here are- a) The ENTIRE template including all the pages w

We need a php developer for website, SanaSana Website Ecommerce website ...

SanaSana Website Ecommerce website using MySQL, Magento, PHP. There is several customization required for themes. Data has by now been procured. Desired Skills are MySQL Admi

We are seeking an experienced web developer, We are seeking an experienced ...

We are seeking an experienced web developer with the following skills- a) Front-end development (HTML5/CSS3) b) Front-end scripting and common libraries (Javascript, JQuery)

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