• Technical IT

    Solutions delivered throughout the UK
  • Business Applications

    Solutions delivered throughout the UK
  • Professional Best Practice

    Solutions delivered throughout the UK
  • Professional Development

    Solutions delivered throughout the UK

PHP Programming & MySQL for Web Development

  • Price £1,495.00
  • Duration 5 day(s)
All major credit cards accepted

Description

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.

Skills Gained
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
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

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.

Requirements
Familiarisation with programming concepts is useful, this knowledge can be obtained by attendance on the Concepts of Programming course.

Prerequisites

Introduction to MySQL

Course Content

DAY 1

Session Introduction
Administration and Course Materials
Course Structure and Agenda
Delegate and Trainer Introductions

Session 1: HISTORY OF PHP
Installing PHP
General Requirements
UNIX based Systems
Windows based Systems
Integrated Development Environment (IDE)

Session 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

Session 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


DAY 2

Session 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

Session 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

Session 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


DAY 3

Session 7: PHP FUNCTIONS
Conditionally Created Functions
Functions Created Inside Functions
Argument Passing by Value
Argument Passing by Reference
Returning Values
Including External PHP Functions

Session 8: PHP OBJECT ORIENTED
Classes and Inheritance
Classes
Inheritance
Keywords

Session 9: PHP & PEAR
What is PEAR?
Command Line Package Installer
Fully-Automatic Installation
Semi-Automatic Installation
What is PECL

Session 10: PHP & HTML
HTML/PHP Examples


DAY 4

Session 11: MySQL
Installing MySQL
Testing MySQL

Session 12: BASIC SQL STATEMENTS
Creating Databases and Tables
Inserting Data into Tables
Viewing Tables
UPDATE
Drop

Session 13: CONNECTING TO MySQL
mysql_connect
mysql_error
mysql_select_db
Die

Session 14: USING PHP TO PERFORM DATABASE FUNCTIONS
Inserting Data into a Database
Creating Queries
Executing Queries
Processing the Returned Query Data
Updating the Database


DAY 5

Session 15: GENERATING HTML USING PHP
PHP Inside HTML
HTML Form with Embedded PHP
Multiple HTML Pages/Forms with PHP

Session 16: EMAIL AND COOKIES USING PHP
Generating Email using PHP
Generating Cookies using PHP
Using Cookies

Session 17: PHP AND DATABASE SECURITY
Designing Databases
Connecting to Database
Encrypted Storage Model
SQL Injection
Security Techniques
Error Reporting
User Submitted Data

Make Enquiry

Course Enquiry
  •  
  •  

Book Now

Course Enquiry
  •  
  •  

Find your local training centre