Course Details close

Course Details

(inc GST)
$ 1485
Duration:3 days
Level 3
321 Pitt St
Sydney NSW 2000
Participants:Max 10
Length:9:00 to 16:30
Break Times:
10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Course Dates: View
Course Outline: View

PHP and MySQL Advanced Web Design Course

   (4.8 out of 5)
Location: Level 2
80 Mount St
North Sydney
NSW 2060
Break Times:
10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Duration: 3 days Participants: Max 10
Course Length: 9:00 to 16:30 Price:
(inc GST)
$ 1485
Sale Price:
(inc GST)

Quick links

PHP and MySQL Advanced Web Design Course

Course Overview

This course is designed for participants wanting to build on their PHP and MySQL knowledge and skills to catapult them through to the Advanced level. During this course students will learn how to plan, create and develop a database driven website (dynamic website) incorporating a basic content management system, user registration and a simple e-commerce system. Students will also learn how to create, design, optimise a MySQL database, build and implement sticky forms, conduct FULLTEXT searches, sort database results, implement form validation using regular expressions and work with HTTP headers.

Ideally, students should already have completed the PHP and MySQL Essentials course and have at least six weeks practical experience programming in PHP and have relevant experience writing SQL statements including SELECT, INSERT, DELETE and UPDATE queries.

Course Prerequisites

PHP and MySQL Essentials Training Course or equivalent

Course Inclusions

FREE Course Re-sit

8 months

When you book a public course at Raisng the Bar we offer you a FREE course re-sit for up to 8 months from the scheduled course date.

FREE Email Support

12 months

Free email support for up to 12 months from the scheduled course date.

Small Class Sizes

10 students

All of our courses are capped at a maximum of 10 students to maximise your learning experience.

Classroom Training

All of our courses are face to face, hands on, classroom based training delievered by .

Course Manual

Every student will receive a printed course manual with step by step instructions to use as a reference guide.

Computer Lab

No need to bring your own laptop. Our training courses are conducted in fully equipped computer labs with free Wi-Fi.

Course Certificate

Every student receives a certificate of completion at the end of course to recognise your new skills.

Virtual Course Dates (via Zoom)

Course Date Price Add Course Qty Status

There are currently no virtual course dates scheduled for this course.

Call us today to discuss - 1300 937 782.

Public Course Dates

Course Date Price Add Course Qty Status

There are currently no public dates scheduled for this course.

If you have 3 or more people interested in this course, call us today to discuss group training - 1300 937 782.

Course Outline

Introducing the Course

  • Course Methodology and Format
  • Understanding Course Objectives and Pre-requisites
  • Why PHP and MySQL Databases?

Introduction to PHP Programming

  • Basic PHP Syntax
  • Sending Data via Web Browsers
  • Understanding PHP, HTML and White Space
  • Writing Comments in PHP
  • What are Variables?
  • About String Variables
  • About Number Variables
  • About Constants
  • Single vs. Double Quotation Marks

More on PHP Programming

  • HTML Form Creation
  • Handling HTML Form Data
  • Working with Magic Quotes
  • Operators and Conditionals
  • Form Data Validation
  • What are Arrays?
  • For Next and While Loops

Creating a Dynamic Web Site

  • Including Multiple Files
  • Utilise PHP Redux for Handling HTML Forms
  • Sticky Forms
  • User Defined Functions
  • Variable Scope
  • Functions for Date and Time
  • Sending Emails

Intro to MySQL and SQL

  • Setting Column Types
  • Setting Column Properties
  • Working with the MySQL Client
  • Creating a Database
  • Creating Tables
  • Inserting Records
  • Selecting Data Using SELECT Statement
  • Using Conditionals in SQL
  • LIKE and NOT LIKE with Wildcards
  • Sorting the Results of a Query
  • Filtering Query Results
  • Updating Data
  • Deleting Data
  • Using Functions in Queries

Advanced SQL in MySQL

  • Relational Database Design
  • Performing Joins in Queries
  • Grouping Results
  • Creating Indexes in MySQL
  • Utilising Different Table Types
  • FULLTEXT Searches
  • Database Optimisation

Debugging and Error Handling

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

PHP Programming and MySQL

  • Customising the Template
  • Connecting to a MySQL Database
  • Selecting the MySQL Database
  • Executing Queries
  • Displaying Query Results
  • Ensuring Secure SQL
  • Counting Records in SQL
  • Updating Records with PHP

Developing a Web Application

  • Adjusting Behaviour for Server Settings
  • Manually Passing Values to a Script
  • Hidden Form Inputs
  • Edit Records
  • Query Results Pagination
  • Create Sortable Displays
  • Understanding the HTTP Headers

Cookies and Sessions

  • Using Cookies to Store Data
  • Using Sessions to Store Data
  • Cookies and Sessions
  • Improving Session Security

Web Application Security

  • Better Form Validation Security
  • Handling HTML Elements
  • Validating Form Data by Type
  • Form Validation Using JavaScript
  • Regular Expressions (Regex)
  • Database Security and Encryption

Extended Topics

  • File Upload Handling
  • Combining PHP and JavaScript
  • Utilising Output Buffering
  • Working with the Improved MySQL Extension
  • New Features in MySQL
  • Using PEAR

Example: Content Management

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

Example: User Registration

  • Building the Templates
  • Writing the Configuration Scripts
  • Constructing the Home Page
  • User Registration
  • User Account Activation
  • Logging In and Logging Out
  • Managing Passwords

Example: E-Commerce

  • Creating the Database
  • The Admin Side
  • Create the Public Template
  • Setup the Product Catalogue
  • Deign The Shopping Cart
  • Recording Orders

Need Assistance

  • Send Email
Raising the Bar
Warning Icon Information Icon

1300 937 782 Contact us