Interfacing Applications to MySQL Databases

Interfacing Applications to MySQL Databases - module S156

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

Specialist books

Opentalk forum discussions related to this topic

Perl and MYSQL
Connecting to MySQL over an unreliable network
Using ASP with MySQL
SQL Injection Attacks
Mysql Regex question
MySQL Java PreparedStatement Quoting
Use of qq to prevent Mysql injection

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

Course links

The following web pages are used as references / examples in this module

[Link] mysqltcl - Tcl Mysql Interface (version 2.50)
(at http://www.xdobry.de/mysqltcl)

[Link] JDBC Drivers
(at http://industry.java.sun.com/products/jdbc/drivers)

We check these links from time to time with a spider written in PHP. Latest full check was on Saturday, 12th June 2004. Titles are extracted from the web pages listed.

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.