Exercises, examples and other material relating to training module H201. This module is presented on
Private Courses and
Specially Run Courses only
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 ... | 2011-09-23 |
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 ... | 2010-01-31 |
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:
<?php
mysql_connect("localhost","womble","wimbledon");
mysql_query("create database gerald");
mysql_select_db("gerald");
mysql_query("create ... | 2009-03-08 |
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 ... | 2008-03-18 |
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 ... | 2008-02-27 |
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 ... | 2006-06-05 |
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 |
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
[here].
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
Ruby,
Lua,
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 700 books on the subjects on which we teach.
These books are available for reference at our training centre.