PHP And My SQL Training Modules
Duration: 40 hrs.
Description
PHP and MySQL Training for Dynamic Website Development is an introductory course in the PHP and MySQL technology. Students will receive hands - on training in PHP programming language, MySQL database administration, SQL database language, and web development principles. The course is led by an instructor with over six years of web programming experience in developing both enterprise and consumer level business applications. Upon completion, you will be able to create powerful database - driven websites.
Course Content
Module 1 – Introduction to PHP
From Static to Dynamic Websites,
What is PHP ( php.net )?
What is MySQL ( mysql.com )?
Where to get PHP and MySQL?
The Big Picture – How PHP and MySQL fit the Web.
Module 2 – PHP Fundamentals
PHP.ini Configuration File ( brief description, details in the appendix ),
Basic Syntax,
Mixing PHP and HTML,
About Comments.
Module 3 – Quick Start for Programmers
PHP Language Overview ( skip to Module – Arrays )
Module 4 - Variables, Data types, Operators
Escaping Special Characters,
Strings,
Numbers.
Module 5 - String Manipulations
String Concatenation, Upper / Lower Case, Sub Strings, Replacement,
String Formatting with printf.
Module 6 – Conditionals
If Statement,
Switch Statement.
Module 7 - Loops
For Loop,
While Loop,
Foreach Loop,
Loop Control ( break and continue ),
Nested Loops.
Module 8 - Functions
Function Definition,
Function Scope,
Arguments and Return Values.
Module 9 – Arrays
What Are Arrays ( definition ),
Indexing by Number,
Indexing by Strings – Associative Arrays,
Arrays and Loops.
Module 10 – Form Processing
Review of HTML Forms ( check boxes, text fields, radio buttons ),
Retrieving Form Data,
The GET and POST method,
Submitting to Itself.
Module 11 – Validating User Input with Regular Expressions
Intro to Regular Expression Metacharacters,
Verifying Email Addresses, ZIP code, Phone Numbers, Credit Cards,
PCRE Functions.
Module 12 – Files and Directories
Read and Writing Files,
Working with Directories,
Working with CSV Files,
About File Permissions.
Module 13 – Introduction to MySQL Administration
The Command - Line Client,
MySQL Control Center,
Connecting to Database Server,
Selecting a Database.
Module 14 – SQL Language
The Big Picture: Databases, Tables, and Fields,
SELECT Statement.
INSERT, UPDATE and DELETE Statement,
CREATing Databases.
Module 15 – PHP and MySQL
Connecting from PHP to MySQL,
Executing SQL Queries,
Retrieving Query Results,
Putting It All Together.
Module 16 – Sessions and Cookies
Introduction to Sessions and Cookies,
Password - protecting Pages.
Module 17 – Objects in PHP
Introduction to Objects,
Properties and Methods.
Module 18 – Introduction to PEAR
Installing PEAR,
Overview of PEAR Library.
Module 19 – Debugging PHP Code
About PHP Error Handling,
Using Print to Narrow Error Messages.
Module 20 – Summary Though Real-World Example
Project.
