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

Ajax, HTML5, CSS3, Jquery/Ajax, PHP, Google SQL, and the Google App Engine ...

HTML5, CSS3, Jquery/Ajax, PHP, Google SQL, and the Google App Engine as the Project Description: Additionally technical requirements: We need HTML5, CSS3, Jquery/Ajax, PHP, G

I want a web expert for a site, I Want a web expert for a site I have a ...

I Want a web expert for a site I have a website built as well as hosted on VPS need your expert decision to convert that to go daddy's Linux hosting server keeping all the featu

Need help to develop online calculator, Develop Online Calculator I want...

Develop Online Calculator I want someone who sees the big picture with this project. I want an online calculator created that will utilize the inputs from users to determine wha

We are looking for web developer and programmer, We are looking for Web Dev...

We are looking for Web Developer and Programmer Responsibilities- Develop both internal and external website and web-based applications/features a) Generate, maintain and arc

Internet connection, Before we can employ the Internet, we need to gain acc...

Before we can employ the Internet, we need to gain access to it.  This access is attained in one of many ways, which will be discussed in this section. Above all, the Internet is c

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

Geoip2 installation assistance, GeoIP2 installation assistance Can someo...

GeoIP2 installation assistance Can someone help us implement Geoip2 on website? We consume GeoIPlite working as we speak, we at present want to update it. Desired Skills a

Calling deferred code from a script, A function is a deferred script since ...

A function is a deferred script since it does not do anything till a function, an event, a JavaScript link, or an immediate script calls it. You have possibly noticed that you can

We need a website expert for website template, We need a Website expert ...

We need a Website expert We have a website template We want to have an English version and add our own content in English and ftp to a server Desired Skills are MySQL Admi

Colgroup, describes a group of columns in the table and let you to set the ...

describes a group of columns in the table and let you to set the properties of those columns. goes after the tag immediately and bef

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