Computer and Business Skills training

Sign Up
Home / PHP Training

PHP MySQL Training

Chicago, Los Angeles

Looking for a PHP training class in Chicago or Los Angeles?

We offer hands-on PHP classes taught by experienced Web developers, who are present in the classroom.

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.

No minimum class size - all classes guaranteed to run!

You will receive the following with each PHP course:

  • PHP training manual
  • Certificate of Course Completion
  • Free repeat valid for 6 months (in case you need a refresher)

Onsite training available countrywide.

Course Summary

php logo

PHP and MySQL Web Development

This class will introduce you to the basics of PHP and MySQL. You will start from the ground up, learning PHP syntax, conditional statements, arrays, loops, strings, functions etc. You will work with forms, sanitize user input for security, send emails, work with cookies to collect information, and upload files. You will use phpMyAdmin to build your database and tables and write SQL queries to fetch, insert, update, delete, and search records.

3 Days | $1495.00

Book this course

Class Timetable

Past Student Reviews

What's Included

Certificate of Course Completion
Training Manual
FREE Class Repeat

Detailed course 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

  • Form Basics and Security

In this exercise, we will cover the basics of PHP form submission. You will learn the difference between POST and GET, how to deal with radio buttons, checkboxes, and select fields, and how to secure your pages from attacks.

    • Setting up a basic form
    • Post vs. Get
    • Radios, Checkboxes, and Select Fields
    • Magic Quotes
    • Securing the page

  • 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.



230 W Monroe St
IL 60606View Map

  • PHP and MySQL Web Development
  • Jan 29 - 31Book
  • Mar 30 - Apr 1Book
  • Jun 1 - 3Book

Guaranteed to Run Limited Seats Left

Class times: 9.00am to 4.30pm

Servicing Arlington Heights, Aurora, Bollingbrook, Chicago Loop,
Deerfield, Des Plaines, Evanston, Highland Park, Joliet, Naperville,
Schaumburg, Skokie, South Chicago and surrounding areas.

Los Angeles

915 Wilshire Blvd
Los Angeles
CA 90017View Map

  • PHP and MySQL Web Development
  • Feb 10 - 12Book
  • Apr 20 - 22Book
  • Jun 15 - 17Book

Guaranteed to Run Limited Seats Left

Class times: 9.00am to 4.30pm

Servicing Anaheim, Burbank, Covina, Downtown, Fullerton,
Irvine, Long Beach, Northridge, Pasadena, San Bernardino,
Santa Monica, Van Nuys, Ventura and surrounding areas.

Other Cities

Request onsite training quote

Choosing the right course

Recent student feedback

4.6 stars This class was thorough, and challenging. The topic, PHP and MySQL, can be quite difficult to understand. However our instructor, Chris, did a great job of providing real world knowledge, and we catered the scope of the class to an actual PHP site we were considering building. I would recommend this class to anyone wishing to "get their feet wet" and provide a good foundation for further learning of the PHP and MySQL language. Dan Uhle
School District 69
5.0 stars Another great PHP experience with Chris. He always takes the extra time to make sure I understand what is going on and why something is being done a certain way. Will definitely be back! Thanks.Mike White
4.6 stars This course was a great help even with my knowledge of PHP. Although I understood some of the fundamentals of the program, this class brought it all together and filled in pieces of knowledge that I was missing. Chris is a great instructor. I enjoyed how he transitioned from PHP & MySQL and how they relate, interact and compliment each other. He is able to interact with his students and allow them to engage in the classroom while at the same time creating a very comfortable learning environment. He took the time to answer all of my questions and was very thorough in his answers. I'd definitely take a class from him again. Alanys New York, NYAlanys Gazapo
4.9 stars For anyone looking to advance their knowledge in web development, Training Connection is the place to start. I wanted to supplement my web design knowledge with PHP/mysql training. Chris, the instructor, took the class step-by-step through the process of a data-based driven website. There was no rushing material, overloading, or pressure of retention of data. I've had some programming in C++ and java and this course filled in the gaps. Fast connecting computers made sorting back and forth through files a breeze. I can't wait to start my CSS class to continue my path of knowledge with Training Connection. Stephen Thomas - Ocean Blue DesignsStephen Thomas

How to Register

Register here

Why train with us?

4.7 / 5

based on 201 reviews

Fresh Peet's Coffee brewed every day FREE Class Repeat with each course