PHP and MySQL example application - adhoc database analysis

PHP and MySQL example application - adhoc database analysis - module H204

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.

This topic is presented on public course PHP Programming

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 http://www.training-notes.co.uk.

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 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 600 books on the subjects on which we teach. These books are available for reference at our training centre. Also available is the Opentalk Forum for discussion of technical questions.