Introduction to PHP and MySQL Course
(4.74 out of 5) 229 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.
Course Details
$1485 incl GST
- Duration:3 Days
- Max. Class Size:10
- Avg. Class Size:5
-
Study Mode:
Classroom Online Live
- Level:Beginner
- 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
| 01 - 03 Jul 24 | Mon - Wed | Online Live |
| 21 - 23 Aug 24 | Wed - Fri | Online Live |
| 14 - 16 Oct 24 | Mon - Wed | Online Live |
| 11 - 13 Dec 24 | Wed - Fri | Online Live |
| 03 - 05 Feb 25 | Mon - Wed | Online Live |
| 26 - 28 Mar 25 | Wed - Fri | Online Live |
Melbourne Class Dates
Level 12, 379 Collins Street, Melbourne , VIC 3000
| 01 - 03 Jul 24 | Mon - Wed | Online Live |
| 21 - 23 Aug 24 | Wed - Fri | Online Live |
| 14 - 16 Oct 24 | Mon - Wed | Online Live |
| 11 - 13 Dec 24 | Wed - Fri | Online Live |
| 03 - 05 Feb 25 | Mon - Wed | Online Live |
| 26 - 28 Mar 25 | Wed - Fri | Online Live |
Brisbane Class Dates
Level 6, 371 Queen Street, Brisbane , QLD 4000
| 01 - 03 Jul 24 | Mon - Wed | Online Live |
| 21 - 23 Aug 24 | Wed - Fri | Online Live |
| 14 - 16 Oct 24 | Mon - Wed | Online Live |
| 11 - 13 Dec 24 | Wed - Fri | Online Live |
| 03 - 05 Feb 25 | Mon - Wed | Online Live |
| 26 - 28 Mar 25 | Wed - Fri | Online Live |
Canberra Class Dates
All courses facilitated in, Online Live format ,
| 01 - 03 Jul 24 | Mon - Wed | Online Live |
| 21 - 23 Aug 24 | Wed - Fri | Online Live |
| 14 - 16 Oct 24 | Mon - Wed | Online Live |
| 11 - 13 Dec 24 | Wed - Fri | Online Live |
| 03 - 05 Feb 25 | Mon - Wed | Online Live |
| 26 - 28 Mar 25 | Wed - Fri | Online Live |
Adelaide Class Dates
All courses facilitated in, Online Live format ,
| 01 - 03 Jul 24 | Mon - Wed | Online Live |
| 21 - 23 Aug 24 | Wed - Fri | Online Live |
| 14 - 16 Oct 24 | Mon - Wed | Online Live |
| 11 - 13 Dec 24 | Wed - Fri | Online Live |
| 03 - 05 Feb 25 | Mon - Wed | Online Live |
| 26 - 28 Mar 25 | Wed - Fri | Online Live |
Perth Class Dates
All courses facilitated in, Online Live format ,
| 01 - 03 Jul 24 | Mon - Wed | Online Live |
| 21 - 23 Aug 24 | Wed - Fri | Online Live |
| 14 - 16 Oct 24 | Mon - Wed | Online Live |
| 11 - 13 Dec 24 | Wed - Fri | Online Live |
| 03 - 05 Feb 25 | Mon - Wed | Online Live |
| 26 - 28 Mar 25 | Wed - Fri | Online Live |
Course Units
⊕ Expand full topic list
Unit 1: Setting Up the PHP Development Environment
- 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)
⊕ See more
Unit 2: Understanding PHP: Language Basics
- 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
⊕ See more
Unit 3: Passing Information with PHP
- Superglobal Arrays
- Variable Scope
- $GLOBALS
- $_SERVER
- $_GET
- Accessing URL Variables
- $_POST
- $_REQUEST
- $_FILES
- $_SESSION
- Using session_destroy()
- $_COOKIE
⊕ See more
Unit 4: Working with Databases
- 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 (*)
⊕ See more
Unit 5: Building the Entry Manager
- 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
⊕ See more
Unit 6: Adding Support for Multiple Pages
- 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
⊕ See more
Unit 7: Updating and Deleting Entries
- 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
⊕ See more
Unit 8: Adding the Ability to Upload Images
- 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
⊕ See more
Unit 9: Syndicating the Blog
- Creating an RSS Feed
- Describing Your Feed
- Creating Feed Items
- Publishing Your Feed
- Adding the Feed to the Blog
⊕ See more
Unit 10: Adding a Commenting System to Your Blog
- 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
⊕ See more
Related Courses
Course Reviews
The training course on PHP and SQL with Mark was great. I found him very knowledgeable yet considerate of the student's level of understanding. Taking time to make sure the concepts are clear and easy to digest. The content of the course is great and dives deep into the main functions of a dynamic website. Thanks to Mark I now understand PHP much better.
I really enjoyed this course, thanks Mark it was very informative and I really got a lot out of it :-). I am looking forward experimenting more with PHP.
this is a great course for people who want to learn or jumpstart there memory. Mark is a very good teacher he gets you involved if you have a problem share your screen and he will walk you through step by step on how to fix the issue
I loved it! Mark was incredible informative and really catered the education style to my own prior programming experience which really helped consolidate my understanding of the PHP and MySQL, and then assisted in answering further questions around the topic!
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.