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

Crud application criteria, CRUD application criteria -Use a proper data...

CRUD application criteria -Use a proper data model, this means using Object Oriented PHP if you choose PHP -This model should have around 6-8 properties -The model should

Describe two types of looping statements in php, Question: (a) Describe...

Question: (a) Describe the two methods used to retrieve information from web forms using PHP. (b) Explain two different kinds of arrays that PHP uses. Give an example scri

We need a web developer for equity company, We need a Web Developer for Equ...

We need a Web Developer for Equity Company Gameplan is in search of a developer to join our NYC/NJ-based development team. You will be part of a slight startup development team

Need a wordpress splash page need customization, Need a Wordpress Splash Pa...

Need a Wordpress Splash Page Need Customization Here is what I want the splash page to accomplish- 1. Pop up must only show up on the homepage. 2. You can't click outside

We need help to modify a web page, We need help to Modify a web page We ...

We need help to Modify a web page We need help to Modify a web page to include posting a new category to our menu including add Add heading as well as text to our current web

No frames tag, The tag can be employed for those browsers which are not ab...

The tag can be employed for those browsers which are not able to interpret tags. Even if most, if not all, of your visitors will be capable to see fr

We need to create a localization tool to organise multiple, We need to crea...

We need to create a localization tool to organise multiple planning The web based tool must do the follow Import excel sheet where you have a list of n events with at least t

We need help for back-end of laravel framework, We need help for back-end o...

We need help for back-end of Laravel Framework We have a new website/CMS already built on Laravel framework using PHP & AngularJS. We are in need of a freelance programmer to wo

Need help in shopperpress customization, Shopperpress Customization I ne...

Shopperpress Customization I need somebody who can commit to work with me starting immediately. The site is built however there are a few customizations needed. Like the menu

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