PHP & MySQL Training

Online or in-person classes

Looking for a PHP class?

We offer hands-on PHP classes taught by live instructors.

PHP is the Web's most popular server-side scripting language. It is fast, stable, feature-rich and free to use.

PHP can help bring your website to life, changing it from a static HTML experience to a two-way interactive user experience.

Satisfaction Guaranteed

What's Included

  • PHP training manual
  • Certificate of Course Completion
  • Small class size (avg 2-3 trainees)
  • FREE repeat class valid for 12 months

View our Covid-19 Protocols
Onsite PHP training available countrywide.

Book Course Group Training

Detailed Course Outline

PHP and MySQL Web Development

PHP and MySQL Web Development

This JavaScript class is suitable for beginners. You will learn how to create better user experiences by adding interactive elements for your Web pages. This class will introduce you to JavaScript syntax, before delving into jQuery the World's most popular JavaScript library.

Book this course Download PDF TimeTable
3 Days $1495

Detailed Course Outline Hide outline

Basic PHP Syntax
This exercise gets you started with the basics of PHP syntax. If you don't have previous programming experience, you will find that PHP is pretty simple to learn.
  • Echo, Strings, and Variables
  • Single Quotes vs. Double Quotes
  • Escaping Characters
  • Heredoc
  • Concatenation
  • Comments
Working with Numbers
In this exercise, we will show you how PHP works with numbers.
  • Arithmetic Operators
  • Assignment Operators
  • Table of Arithmetic Operators
  • Table of Assignment Operators
  • Defining a Site and Testing Server in Dreamweaver
Conditionals
Conditional operators will be one of the most-used elements of your programming life. Simply put, conditional operators are a way to choose when certain things happen. For example, if something is true, then do something. If it is not true, do something else.
  • If/Else
  • Elseif
  • Switch
  • Comparison Operators
  • Logical Operators
  • The Difference Between == and ===
Arrays
One of the most common and powerful types of variables is called an array. There are many ways you can create, output, and manipulate arrays, but here we will just focus on some of the most commonly-used basics.
  • Creating a simple array
  • Using array()
  • Multidimensional Arrays
  • Printing an Entire Array Using print_r()
Loops
Loops are an incredibly important and often-used element of your programming tool belt. Here we will explore the many kinds of loops PHP has to offer.
  • While Loops
  • Do...While
  • For Loops
  • ForEach
  • Break Out of Loop
  • Continue
Working with Strings
Let’s explore some basic string functions.
  • Comparing Strings
  • Converting to Upper and Lower Case
  • Searching Through Strings
  • Case-Sensitive and Case-Insensitive
Functions & Objects
In this exercise, you will learn the basics of functions and how to use arguments within them. We will go over how to create objects with properties and methods. We will explore the differences between public and private properties, and how to extend classes' functionality.
  • Functions
  • Arguments
  • Objects and Properties
  • Objects and Methods
  • Private Properties
  • Creating Classes that Extend Classes
Sending Email
One of the great things about PHP is how easy it is to send an email. In this exercise we will show you how to set up MAMP Pro or XAMPP to send test emails.
  • Setting Up MAMP Pro
  • Setting Up XAMPP and Mercury Mail
  • Sending a Test Email
Simple Form Validation and Email
This exercise will focus on a very simple form validation script that checks for simple errors, sanitizes input, and sends an email.
  • Sanitizing Input
  • Error Checking
  • Displaying Errors
  • Sending Email
  • Adding a Thank You Page
  • Including Files
Cookies
Every website should use analytics to track where visitors come from and find information such as their landing page, how many times they have visited, where they came from, etc. and store it in a cookie.
  • Adding Cookies
  • Tracking the Number of Visits
  • Sending an Email with the Cookie Info
Sessions
In this exercise we will create a simple login/logout application where we make a few pages password-protected.
  • Starting a Session
  • Using Session Variables
  • Log In/Log Out
  • Destroying Session Variables
File Uploads
In this exercise we will show you some very basic security measures as well as how to upload files. If you add this type of capability on your live site, it should be in a password-protected area or authenticated in some way.
  • Making a File Upload Form
  • The $_FILES Array
  • Uploading Files
  • Basic Security
