PHP With MySql

1: Hour Daily

Duration :-Months

The MySQL database and PHP programming language provide a powerful, open, and free platform for developing database-driven Web sites.

PHP Training Overview

MySQL and PHP are two of the most popular open source technologies to emerge during the past decade. PHP is a powerful language for writing server-side Web applications. MySQL is the world's most popular open source database. Together, these two technologies provide you with a powerful platform for building database-driven Web applications.

This hands-on MySQL and PHP training course teaches attendees everything they need to successfully build data-driven Web sites using MySQL and PHP.

PHP Training Objectives

To teach attendees the PHP programming skills they need to successfully build interactive, data-driven sites
To teach students enough MySQL database skills to build the databases that will power their sites

PHP Training Outline

A. PHP Basics

How PHP Works
The php.ini File
Basic PHP Syntax
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
Creating Dynamic Pages

(a) Single Quotes vs. Double Quotes

(b) Howdy World!

20. Single Quotes vs. Double Quotes

21. Howdy World!

22. Conclusion

B. Flow Control

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

C. Arrays

Enumerated Arrays
Initializing Arrays
Appending to an Array
Reading from Arrays
Looping through Arrays
Associative Arrays

1. Initializing Associative Arrays

2. Reading from Associative Arrays

3. Looping through Associative Arrays

4. Superglobal Arrays

Initializing Associative Arrays
Reading from Associative Arrays
Looping through Associative Arrays
Superglobal Arrays
Two-dimensional Arrays

1. Reading from Two-dimensional Arrays

2. Looping through Two-dimensional Arrays

Reading from Two-dimensional Arrays
Looping through Two-dimensional Arrays
Array Manipulation Functions
Conclusion

D. PHP and HTML Forms

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

E. String Manipulation

Formatting Strings

1. Concatenation

2. String Manipulation Functions

3. Examples of String Functions

Concatenation
String Manipulation Functions
Examples of String Functions
Magic Quotes

1. magic_quotes_gpc

2. magic_quotes_runtime

3. Recommendation on Magic Quotes

4. Conclusion

F. Reusing Code and Writing Functions

Including Files

1. require

2. require_once

3. auto_prepend_file and auto_append_file

require
require_once
auto_prepend_file and auto_append_file
User Functions

1. Defining and Calling Functions

2. Default Values

3. Variable Scope

4 .By Reference vs. By Value

5. Form Processing

6. Code Organization

7. Conclusion

G .Simple SELECTs

Introduction to the Northwind Database
Some Basics
Comments
Whitespace and Semi-colons
Case Sensitivity
Comments
SELECTing All Columns in All Rows
SELECTing Specific Columns
Sorting Records

1. Sorting By a Single Column

2. Sorting By Multiple Columns

3. Sorting By Column Position

4. 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

1. Checking for Equality

2 .Checking for Inequality

3. Checking for Greater or Less Than

4. Checking for NULL

5. 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

1. The BETWEEN Operator

2. The IN Operator

3. The LIKE Operator

4. The NOT Operator

The BETWEEN Operator
The IN Operator
The LIKE Operator
The NOT Operator
Checking Multiple

1. AND

2. OR

3. Order of Evaluation

AND
OR
Order of Evaluation
Conclusion

H. Subqueries, Joins and Unions

Subqueries
Joins

1. Table Aliases

2. Multi-table Joins

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

I. Inserting, Updating and Deleting Records

INSERT
UPDATE
DELETE
Conclusion

J. Managing Data

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

K. PEAR:DB

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

L. Authentication with PHP and SQL

A Database-less Login Form
Conclusion

M. Regular Expressions

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

1. Start and End ( ^ $ )

2. Number of Occurrences ( ? + * {} )

3. Common Characters ( . \d \D \w \W \s \S )

4. Grouping ( [] )

5. Negation ( ^ )

6. Subpatterns ( () )

7. Alternatives ( | )

8. Escape Character ( \ )

Start and End ( ^ $ )
Number of Occurrences ( ? + * {} )
Common Characters ( . \d \D \w \W \s \S )
Grouping ( [] )
Negation ( ^ )
Subpatterns ( () )
Alternatives ( | )
Escape Character ( \ )
Form Validation Functions with Regular Expressions
Conclusion

N. Session Control and Cookies

Sessions
Configuring Sessions
Session Functions
Cookies
Conclusion

O. Sending Email with PHP

mail()
Shortcomings of mail
PHPMailer
Conclusion

P. File System Management

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

Back

PHP With MySql

1: Hour Daily

Duration :-Months

Open Source Technology