PHP & MySQL Course Module

      

Introduction to PHP & Mysql
• From Static to Dynamic Websites
• What is PHP?
• What is MySQL?
• Where to get PHP and MySQL?
• The Big Picture: How PHP and MySQL fit the Web

PHP Fundamentals
• PHP.ini Configuration File
• Basic Syntax
• Mixing PHP and HTML
• About Comments

Quick Start for Programmers
• PHP Language Overview

Variables, Datatypes, Operators
• Escaping Special Characters
• Strings
• Numbers

String Manipulations
• String Concatenation, Upper/Lower Case, Sub Strings, Replacement
• String Formatting with printf

Conditionals
• If Statement
• Switch Statement

Loops
• For Loop
• While Loop
• Foreach Loop
• Loop Control (break and continue)
• Nested Loops

Functions
• Function Definition
• Function Scope
• Arguments and Return Values

Arrays
• What Are Arrays (definition)
• Indexing by Number
• Indexing by Strings - Associative Arrays
• Arrays and Loops

Form Processing
• Review of HTML Forms (check boxes, text fields, radio buttons)
• Retrieving Form Data
• The GET and POST method
• Submitting to Itself

Validating User Input with Regular Expressions
• Intro to Regular Expression Metacharacters
• Verifying Email Addresses, ZIP code, Phone Numbers, Credit Cards
• PCRE Functions

Files and Directories
• Read and Writing Files
• Working with Directories
• Working with CSV Files
• About File Permissions

Introduction to MySQL Administration
• The Command-Line Client
• MySQL Control Center
• Connecting to Database Server
• Selecting a Database

SQL Language
• The Big Picture: Databases, Tables, and Fields
• SELECT Statement
• INSERT, UPDATE, and DELETE Statement
• CREATing Databases

PHP and MySQL
• Connecting from PHP to MySQL
• Executing SQL Queries
• Retrieving Query Results
• Putting It All Together
Sessions and Cookies
• Introduction to Sessions and Cookies
• Password-protecting Pages

Objects in PHP
• Introduction to Objects
• Properties and Methods

Introduction to PEAR
• Installing PEAR
• Overview of PEAR Library

Debugging PHP Code
• About PHP Error Handling
• Using Print to Narrow Error Messages

Advanced Topics
• PHP and Javascript
• PHP and Images
• PHP and PDF
• PHP and Flash