Modern applications tend to use a combination of technologies to provide the whole solution. This long module is an example of such an application. It's a simple content management system using HTML to format web pages, SQL to hold the content, and PHP to glue the components together. During the course, we won't go through every line of this example, instead, we'll just overview it. When you're writing your own applications after the course, you'll be able to look back at this example and see how we've combined the technologies in a similar application.

This topic is presented on Private Courses and Specially Run Courses only

confirm.php4	Confirm and update to the content, and save it into database
create.sql	File of SQL commands to create an empty database and tables for this example
display.php4	Display a single record from the database in full detail
edit.php4	Offer the content editor a record to edit (or a blank record)
error.txt	Error messages file - allows for translation into other languages
index.php4	Start of application - offer a series of search boxes, and also an editior's login form
offeredit.php4	Validate an editor's login if necessary, and offer a list of records that can be edited
select.php4	List out all records that match the searcher's criteria, in the form of a selection menu
stdfuncs.inc	Standard functions for all pages e.g. open database connection, shopping cart handling
tail.txt	Boiler plate HTML for the foot of every page
top.txt	Boiler plate HTML for the head of every page
user.inc	User definable functions - optional file that may include functions to run on any of the database columns when the content is being reported

Interactive websites through PHP