Spring 2011
PHP/MySQL Project

Project Type: Individual Project

You are required to create some kind of online survey that users can go to and fill out information that will go into a MySQL database. You will also need to make a page that will retrieve the database information on a web page. You will need to follow the following steps:

Putting Information into the Database (index.php)
1). Using phpMyAdmin at your hosting account, create a new table for this project and create the fields necessary to store the data from your fill-in-form. I’d like you to use more than one column type or “data type” (i.e. varchar, int, tinyint).

2). Create the HTML fill-in-form page, storing it as index.php.

* Find this line: <form name=”form1″ method=”post” action=”">

* Change it to: <form method=”post” action=” intermediate.php “>


3). Create the intermediate.php file to place the information into the database. (Refer to the PHP/MySQL Lesson to remember how to do this).

4). Fill out your form and check to make sure the data made it into the database by logging back into phpMyAdmin.

Please do not do exactly what we did in the lesson in class. Credit is given to those who use different data types or input fields and to those who work on a nicely formatted and aesthetic retrieval page.

Retrieving Information from the Database on a Web Page (retrieval.php)
You’ll need to create a page that retrieves the information from the database and displays it on a web page that you create. Again, refer to the PHP/MySQL Lesson to remember how to do this. Try to make a page that will have some nice formatting, instead of just letting the data get spread across the page haphazardly. Call this retrieval page retrieval.php.

*** You are required to send me the following via email by the due date.
– Three text files as attachments (index.php, intermediate.php and retrieval.php)
– URL of the Survey and Retrieval page.