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.

Timetable

Chicago

230 W Monroe St
#610
Chicago
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
#1800
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

"Chris was an excellent teacher. He was knowledgeable, delivered information clearly, was patient, friendly, and I was happy with the course. I learned a lot, and was happy to see Chris adjust the class for our various levels of knowledge." Martin Bhatia - Paw Naturals

"Chris was able to take a project that I am working on and use it as the model for teaching the entire class, while at the same time hitting on all of the appropriate course material. It was an awesome experience." Rod Sampson - Fuji America Corporation

"This was by far one of the best classes I have ever taken. The instructor (Chris) was very well-informed and engaging. It was informative and fun. Thank you so much for a wonderful experience." Craig Hawley - Grumman/Butkus Associates

Student sign-ins

 

How to register

Register here

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