Interfacing Applications to MySQL Databases

MySQL module S156

Exercises, examples and other material relating to training module S156. This topic is presented on public courses MySQL, Extra Day

The MySQL Relational database - training course - Structure, Installation, Administration, Database Design and Programming through SQL

The MySQL Relational database - Structure, Installation, Administration, Database Design and Programming through SQL This course introduces you to the ...

http://www.wellho.net/course/mqfull.html [course]

Extra Days - training course - Subjects not covered on regular public courses!

Extra Days - Subjects not covered on regular public courses! We offer a wide range of public courses which well cover the training needs of the majority ...

http://www.wellho.net/course/axfull.html [course]

Using a MySQL database to control mod_rewrite via PHP

Question: How can I set up Apache httpd / mod_proxy to use a program rather that a list of URL patterns to control my rewrites? Specify a rewrite map ...

http://www.wellho.net/mouth/1381_Usi ... a-PHP.html [short article]

MySQL version 5, PHP version 5 and mysqli

There s a great deal of code and data that uses MySQL version 3 and PHP version 4 and it works very well. Many users are NOT rushing to upgrade. But MySQL ...

http://www.wellho.net/solutions/mysql-my ... ysqli.html [longer article]

Interfacing applications to a MySQL database engine

At the core of MySQL is mysqld , the database engine daemon which handles connections and requests via a TCP port - typically post no. 3306. Provided ...

http://www.wellho.net/solutions/mysql-in ... ngine.html [longer article]

Accessing a MySQL database via a browser, Perl and CGI

div class= introhead Making a database available via a browser /div Here s a putting all the technology together demonstration ... showing the elements ...

http://www.wellho.net/solutions/perl-acc ... d-cgi.html [longer article]

Using a MySQL database from Perl

Both Perl and MySQL are major pieces of open source software with a multitude of facilities available - yet you can use them together with just a tiny ...

http://www.wellho.net/mouth/644_Usin ... -Perl.html [short article]

Structured Query Language is, as its name implies, a programming language. Application programs send commands in SQL to the relational database and also provide the application's user interface. In other words, they provide the glue between the application user and the database. Such programs can be written in a variety of languages including C, PHP, Java and Perl.

This topic is presented on public courses MySQL, Extra Day

Examples from our training material

mkexcel.php	Returning data from a database via a URL as an excel spread sheet in PHP
mkexcel2.php	Returning data, opening Excel including formulas, from PHP
mqxyz.php	Simple demo of PHP table from SQL
t1.php4	PHP table insert into two tables / join / enquire
t1.sql	create tables for t1 demo

Background information

This module is available under an Open Training Notes License for free download from http://www.training-notes.co.uk.

Topics covered in this module

Interfacing MySQL to Perl.
The Perl program in detail.
A Further Example.
Interfacing MySQL to PHP.
Interfacing MySQL to Java.
Interfacing MySQL to Tcl/Tk.
Interfacing MySQL to C.
When should I choose MySQL?.
Brief comparisons.
Limitations of MySQL, and work-arounds.
subselects.
transactions and commit/rollback.
Foreign keys and referential Integrity.
Stored procedures and triggers.
Views.
Record level privileges and locking.
Why are the limitations not always limitations?.

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 700 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.