Course Outline

COURSE SYLLABUS

PHP & MySQL Bootcamp

Unlock the dynamic power of the web with PHP & MySQL and gain a fundamental

understanding of these two building blocks of dynamic websites. Learn how to use these

database languagues to interact with customers, collect and display information from a

database, send emails, and more.

Group classes in NYC and onsite training is available for this course.

For more information, email hello@nobledesktop.com or visit:

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

The Difference Between == and ===

Section 2

Arrays

Creating a simple array

Using array()

Multidimensional Arrays

Printing an Entire Array Using print_r()

Loops

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

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

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

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

SQL: Delete

The DELETE Statement

Deleting Rows from a Database

Passing ID Variables in a URL

Wildcard Searches