Yelp Facebook LinkedIn YouTube Twitter Instagram

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.

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.

Read more
  • Small Classes
  • Computer Provided
  • Book included
  • Free Retake

Register for a Class
  • $975
  • 18 Hours
  • Mac or PC
  • 185 Madison Ave, NYC or live online
  • FAQ •
  • 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.

    Payment Plan

    This course is not eligible for a payment plan, which is only available for programs priced at $2,495 and above. Read our Payment Plan FAQ for more details.

    Take this course as part of a certificate program and save:
  • • Policies

Corporate training available

Email

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

  • “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

See our 2,656 testimonials
5
4.9
4.9

Frequently Asked Questions

  • Are there prerequisites? Do I need to come in with any prior coding knowledge?

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

  • 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.

  • Do you offer discounts or a payment plan 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.

    Payment Plan

    This course is not eligible for a payment plan, which is only available for programs priced at $2,495 and above. Read our Payment Plan FAQ for more details.

    Take this course as part of a certificate program and save:

  • 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!
Coders learning PHP for back-end functionality

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

PHP training workbook with exercises

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

Students graduating the Web Development Certificate program

Part of a Certificate Program

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

Related Classes & Certificates

Python for Web Development Bootcamp

30 Hours

$1595

More details

Ruby on Rails Bootcamp

60 Hours

$2495

More details

Front-End Web Development Certificate

72 Hours

$2995

More details
See all related Web Development classes

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.