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
- 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.
©2005 - Bryson R. Payne, Ph.D. - All