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
- 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
Course Dates
Sydney Class Dates
Level 11, 32 Walker Street, North Sydney , NSW 2060
| 20 - 22 Jan 25 | Mon - Wed | Online Live |
| 12 - 14 Mar 25 | Wed - Fri | Online Live |
| 06 - 08 May 25 | Tue - Thu | Online Live |
| 30 Jul - 01 Aug 25 | Wed - Fri | Online Live |
| 20 - 22 Oct 25 | Mon - Wed | Online Live |
Melbourne Class Dates
Level 12, 379 Collins Street, Melbourne , VIC 3000
| 20 - 22 Jan 25 | Mon - Wed | Online Live |
| 12 - 14 Mar 25 | Wed - Fri | Online Live |
| 06 - 08 May 25 | Tue - Thu | Online Live |
| 30 Jul - 01 Aug 25 | Wed - Fri | Online Live |
| 20 - 22 Oct 25 | Mon - Wed | Online Live |
Brisbane Class Dates
Level 6, 371 Queen Street, Brisbane , QLD 4000
| 20 - 22 Jan 25 | Mon - Wed | Online Live |
| 12 - 14 Mar 25 | Wed - Fri | Online Live |
| 06 - 08 May 25 | Tue - Thu | Online Live |
| 30 Jul - 01 Aug 25 | Wed - Fri | Online Live |
| 20 - 22 Oct 25 | Mon - Wed | Online Live |
Canberra Class Dates
All courses facilitated in, Online Live format ,
| 20 - 22 Jan 25 | Mon - Wed | Online Live |
| 12 - 14 Mar 25 | Wed - Fri | Online Live |
| 06 - 08 May 25 | Tue - Thu | Online Live |
| 30 Jul - 01 Aug 25 | Wed - Fri | Online Live |
| 20 - 22 Oct 25 | Mon - Wed | Online Live |
Adelaide Class Dates
All courses facilitated in, Online Live format ,
| 20 - 22 Jan 25 | Mon - Wed | Online Live |
| 12 - 14 Mar 25 | Wed - Fri | Online Live |
| 06 - 08 May 25 | Tue - Thu | Online Live |
| 30 Jul - 01 Aug 25 | Wed - Fri | Online Live |
| 20 - 22 Oct 25 | Mon - Wed | Online Live |
Perth Class Dates
All courses facilitated in, Online Live format ,
| 20 - 22 Jan 25 | Mon - Wed | Online Live |
| 12 - 14 Mar 25 | Wed - Fri | Online Live |
| 06 - 08 May 25 | Tue - Thu | Online Live |
| 30 Jul - 01 Aug 25 | Wed - Fri | Online Live |
| 20 - 22 Oct 25 | Mon - Wed | Online Live |
Course Units
⊕ Expand full topic list
Unit 1: Introducing the Course
- Getting familiar with the course methodology and format
- Understanding the course objectives and pre-requisites
- Why PHP and MySQL?
⊕ See more
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
⊕ See more
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
⊕ See more
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
⊕ See more
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
⊕ See more
Unit 6: Advanced SQL and MySQL
- Database Design
- Performing Joins
- Grouping Selected Results
- Creating Indexes
- Using Different Table Types
- Performing FULLTEXT Searches
- Database Optimization
⊕ See more
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
⊕ See more
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
⊕ See more
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
⊕ See more
Unit 10: Cookies and Sessions
- Using Cookies
- Using Sessions
- Sessions and Cookies
- Improving Session Security
⊕ See more
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
⊕ See more
Unit 12: Extended Topics
- Handling File Uploads
- PHP and JavaScript
- Using Output Buffering
- Using the Improved MySQL Extension
- New MySQL Features
- Using PEAR
⊕ See more
Unit 13: Example—Content Management
- Creating the Template
- Creating the Basic Pages
- Managing URLs
- Managing Files
⊕ See more
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
⊕ See more
Unit 15: Example—E-Commerce
- Creating the Database
- The Administrative Side
- Creating the Public Template
- The Product Catalogue
- The Shopping Cart
- Recording the Orders
⊕ See more
Related Courses
Course Reviews
Very informative and well prepared. Found the course extremely useful in progression my own foundation level. Would highly recommend.
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!
The course was well presented in a logic order and covered key aspects and features of advanced PHP and MySQL programming.
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.
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.