Home Accessibility Courses Twitter The Mouth Facebook Resources Site Map About Us Contact
 
For 2023 (and 2024 ...) - we are now fully retired from IT training.
We have made many, many friends over 25 years of teaching about Python, Tcl, Perl, PHP, Lua, Java, C and C++ - and MySQL, Linux and Solaris/SunOS too. Our training notes are now very much out of date, but due to upward compatability most of our examples remain operational and even relevant ad you are welcome to make us if them "as seen" and at your own risk.

Lisa and I (Graham) now live in what was our training centre in Melksham - happy to meet with former delegates here - but do check ahead before coming round. We are far from inactive - rather, enjoying the times that we are retired but still healthy enough in mind and body to be active!

I am also active in many other area and still look after a lot of web sites - you can find an index ((here))

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 H204
PHP and MySQL example application - adhoc database analysis
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 subjectupdated
572Giving 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
adhoc.conf   Configuration file for ad hoc MySQL query system
adhoc_sql_query_engine.php   Application to look after generalise casual queries on a complex table structure
businesslogic.inc   BUSINESS LOGIC
help1.txt   Sample help file
help10.txt   Sample help file - query type
help11.txt   Sample help file - select rows
help12.txt   Sample help file - select columns
help199.txt   Sample help file - logout
help20.txt   Sample help file - result page
helppage.php   Help system - template wrapper
page_layout.htp   Template for adhoc MySQL Query system
sampledata.sql   Commands used to create sample SQL database and tables
sqlwrapper.inc   An SQL wrapper to aid portability
webhelpers.inc   standard functions 4 layer model applications
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.


You can Add a comment or ranking to this page

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

PAGE: http://www.wellho.net/resources/H204.html • PAGE BUILT: Sun Oct 11 14:50:09 2020 • BUILD SYSTEM: JelliaJamb