PHP & MySQL Book

Setup & Introduction

Downloading the Class Files

Before You Begin

• Supported browsers
• Recommended software

Mac: Setting Up the Local Server

• Differences between MAMP and MAMP PRO
• Installing MAMP PRO
• Installing MAMP
,

Windows: Setting Up the Local Server

• Windows: Installing XAMPP

Section 1

Setting Up: Do This Before Other Exercises!

• Setting up your class files
• Setting MAMP PRO to display errors

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

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

Reference Material