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

Insert text in cells, In Dreamweaver, you may directly type content into a ...

In Dreamweaver, you may directly type content into a layout cell, or you can cut & paste content from another document in a layout cell. In this unit, you will insert text to the l

WEB, 2346 3245654

2346 3245654

Market value targeted to regions or countries, A website that permits you t...

A website that permits you to enter data for a specific product make and model and perform a search on multiple websites, of any kind to generate a report of the different prices,

We are seeking a php web developer, Web Developer - PHP & MySQL We are s...

Web Developer - PHP & MySQL We are seeking a PHP Web Developer who has strong MySQL skills as well as who will be responsible for the design, development and deployment of custo

We need e-paper solution, We need e-paper solution For daily newspaper n...

We need e-paper solution For daily newspaper need an e-paper solutions with archive option on my own server prefer php Desired Skills are PHP, .NET for Web

We need help in google maps page modification required, We need help in Goo...

We need help in Google Maps Page Modification Required I want a modification to a Google Maps Page. When the page returns the location address I need the user to be able to c

Apply color and style on text, You will now apply additional formatting cha...

You will now apply additional formatting changes to the text like changing the color & style to generate heading text. 1. In the primary text description layout cell, choose t

We are seeking an experienced web developer, We are seeking an experienced ...

We are seeking an experienced web developer with the following skills- a) Front-end development (HTML5/CSS3) b) Front-end scripting and common libraries (Javascript, JQuery)

Need help to set ogone payment module for magento shop, Set Ogone payment m...

Set Ogone payment module for magento shop Seeking a magento developer who can set the Payment settings for a Magento store client of us. And likewise fix some other issues fo

Want help in magneto multi-vendor store, Magneto multi-vendor store We a...

Magneto multi-vendor store We are looking for a Magneto multi-vendor store. We need a developer that has already developed the same type of site therefore that we can edit & twe

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