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

Need help in cloud software developer, Cloud software developer Skills r...

Cloud software developer Skills required- 1) HTML5 2) CSS3 3) Javascript 4) PHP 5) XML Job Description- We're looking for a Web Developer. Your responsibilit

We are looking for web programmer, We are looking for Web Programmer We ...

We are looking for Web Programmer We are a design as well as marketing firm in need of web support. Fundamentally we will design the look of our clients' websites as well as

I need help for presentation website in progressive design, Presentation we...

Presentation website in progressive design We want a Presentation website in a progressive design with easy CMS. The website will represent a carpenter as well as contain the fo

Need help in website creation, Website creation - similar to seedrs.com cro...

Website creation - similar to seedrs.com crowd funding Looking to receive quotes as well as approximate time frame for the development of a website similar to Seedrs.com. Ope

We are looking for a developer of responsive website, Looking for someone t...

Looking for someone to make my blog responsive on all devices Job Description- We are looking for a Web Developer. Your responsibilities- a) Review business requirements

Export a dreamweaver document as xml file, Step 1: Select File -> Open, ...

Step 1: Select File -> Open, Step 2: Choose the document which uses a template (and has editable regions)  Step 3: Click Open Step 4: Select File -> Export -> Exp

We need help in casino site - bitcoin payment, We need help in Casino site ...

We need help in Casino site - Bitcoin payment Need a ready solution to launch a casino site which accepts crypto currencies. I want it urgently and would be interested in hearin

I need a web developer develop a simple corporate responsive, I need a Web ...

I need a Web Developer Start-up company in Tel Aviv is looking for a talented Web Developer to develop a simple (no backend) corporate responsive website of 5 Pages Job descript

We need help for simple php online ordering system, We need help for Simple...

We need help for Simple php online ordering system I need a basic online ordering system for restaurant which is very user friendly, both client side as well as back panel. It m

Differences between include(), Question: (a) What are the differences ...

Question: (a) What are the differences between include(), require() and include_once()? (b) Convert the below if-elseif code to its equivalent switch case version: $day

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