Course Code: phpmysql
Duration: 40 hours
Prerequisites:

Programming experience with another language would be beneficial and an appreciation of HTML would be an advantage.

Overview:

The delegate will learn to: 
• Declare variables and initialise them 
• Construct expressions with arithmetic, logical and relational operators 
• Use iterative type statements 
• Use conditional statements 
• Read/write text and binary files 
• Manipulate text using regular expression 
• Use and code functions 
• Use built-in library functions 
• Use arrays and hashes 
• Create and use external PHP Code 
• Install and Test MySQL 
• Basic SQL Syntax 
• Connect to a MySQL Database with Error Checking 
• Use PHP to Interact with a MySQL Database 
• Utilise PHP with the HTML Environment 
• Work with Email and Cookies 
• Consider Security Implications when using PHP and MySQL

Course Outline:
  • Course Introduction
  • Module 1: HISTORY OF PHP 
    • Installing PHP
    • General Requirements
    • UNIX based Systems
    • Windows based Systems
    • Integrated Development Environment (IDE)
  • Module 2: PHP LANGUAGE BASICS
    • 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
  • Module 3: PHP VARIABLES
    • 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
  • Module 4: CONTROL STRUCTURES 
    • Statement Blocks
    • If Construct
    • Else Keyword
    • Elseif Keyword
    • Looping Constructs
    • While Loop
    • Do-while Loop
    • For Loop
    • Foreach Loop
    • Loop Control Words
    • Break
    • Continue
  • Module 5: REGULAR EXPRESSIONS
    • 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
  • Module 6: PHP ARRAYS
    • 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
  • Module 7: PHP FUNCTIONS
    • Conditionally Created Functions
    • Functions Created Inside Functions
    • Argument Passing by Value
    • Argument Passing by Reference
    • Returning Values
    • Including External PHP Functions
  • Module 8: PHP OBJECT ORIENTED
    • Classes and Inheritance
    • Classes
    • Inheritance
    • Keywords
  • Module 9: PHP & PEAR
    • What is PEAR?
    • Command Line Package Installer
    • Fully-Automatic Installation
    • Semi-Automatic Installation
    • What is PECL
  • Module 11: MySQL
    • HTML/PHP Examples
  • Module 12: BASIC SQL STATEMENTS 
    • Creating Databases and Tables
    • Inserting Data into Tables
    • Viewing Tables
    • UPDATE
    • Drop
  • Module 13: CONNECTING TO MySQL
    • mysql_connect
    • mysql_error
    • mysql_select_db
    • Die
  • Module 14: USING PHP TO PERFORM DATABASE FUNCTIONS
    • Inserting Data into a Database
    • Creating Queries
    • Executing Queries
    • Processing the Returned Query Data
    • Updating the Database
  • Module 15:GENERATING HTML USING PHP
    • PHP Inside HTML 
    • HTML Form with Embedded PHP 
    • Multiple HTML Pages/Forms with PHP
  • Module 16: EMAIL AND COOKIES USING PHP
    • Generating Email using PHP 
    • Generating Cookies using PHP 
    • Using Cookies
  • Module 18:PHP AND DATABASE SECURITY
    • Designing Databases 
    • Connecting to Database 
    • Encrypted Storage Model 
    • SQL Injection 
    • Security Techniques 
    • Error Reporting 
    • User Submitted Data