• Search
  • Cart
  • Courses

Introduction to PHP and MySQL

(4.73 out of 5) 213 Student Reviews

About the Course

During this 3 day course, participants will step through how to build an entire dynamic website, ensuring that they have the necessary experience, skills and confidence to build a dynamic website later on. Students will learn how to install and configure the Apache, PHP, and MySQL software, and write commands in Structured Query Language (SQL) to query and modify the MySQL database. Other topics include gathering and processing information from forms, file uploading, relational database design and password-protection.

Who should do this course?

This course is intended for anyone looking to create code a database-driven website using PHP and MySQL.

Prerequisites

Participants should have already completed the HTML and CSS courses and have good understanding of these technologies prior to attending this course or have the equivalent experience with HTML and CSS.

Quick Facts

$ 1485 incl GST

Duration: 3 Days

Max. Class Size: 10

Avg. Class Size: 5

Level: Beginner

Times: 9.00am to 5.00pm approx

Course Dates

09-11 Aug 17Wed - Fri

04-06 Oct 17Wed - Fri

20-22 Nov 17Mon - Wed

17-19 Jan 18Wed - Fri

26-28 Feb 18Mon - Wed

Address

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

View map

Click Here external link for Google Map

12-14 Jul 17Wed - Fri

28-30 Aug 17Mon - Wed

11-13 Oct 17Wed - Fri

29 Nov - 01 Dec 17Wed - Fri

17-19 Jan 18Wed - Fri

More Dates

Address

Level 12
379 Collins Street,
Melbourne , VIC 3000

View map

Click Here external link for Google Map

23-25 Aug 17Wed - Fri

14-16 Nov 17Tue - Thu

07-09 Feb 18Wed - Fri

30 Apr - 02 May 18Mon - Wed

25-27 Jul 18Wed - Fri

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: Setting Up the PHP Development Environment

See topics

  • Introduction to Apache, MySQL, and PHP
  • Stable/Production vs. Development Releases
  • Understanding How PHP Works
  • Server-Side vs. Client-Side Scripting
  • Installing PHP, Apache, and MySQL (the Hard Way)

Unit 2: Understanding PHP: Language Basics

See topics

  • Embedding PHP Scripts
  • Alternative Delimiters
  • Variables and Datatypes
  • Storing Values in a Variable
  • Understanding Strings
  • Understanding Integers
  • Understanding Floating Point Numbers
  • Understanding Boolean Values
  • Understanding Arrays
  • Sending Data to the Browser as Output
  • The print() Statement
  • The echo() Statement
  • The printf() Statement
  • The sprintf() Statement
  • Commenting Your Code
  • Understanding Arithmetic Operators
  • Understanding Arithmetic Assignment Operators
  • Understanding Comparison Operators
  • Understanding Error Control Operators
  • Understanding Incrementing/Decrementing Operators
  • Understanding Logical Operators
  • Understanding String Operators
  • Control Structures
  • Returning Values from Functions

Unit 3: Passing Information with PHP

See topics

  • Superglobal Arrays
  • Variable Scope
  • $GLOBALS
  • $_SERVER
  • $_GET
  • Accessing URL Variables
  • $_POST
  • $_REQUEST
  • $_FILES
  • $_SESSION
  • Using session_destroy()
  • $_COOKIE

Unit 4: Working with Databases

See topics

  • The Basics of MySQL Data Storage
  • Manipulating Data in MySQL Tables
  • Creating and Deleting Databases
  • Deleting Databases Using DROP
  • Creating Databases Using CREATE
  • The CREATE TABLE Statement
  • Data Types in MySQL
  • Understanding PRIMARY KEY
  • Understanding AUTO_INCREMENT
  • Indexes in MySQL
  • The INSERT Statement
  • The SELECT Statement
  • The UPDATE Statement
  • The JOIN Statement
  • The DELETE Statement
  • Opening a Connection
  • PHPís MySQL Extension
  • The MySQLi Extension
  • Using Prepared Statements
  • Using MySQLi
  • Using Prepared Statements with MySQLi
  • PHP Data Objects (PDO)
  • Understanding Table Structure
  • Planning Database Tables
  • The Shortcut Selector (*)

