Computer and Business Skills training

Home / PHP

PHP Training

Chicago, Los Angeles

PHP is a widely-used open source scripting language used to build database driven websites.

No minimum class size - all classes guaranteed to run!

We specialize in face-to-face instructor-led PHP training. Our instructors are experienced Web developers.

Onsite training available countrywide.

Course summary

PHP Web Development

On this hands-on PHP course you will learn to build a database driven website. You will learn the basics of PHP, SQL (a language used to query a database) and MySQL.

3 Days | $1495.00

Book this course

View class timetable View past student reviews

What's Included

Certificate of Course Completion
Training Manual
FREE Class Repeat

Detailed course outline

  • Installation
    • Windows Installation
    • Installing MySQL
    • Installing PHP
    • Linux Installation
    • Mac OS X Installation
    • Post-Installation Setup Tasks
    • If Your Web Host Provides PHP and MySQL
    • Your First PHP Script
  • Getting Started with MySQL
    • An Introduction to Databases
    • Logging On to MySQL
    • So what's SQL?
    • Creating a Database
    • Creating a Table
    • Inserting Data into a Table
    • Viewing Stored Data
    • Modifying Stored Data
    • Deleting Stored Data
  • Getting Started with PHP
    • Introducing PHP
    • Basic Syntax and Commands
    • Variables and Operators
    • Arrays
    • User Interaction and Forms
    • Control Structures
    • Multipurpose Pages
  • Publishing MySQL Data on the Web
    • A Look Back at First Principle
    • Connecting to MySQL with PHP
    • Sending SQL Queries with PHP
    • Handling SELECT Result Sets
    • Inserting Data into the Database
    • A Challenge
  • Relational Database Design
    • Giving Credit where Credit is Due
    • Rule of Thumb: Keep Things Separate
    • Dealing with Multiple Tables
    • Simple Data Relationships
    • Many-to-Many Relationships
  • A Content Management System
    • The Front Page
    • Managing Authors
    • Deleting Authors
    • Adding Authors
    • Editing Authors
    • Magic Quotes
    • Managing Categories
    • Managing Jokes
    • Searching for Jokes
    • Adding Jokes
    • Editing and Deleting Jokes
  • Content Formatting and Submission
    • Out with the Old
    • Regular Expressions
    • String Replacement with Regular Expressions
    • Boldface and Italic Text
    • Paragraphs
    • Hyperlinks
    • Matching Tags
    • Splitting Text into Pages
    • Putting it all Together
    • Automatic Content Submission
  • MySQL Administration
    • Backing up MySQL Database
    • Standard Backups Aren't Enough
    • Database Backups using mysqldump
    • Incremental Backups using Update Logs
    • MySQL Access Control
    • Using GRANT
    • Using REVOKE
    • Access Control Tips
    • Locked Out?
    • Checking and Repairing MySQL Data Files
  • Advanced SQL
    • Sorting SELECT Query Results
    • Setting LIMITs
    • LOCKing TABLES
    • Column and Table Name Aliases
    • GROUPing SELECT Results
    • LEFT JOINs
    • Limiting Results with HAVING
  • Advanced PHP
    • Server-Side Includes with PHP
    • Increasing Security with Includes
    • Semi Dynamic Pages
    • Handling File Uploads
    • Assigning Unique File Names
    • Recording Uploaded Files in the Database
    • Email in PHP
  • Storing Binary Data in MySQL
    • Binary Column Types
    • Storing Files
    • Viewing Stored Files
    • The Complete Script
    • Advanced Considerations
    • MySQL Packet Size
    • PHP Script Timeout
  • Cookies and Sessions in PHP
    • Cookies
    • PHP Sessions
    • A Simple Shopping Cart

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

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.

Other Cities

Request onsite training quote

Los Angeles

915 Wilshire Blvd
Los Angeles
CA 90017View Map

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.

Choosing the right class

Recent student feedback

5.0 stars Chris was a great instructor. He basically geared the class to our level of knowledge which kept us challenged, but not lost throughout the whole class. This is the best development course I have ever taken.
5.0 stars This is the first time that my company is using your company as a vendor. But hey, I already told my admin officer that your company do offer a lot of other trainings that we used to send people to else where. why not just see if your computer offer same type of class and have it here especially it is located in the same building which can save money to send people out for training, travel, hotel, etc. I will be taking MS-Excel/Powerpoint training classes next year. I will pick your company again as I love it. Especially I am the type who do not like to travel elsewhere. I would like to get to go home everyday to see my 2 lovely girls. The training center is nice and neat and clean. Very well equiped.
4.8 stars Oliver was excellent. He's honestly an amazing teacher and I was EXTREMELY impressed with him. I'd love to take another class with him.
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, NY

How to Register

Register here

Why train with us?

4.7 / 5

based on 171 reviews

Need Group training quotation? Fresh Starbucks brewed every day FREE Class Repeat with each course

Some of our clients who trust us with their training needs


Founded in 2006, Training Connection is a traditional computer
and business skills training company. We believe that learning
from a live trainer is the most effective way to learn! Our training
centers are located in Chicago and Los Angeles and we deliver
all our courses onsite countrywide.
All rights reserved. Copyright 2006-2015.





Google Plus

230 W Monroe Street, Suite 610
Chicago IL, 60606

Los Angeles

Google Plus

915 Wilshire Blvd, Suite 1800
Los Angeles CA, 90017

# # # # # # # # # # # # # # # # #