Creating a Database/MySQL/SELECT
In this exercise, you’ll learn how to create a database in the phpMyAdmin control panel, as well as how to connect to a database and display some data.
  • Creating a New Database
  • Connecting to the Database
  • SQL Basics
  • The SELECT Statement
  • Display the Number of Rows Returned
  • Making a Reusable Connection Script
  • MySQL vs. MySQLi vs. PDO
Making a Reusable Connection Script
Because we will be connecting to the same database from several webpages, it makes sense to save the connection script into another page. That way, we can just include it at the top of any page that needs to connect to the database.
  • Error Checking
  • Making an Include
  • Sorting Results
Prepared Statements
In this exercise we are going to show how to select a certain row of data in a database. We will select all the records in the database that are equal to a certain email.
  • Selecting and Filtering Results
  • Preventing SQL Injection Attacks with Prepared Statements
SQL: Insert
Interacting with a database wouldn't be much use if we couldn't add data to it. Here you will learn how to insert records into a database using prepared statements.
  • The INSERT Statement
  • Using phpMyAdmin
  • Inserting Information from a Form
SQL: Update
This exercise will show you the SQL syntax for updating a record in a database as well as how to use a form to update user information including checkboxes and hidden fields.
  • The UPDATE Statement
  • Update Form
  • Display Data in the Update Form
  • Display Checkboxes
  • Hidden Fields
SQL: Delete
This exercise shows you how to delete records from a database.
  • The DELETE Statement
  • Deleting Rows from a Database
  • Passing ID Variables in a URL
SQL: Search
There are an enormous number of ways to search for information in a database. We will show how to perform a basic wildcard search on a column.
  • Wildcard Searches
  • Searching with a Form
Basic PHP Syntax
This exercise gets you started with the basics of PHP syntax. If you don't have previous programming experience, you will find that PHP is pretty simple to learn
  • Echo, Strings, and Variables
  • Single Quotes vs. Double Quotes
  • Escaping Characters
  • Heredoc
  • Concatenation
  • Comments
Working with Numbers
In this exercise, we will show you how PHP works with numbers.
  • Arithmetic Operators
  • Assignment Operators
  • Table of Arithmetic Operators
  • Table of Assignment Operators
  • Defining a Site and Testing Server in Dreamweaver
Conditionals
Conditional operators will be one of the most-used elements of your programming life. Simply put, conditional operators are a way to choose when certain things happen. For example, if something is true, then do something. If it is not true, do something else.
  • If/Else
  • Elseif
  • Switch
  • Comparison Operators
  • Logical Operators
  • The Difference Between == and ===
Arrays
One of the most common and powerful types of variables is called an array. There are many ways you can create, output, and manipulate arrays, but here we will just focus on some of the most commonly-used basics.
  • Creating a simple array
  • Using array()
  • Multidimensional Arrays
  • Printing an Entire Array Using print_r()
Loops
Loops are an incredibly important and often-used element of your programming tool belt. Here we will explore the many kinds of loops PHP has to offer.
  • While Loops
  • Do...While
  • For Loops
  • ForEach
  • Break Out of Loop
  • Continue
Working with Strings
Let’s explore some basic string functions.
  • Comparing Strings
  • Converting to Upper and Lower Case
  • Searching Through Strings
  • Case-Sensitive and Case-Insensitive
Functions & Objects
In this exercise, you will learn the basics of functions and how to use arguments within them. We will go over how to create objects with properties and methods. We will explore the differences between public and private properties, and how to extend classes' functionality.
  • Functions
  • Arguments
  • Objects and Properties
  • Objects and Methods
  • Private Properties
  • Creating Classes that Extend Classes
Sending Email
One of the great things about PHP is how easy it is to send an email. In this exercise we will show you how to set up MAMP Pro or XAMPP to send test emails.
  • Setting Up MAMP Pro
  • Setting Up XAMPP and Mercury Mail
  • Sending a Test Email
Simple Form Validation and Email
This exercise will focus on a very simple form validation script that checks for simple errors, sanitizes input, and sends an email.
  • Sanitizing Input
  • Error Checking
  • Displaying Errors
  • Sending Email
  • Adding a Thank You Page
  • Including Files
