Authentication: A program named login1.php be called to do the following functions after the Submit button is clicked. 4.1 The customer login and password must be read from the table databasename.Customers. Login and password cannot be hard coded in the program. 4.2 The input login should NOT be case sensitive, but the password should be case sensitive. 4.3 If the login or password is empty, please show corresponding error messages and exit the program and NOT access the database. * If both login and password are not empty, the program should access the table databasename.Customers to verify the login and password. 4.4 If the login does not exist in the database, please display an error message Login XXXX doesnt exist in the database and exit the program. 4.5 If the login exists in the database, but password doesnt match the record in database, please display an error message login xxxx exists, but password not matches. and exit the program.

This is not what it will look like

After "Submit is clicked, it will go to ""login1.php".

This is the code for p1.

Welcome to Austin Huang's CPS3740 project 1. Display all customers

Login ID: Password:

Here is the table in the database

mysql> SELECT * FROM ???????.Customers;

+----+-----------+-------+----------+------------+--------+-----------------+--------+-------+---------+

| id | name | login | password | DOB | gender | street | city | state | zipcode |

+----+-----------+-------+----------+------------+--------+-----------------+--------+-------+---------+

| 1 | New Test | huang | 123 | 1980-03-13 | M | 333 Union St. | Union | NJ | 07083 |

| 2 | Mary Lee | mary | 1234 | 1990-08-13 | F | 300 Central St. | Newark | NJ | 07029 |

| 3 | Tim Smith | tim | 2018 | 1970-12-20 | M | 120 Main Ave. | Edison | NJ | 07731 |

| 4 | Sarah Wu | sarah | 3740 | 1965-02-19 | F | 319 King St. | Union | NJ | 07083 |

+----+-----------+-------+----------+------------+--------+-----------------+--------+-------+---------+

I do not need any CSS or any fancy stuff for the login. I don't need a log out button, I just want the program to work or run when using any of the passwords or using the mysql username and passwords given.

Welcome to Austin Huang's CPS3740 project 1 Display all customers Login ID: huang Password: Submit