PHP and MySQL for Content Management

PHP and MySQL for Content Management - module H201

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

Examples from our training material

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

Pictures

Interactive websites through PHP

Background information

Some modules are available for download as a sample of our material or under an Open Training Notes License for free download from http://www.training-notes.co.uk.

Topics covered in this module

Functional overview.
Planning of the application.
For a regular user.
For data editors.
For the administrator.
Design summary.
A detailed study of the application.
The application as seen by the user.
The Front page "index.php4".
The selection page.
The full record display page.
Files that are only used indirectly.
File stdfuncs.inc.
File top.txt.
File tail.txt.
File create.sql.
The application as seen by an editor.
The application as seen by the administrator.
Source files affecting editors and administrators.
The editor's selection page "offeredit.php4".
The edit page - edit.php4.
The confirm page - confirm.php4.
Extensions.
Conclusion.

Complete learning

If you are looking for a complete course and not just a information on a single subject, visit our Listing and schedule page.

Well House Consultants specialise in training courses in Python, Perl, PHP, and MySQL. We run Private Courses throughout the UK (and beyond for longer courses), and Public Courses at our training centre in Melksham, Wiltshire, England. It's surprisingly cost effective to come on our public courses - even if you live in a different country or continent to us.

We have a technical library of over 600 books on the subjects on which we teach. These books are available for reference at our training centre. Also available is the Opentalk Forum for discussion of technical questions.