1. Watch the instructional video here that shows how to complete the assignment then complete the steps below.
2. Right-click on this feedback sql table, and save link as feedback.sql it to your desktop.
3. Go to http://student.santarosa.edu/phpmyadmin/ and then upload feedback.sql to your database.
4. Select feedback_spry_start.php from the chapter 9 folder in the examples folder of the textbook files and save it as hw12.php. This contains all the fields you will use to connect to your database table and later on pull into a Master page that will display all the entries made into your form.
5. Modify the feedback form so it submits data to the feedback table you just uploaded to your database. Make sure to copy the code below and paste it into line 2 of your feedback form.
6. <?php
   // if form has been submitted, convert $_POST subarrays to strings
   if (array_key_exists('send', $_POST)) {
   if (isset($_POST['interests'])) {
   $_POST['interests'] = implode(',', $_POST['interests']);
   }
   else {
   $_POST['interests'] = '';
   }
   if (isset($_POST['views'])) {
   $_POST['views'] = implode(',', $_POST['views']);
   }
   else {
   $_POST['views'] = '';
   }
   }
   ?>
7. Create a Master page that collects all the records in the feedback table. Save it as hw12a.php
8. Create a Detail page that filters the records based on the hyperlinked name message_id value passed to it from the master page. Save it as hw12b.php
9. Create an editiable region in your hw12.php page which will allow for the use of InContext Editing Tools.
10. Upload all the necessary pages including the entire ice directory to your website

Contact Us

We welcome feedback from visitors to our site. Please use the following form to let us know what you think about it.