Programming experience with another language would be beneficial and an appreciation of HTML would be an advantage.
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 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