Full star Half star Star PDF
The Ultimate Training Experience.

Advanced PHP Web Development Course

(4.80 out of 5) 118 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 Details

$1485 incl GST

  • Duration:3 Days
  • Max. Class Size:10
  • Avg. Class Size:5
  • Study Mode:
    Classroom Online Live
  • Level:Advanced
  • CPD Hours:18 hours
  • Course Times: Classroom: 9.00am to 5.00pm approx(Local Time) Online Live: 9.00am to 5.00pm approx(AEST or AEDT)
  • Download Course PDF
Pay Later

Course Dates

Sydney Class Dates

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

21-23 Jan 26 Wed - Fri Online Live
13-15 Apr 26 Mon - Wed Online Live
08-10 Jul 26 Wed - Fri Online Live
28-30 Sep 26 Mon - Wed Online Live
16-18 Dec 26 Wed - Fri Online Live
Melbourne Class Dates

Level 12, 379 Collins Street, Melbourne , VIC 3000

21-23 Jan 26 Wed - Fri Online Live
13-15 Apr 26 Mon - Wed Online Live
08-10 Jul 26 Wed - Fri Online Live
28-30 Sep 26 Mon - Wed Online Live
16-18 Dec 26 Wed - Fri Online Live
Brisbane Class Dates

All courses facilitated in, Online Live format , QLD

21-23 Jan 26 Wed - Fri Online Live
13-15 Apr 26 Mon - Wed Online Live
08-10 Jul 26 Wed - Fri Online Live
28-30 Sep 26 Mon - Wed Online Live
16-18 Dec 26 Wed - Fri Online Live
Canberra Class Dates

All courses facilitated in, Online Live format , ACT

21-23 Jan 26 Wed - Fri Online Live
13-15 Apr 26 Mon - Wed Online Live
08-10 Jul 26 Wed - Fri Online Live
28-30 Sep 26 Mon - Wed Online Live
16-18 Dec 26 Wed - Fri Online Live
Adelaide Class Dates

All courses facilitated in, Online Live format , SA

21-23 Jan 26 Wed - Fri Online Live
13-15 Apr 26 Mon - Wed Online Live
08-10 Jul 26 Wed - Fri Online Live
28-30 Sep 26 Mon - Wed Online Live
16-18 Dec 26 Wed - Fri Online Live
Perth Class Dates

All courses facilitated in, Online Live format , WA

21-23 Jan 26 Wed - Fri Online Live
13-15 Apr 26 Mon - Wed Online Live
08-10 Jul 26 Wed - Fri Online Live
28-30 Sep 26 Mon - Wed Online Live
16-18 Dec 26 Wed - Fri Online Live

Course Units

Unit 1: Introducing the Course

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

Unit 2: Introduction to PHP

  • 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

  • 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

  • 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

  • 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

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

Unit 7: Error Handling and Debugging

  • 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

  • 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

  • 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

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

Unit 11: Web Application Security

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

Unit 12: Extended 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

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

Unit 14: Example—User Registration

  • 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

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

Related Courses

Introduction to PHP and MySQL Course
Introduction to PHP and MySQL
(4.74 out of 5)
$1485.00
Learn More
Python Beginner Course
Python Beginner
(4.88 out of 5)
$1980.00
Learn More
Python Intermediate Course
Python Intermediate
(4.84 out of 5)
$1980.00
Learn More
Java Beginner - Syntax and Coding Course
Java Beginner - Syntax and Coding
(4.74 out of 5)
$2310.00
Learn More

Student Reviews

(5.0)
28 October, 2019

Very informative and well prepared. Found the course extremely useful in progression my own foundation level. Would highly recommend.

Gerard A
(5.0)
28 October, 2019

Well prepared and delivered at a nice pace. Mark's extensive real-world experience was impressive and facilitated the easy explanation of the advanced topics. I now feel more confident in my approach to PHP/MySQL programming upon my return to work. Much appreciated!

Nathan E
(5.0)
23 January, 2017

The course was well presented in a logic order and covered key aspects and features of advanced PHP and MySQL programming.

Brad R
(5.0)
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.

Justinian L
(5.0)
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.

John B
(5.0)
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!

Nerida
(4.9)
20 August, 2014

This course has been very informative. The Teacher was very well versed in the Subject he taught and was able to break down several areas that i have had difficulty with in the past. The speed at which we progressed through the course elements was fair, no one was left behind, and we were all able to follow the Teacher's instruction with little difficulty. All in all i am extremely glad i entered this training, i know the advice and techniques i was given, as well as good training examples we attempted will help me exponentially in the projects i am currently working on. Thank you so much DWT, i would not be surprised if i came back to try another course from you guys also. Thank you again, Jordan Thurston.

Jordan T
(5.0)
20 August, 2014

The course presented a good high level portrait of composition. While online tutorials often cover individual techniques, they often do so without a mind to a real context in which the technique pays off. A concept has little resonance deprived of context and any real sense of utility. The course presented content in a context, where techniques that seemed questionably useful suddenly represented massive improvements in terms of dynamic code, brevity, correctness. It also helped correct an amount of bias in terms of techniques and structures - a consequence of baggage with java, apex, etc. Fit description. It certainly helped to see the process.

Simon C
(5.0)
18 June, 2014

Excellent course and well presented. Mark was able to answer all of my noob/beginner questions and on multiple occasions went into details to a point that I was able to understand (being at a beginner level and all) It is evident and obvious that Mark has a passion for PHP and I think this is required for any teacher teaching a certain subject and is also great to see! I have now moved from a beginners level knowledge to intermediate and look forward increasing my knowledge. Please excuse my spelling and literature...it's a Friday afternoon. -James

James P
(4.4)
26 March, 2014

Some of the course was fast paced and hard to understand but Mark showed great patience and thoroughness in his explanations.

Aroleon G
(4.8)
21 October, 2013

Course instructor and support staff extremely helpful. Will definitely recomment DWT for courses in other areas to do with my work should I get the chance.

Matthew S
(5.0)
21 October, 2013

This was a great course. Highly enjoyable with an enthusiastic instructor who knew his stuff. It was on par for my needs and convered the areas that I wanted to know about.

Kirralee S
(4.8)
21 October, 2013

Course was well presented and structured. Provided additional information which did help understand fundemental concepts. Instructor is very knowledgeable.

Nik
(5.0)
26 August, 2013

This instructor (Mark) was brilliant! The pace was enjoyable and I learnt a lot from it. We built an e-commerce website from scratch and learnt lots of PHP tips and traps along the way. I strongly recommend this course to others who are interested in PHP programming and website development.

Austin E
(5.0)
20 February, 2013

Thoroughly enjoyed this course. The statement "The instructor shared valuable real world experience" was beyond expectation.

Griffith Y
Read all course reviews

Enquire Now

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

Note: Form fields marked with * are required.

Your details
Please enter a valid email address for shipping updates.
I am enquiring about a...
REQUEST A CALLBACK
A team member will call you at a time convenient to you.
Your message was sent, thank you!
Contact us

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