Unit 5: Building the Entry Manager

See topics

  • Planning the Entry Database Table
  • Creating the Entry Input Form
  • Create a Script to Process the Form Input
  • Performing the Initial Verification
  • Connect to the Database
  • Keeping Database Credentials Separate
  • Connecting to the Database in update.inc.php
  • Save the Entry to the Database
  • Retrieve the Entryís Unique ID and Display the Entry to the User
  • Displaying the Saved Entries
  • Planning Your Scripts
  • Separation of Logic in Programming
  • Mapping Your Functions to Output Saved Entries
  • Writing the Database Functions
  • Writing the Business Function
  • Writing the Presentation Code

Unit 6: Adding Support for Multiple Pages

See topics

  • Add a page Column to the entries Table
  • Modify Your Functions to Accept Page Parameters
  • Accepting Page Information in the URL
  • Using the Page Information to Filter Entries
  • Modifying admin.php to Save Page Associations
  • Saving Page Associations
  • Using .htaccess to Create Friendly URLs
  • Creating Your .htaccess File
  • Creating Friendly URLs Automatically
  • Adding a Menu
  • Creating Different Viewing Styles for the Pages

Unit 7: Updating and Deleting Entries

See topics

  • Creating Administrative Links
  • Displaying Administrative Links
  • Passing URL Values to admin.php with .htaccess
  • Modifying the Original Admin Rule
  • The New Admin Rule
  • Populating Your Form with the Entry to Be Edited
  • Updating Entries in the Database
  • Handling Entry Deletion
  • Confirming Your Choice to Delete an Entry
  • Handling Your Submitted Confirmation Form
  • Removing Deleted Entries from the Database

Unit 8: Adding the Ability to Upload Images

See topics

  • Adding a File Input to the Admin Form
  • Accessing the Uploaded File
  • A Quick Refresher on the $_FILES Superglobal Array
  • Writing the Image Handling Class
  • Saving the Image
  • Checking for Errors Using Exceptions
  • Saving the File
  • Modifying update.inc.php to Save Images
  • Using try...catch with Exceptions
  • Creating a New Folder
  • Renaming the Image
  • Determining the File Extension
  • Storing and Retrieving Images from the Database
  • Adding a Function to Format Images for Output
  • Resizing Images

Unit 9: Syndicating the Blog

See topics

  • Creating an RSS Feed
  • Describing Your Feed
  • Creating Feed Items
  • Publishing Your Feed
  • Adding the Feed to the Blog

Unit 10: Adding a Commenting System to Your Blog

See topics

  • Creating a comments Table in the Database
  • Building a Comments Class
  • Building the Comment Entry Form
  • Storing New Comments in the Database
  • Retrieving All Comments for a Given Entry
  • Displaying Comments for a Given Entry
  • Deleting Comments

Packages

Web Developer Package

$ 3630 incl GST

(You save $1320)

Duration

10 days

Reviews

(4.70 out of 5) Chris U [ 27 February, 2017 ]
Very informative course and covered a lot of material. Students should definitely have an appreciation of basic coding techniques prior to attending this course.
(5.00 out of 5) Thompson [ 27 February, 2017 ]
Well structured and thorough course into PHP and MySQL. The content was delivered extremely well and the use of relevant and/or practical examples to demonstrate the concepts made this course easy to pick up whilst also allowing immediate application of learnt knowledge back in the workplace. I would highly recommend this course because something it does better than the internet is to filter out the bad coding practices and ensure you know how to write PHP efficiently and correctly.

See more reviews

(4.90 out of 5) Chandan P [ 07 November, 2016 ]
Its very helpful for beginners. Full hands on type training which is more beneficial than powerpoint presentation.
(5.00 out of 5) Mitchell M [ 10 February, 2016 ]
Excellent course. From someone who has a very basic programming knowledge, the course developed my understanding further. Recommend for other students. Highly recommend Mark has the course teacher.

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