PHP & MySQL Bootcamp

PHP & MySQL Classes NYC

Add Back-End Functionality with PHP & MySQL

So you’re comfortable making static web pages, but now you want to have your site actually do something? PHP and MySQL unlock the dynamic power of the web allowing you to create pages that interact with customers, collect and display information from a database, send emails, and more.

Learn PHP & MySQL Fundamentals

This training introduces you to PHP and MySQL, giving you a fundamental understanding of those two building blocks of dynamic websites.

We’ll show you how to work with forms, sanitize user input for security, send emails, work with cookies to collect information on your users and upload files. You’ll interact with databases using SQL to fetch, insert, update, delete, and search records. You’ll learn how to use phpMyAdmin to create databases and tables, as well as data-typing and indexes.

What is PHP?

PHP is the web’s most popular server-side scripting language. Huge sites like Facebook, Wikipedia, Baidu, Tumblr and more run on it as it is fast, free, stable, and feature-rich. PHP can help bring your website to life, changing it from a static HTML-only experience to a two-way interactive user experience. PHP is the backbone of many web related activities that we take for granted, such as handling form submissions, powering e-commerce transactions, and interacting with a database.

In addition many of the most popular CMS (Content Management Systems) such as WordPress, Drupal, and Joomla are written in PHP. Understanding this language will enable you to have a deeper understanding of these web tools making them easier to customize for your needs.

What is MySQL?

What database is nearly always paired with PHP? MySQL. MySQL is the world’s most popular open source database. Your database can store customer information, product information, and much, much more. Together PHP and MySQL are available for free on nearly every host.

Prerequisite: Solid understanding of HTML, but you don’t need to have prior programming experience. Please note that to run a local server on each machine we use XAMPP (Free) for the PC and MAMP Pro ($69) for the Mac.

18 Hours
Mac or PC provided
Book included
Free retake

Register for a class

$975 Discounts • Policies

594 Broadway, NYC or Live Online

What You’ll Learn

Use PHP to bring websites to life, turning static HTML into a two-way, user-interactive experience
Get an introduction to the basics of PHP and MySQL
Understand how PHP & MySQL can be used to handle form submissions, interact with databases, and more
Gain a solid foundation of how PHP works, including working with forms, sessions, and more
Learn the basics of MySQL, using SQL to fetch, insert, update, delete, and search records

View full syllabus

PHP & MySQL Bootcamp Class Syllabus

What You’ll Learn

Section 1

Basic PHP Syntax

Topics

Echo, Strings, and Variables
Single Quotes vs. Double Quotes
Escaping Characters
Heredoc
Concatenation
Comments

Working with Numbers

Topics

Arithmetic Operators
Assignment Operators
Table of Arithmetic Operators
Table of Assignment Operators
Defining a Site and Testing Server in Dreamweaver

Conditionals

Topics

If/Else
Elseif
Switch
Comparison Operators
Logical Operators
The Difference Between == and ===

Section 2

Arrays

Topics

Creating a simple array
Using array()
Multidimensional Arrays
Printing an Entire Array Using print_r()

Loops

Topics

While Loops
Do...While
For Loops
ForEach
Break Out of Loop
Continue

Working with Strings

Topics

Comparing Strings
Converting to Upper and Lower Case
Searching Through Strings
Case-Sensitive and Case-Insensitive

Section 3

Form Basics and Security

Topics

Post vs. Get
Radios, Checkboxes, and Select Fields
Magic Quotes
Securing the page
Using Functions

Sending Email

Topics

Setting Up MAMP Pro
Setting Up XAMPP and Mercury Mail
Sending a Test Email

Simple Form Validation and Email

Topics

Sanitizing Input
Error Checking
Displaying Errors
Sending Email
Adding a Thank You Page
Including Files

Section 4

Cookies

Topics

Adding Cookies
Tracking the Number of Visits
Sending an Email with the Cookie Info

Sessions

Topics

Starting a Session
Using Session Variables
Log In/Log Out
Destroying Session Variables

File Uploads

Topics

Making a File Upload Form
The $_FILES Array
Uploading Files
Basic Security

Section 5

Creating a Database/MySQL/SELECT

Topics

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

Topics

Error Checking
Making an Include
Sorting Results

Prepared Statements

Topics

Selecting and Filtering Results
Preventing SQL Injection Attacks with Prepared Statements

Section 6

SQL: Insert

Topics

The INSERT Statement
Using phpMyAdmin
Inserting Information from a Form

SQL: Update

Topics

The UPDATE Statement
Update Form
Display Data in the Update Form
Display Checkboxes
Hidden Fields

SQL: Delete

Topics

The DELETE Statement
Deleting Rows from a Database
Passing ID Variables in a URL

SQL: Search

Topics

Wildcard Searches
Searching with a Form

Create Dynamic Websites

This 18-hour course is one of the final classes included in the Web Development Certificate. Gain back-end coding experience as you learn from professsional web developer instructors. You’ll get our custom PHP & MySQL training workbook used by universities and institutions around the world, as well as a free retake within six months of taking the course.

“This class was a fantastic overview of PHP. After working in Front End development for many years and touching PHP and working with databases, this course really helped piece it all together for me. I only wish I had taken it sooner. The speed and topic coverage was just perfect, and the book is a great resource that I can use to refresh at any time.”

Lynnette Colalillo

Web Developer

Learned the fundamentals of PHP
“PHP & MySQL is a great introductory class. Jeremy skillfully guided the students through the PHP syntax, SQL statements, database, form validation, and setting up the server. He took extra time to work closely with students and went the extra distance as needed, filling gaps with bonus classes including how to upload files to the server. Attend this class if you are looking to get started with PHP programming.”

William Bly

United Nations
“I went into this class knowing that I really need to get an overview of PHP. I wasn't exactly looking forward to it, but it turned out that the class was a great introduction and actually left me excited to learn more and develop my PHP skills. Thanks!”

Cathy Bechler

YAI

Completed the PHP & MySQL course
“Once again I leave a Noble class feeling like I really learned the material. This PHP class will definitely help take my web development to the next level.”

Wendell Laurent

Graphic Designer/Web Developer, New York Province Jesuits

Learned server-side scripting with PHP & using MySQL for databases

See our 2470 testimonials

Learn PHP Fundamentals

“PHP & MySQL is a great introductory class. Jeremy skillfully guided the students through the PHP syntax, SQL statements, database, form validation, and setting up the server. He took extra time to work closely with students and went the extra distance as needed, filling gaps with bonus classes including how to upload files to the server. Attend this class if you are looking to get started with PHP programming.”
William Bly, United Nations

Coders learning PHP for back-end functionality

Custom Workbook Included

“This class was a fantastic overview of PHP. After working in Front End development for many years and touching PHP and working with databases, this course really helped piece it all together for me. I only wish I had taken it sooner. The speed and topic coverage was just perfect, and the book is a great resource that I can use to refresh at any time.”
Lynnette Colalillo, Web Developer

PHP training workbook with exercises

Part of a Certificate Program

This course is included in the immersive Web Development certificate program. Take the other courses to earn a certificate!

Students graduating the Web Development Certificate program

Register for PHP & MySQL Bootcamp

$975 Discounts • Policies

594 Broadway, NYC or Live Online