PHP Programming & MySQL for Web Development

PHP Programming & MySQL for Web Development Course Overview

Course Prerequisites

• • Have attended Introduction to MySQL or have equivalent knowledge
  • Familiarisation with programming concepts is useful, this knowledge can be obtained by attendance on the Concepts of Programming course

Course Objectives

• • Demonstrate a good practical knowledge of how to write successful HTML/PHP code utilising a MySQL database

Target Audience for this Course

• • This course would benefit UNIX and Windows Users, Web Developers and Programmers wishing to create web based systems utilising PHP and MySQL.

Skills Gained from this Training

• • 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
  • PHP Configuration
  • 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

Included with this course

• • Comprehensive course materials and exercises

PHP Programming & MySQL for Web Development Course Content

• HISTORY OF PHP

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

• 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

• 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

• 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

• 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

• 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

• PHP FUNCTIONS

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

• PHP OBJECT ORIENTED

  Classes and Inheritance
  Classes
  Inheritance
  Keywords

• PHP & PEAR

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

• PHP & HTML

  HTML/PHP Examples
  

• PHP CONFIGURATION

  Working with External Files
  Error Reporting
  Interacting with External Programs

• BASIC SQL STATEMENTS

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

• CONNECTING TO MySQL

  mysqli_connect
  mysqli_error
  Die

• USING PHP TO PERFORM DATABASE FUNCTIONS

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

• GENERATING HTML USING PHP

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

• EMAIL AND COOKIES USING PHP

  Generating Email using PHP
  Generating Cookies using PHP
  Using Cookies

• PHP AND DATABASE SECURITY

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