Using MySQL Databases in PHP Pages

Using MySQL Databases in PHP Pages - module H113

This module teaches you some of the PHP functions that let you connect to a MySQL database. It also tells you how to write PHP code that can be used on data held in other relational databases without the need to duplicate or rewrite large amounts of code.

This topic is presented on public courses PHP Programming, MySQL

Examples from our training material

agents.php	Joining MySQL database and searching results in PHP
aos.php	Save a MySQL result set to the local machine
bookstats.php	PHP to front a MySQL multiway join
mqchunks.php	Pagination through a database - PHP and MySQL
mqclim.php	searching and paging through results
people.php4	Simple database lookup - using MySQL from PHP
pic_alog.php4	view images stored in a MySQL database via PHP
pic_up.php4	Uploading an image from a form to a MySQL database via PHP
picclim.php	Search a database of images
picscript.php	Retrieve an image from a database and display it
sekiy.php4	Converts data into MySQL commands
select1.php4	Selecting information from a database table - unchecked
select2.php4	Selecting information from a database table - fully validated
sqd.php	Algorithm selection of where clauses
sql_image_store.html	Web page to call up an image held in an SQL database
sqladd.php4	Add information to a database table
sqlcreate.php4	Create a MySQL table from a PHP page
sqldelete.php4	deleting a database table from PHP
sqlhelper.inc	PHP helper - make up a where clause element
sqlreport.php4	report on information held in a relational database
sqltab.php4	Full navigation around an SQL database from PHP
yikes.php4	Downloading complete database via a PHP script

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

Database structure.
How to create a new table.
Adding information to a table.
Selecting information from a table and reporting it to a web page.
Deleting a table.
User input checking and other testing.
Example: A PHP script to select and view the data in any table.
Downloading all the tables from a database.
Uploading tables from a flat text file.
Using other relational databases from PHP.
Using Oracle 8.x and 9.x.
Using the Oracle OCI9 API.
Portable database connection.

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.