+44 7459 302492
info@uplatz.com
PHP Programming & MySQL for Web Development
PHP Programming & MySQL for Web Development Course Overview
The PHP Programming & MySQL for Web Development course is designed to give delegates the knowledge to develop/maintain PHP scripts utilizing the MYSQL database system and HTML.
----------------------------------------------------------------------------------------------------------------------------------
Who will the Course Benefit?
UNIX and Windows Users, Web Developers and Programmers wishing to create web based systems utilising PHP and MySQL.
---------------------------------------------------------------------------------------------------------------------------------------
Course Objectives
On completion of the PHP Programming & MySQL for Web Development course the delegate will have a good practical knowledge of how to write successful HTML/PHP code utilising a MySQL database.
---------------------------------------------------------------------------------------------------------------------------------------
This is a PHP Programming & MySQL for Web Development course by Uplatz.
PHP Programming & MySQL for Web Development
PHP Programming & MySQL for Web Development Training Course
Course Introduction
- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
Session 1: 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
- Operators
- Assignment Operators
- Increment/Decrement Operators
- Arithmetic Operators
- String Operators
- Comparison Operators
- Logical Operators
Session 2: PHP VARIABLES AND ARRAYS
- 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
- Super Globals
- Constants
- Variable Variables
- Creating/modifying indexed and associative arrays
- Multi-Dimensional arrays
- Using array functions
- Sorting an array
PHP Programming & MySQL for Web Development Training Course
Session 3: CONTROL STRUCTURES
- Statement Blocks
- If Construct
- Else Keyword
- Elseif Keyword
- Switch
- Looping Constructs
- While Loop
- Do-while Loop
- For Loop
- Foreach Loop
- Loop Control Words
- Break
- Continue
Session 4: PHP FUNCTIONS
- Overview
- Variable Scoping
- Global Keyword
- Static Keyword
- Argument Passing by Value
- Argument Passing by Reference
- Returning Values
- Including External PHP Functions
- Conditionally Created Functions
- Functions Created Inside Functions
Session 5: REGULAR EXPRESSIONS
- Meta-Characters
- Sequences
- Sets
- Pattern Matching with ereg and eregi
- Pattern Matching with preg_match
- Splitting Text – preg_split
- Replacing Text – preg_replace
PHP Programming & MySQL for Web Development Training Course
Session 6: PHP OBJECT ORIENTED
- PHP Object Orientated Concepts
- Creating Classes and Objects
- Constructor and Destructor functions
- Inheritance
- Access Modifiers
Session 7: PHP & PEAR
- What is PEAR?
- Command Line Package Installer
- Fully-Automatic Installation
- Semi-Automatic Installation
- What is PECL?
Session 8: PHP & HTML
- HTML/PHP Examples
PHP Programming & MySQL for Web Development Training Course
Session 9: PHP CONFIGURATION
- Working with External Files
- Error Reporting
- Interacting with External Programs
Session 10: BASIC SQL STATEMENTS
- Creating Databases and Tables
- Inserting Data into Tables
- Viewing Tables
- UPDATE
- Drop
Session 11: CONNECTING TO MySQL
- mysqli_connect
- mysqli_error
- Die
Session 12: USING PHP TO PERFORM DATABASE FUNCTIONS
- Inserting Data into a Database
- Creating Queries
- Executing Queries
- Processing the Returned Query Data
- Updating the Database
PHP Programming & MySQL for Web Development Training Course
Session 13: GENERATING HTML USING PHP
- PHP Inside HTML
- HTML Form with Embedded PHP
- Multiple HTML Pages/Forms with PHP
Session 14: EMAIL AND COOKIES USING PHP
- Generating Email using PHP
- Generating Cookies using PHP
- Using Cookies
Session 15: PHP AND DATABASE SECURITY
- Designing Databases
- Connecting to Database
- Encrypted Storage Model
- SQL Injection
- Security Techniques
- Error Reporting
- User Submitted Data
