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

I need help in woocommerce and wordpress extra developemnt, I need help in ...

I need help in woocommerce and wordpress extra developemnt needed on existing website I have an existing website which I want some extra development on. It's a pretty simple cus

We need help to develop a price comparison website, We need help to develop...

We need help to develop a Price Comparison Website I need to start a new website which compares prices of different products among different categories available on different ec

Web based program developed with microsoft sql server, We have a web based ...

We have a web based program developed with Microsoft SQL Server and .NET C#. There are some reports requires to be created. Required Skills are Strong Knowledge in MS SQL Ser

I want help in fantasyhubfund minimum viable product, FantasyHubFund Minimu...

FantasyHubFund Minimum Viable Product We want a developer that can start as soon as humanly possible on a small project build. This project consists of four pages, some pop up m

We need a jr developer, Jr Developer a) I have an Immediate project that...

Jr Developer a) I have an Immediate project that needs to be done right now. I have a few PSDs that want to be converted to HTML / CSS for Email (MailChimp) I am looking for a J

We need help in custom hook for a wordpress plugin, We need help in Custom ...

We need help in Custom Hook for a Wordpress plugin We are in search of someone that can create a custom hook from one plugin into another. The logic is that while a user clic

Need a cake php developer with good skillet, Require to get some Changes do...

Require to get some Changes done on a Cake PHP Website Project Description: Need a Cake PHP Developer with good skillet and decent command over the Framework. The develope

I need help in crowd funding website, Crowd Funding Website We would lik...

Crowd Funding Website We would like to identical a site, with exact features, functionality and details. Let us know if you need more details. Desired Skills are PHP, Web

Xenforo add-on required, Project Description: I am seeking an add-on to ...

Project Description: I am seeking an add-on to be coded for the Xenforo forum software. The add-on would be a post pruning system that will be customized on a per-forum level. I

Client specific url website in php, JC - Client Specific URL Website Ple...

JC - Client Specific URL Website Please respond as follows- 1) Do you FULLY understand the requirements? 2) Are you an EXPERT with Magento? 3) Do you have ANY questions

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