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 WorksThe 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 ProcessingIf Conditions
If Conditions
Loops
while
do...while
for
break and continue
while
do...while
for
break and continue
Arrays
Enumerated ArraysInitializing 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 FormsHow HTML Forms Work
A Sample HTML Form
Form Variables
How HTML Forms Work
A Sample HTML Form
Form Variables
String Manipulation
Formatting StringsConcatenation
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 Filesrequire
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 DatabaseSome 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
SubqueriesJoins
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
INSERTUPDATE
DELETE
Managing Data
Querying a Databasemysqli() 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 DBWhy 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 FormRegular Expressions
Regular ExpressionsPerl-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 CookiesSessions
Configuring Sessions
Session Functions
Configuring Sessions
Session Functions
Cookies
Conclusion
Sending Email with PHP
Sending Email with PHPmail()
Shortcomings of mail()
Shortcomings of mail()
PHPMailer
Conclusion
File System Management
File System ManagementOpening 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