PHP and MySQL Overview

Course Description

In this PHP training course, students will learn to create database-driven websites using PHP and MySQL or the database of their choice. The class also covers SQL basics. This course would be a good grounding for someone embarking on web application development for the LAMP (Linux, Apache, MySql and PHP) platform.
5 days
Contact us for pricing
 

Prerequisites

Experience in the following areas is required:

- HTML

Experience in the following areas would be beneficial.

- CSS
- Basic Programming
- XML

PHP Basics

How PHP Works
The php.ini File
Basic PHP Syntax
PHP Tags
PHP Statements and Whitespace
Comments
PHP Functions
Hello World!
PHP Tags
PHP Statements and Whitespace
Comments
PHP Functions
Hello World!
Variables
Variable Types
Variable Names (Identifiers
Type Strength
Hello Variables!
Variable Scope
Superglobals
Constants
Variable-Testing and Manipulation Functions
Variable Types
Variable Names (Identifiers
Type Strength
Hello Variables!
Variable Scope
Superglobals
Constants
Variable-Testing and Manipulation Functions
PHP Operators
Creating Dynamic Pages
Single Quotes vs. Double Quotes
Howdy World!
Single Quotes vs. Double Quotes
Howdy World!

Flow Control

Conditional Processing
If Conditions
If Conditions
Loops
while
do...while
for
break and continue
while
do...while
for
break and continue

Arrays

Enumerated Arrays
Initializing Arrays
Appending to an Array
Reading from Arrays
Looping through Arrays
Initializing Arrays
Appending to an Array
Reading from Arrays
Looping through Arrays
Associative Arrays
Initializing Associative Arrays
Reading from Associative Arrays
Looping through Associative Arrays
Superglobal Arrays
Initializing Associative Arrays
Reading from Associative Arrays
Looping through Associative Arrays
Superglobal Arrays
Two-dimensional Arrays
Reading from Two-dimensional Arrays
Looping through Two-dimensional Arrays
Reading from Two-dimensional Arrays
Looping through Two-dimensional Arrays
Array Manipulation Functions

PHP and HTML Forms

HTML Forms
How HTML Forms Work
A Sample HTML Form
Form Variables
How HTML Forms Work
A Sample HTML Form
Form Variables

String Manipulation

Formatting Strings
Concatenation
String Manipulation Functions
Examples of String Functions
Concatenation
String Manipulation Functions
Examples of String Functions
Magic Quotes
magic_quotes_gpc
magic_quotes_runtime
Recommendation on Magic Quotes
Conclusion
magic_quotes_gpc
magic_quotes_runtime
Recommendation on Magic Quotes

Reusing Code and Writing Functions

Including Files
require
require_once
auto_prepend_file and auto_append_file
require
require_once
auto_prepend_file and auto_append_file
User Functions
Defining and Calling Functions
Default Values
Variable Scope
By Reference vs. By Value
Defining and Calling Functions
Default Values
Variable Scope
By Reference vs. By Value
Form Processing
Code Organization
Code Organization

Simple SELECTs

Introduction to the Northwind Database
Some Basics
Comments
Whitespace and Semi-colons
Case Sensitivity
Comments
Whitespace and Semi-colons
Case Sensitivity
SELECTing All Columns in All Rows
SELECTing Specific Columns
Sorting Records
Sorting By a Single Column
Sorting By Multiple Columns
Sorting By Column Position
Ascending and Descending Sorts
Sorting By a Single Column
Sorting By Multiple Columns
Sorting By Column Position
Ascending and Descending Sorts
The WHERE Clause and Operator Symbols
Checking for Equality
Checking for Inequality
Checking for Greater or Less Than
Checking for NULL
WHERE and ORDER BY
Checking for Equality
Checking for Inequality
Checking for Greater or Less Than
Checking for NULL
WHERE and ORDER BY
The WHERE Clause and Operator Words
The BETWEEN Operator
The IN Operator
The LIKE Operator
The NOT Operator
The BETWEEN Operator
The IN Operator
The LIKE Operator
The NOT Operator
Checking Multiple Conditions
AND
OR
Order of Evaluation
AND
OR
Order of Evaluation

Subqueries, Joins and Unions

Subqueries
Joins
Table Aliases
Multi-table Joins
Table Aliases
Multi-table Joins
Outer Joins
Unions
UNION ALL
UNION Rules
UNION ALL
UNION Rules

Inserting, Updating and Deleting Records

INSERT
UPDATE
DELETE

Managing Data

Querying a Database
mysqli() Overview
mysqli Methods and Properties
Inserting and Updating Records
mysqli Prepared Statements
mysqli() Overview
mysqli Methods and Properties
Inserting and Updating Records
mysqli Prepared Statements

PEAR:DB

Advantages and Disadvantages of PEAR DB
Why use a database abstraction layer?
When not to use a database abstraction layer?
Why use a database abstraction layer?
When not to use a database abstraction layer?
Using PEAR DB

Authentication with PHP and SQL

A Database-less Login Form

Regular Expressions

Regular Expressions
Perl-compatible Regular Expression Functions
preg_match()
preg_replace()
Regular Expression Tester
preg_match()
preg_replace()
Regular Expression Tester
Regular Expression Syntax

Session Control and Cookies

Session Control and Cookies
Sessions
Configuring Sessions
Session Functions
Configuring Sessions
Session Functions
Cookies
Conclusion

Sending Email with PHP

Sending Email with PHP
mail()
Shortcomings of mail()
Shortcomings of mail()
PHPMailer
Conclusion

File System Management

File System Management
Opening a File
fopen()
fopen()
Reading from a File
fgets()
fgets()
Writing to a File
fwrite()
fwrite()
File Locking
flock()
flock()
Uploading Files via an HTML Form
Getting File Information
More File Functions
Directory Functions
Getting a Directory Listing
Getting a Directory Listing
Conclusion

MySQLPHP