1300 888 724

8.30am to 5:30pm AEST (Mon-Fri)
  • Search
  • Cart
  • Courses

Advanced PHP Web Development Course

(4.79 out of 5) 113 Student Reviews

About the Course

During the 3-day course, participants will be introduced to a range of advanced PHP and MySQL techniques, including sticky forms and database design, creation, and optimization. Students will also learn how to conduct FULLTEXT searches, sortable database results, secure form validation, and how to use HTTP headers and regular expressions.

Who should do this course?

This course is intended for anyone looking to expand their current PHP and MySQL knowledge to that of an Advanced PHP Developer. On completion of the course, participants should be able to create a basic content management, user registration, and simple e-commerce system using PHP and MySQL.

Prerequisites

To gain the most from the class, participants should already have completed Introduction to PHP and MySQL course and had at least six weeks practical experience thereafter, or have equivalent knowledge. This includes practical experience using PHP syntax, functions, and variables, and experience with the SQL command set, including SELECT, INSERT, and UPDATE.

Course Benefits

  • FREE Re-sit up to 8 months
  • FREE eMail Support
  • Certified Expert Trainers
  • Printed Course Manual
  • Certificate of Completion
  • Small Class Sizes
  • Hands-on Training Methods
  • Fully Set-Up Computer Labs

Quick Facts

$ 1485 incl GST

Duration: 3 Days

Max. Class Size: 10

Avg. Class Size: 5

Level: Advanced

Times: 9.00am to 5.00pm approx

Course Dates

16-18 Oct 17Mon - Wed

11-13 Dec 17Mon - Wed

07-09 Mar 18Wed - Fri

30 May - 01 Jun 18Wed - Fri

20-22 Aug 18Mon - Wed

Address

Level 11,
32 Walker Street,
North Sydney , NSW 2060

View map

Click Here external link for Google Map

01-03 Nov 17Wed - Fri

20-22 Dec 17Wed - Fri

13-15 Mar 18Tue - Thu

06-08 Jun 18Wed - Fri

27-29 Aug 18Mon - Wed

Address

Level 12
379 Collins Street,
Melbourne , VIC 3000

View map

Click Here external link for Google Map

Upon demand

This course is currently upon demand in Brisbane

Address

C/O Support Technology
Level 6, 371 Queen Street,
Brisbane , QLD 4000

View map

Click Here external link for Google Map

Upon demand

This course is currently upon demand in Canberra

Address

C/O Atlas Business Services
Level 1, 33 Ainslie Place,
Canberra , ACT 2601

View map

Click Here external link for Google Map

Upon demand

This course is currently upon demand in Adelaide

Address

C/O The International Visualisation Centre (IVC)
19 Young Street,
Adelaide , SA 5000

View map

Click Here external link for Google Map

Upon demand

This course is currently upon demand in Perth

Address

C/O Saxons Training Facilities
Level 1, 140 St Georges Terrace,
Perth , WA 6000

View map

Click Here external link for Google Map

Please Join the waiting list and We'll notify you when a new class is scheduled or if a place becomes available.

Course Units

Expand full topic list

Unit 1: Introducing the Course

See topics

  • Getting familiar with the course methodology and format
  • Understanding the course objectives and pre-requisites
  • Why PHP and MySQL?

Unit 2: Introduction to PHP

See topics

  • Basic Syntax
  • Sending Data to the Web Browser
  • Understanding PHP, HTML, and White Space
  • Writing Comments
  • What are Variables?
  • About Strings
  • About Numbers
  • About Constants
  • Single vs. Double Quotation Marks

Unit 3: Programming with PHP

See topics

  • Creating an HTML Form
  • Handling an HTML Form
  • Managing Magic Quotes
  • Conditionals and Operators
  • Validating Form Data
  • What are Arrays?
  • For and While Loops

Unit 4: Creating Dynamic Web Sites

