Home Accessibility Courses Twitter The Mouth Facebook Resources Site Map About Us Contact
Python, Lua and Tcl - public course schedule [here]
Private courses on your site - see [here]
Please ask about maintenance training for Perl, PHP, Java, C, C++, Ruby, MySQL and Linux / Tomcat systems

Phone System reconfiguration 11.1.2018 and 12.1.2018 - we are on email but incoming phone not available all the time

Well House Consultants
You are on the site of Well House Consultants who provide Open Source Training Courses and business hotel accommodation. You are welcome to browse and use our resources subject to our copyright statement and to add in links from your pages to ours.
Other subject areas - resources
Java Resources
Well House Manor Resources
Perl Resources
Python Resources
PHP Resources
Object Orientation and General topics
MySQL Resources
Linux / LAMP / Tomcat Resources
Well House Consultants Resources
Extras Resources
C and C++ Resources
Ruby Resources
Tcl/Tk Resources
Web and Intranet Resources
PHP module H201
PHP and MySQL for Content Management
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 subjectupdated
3453Reading 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 ...
1745Moodle, 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 ...
2071Setting 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 ...
1576Making 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 ...
1555Advanced 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 ...
647Checking 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
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.
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.

You can Add a comment or ranking to this page

© WELL HOUSE CONSULTANTS LTD., 2018: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 793803 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho

PAGE: http://www.wellho.net/resources/H201.html • PAGE BUILT: Mon Feb 8 18:55:24 2016 • BUILD SYSTEM: WomanWithCat