Win a Free Class!

Join our email list for a chance to win

PHP & MySQL

Dynamic Websites & Databasing

PHP is the web’s most popular server-side scripting language. Huge sites like Yahoo, Wikipedia, Flickr, Digg, Vimeo, 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.

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

This class will introduce you to the basics of PHP and MySQL. We’ll start from the ground up, building a solid foundation of how PHP works, thus allowing you to tackle your own projects and applications. 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.

This class assumes that you have a 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 ($59) for the Mac.

Upcoming Classes

Price: $975 Click for Discounts

  • 18 hours of Hands-On Training
  • Custom Written Workbook Included
  • Mac or PC
  • In New York City and Live Online

We Literally Wrote the Book!

Php black v2

To make the perfect class we had to write our own workbooks which are included with each class.

Can’t take a class? Our workbooks are the next best thing.

Buy Workbook

Other Related Classes

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

Why Train With Noble?

27 Years of Experience

Noble Desktop has been teaching computer graphics and web development since 1991. In all those years we have perfected the craft of teaching. If students get hung up on any issue, we tweak the class to make it work better. Every instructor uses the same time-tested curriculum we have developed. Ask around: Noble Desktop has a stellar reputation for exceptional computer graphics training.

Our Teaching Method is Better

We don't ask you to simply "follow along," copying what the instructor does. Instead we ask you to focus 100% attention on the lesson at hand. Only after the lesson do you then put into practice what you have learned by working on a computer with our step-by-step workbooks. This "learn, then practice" method results in the student learning and retaining much more than traditional "follow along" classes.

We Wrote the Book Ourselves

Most of our classes include a custom training workbook written by our top instructors. Take it home with you: with step-by-step exercises and power-user keyboard shortcut guides, it’s like having a refresher course right on your desk. We wrote the book ourselves because we couldn't find any book that was good enough. Now our books are being used by other schools and training centers worldwide.

We Provide Computers, Mac or PC

Since when did training centers expect you to "bring a laptop"? Noble Desktop has always had classrooms full of computers, Mac and PC. Each computer is loaded with software and has a 19-inch monitor. The next time you are asked to "bring a laptop," ask why you aren't being provided a computer. Noble Desktop always has up-to-date equipment in our state-of-the-art classrooms.

Not Just Anyone Can Teach

All our instructors are working professionals who bring on-the-job experience to the classroom. But we don't just let anyone teach a course. How many experts do you know who can't teach? We've learned to audition and test our instructors. Only after they have been through our screening process will they be put in front of students. And they are required to use our time-tested curriculum, assuring a positive learning experience for all our students. Read our instructor bios.

Money-Back Guarantee

We’re the only school to offer an unconditional money-back guarantee. If within the first half of the class you don’t absolutely love it, we’ll give you a full refund. Please note any request needs to be made before the halfway point of any class.

We Are NY State-Licensed, and Adobe Authorized

When looking at a computer training school, check to see if they are NY State-licensed. Any school in New York should be licensed by law. Noble Desktop follows state-issued guidelines for curriculum development and teacher licensing. Adobe Authorized means our instructors have passed the rigorous Adobe Certification Exam, and that we follow Adobe's quality-control standards.

Our Students Love Us! 2200+ Testimonials and Counting

We offer our guarantee because we think we’re the best—but don’t take our word for it. Ask more than 2200 industry professionals who have enjoyed our classes and are putting what they learned to use on the job. Read their testimonials.