LAMP Pro - Linux, Apache, MySQL, PHP
Description:
This hands on PHP Programming course provides the knowledge necessary to design and develop dynamic, database-driven web pages using PHP version 5. PHP is a web language which is , quick to learn, easy to deploy and provides substantial functionality required for e-commerce. This course introduces the PHP framework and syntax, and covers in depth the most important techniques used to build dynamic web sites. Students will learn how to connect to any ODBC-compliant database, and perform hands on practice with a MySQL database to create database-driven HTML forms and reports. Students also learn how to configure PHP and Apache Web Server. Comprehensive lab exercises provide facilitated hands on practice crucial to develop competence web sites.
Prerequisites:
Basic computer skills and knowledge of HTML fundamentals
Course Overview:
· Linux Introduction
· XHTML
· Javascript + CSS
· AJAX
· PHP5 Programming
· MySQL for Developer
· CakePHP - Framework - Introduction
· Drupal - CMS - Introduction
· Apache - Web Server
Overview Of PHP
· Static vs. Dynamic Web Sites
· Dynamic Content from Databases
· Developing Dynamic Internet Applications
· Client-Side Scripting vs. Server-Side Scripting
· Overview of PHP Advantages & Capabilities
· Configuring PHP.INI
· PHP vs. ASP
Basic Scripting and Looping Constructs
· PHP Scripting Fundamentals
· Print Statement
· Code Blocks
· Primitive Data Types
· Defining Constants and Variables
· Looping Constructs
· While
· Do While
· For
· Exit & Break
PHP Operators
· Logical Operators
· Relational Operators
· Bitwise Operators
· Other Operators
Conditional Constructs
· True and False Expressions
· If, Else and Elseif
· Switch/Case Statement
· The ? (Ternary) Operator
· Timestamps
Arrays in PHP
· What are Arrays?
· Usage of Arrays in PHP
· Indexing Arrays
· Initializing Arrays
· Adding and Removing from Arrays
· One-dimensional Arrays
· Multidimensional Arrays
· Array Functions
PHP Functions
· Introduction to Functions
· Declaring Functions
· Scope
· Passing Arguments to Functions
· Returning Values from a Function
· Using Include Files
· The Require Statement
· Recursion
· Dynamic Function Calls
· Predefined PHP Functions
· Mailing Functions
Classes And Objects (PHP 5)
· Introduction
· The Basics
· Autoloading Objects
· Constructors and Destructors
· Visibility
· Scope Resolution Operator (::)
· Static Keyword
· Class Constants
· Class Abstraction
· Object Interfaces
· Overloading
· Object Iteration
· Patterns
· Magic Methods
· Final Keyword
· Object cloning
· Comparing objects
· Reflection
· Type Hinting
File Handling
· Searching File Contents With Regular Expressions
· Changing and Editing File Contents
· Splitting and Joining Information Inside Files
· File Uploading
· String Functions
· Regular Expression Functions
· Reading, Writing and Deleting Files
· Handling File Permissions
· File Locking
· Reading Directory Contents
· Creating and Deleting Directories
Working with Databases and Forms
· Configuring PHP For Database Support
· PHP’s Database APIs
· PHP’s SQL API
· MySQL vs. Access
· MySQL vs. SQL Server
· Database Drivers
· Database Driver Class Wrappers
· ODBC
· Simple SQL Queries via PHP
· Tracking Visitors with Session IDs
· Populating Forms
· Retrieving Data from Forms
Using Cookies with PHP
· Purpose of Cookies
· Cookie Myths
· Setting Cookies
· Retrieving Cookies
· Expiring Cookies
· Deleting Cookies
· Storing Arrays in Cookies
Miscellaneous PHP Tasks
· Error Logging
· Session Management & Maintaining State
· Using Environmental Variables
· Changing Execution by Redirecting to Other URLs
· Embedding JavaScript with PHP
· Using HTTP & FTP Protocols to Pass Data
· Showing Different Content to Different Browsers
· Getting IP Addresses from Visitors
Using MySQL 5.0
Introduction to MySQL AB
· Overview of MySQL AB
· What is MySQL?
· History of MySQL
· The Main Features of MySQL
Create & Manage Database and tables
· Connecting to and Disconnecting from the Server
· Entering Queries
· Creating and Using a Database
· Creating and Selecting a Database
· Creating a Table
· Loading Data into a Table
· Retrieving Information from a Table
· Getting Information About Databases and Tables
Data Types
Functions and Operators
SQL Statement Syntax
Data Definition Statements
· ALTER DATABASE Syntax
· ALTER TABLE Syntax
· CREATE DATABASE Syntax
· CREATE TABLE Syntax
· DROP DATABASE Syntax
· DROP TABLE Syntax
· RENAME TABLE Syntax
Data Manipulation Statements & Control Statements
· DELETE Syntax
· DO Syntax
· INSERT Syntax
· LOAD DATA INFILE Syntax
· REPLACE Syntax
· SELECT Syntax
· Subquery Syntax
· TRUNCATE Syntax
· UPDATE Syntax
Stored Procedures and Functions
· Stored Routines and the Grant Tables
· Stored Routine Syntax
· Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()
Triggers
· CREATE TRIGGER Syntax
· DROP TRIGGER Syntax
· Using Triggers
Views
· ALTER VIEW Syntax
· CREATE VIEW Syntax
· DROP VIEW Syntax
· Using PHP MyAdmin to configure MySQLFunctions and Operators
Introduction to the Apache Web Server
· Configuration Files
· PHP Installation and Configuration
· WWW Sites within Apache
· Website Properties
· RPM Installation vs. Binary Installation
DURATION
· 80 Hrs - 2 / 4 / 8 Hrs per Day
