PHP & MySQL Training Course

PHP is an open source scripting language designed for building dynamic websites. It integrates easily with the popular MySQL database.

MySQL is an open source software relational database management system (RDBMS) which uses SQL (Structured Query Language)

PHP & MySQL are designed to work together, allowing you to build data driven websites.

Some of the things that PHP & MySQL can be used for are:

  • Creating content management systems (CMS)
  • Building galleries, blogs, forums, guestbooks; all with back-end user/password secured administration sections
  • Processing data from web forms, including form validation
  • Create customized web pages based on a particular visitor, using information you have gathered from them using cookies

Here are some of MySQL's advantages

  • It's fast
  • It's free to use, and commercial licenses are reasonable
  • It's easy to use
  • It is cross platform
  • There is a wide community of technical support
  • It's secure
  • It supports large databases
  • It is designed specifically for web base applications and hence works very well partnered with PHP

Course Details

Duration: 2 days.
Dates: Contact us for availability.
Location: Our MySQL & PHP training course is held at 26 Palmerston Place, Edinburgh, Scotland
Fees: £659.00 + VAT.

View the course content

Get in Touch

Book Now bade

Questions?

If you have any questions about our training courses or just want to discuss your requirements with a member of our training team then you can:

For more information about payment, please read our terms and conditions.

To express a register of interest for this MySQL course fill in the form below:







PHP & MySQL Course Contents

The following represents a typical breakdown of our PHP & MySQL course, however we can tailor all our courses to specific requirements as required.

Introduction to PHP
  • What is PHP & What can it be used for?
  • Installing and running PHP under Apache webserver
  • Variables, Functions, Arrays
  • Programming constructs; including IF, ELSE, WHILE, FOR, SWITCH, CASE
  • Passing data values in a URL
  • Passing data values in a form
  • Processing user input data - form validation
  • Using text files as data with PHP (e.g.CSVs)
Example PHP applications
  • Building a well structured form validation script
  • Building a webpage structure with PHP using a CLASS as an introduction to Object Oriented programming (OOP)
  • Creating a photo gallery with PHP to illustrate the GD library functions in PHP
Introduction to MySQL
  • What is MySQL
  • How to install and connect to MySQL
  • SQL - Structured Query Language
  • Creating a database and tables
  • Populating tables with data; Adding/Editing/Deleting
  • How to use Foreign Keys
  • Contructing and running queries
  • How to use JOINs
  • How to use front-end applications to manage a database; phpMyAdmin, SQLyog
  • Using PHP to connect to MySQL and run queries
  • Building a basic Content Management System in PHP to manage a small example MySQL database
  • Searching a database (queries generated from PHP script)
  • Backup
  • Installing an off-the-shelf Content Management System which uses PHP & MySQL (MODx) with an introduction to how to use and extend it's functionality by modifying existing PHP code or adding in your own PHP code.

Skills Gained:

  • Creating dynamic PHP/MySQL websites
  • Building blocks / syntax of the PHP language
  • General programming techniques
  • How to debug your code
  • How to write clean re-usable code
  • How to adapt PHP/MySQL packages
  • The basics of the SQL language
  • Database design
  • Integration of PHP with MySQL