See topics

  • Including Multiple Files
  • Handling HTML Forms with PHP Redux
  • Making Sticky Forms
  • Creating and Calling your Own Functions
  • Variable Scope
  • Date and Time Functions
  • Sending Email

Unit 5: Introduction to SQL and MySQL

See topics

  • Choosing your Column Types
  • Choosing Other Column Properties
  • Using the mysql Client
  • Creating Databases and Tables
  • Inserting Records
  • Selecting Data
  • Using Conditionals
  • Using LIKE and NOT LIKE
  • Sorting Query Results
  • Limiting Query Results
  • Updating Data
  • Deleting Data
  • Using Functions

Unit 6: Advanced SQL and MySQL

See topics

  • Database Design
  • Performing Joins
  • Grouping Selected Results
  • Creating Indexes
  • Using Different Table Types
  • Performing FULLTEXT Searches
  • Database Optimization

Unit 7: Error Handling and Debugging

See topics

  • General Error Types and Debugging
  • Displaying PHP Errors
  • Adjusting Error Reporting in PHP
  • Creating Custom Error Handlers
  • Logging PHP Errors
  • PHP Debugging Techniques
  • SQL and MySQL Debugging Techniques

Unit 8: Using PHP with MySQL

See topics

  • Modifying the Template
  • Connecting to MySQL and Selecting the Database
  • Executing Simple Queries
  • Retrieving Query Results
  • Ensuring Secure SQL
  • Counting Returned Records
  • Updating Records with PHP

Unit 9: Web Application Development

See topics

  • Adjusting Behavior 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

Unit 10: Cookies and Sessions

See topics

  • Using Cookies
  • Using Sessions
  • Sessions and Cookies
  • Improving Session Security

Unit 11: Web Application Security

See topics

  • More Secure Form Validation
  • Handling HTML
  • Validating Data by Type
  • Form Validation with JavaScript
  • Regular Expressions
  • Database Security and Encryption

Unit 12: Extended Topics

See topics

  • Handling File Uploads
  • PHP and JavaScript
  • Using Output Buffering
  • Using the Improved MySQL Extension
  • New MySQL Features
  • Using PEAR

Unit 13: Example—Content Management

See topics

  • Creating the Template
  • Creating the Basic Pages
  • Managing URLs
  • Managing Files

Unit 14: Example—User Registration

See topics

  • Creating the Templates
  • Writing the Configuration Scripts
  • Creating the Home Page
  • Registration
  • Activating an Account
  • Logging in and Logging Out
  • Password Management

Unit 15: Example—E-Commerce

See topics

  • Creating the Database
  • The Administrative Side
  • Creating the Public Template
  • The Product Catalogue
  • The Shopping Cart
  • Recording the Orders

Reviews

(5.00 out of 5) Brad R [ 23 January, 2017 ]
The course was well presented in a logic order and covered key aspects and features of advanced PHP and MySQL programming.
(5.00 out of 5) Justinian L [ 10 October, 2016 ]
Mark, our instructor doesn't mind to go the extra miles to ensure that we understand the important object oriented programming concept in PHP. Besides that, Mark showed us some useful PHP tricks which would make our life much easier. Thanks Mark.

See more reviews

(5.00 out of 5) John B [ 01 August, 2016 ]
Great one on one with teacher. Concepts explained well and I was able to relate my previous experience in other languages with the examples provided by the teacher. I believe this was possible because my teacher understood me from a programming perspective.
(5.00 out of 5) Nerida [ 20 August, 2014 ]
Russell was fantastic and very patient with me. I didn't have a great chance to practice between the intro course and this one but it was worth coming anyway. Doing a project to put together different components and build on the skills learnt helped a lot. Russel explains things so well and challenges us but it is not intimidating rather more enjoyable to see what I know and test myself. he also explains about the real world applicability of things which is really helpful. Thanks for a great course!

Read all reviews

Enquire Now

Fill in your details to have a training consultant contact you to discuss your training needs.

Your details

Other Ways To Get In Touch

You can also Book Online or call us on 1300 888 724

Back to Top