PHP & My SQL Training

Introduction

• Installing PHP & MySQL

• Introducing PHP & MySQL

• Installing Your Own Web Server

• Your First PHP Script

MySQL Databases

• Your First Database

• An Introduction to Databases

• Using phpMyAdmin to Execute SQL

• SQL Basics

PHP Fundamentals Part 1

• Introducing PHP

• PHP Variables, Operators, and Comments

• PHP Arrays

• Passing Variables in Links

• Passing Variables in Forms

PHP Fundamentals Part 2

• PHP Conditional Statements

• PHP Loops

• PHP Functions

• PHP Templates

• Controllers and Templates

Displaying MySQL Content

• Connecting to MySQL with PHP

• Sending SQL Queries with PHP

• Handling SELECT Result Sets

Modifying Database Content with PHP

• Inserting Data into the Database

• Deleting Data from the Database

• Updating Data in the Database

Extended Database Design: Multi-table Queries

• SELECT with Multiple Tables

• Simple Relationships

• Many-to-Many Relationships

Structured PHP Programming

• Including HTML Content and PHP Code

• Types of Includes

• Custom Functions

• Variable Scope and Global Access

Feeding Web Pages With AJAX

• Creating the Client Side User Interface

• Passing Data to Server Side PHP Using jQuery

• Passing AJAX Data to Client Using PHP

Course Duration: 2 Days

Cost: £595 + VAT

PHP and MySQL Training Inverness, Aberdeen, Glasgow, Edinburgh, Dunfermline and other sites throughout the UK including onsite closed company courses are available.