Lab 14: Content Management

Student Learning Objectives

Design and implement using interactive PHP/Web application that uses
- Dynamically create an XHTML Form to get user input
- SQLite database to store and retrieve Web site content
- Server-side PHP scripting to create and display dynamic content based on user input

Assignment

Create a simple database content management system

Create a XHTML page that contains a form that allows a user to choose from a selection of topics.
Create a PHP script that, based on their selection, retrieves the contents of a row from a database and displays the content in a dynamic PHP page

Save your files in folder lab14 on your cs350 u:\htdocs\ folder.
To help with grading, begin your pages with your account number (e.g. in cs35002_nn [h1]) and your own name [h2]

Screen Snapshots

Given as an example only Create your own input form, content, and output display format.

user input output screen snapshot

To Receive Credit

This lab is due at the start of the class on Tuesday
Save your files in folder u:\htdocs\lab14 in your cs350 account.
Print out and staple together two printouts:
- your user input form page as displayed in a browser
- your output PHP page as displayed in a browser
your other files will be checked online

Grading Criteria

Labs will be graded on a scale of 0 to 10:
- 10: Excellent: no problems detected in the code, users may select from at least four items, and the contents are correctly displayed (with formatting) in the output page.
- 9: Very well done: Minor usability problems in the user input form or the output page's contents lack formatting but basic functionality works correctly.
- 8: Well done: either the user input page or the output page has minor problems that affect its functionality.
- 7: Acceptable: both the user input page and the output page have minor problems that affect their functionality.
- 6: Problems: Major problems are present in the pages.
- 5, 4, 3: Incomplete: the lab was attempted but over one-third of the requirements still undone.
- 0: Lab not submitted, no work done. You are allowed to drop your lab lowest score.