PHP Project
For this project you will use HTML, forms, PHP, and MySQL to collect data from users, store that data in a MySQL database table, retrieve and display the data from the table, make changes to the data in the table, and delete records from the table. The subject or "theme" of your web site and table will be up to you - a web site with a coherent theme where you collect data from users. I expect the web pages to include some formatting - the details are included below.
You can use other homework assignments, notes, and online resources to help you write your program. Project must be your own and unique (e.g., shouldn't only vary by data names).
Project Outline
Your project will include files and scripts to do the following:
Create Table: Write a PHP script to create a table in your database server to hold your user data.
Data Input :
•Create a nicely formatted (based on formatting topics we've covered so far) web page with a form to collect user data. Include at least one image on the page, a different background color, and a table to structure form elements. The form should use the POST method to send data to a PHP script. You should collect at least 5 pieces of data from the user.
•Write the PHP script called in the previous step to add the data to the data table.
Data Retrieval and Display :
•Modify the Data Input page from above to include only one text box in the form - to input the id of a record the user would like to retrieve.
On submit, the form should call a PHP script to retrieve and display the record.
•Write the PHP script called in the previous step to display the data for that record. Format the data nicely.
Data Edit :
•Create a page and scripts to modify a data record. Use the web page from the Data Retrieval and Display section to first retrieve and display the data. Then include a form with a Submit button (label it Update) that calls a PHP script to update the record from the table.
Data Delete :
•Create a page and scripts to delete a data record. Use the web page from the Data Retrieval and Display section to first retrieve and display the data. Then include a form with a Submit button (label it Delete) that calls a PHP script to delete the record from the table.
Bonus:
•Write a PHP script to retrieve and output ALL the data from the database. See Slide 7 of the PHP - Databases PowerPoint as reference.
Format the data as nicely as possible.
Submit a .zip file containing all of your files for the assignment.