PHP Programming and MySQL for Web Development

PHP Programming & MySQL for Web Development Training CourseCourse Contents - DAY 1Course Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

• Installing PHP
• General Requirements
• UNIX based Systems
• Windows based Systems
• Integrated Development Environment (IDE)

• Programming Basics
• Comment markers
• PHP Tags
• Output Commands
• Using STDIN STDOUT and STDERR
• Using Files
• Include_path
• Opening files
• Reading files
• Writing to Files
• RTRIM

• Naming Rules
• Data Types
• Numerical
• Integer
• Floating Point Numbers
• Floating Point Precision
• Single Quoted Strings
• Double Quoted Strings
• Creating and Assigning Variables
• Assigning Values to Variables
• Type Conversion
• Variable Scoping
• Global Keyword
• Static Keyword
• Super Globals
• Constants
• Variable Variables
• Operators
• Assignment Operators
• Increment/Decrement Operators
• Arithmetic Operators
• String Operators
• Comparison Operators
• Logical Operators

• Statement Blocks
• If Construct
• Else Keyword
• Elseif Keyword
• Looping Constructs
• While Loop
• Do-while Loop
• For Loop
• Foreach Loop
• Loop Control Words
• Break
• Continue

• Meta-Characters
• Backslash
• Unicode Character Properties
• Circumflex and Dollar
• Full Stop
• Square Brackets
• Vertical Bar
• Multipliers
• Subpatterns
• Repetition
• Pattern Matching with ereg and eregi
• Pattern Matching with preg_match
• Splitting Text
• Switch

• Syntax
• Creating/Modifying with Square-Bracket Syntax
• Array Functions
• Pitfalls when using Arrays
• Using a Return value as a Key
• Converting to Array
• Sorting an Array
• Multi-Dimensional Arrays
• Example
• Creating a new Multi-Dimensional Array

• Conditionally Created Functions
• Functions Created Inside Functions
• Argument Passing by Value
• Argument Passing by Reference
• Returning Values
• Including External PHP Functions

• Classes and Inheritance
• Classes
• Inheritance
• Keywords

• What is PEAR?
• Command Line Package Installer
• Fully-Automatic Installation
• Semi-Automatic Installation
• What is PECL

• HTML/PHP Examples

• Installing MySQL
• Testing MySQL

• Creating Databases and Tables
• Inserting Data into Tables
• Viewing Tables
• UPDATE
• Drop

• mysql_connect
• mysql_error
• mysql_select_db
• Die

• Inserting Data into a Database
• Creating Queries
• Executing Queries
• Processing the Returned Query Data
• Updating the Database

• PHP Inside HTML
• HTML Form with Embedded PHP
• Multiple HTML Pages/Forms with PHP

• Generating Email using PHP
• Generating Cookies using PHP
• Using Cookies

• Designing Databases
• Connecting to Database
• Encrypted Storage Model
• SQL Injection
• Security Techniques
• Error Reporting
• User Submitted Data