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

5.0 stars 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.
4.6 stars I was so impressed with the level of detail in this course, but also the personalization. My instructor did a great job of tailoring examples & content to fit my individual work. Enjoyed the whole class; thanks so much!
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
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.

How to Register

Register here

Why train with us?

4.7 / 5

based on 170 reviews

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