This project involves some basic MySQL database manipulation using PHP.
An HTML page contains a POST form with three text fields, the results of which are sent to [login to view URL]:
oldID
email
newID
[login to view URL] (which is this project) does the following:
if all fields are blank, it outputs “please input something??
if email has data, but the other 2 are blank, it outputs “missing old id??
if (oldID has data AND newID is blank AND field ‘ID’ in any row in ‘table1’ in database ‘myDB’ contains oldID) then output “your key is oldID??
if (email has data AND newID has data AND (field ‘Email’ in any row in ‘table2’ in database ‘myDB’ contains email) AND (field ‘ID’ in any row in ‘table1’ in database ‘myDB’ is equal to 'ID' from the row in 'table2' in which email was found) AND (email is in ‘table4’ (0 OR 1) times)) then output “your key is newID?? AND add email to ‘table4’
in all other cases, output “invalid input??
table1 and table2 already exist. The design of table4 is up to you.
Please post if you have any questions.
## Deliverables
1) Complete and fully-functional working program(s) as well as complete source code of all work done.
2) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased.
## Platform
LAMP