Byron Employment

Byron Employment. Over 71,743 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $880.00

About this course

Once you understands the basics of how PHP and MySQL work both individually and together, you’ll need a few more things in your toolbox to get the most out of their abilities. The PHP and MySQL Masterclass will take you through all the important features you’ll need when developing your own dynamic websites and applications.


Intermediate Technical

Delivery Method



1 day


9am - 4pm


Max 8 students

What you will learn

PHP has powerful Object Oriented Programming abilities, and we’ll take you through how to take advantage of these to build your own re-usable classes. You’ll learn how to keep user-specific data between scripts with sessions.
We’ll show you how to access and manipulate files and folders on the server, including reading, editing and outputting images on the fly. You’ll also get an overview of using PHP with the Unix cron job system, allowing you to run PHP scripts at regular intervals without user interaction.
Before the day is done we’ll take you through creating a simple CMS (Content Management System), the basis of almost any dynamic website, and the best way to keep your content and design separate yet have both easy to manage by yourself or end users.

Assumed knowledge

Web Developer You’ll need a working knowledge of both PHP and MySQL to take this course, preferably with some experience writing your own code. We recommend you first take our PHP and MySQL Essentials course unless you've already been working with PHP for some time. Please get in touch with our office if unsure.


Advanced PHP and MySQL
Database design
Performing joints
Grouping selected results
Creating indexes
Using different table types
Performing FULLTEXT searches
Database optimisation

Web Application Developement
Adjusting behaviour for server settings
Sending values to a script manually
Using hidden form inputs
Editing existing records
Paginating query results
Making sortable displays
Understanding HTTP headers

Web Application Security
More secure form validation
Handling HTML
Validating data by type
Form validation with JavaScript
Regular expressions
Database security and encryption

Cookies vs Sessions
Creating a Session
Storing & Accessing Simple Variables
Storing Objects

Objects & Classes
Object Oriented Programming
Creating Classes
Class Inheritance
Manipulating Objects
PHP4 vs PHP5

Getting Image Info
Reading Images
Outputting Images
Resizing Images
Basic Geometry & Text

Cron Jobs
Setting Up Cron Jobs
Differences to Web
Hidden Dangers

How Content Management Works
CMS Tables
Creating Articles
Editing Articles
Formatting & Displaying Articles

File System
Navigating the File System
Windows vs Unix
File Permissions
Reading Files
Manipulating Files
Creating Files

Extended Topics
Handling file uploads
PHP and JavaScript
Using otput buffering
Using the improved MySQL extention
New MySQL features
Using PEAR

Companion courses

Any course listed on this page is considered a companion course. A 10% discount is applied to the total amount when two or more companion courses are booked together.

Please note:
Companion discounts are only available for scheduled courses. That is, those courses that have scheduled dates in your town. Courses listed as on-request (or on-demand) do not qualify.

Available companions will appear in a panel when you click Book Now and select a location.

The discount will appear in your shopping cart and will apply to the total.

Group bookings

Discounts apply to bookings of two or more people from one organisation: 5% off for two people, 10% for three etc.

Please note:
Group discounts will be automatically applied to the total in your shopping cart. Click Recalculate to view the discounted fee before progressing to the checkout.

Custom training

Customised training may prove more favourable in terms of both price and outcomes if your group is larger than 3 or 4 or if you have specific needs in mind.

Get in touch with our staff to discuss your needs and we can assist you make the right decision.

Here's what you get on a Fearless course

Course Materials

We typically supply detailed course notes or a reference text or in some cases both. Either way, we try to provide sufficient supporting material so that you can return to your work place with sufficient confidence to permit further learning.


We like to look after our customers with:
  • Quality catering from local cafes
  • Fresh fruit
  • Filter coffee and good biscuits
  • Table sweets
  • Chilled water
We also accommodate special dietary requirements such as vegetarian, gluten intolerance etc.


There's nothing worse than leaving a course and feeling left on your own. We like to ensure our customers have all the support and backup they need including:
  • 90 days unlimited support by phone, email or instant messaging
  • On-going support through our Fearless Flyer program (for an extra fee)
  • A free re-sit of this course on any scheduled date in the future

You also get

  • A certificate of completion
  • A CD-ROM with worked examples (for most courses)


All Publicly Scheduled Fearless courses provide lunch for their students.


CALL NOW ON 1 300 738 797

CALL 1 300 738 797 OR

Search Courses

Quick Job Search