Lab 6
 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: 

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).

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