PHP & MYSQL ADVANCED

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

Raising the Bar

1300 937 782

www.rtb.com.au

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

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