Integrating PHP with MySQL

SPRING Semester Dates: Every Saturday 6/9/08 - 20/9/08
Times: 9am to 4pm
Duration: 18 hours (6 hours x 3 weeks)
Fees: $1000.00
Venue: City campus - Building 10

Expressions and Enrolment

If you are interested in this course, please submit an Expression of Interest form to register your interest. Please note if you wish to enroll into this short course, you must also submit an Application Form [PDF 114k] to pay for and secure a place. Submission of an application form is confirmation of your intent to enroll and terms and conditions will apply.

Page Index
Who should attend
Course Objectives
Course Description
Course Outline

Who Should Attend?

This course is aimed at people who wish to:

  • Improve their PHP skill level.
  • Use PHP to interrogate MySQL databases
  • Use PHP to maintain and update MySQL databases.
  • Use MySQL as a data storage system on websites that require a sophisticated database facility.

Participants should have basic computer literacy, including the use of application software such as word-processors, spreadsheets and/or databases and understanding of the Internet. Prior familiarity with PHP is not required, but knowledge of elementary programming concepts such as storing of data in variables, datatypes, arrays, functions and control logic (if statements and loops) is mandatory as the course will assume familiarity with these concepts. Familiarity with elementary HTML is desirable.

Course Objectives

At the end of this short course the student will be able to:

  • Demonstrate basic knowledge of the PHP Scripting Language
  • Describe how PHP can be used to log on and interact with MySQL databases.
  • Determine how simple database queries can be constructed using MySQL and PHP.
  • Design and implement basic and more complex database queries using MySQL and PHP.
  • Implement the basics of MySQL database tables by adding, changing and deleting data using PHP and HTML forms.

Course Description

This course shows you how to use the PHP scripting language and a web browser to access MySQL databases and tables. Simple and complex queries can be set up through a web page which calls a PHP script to carry out the enquiry. PHP can present the results of the query as a web page. PHP can also be used to provide a web interface to add, delete and edit rows of data in MySQL tables.

Course Outline

  • The Client Server model and its relationship to PHP and MySQL.
  • An Introduction to PHP Programming.
  • PHP data types, variables, arrays and loops
  • Basic concepts of MySQL - Databases, tables, logging on, logging off
  • Simple Queries in MySQL.
  • Using PHP to connect to a MySQL Database
  • Using forms to pass data to PHP scripts.
  • Creating and executing simple queries using PHP.
  • Displaying the results of simple queries.
  • Creating more complex queries in MySQL
  • Creating more complex queries with forms and PHP.
  • Adding, editing and deleting data in MySQL tables with forms and PHP.