Exercises, examples and other material relating to training module H204. This topic is presented on public courses
Learning to program in PHP,
PHP Programming
Background
A database SELECT is comprised two types of element - the elements which
specifies the tables to be joined and how they're to be joined, and the
elements that specify which rows and columns are wanted on the results,
and how they're to be grouped and sorted. The sample application covered
in this module allows authorised users to select rows and columns from a
set of tables, but places the joins and other mandatory elements in
configuration files beyond their reach.
Articles and tips on this subject | updated |
572 | Giving the researcher power over database analysis Sometimes, you'll be able to define the queries you'll be doing on a database to a number of specific types, but in other applications you'll be able to narrowly define how you do your joins, but you'll have a wide variety of extraction requirements. This sort of requirement is typical of medical researchers, ... | 2006-06-05 |
Examples from our training material
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
Good practise in action.
4 layer model for application design.
Use of separate business logic, web help and templates.
Contextual Help system.
Login screens.
Building us a MySQL query in a PHP script.
Writing your own configuration file.
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.