Building Dynamic Websites Using PHP and MySQL

Learn how to build dynamic, database-driven websites and applications with PHP and MySQL.

Course Description

You know a thing or two about Web design - you’ve probably designed some Websites for yourself, your friends and maybe even paying clients. But then it comes time to fix that typo, edit some content or update the year in the copyright notice at the bottom of every page in your site - what a hassle! By starting to build Websites using PHP and MySQL - the most popular general-purpose scripting language and relational database management system (RDBMS) used on the Web today - you can take your Web skills to the next level and break free from the brochure-site syndrome.

Download an enrolment form

Course Outline

Topic 1: Introduction

  1. What is PHP?
  2. What is MySQL?
  3. Installation
  4. Your First PHP Script
  5. Online Resources

Topic 2: Getting Started with MySQL

  1. An Introduction to Databases
  2. Logging On to MySQL
  3. Using Structured Query Language (SQL)
  4. Creating a Database
  5. Creating a Table
  6. Inserting Records into a Table
  7. Viewing Records
  8. Updating Records
  9. Deleting Records

Topic 3: Getting Started with PHP

  1. Basic Syntax and Commands
  2. Variables and Operators
  3. User Interaction and Forms
  4. Control Structures

Topic 4: Publishing MySQL Data on the Web

  1. Connecting to MySQL with PHP
  2. Sending SQL Queries with PHP
  3. Handling SELECT Result Sets
  4. Inserting Data into the Database

Topic 5: Advanced PHP

  1. Includes
  2. User-Defined Functions
  3. Building the CMS
  4. Cookies
  5. Securing the CMS

Topic 6: A Database Driven Website

  1. Creating the Website

Course Details

Course Code PHP
Cost $AU865.00
Course Duration 5 Weeks (2 nights per week)
2008 Course Dates Monday and Wednesday, 3 March 2008 - 2 April 2008
Tuesday and Thursday, 15 July 2008 - 21 August 2008
Monday and Wednesday, 10 November 2008 - 17 December 2008

Download an enrolment form