Lab 7 - revised
 Using PHP and MySQL

This project will combine what we have learned about accessing and manipulating tables in MySQL with PHP-based interaction, allowing you to produce a PHP-driven interactive Web database.

From Lab 6, you have three tables for a Content Management System (url_titles, urls, and url_types). In class, we will put together part of the CMS site (in a folder called lab7 on your ISCM Web site) - the source code for the parts we perform in class will be given here: [LINKS]

The CMS site should have the following pages/functions:

• Welcome/index page - your name, info about the site, link to "Suggest a site" and "View sites"
• Suggest a site - allows visitors to suggest a url; provides a text box for the URL and Title, along with dynamically generated selection list entries for the type(s) as a Categories option (multiple select list). When the visitor submits the url, the following page should add it to the database (in all three tables).
• View sites - lists all the sites in the database, along with each url's URL, title, and type(s).
• DO NOT DO - moved to next lab. Admin function - PASSWORD PROTECTED - Displays all urls and their types and titles. Has three forms: Verify a url (for unverified sites), Remove a url, and Update a url.

Save the page, upload it to the server, and link to it from your main page.