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

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

Pre tag, This tag is utilized to present the text precisely as written in t...

This tag is utilized to present the text precisely as written in the code, by including whitespace characters. This is terminated by a tag.  Take the example illustrat

Nested list, 1. Develop a Web page, indicating an ordered list of the names...

1. Develop a Web page, indicating an ordered list of the names of your five friends. 2. Develop an HTML document with a nested list indicating the content page of any book 3.

We need a back-end programmer, We need a back-end programmer My name is ...

We need a back-end programmer My name is David from the Netherlands as well as I am in the middle want of developing a site with HQ drum tutorials with the option do offer it in

Hyper text markup language, As specified earlier, HTML is Hyper Text Markup...

As specified earlier, HTML is Hyper Text Markup Language. HTML provides way of displaying any Web pages along with text & images or multimedia content. HTML is not a programming la

Event handlers, An event handler executes segment of code depend on certain...

An event handler executes segment of code depend on certain events occurring in the application, like onClick or onLoad. JavaScript event handlers can be divided in two parts: non-

Need help to modify phpmelody template, Modify phpmelody template We hav...

Modify phpmelody template We have a video hosting site that uses the phpmelody backend as well as we would like someone with experience in that software to alter the template to

Design and implement a frame-based personal web page, Design and implement ...

Design and implement a frame-based personal Web page. Include everything that you would like to share with your friends. This must include but not limited to: A short biogra

I need a website designing, Website Designing Want to revamp an existing...

Website Designing Want to revamp an existing website Job description- Need to change the look of an existing website therefore that it can have greater hits Web developmen

I want a wordpress developer to done by task, I want a WordPress Developer ...

I want a WordPress Developer to done by task I want a WordPress developer to get my task done. The task is very simple however leads to other tasks. Desired Skills are PHP, W

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