PHP & MySQL Bootcamp NYC | Hands-on Web Development Classes

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?

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.

Please note that to run a local server on each machine we use XAMPP (Free) for the PC and MAMP Pro ($79) for the Mac.

This course has a prerequisite

Students should feel comfortable coding HTML and CSS. You should have knowledge equivalent to our Web Development Level 2 class.

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.

Highly Reviewed by Our Alumni

From our hands-on training style to world-class instructors and proprietary curriculum, we deliver a learning experience our alumni can be proud of.

PHP & MySQL Bootcamp is rated 4.7 stars

in the past 24 months

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

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

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

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
New York Province Jesuits

Noble Desktop provided me with a solid foundation of web development knowledge. Their instructors are easy to approach, and the curriculum is laid out in a logical progression that makes sense and helps you to grasp a lot of information. Thank you Noble Desktop for helping me in pursuing my next career path!

Mike St.Pierre

Learn the Skills Guarantee™

Learn the concepts and skills covered in this course or your tuition is on us. See details and terms & conditions.

Hands-on training in small groups

Work on projects proven to boost retention

Time-tested curriculum and supporting materials

Refined over many cohorts for an optimal learning experience

The teaching method at Noble Desktop is perfect and the classes provide you with infinite knowledge that makes you eager to take everything they offer. I love Noble!
—Ivonne Ackerman

Learn from industry experts with teaching experience

Experienced educators who are driven to help you succeed

Retake the course for free within one year

Refresh the materials and gain additional practice

Schedule & Enrollment: PHP & MySQL Bootcamp

18 Hours
$975

Discounts
Discounts
- 10% Alumni Discount: Get 10% off this course if you’ve previously taken any 12+ hour course.
- $100 Individuals Discount: Take $100 off this course if you’re an individual paying for yourself (you’re not being reimbursed by a company).
Discounts are applied at checkout (no promo code required) and will be verified after you place your order. Discounts are subject to change. Read our discount policies for more details.
Policies

NYC or Live Online
Free retake
Setup assistance
Expert instructors
Small classes

Course times are listed in Eastern Time.

Not currently scheduled.

Email hello@nobledesktop.com to request this course, or see related courses with upcoming availability

See related courses

Tuition

As one of our smaller courses, tuition for this course is due in full before the start date. The best way to save on this course is to take it as part of a certificate program.

Full Tuition

$975
Due before the class starts

What’s Included

18 hours of hands-on instruction
Live, project-based training from experts
Proprietary workbook included
Retake for free within 1 year
Verified digital certificate of completion
Small class sizes

What’s included with my tuition?
- A hands-on learning experience working on projects and exercises, which is proven to boost comprehension, retention, and engagement
- Expert instructors who are industry professionals and experienced educators that are driven to help you succeed
- Top-notch curricula that have been tried and tested over many cohorts and are consistently improved for an optimal learning experience
- Supplemental materials to assist both during and after the course - please refer to specific course pages to see what supplemental materials are offered
- A 1-year free retake policy which allows students to retake any part of the course or program for free to refresh the materials and gain additional practice
- A certificate of completion to verify your accomplishment
Are there any additional fees or expenses?

There are no extra fees or taxes for our courses. The price you see on this page is the maximum you’ll pay us.

However, if you plan to take the course live online, you may need to obtain required software. We’ll help you get set up with a free trial of paid software prior to the class. Most of our coding classes utilize freely-available open-source software. For most of our design and motion graphics courses, we will help you get set up with a free trial of Adobe Creative Cloud. If you attend the course in-person, we will have a computer already set up for you with all of the required software for no additional cost.
Do you offer any discounts for this course?
Discounts
- 10% Alumni Discount: Get 10% off this course if you’ve previously taken any 12+ hour course.
- $100 Individuals Discount: Take $100 off this course if you’re an individual paying for yourself (you’re not being reimbursed by a company).
Discounts are applied at checkout (no promo code required) and will be verified after you place your order. Discounts are subject to change. Read our discount policies for more details.

This Course is Available in NYC or Live Online

On Campus in NYC

185 Madison Ave, NYC

Get face-to-face interaction with an instructor and other students when you learn at our NYC campus. Courses are hands-on with a computer and software provided.

Live, interactive class
Experienced instructor in the room with you
Computer and software provided
Free retake within one year