Cookies
Every website should use analytics to track where visitors come from and find information such as their landing page, how many times they have visited, where they came from, etc. and store it in a cookie.
  • Adding Cookies
  • Tracking the Number of Visits
  • Sending an Email with the Cookie Info
Sessions
In this exercise we will create a simple login/logout application where we make a few pages password-protected.
  • Starting a Session
  • Using Session Variables
  • Log In/Log Out
  • Destroying Session Variables
File Uploads
In this exercise we will show you some very basic security measures as well as how to upload files. If you add this type of capability on your live site, it should be in a password-protected area or authenticated in some way.
  • Making a File Upload Form
  • The $_FILES Array
  • Uploading Files
  • Basic Security
Creating a Database/MySQL/SELECT
In this exercise, you’ll learn how to create a database in the phpMyAdmin control panel, as well as how to connect to a database and display some data.
  • Creating a New Database
  • Connecting to the Database
  • SQL Basics
  • The SELECT Statement
  • Display the Number of Rows Returned
  • Making a Reusable Connection Script
  • MySQL vs. MySQLi vs. PDO
Making a Reusable Connection Script
Because we will be connecting to the same database from several webpages, it makes sense to save the connection script into another page. That way, we can just include it at the top of any page that needs to connect to the database.
  • Error Checking
  • Making an Include
  • Sorting Results
Prepared Statements
In this exercise we are going to show how to select a certain row of data in a database. We will select all the records in the database that are equal to a certain email.
  • Selecting and Filtering Results
  • Preventing SQL Injection Attacks with Prepared Statements
SQL: Insert
Interacting with a database wouldn't be much use if we couldn't add data to it. Here you will learn how to insert records into a database using prepared statements.
  • The INSERT Statement
  • Using phpMyAdmin
  • Inserting Information from a Form
SQL: Update
This exercise will show you the SQL syntax for updating a record in a database as well as how to use a form to update user information including checkboxes and hidden fields.
  • The UPDATE Statement
  • Update Form
  • Display Data in the Update Form
  • Display Checkboxes
  • Hidden Fields
SQL: Delete
This exercise shows you how to delete records from a database.
  • The DELETE Statement
  • Deleting Rows from a Database
  • Passing ID Variables in a URL
SQL: Search
There are an enormous number of ways to search for information in a database. We will show how to perform a basic wildcard search on a column.
  • Wildcard Searches
  • Searching with a Form

"Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class."

Call us

(888) 815-0604

STILL NEED APPROVAL?

Want to reserve a seat but you still need to obtain approval?

No problem, simply call us and we will provisionally hold a seat for you.
There is zero risk, if you don't get approval, we simply cancel the reservation.

PHP training reviews

PHP classes - 5 rating

PHP classes rating: 4.8 stars from 203 reviewers

Jeff
Chris

"I enjoyed the personal attention, as Jeff was able to clearly answer all of my specific questions. I really enjoy the facility and Jeff as my instructor."

"Jeff brought real-world experience, knowledge, and patience to his training. I learned several very useful things that I hope to implement soon. Highly recommended!"

"I've taken multiple courses here at Training Connection and I am confident in saying Jeff Wiatt is one of the best teachers in this school. His enthusiasm and passion for teaching coding to his students is unparalleled. Students feed off that and his energetic personality makes classes full of life and never dull writing countless coding lines. "

"This is my third class with Jeff and we are already talking about adding more. Another great class!!!"

View all student reviews

Free Repeat

We recognize that PHP is a complex programming language and that trainees may benefit from repeating the class. Included in your course price is a FREE Repeat valid for 6 months. Often the repeat class can be with a different trainer too.

Our Walk Away, No Hard Feelings Guarantee

Our Walk Away, No Hard FeelingsTotally Outrageous Guarantee

PHP is not for everyone. If you decided after Day 1 that the class is not for you, we will give you a full refund.

Group PHP Training

We offer group training in PHP. This can be delivered onsite at your premises, at our training center in Los Angeles, or via webinar.
Fill out the form below to receive pricing.

Step 1: Choose your Training Format

Step 2: Choose your Course/s

Step 3: Enter Details

PHP & MYSQL Training FAQ