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