Students seated in computer classroom with workbooks, paying attention to instructor

Live Online

Remote, from anywhere

Get the same interactivity and access to the instructor as in-person students. There are no extra fees and we’ll work with you to ensure your remote setup is perfect.

Live, interactive class
Experienced instructor teaching over Zoom
Remote setup assistance provided
Free retake within one year

Online Training Demo

1-Minute Overview

More about live online training

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

Course Syllabus

Download Syllabus PDF

Section 1

Basic PHP Syntax

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

Working with Numbers

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

Conditionals

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

Section 2

Arrays

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

Loops

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

Working with Strings

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

Section 3

Form Basics and Security

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

Sending Email

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

Simple Form Validation and Email

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

Section 4

Cookies

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

Sessions

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

File Uploads

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

Section 5

Creating a Database/MySQL/SELECT

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

Error Checking
Making an Include
Sorting Results

Prepared Statements

Selecting and Filtering Results
Preventing SQL Injection Attacks with Prepared Statements

Section 6

SQL: Insert

The INSERT Statement
Using phpMyAdmin
Inserting Information from a Form

SQL: Update

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

SQL: Delete

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

SQL: Search

Wildcard Searches
Searching with a Form

Show full syllabus

Frequently Asked Questions

Do I need to bring anything to the class?

No. We provide computers (Mac or PC) with the required software installed. Choose your operating system at checkout.
Does this course require any prior knowledge or experience?

Students should feel comfortable coding HTML and CSS. You should have knowledge equivalent to our Web Development Level 2 class.

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.
Do you offer payment plans or student financing for this course?

This course does not qualify for payments plans or student financing. See our Payment Plan FAQ to find related programs that qualify.
Can I take this course online (remote learning)?
You may attend this training virtually (online) at the scheduled time the course is offered (New York, Eastern Time).

How does attending “live online” work?
- Students can attend this training remotely through screen sharing software (we use Zoom).
- Participants can hear the instruction, ask questions, and even share their screen with the instructor.
- For audio you can use your computer’s microphone/speakers or call a phone number that we’ll provide.
- Classes are activity-based and taught by a live instructor, so we strongly encourage students who are local to the area to attend in person!
- You will need your own computer and copy of any required software. If you don’t have the software, you can usually do a free trial or purchase your own license. If you need assistance, contact us at hello@nobledesktop.com

Corporate & Onsite Training

Purchase group class vouchers at a discount for our regularly-scheduled group classes in NYC, or create a custom training program at your offices.

Private Training

Available onsite at your location
Modern computer labs available at our offices
Customize or choose from our existing courses
Free instructor consultations to finalize content

Group Class Vouchers

Send employees to our group classes
Extensive offerings and flexible scheduling
Simple billing and logistics
Computers and training resources provided

Learn the basics of PHP & MySQL for Back-end Functionality and Databasing

PHP & MySQL

PHP is a free and open source language for back-end web development. It can create web pages dynamically by interacting with a database, collect and process data from web forms, and much more.
MySQL is a popular open source database that is commonly used with PHP.

Front-End & Back-End

The front-end of websites involve coding HTML, CSS, and JavaScript that control the look and feel of a website.
The back-end of websites involve coding languages such as PHP, MySQL, Ruby on Rails, Node.js, etc. to create application-like functionality that typically interact with a database.
The front-end works in a web browser, whereas the back-end works on a web server.

HTML

To create webpages and emails we use HTML code (Hypertext Markup Language).
HTML tags mark up (label) content to indicate headings, paragraphs, lists, links, images, and more.
You can get a quick start in our 3-hour Intro to HTML & CSS class, dive deeper in our 18-hour Web Development Level 1 class, or for the most thorough training earn a Certificate in Web Design.

CSS

CSS (Cascading Style Sheets) code is used to style the contents of a webpage (or email), based on the HTML markup.
CSS controls the appearance of everything, from fonts and color, to building responsive page layouts that look good across screen sizes (mobile, tablet, and desktop).
Start learning CSS in our Web Development Level 1 class. Dive deeper in our Web Development Level 2 class where we cover many important CSS concepts, such as media queries. Learn more advanced ways to optimize for mobile devices and building responsive pages in our Mobile & Responsive Web Design class. The classes can be taken individually, or as part of our Web Design Certificate program.