Exercises, examples and other material relating to training module H201. This module is presented on Private Courses
and Specially Run Courses
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.
|Articles and tips on this subject||updated|
|3453||Reading and using emails including enclosures on your web server.|
The imap module ships with PHP, but isn't always built into the server; you need to build PHP with --with-imap if it's not there. But once you do have the module , you can access your POP3 email server direct from PHP.
Very recently, I was asked if I could extract attachments / enclosures from emails ...
|1745||Moodle, Drupal, Django (and Rails)|
In the 1970s, we had C and in that decade and the following one, we put together our systems in that language and its derivatives.
In the 1990s, we had Perl and in that decade and the following one, we put together our systems in that language are related ones.
In the 2010s, we'll have a wide range ...
|2071||Setting up a MySQL database from PHP|
Yes ... training on a Sunday ;-) ... I've been setting up a MySQL database from a PHP script and testing it. A couple of bits of source to share.
1. The setup of the database:
mysql_query("create database gerald");
|1576||Making PHP and MySQL training relevant to the course delegates|
If I'm training on MySQL or PHP, I'll often come up with an example in front of the class - it's much more effective training to see HOW an answer is reached than to simply be presented with a pre-written example. And so it was yesterday that I wrote a small application to extract data from tables ...
|1555||Advanced Python, Perl, PHP and Tcl training courses / classes|
This item is adapted from an answer that I have just written by email - but the question / conundrum as to what to do with fractured advanced training requirements is a common one, so the answer is worth wider sharing. I believe that our solution provides an innovative way of meeting advanced requirements ...
|647||Checking for MySQL errors|
It's worrying when a web site that's been rock solid starts giving intermittent problems - and even more worrying when those intermittent problems just fade away and you're left unsure as to what was the cause of them. I'm afraid I'm the sort who wonders if and when the issue will return.
And so it ...
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 editor'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|
PicturesInteractive websites through PHP
Some modules are available for download
as a sample of our material or under an Open Training Notes License
for free download from [here]
Topics covered in this module
MySQL table of authorised data editors
Administrator and editor login capability.
Second MySQL table of data to be managed.
Select and display system for any site visitors.
Editing system for authorised editors using cookies and carts.
Authorization through passwords, password edit capability.
Ability to edit editor list for the administrator.
If you are looking for a complete course and not just a information on a single subject, visit our Listing and schedule
Well House Consultants specialise in training courses in
. We run
throughout the UK (and beyond for longer courses), and
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 700 books on the subjects on which we teach.
These books are available for reference at our training centre.