TrainingCompany.Com Logo

Training brochure

 

PHP, MySQL and AJAX Training Courses in London
  • Introduction
  • Advanced
  • AJAX
  • Booking

PHP Introduction
(3 days - £895, plus VAT)

Prerequisites

Computer literacy: the ability to use a mouse and keyboard; familiarity with common computer software; the ability to open and save files. A basic familiarity with HTML, CSS and the creation and management of a website.

Course Goals

To provide delegates with the ability to create dynamic server-side web pages containing content retrieved from a database. Delegates will become familiar with using PHP and MySQL in conjunction to build dynamic websites.

Course Outline

Introduction to Web Applications

Client-Side Versus Server-Side Web Development
Web Applications
Client-Side Technologies
Server-Side Technologies
Database Options
Structured Query Language
Working with Data Source Names

Working with Server-Side Technologies

Working with the Internet Information Services (IIS) Web Server
Working with ASP
Installing and Working with PHP

Working with Dynamic Data

Connecting to a Data Source
Retrieving database information
Adding Dynamic Data to a Web Page
Using Live Data View

Search and Results Pages

Creating a Search Page
Creating the Search Results Page
Creating variables
Creating SQL statements
The Go to Detail Page Server Behavior

Dynamic Web Page Elements

Making Images Dynamic
Dynamic Alt Tags
Dynamic Page Titles
Making Links Dynamic
Binding Form Elements to a Data Source

Security and User Authentication

Creating Registration Pages
Check New User Name
Creating Log-in Pages
Restrict Access to Page
Log-out User

Creating Admin Pages

Creating Add New Record Pages
Creating Delete Record Pages
Creating Update Record Pages
Adding Error Pages

We run courses in PHP in London and all over the UK. Call us now on 020 8298 6109 to discuss your requirements.

Back to top

PHP Advanced
(3 days - £895, plus VAT)

Prerequisites

Experience of using PHP and MySQL to build dynamic web pages as well as a good knowledge of HTML and CSS

Course Goals

To provide an insight into advanced PHP programming concepts, e-commerce, object oriented programming, image generation, the manipulation of PDF files and the use of XML.

Course Outline

Advanced PHP Programming

Code Structure and Documentation
Function Recursion and Static Variables
References and Functions
PERL-Compatible Regular Expressions

Basic OO Programming

Defining a Class
Creating an Object
Creating Constructors
Object Inheritance
Using Class Functions Without Instances
Serializing Objects
Destroying Objects

Developing Web Applications

Catching Exceptions
Using PEAR's HTML_QuickFOrm
Modularizing a Web Site
Error Logging and Reporting
Browser Detection

Database concepts

Database Design and Normalization
Storing Sessions in a Database
Storing BLOBs in a Database
Using Prepared Statements
Database Encryption
Working with Bound Variables

Security

Validating Forms
Validating Forms with JavaScript
Encryption with Mcrypt
HTTP Authentication
Web Server Security
Shared Server Security
Encorporating Captcha with PEAR
Using PEAR Auth

Advanced OO Programming

Inheritance
Access Control
Polymorphism
Encapsulation
Overloading

E-commerce

Creating the Database Administration
Showing the Products Online
Writing a Shopping Cart
Handling Commerical Transactions

Image generation

Creating a Simple Image
Using TrueType Fonts
Creating a Database-Driven Graph
Saving and Building on Existing Images

Creating PDFs

Creating a Simple PDF
Adding Text to PDFs
Drawing Shapes
Using Images
Creating Multiple-Page PDFs

XML and PHP

What is XML?
XML Syntax
Document Type Definitions
Parsing XML With PHP
XML Error Handling

Back to top

PHP and AJAX
(3 days - £895, plus VAT)

Prerequisites

Experience of using PHP and MySQL to build dynamic web pages as well as a good basic knowledge of JavaScript, HTML and CSS

Course Goals

To introduce web developers to the techniques involved in using AJAX to add sophisticated interactivity and enhance the user experience of their PHP web applications. This course is aimed at those who are familiar with the basics of PHP and JavaScript.

Course Outline

AJAX and the Future of Web Applications

Delivering Functionality via the Web
Advantages of Web Applications
Building Websites Since 1990
HTTP and HTML
PHP and Other Server-Side Technologies
JavaScript and Other Client-Side Technologies
What's Been Missing?
Understanding AJAX
Building a Simple Application with AJAX and PHP

Client-Side Techniques with Smarter JavaScript

JavaScript and the Document Object Model
Playing with JavaScript and the DOM
JavaScript Events and the DOM
Using JavaScript Events and the DOM
JavaScript, DOM, and CSS
Working with CSS and JavaScript
Using the XMLHttpRequest Object
Creating the XMLHttpRequest Object
Creating Better Objects for Internet Explorer
Initiating Server Requests Using XMLHttpRequest
Handling Server Response
Making Asynchronous Calls with XMLHttpRequest
Working with XML Structures
Making Asynchronous Calls with XMLHttpRequest and XML
Handling More Errors and Throwing Exceptions
Creating XML Structures

Server-Side Techniques with PHP and MySQL

PHP and DOM
Doing AJAX with PHP 66
Passing Parameters and Handling PHP Errors
Passing PHP Parameters and Error Handling
Connecting to Remote Servers and JavaScript Security
Connecting to Remote Servers
Using a Proxy Server Script
Using a Proxy Server Script to Access Remote Servers
A Framework for Making Repetitive Asynchronous Requests
Implementing Repetitive Tasks
Working with MySQL
Creating Database Tables
Manipulating Data
Connecting to Your Database and Executing Queries
Working with PHP and MySQL
Wrapping Things Up and Laying Out the Structure
Building the Friendly Application

AJAX Form Validation

Implementing AJAX Form Validation
Thread-Safe AJAX
AJAX Form Validation

AJAX Chat

Introducing AJAX Chat
Implementing AJAX Chat

AJAX Suggest and Autocomplete

Introducing AJAX Suggest and Autocomplete
Google Suggest
Implementing AJAX Suggest and Autocomplete
AJAX Suggest and Autocomplete

AJAX Drag and Drop

Using Drag and Drop on the Web
Shopping Carts
Sortable Lists

We run tutor-led training courses on PHP and AJAX in London and throughout the UK. Call us now on 020 8298 6109 to discuss your requirements.

Back to top

Book a Dreamweaver Course

PHP Introduction

PHP Advanced

PHP and AJAX