PRODUCT INFO

Product Guarantee

Testimonials

MAIN LINKS

Multi User Training CDs

	This Week's Special Offer NEW TITLE DISCOUNT!
Adobe Photoshop Elements 10 Tutorial

Quicktime is required for the movies, click here to download if needed.
Please Note: The online FREE lessons have been compressed for faster downloads. Purchased CD ROMs/DVDs load almost instantly and have higher sound and video quality. Please allow a few seconds for the FREE online tutorials to load. If you have any difficulties downloading these FREE online tutorials. Please do not hesitate to contact us for download help.

- See right for full details on this PHP & MySQL Tutorial

- See far right to purchase this PHP & MySQL Training CD/DVD

PHP & MySQL Tutorial

SPECIAL OFFER: 20% DISCOUNT & FREE SHIPPING!

Professionally created, self-study video training.

About this Tutorial

show details

Get to grips with the fundamentals of these popular web development technologies and learn how to apply them in real world scenarios with the help of this PHP & MySQL tutorial. Presented by long time web developer Robert J. Tucker, he uses high quality video training movies to take you through the creation of a CRM (customer relationship management) application. Through this, Robert explains and demonstrates the fundamental concepts and how to leverage the power of PHP & MySQL. In over 10 hours of professional video training, tuition includes standard PHP functions, dealing with variables, how to create MySQL tables, connecting to a MySQL database, how to insert and use database data, MySQL joins, advanced techniques such as sending emails using PHP and creating images with the GD libraries and so much more. You can view the complete training contents and start learning right away, see below for full course listings and click any of the blue linked lessons to sample the FREE PHP & MySQL video tutorials available for evaluation...

hide details

Learn this Software - See below for FREE TUTORIALS

Each Course on 1 or 2 CDs or Download
For Mac and PC

FREE Shipping on ALL Orders

PHP & MySQL Tutorial Info

Tutor: Robert J. Tucker
Duration: 10.5 hrs / 155 video lessons
Cost for UK: £79.95 £63.95 + VAT
Cost for EU: €84.95 €67.95 + VAT
Cost for US & Canada: $124.95 $99.94 *no further discounts can be applied
Product Code: 01600
DELIVERY DETAILS Downloads: Training downloadable when payment processed (by next working day) CDs: Please allow 2-3 days for UK, Europe US & Canada, 3-5 days rest of world IN STOCK - All CDs Shipped Carriage FREE -
Compatibility: MS Windows 7, Vista, XP, 2000, 98, NT, Mac OS X, OS 9

DON'T TAKE OUR WORD FOR IT, SEE OUR CUSTOMER TESTIMONIALS

Benefits of this Software Training

Tuition by expert tutors.

Narrated training videos demonstrate the key tools and professional techniques helping you to work faster and smarter.

Learning is fast as the trainers provide a beginners guide using simplistic terms and minimal jargon.

Personal Tutoring - Step-by-step video training from your own desktop. Delivered via DVD/CD training or online tuition.

The tutor transfers knowledge to you quickly and effectively.

All the concepts of each application are explained clearly and precisely.

Every course works on PC and Mac.

Alternative to a boring book or manual and expensive training courses, seminars, workshops & classes.

Jump to and from lessons - learn at your own pace.

The visual and practical nature shortens the learning curve compared to standard training manuals and for dummies books.
Customer Testimonials

CD CONTENTS & FREE VIDEO TUTORIALS

Click on any linked lesson below for a FREE demo
Purchased CD tutorials load almost instantly and have higher sound & video quality. For tutorial support see left

Intro To Beginners PHP

Intro - What This Course Covers

What We Need

Getting Started

Introducing XAMPP

Downloading XAMPP

XAMPP - Installing

XAMPP - Setting Up

Setting Up A PHP Editor - bluefish

Introduction To bluefish

The bluefish Interface

bluefish Summary

Downloading PHP Snippets

Using PHP Snippets

PHP Comments

Our First PHP Page

Intro To MySQL Databases

Intro To appLaUding

External Helpful Resources

Exercises

Our First Look At MySQL And PHP

Connecting To A MySQL Database - Lesson 1

Connecting To A MySQL Database - Lesson 2

Our First MySQL Query - Lesson 1

Our First MySQL Query - Lesson 2

Creating A MySQL Database

Create MySQL Tables - Lesson 1

Create MySQL Tables - Lesson 2

Database Structure

Updating MySQL Tables

Updating MySQL Tables - Example

MySQL Delete Command

Inserting Data In MySQL

Intro To Variables And Operators

Arithmetic Operators

Assignment Operators

Comparison Operators

Introduction To Arrays

Numeric Arrays

Associative Arrays

Multi-Dimensional Arrays

Creating And Working With Arrays

Creating Arrays From A Text File

Lesson Review

We hope you enjoyed the FREE lessons. To view the complete contents, including ALL the lessons below & above, please purchase the course via CD or Download

Outputting And Processing Data
Hiding Sensitive Data
Including Sensitive Data
PHP Echo And Quotes - Lesson 1
PHP Echo And Quotes - Lesson 2
Formatting Using sprintf
Outputting Tabular Data
Outputting Data And Time
Introduction To Loops
do...while Loops
Repetition - for Loops
Repetition - foreach Loops
MySQL Select
Formatting Outputted MySQL Data
MySQL Joins - Overview
MySQL Joins
MySQL Where And Order By

Dealing With Variables
Intro To Sending Variables
Using Variables With GET
Using Variables With POST
Inserting Sent Data In A Database
Updating A Database With Sent Data - Lesson 1
Updating A Database With Sent Data - Lesson 2
Redirection In PHP 5
Creating A List - Example
Styling The List - Example
What We Have learned

Inserting And Using Database Data
Using One Page To Process Forms - Lesson 1
Using One Page To Process Forms - Lesson 2
Multi Part Forms
Save And Return POST and GET
Save And Return INSERT
Save And Return UPDATE
Normalization
Simple Drop Downs
Complex Drop Downs
Revised Form - The Code
Revised Form - The Result
Lesson Review

MySQL Joins
MySQL Join Types - Examples
MySQL Join Diagrams
Creating Nested Lists
MySQL Nested Processing
Styling Our Lists
Intro To Functions
Included Files

PHP Errors And Security
Introduction To Security And Errors
Error Types - Databases
PHP Error Types
Custom Error Testing
Create A Login Page
Passwords For Login
Protecting Pages
Using Cookies - Theory
Using Cookies - Practice
Access Levels - Basic Restriction
Access Levels - Restrict Fields
Managing Users - Structure
Managing Users - Create New
Audit Trails - Access Function
Audit Trails - Logging Logins
Errors And Security - Review

Building A Template Page
PHP Templates
Building Our PHP Template CSS/HTML
Creating Template Menu
Create Template Login Script
Template Logout Script
CMS Switch Statement
Building Our CMS
Setting up our CMS Content
Complete CMS Module
Review And Exercise

PHP Functions
Function Structure
Built In Functions Maths And Strings
Built In Functions Date And Time
Custom Functions
Format With Functions
Email Address Checking
Database Functions
Array Functions - sort And unique
Array Functions - search, slice And merge
Server Variables
Browser Detection

Using External Files, And Images
Reading Text Files
Writing Text Files
Working With Image Files - exif
Creating Image Files With GD Library
Managing Images With GD Library
Resizing Images With PHP
Uploading Files - Overview
Uploading Files - In Action
Remote File Parsing

Email With PHP
Email With PHP And MySQL
Sendmail SMTP Server
Sendmail mail Function
PHP mail CC And BCC
HTML email Content
Email Out - Hiding SMTP Address
Email Out - Embedded Form
Logging Sent Email

Real Life PHP Introduction
Real Life Introduction
Building PHP Tools - Button Maker
Building PHP Tools - Embedded Tool
Managing Deletions - Suspension Fields
Managing Deletions - Suspend Record
Managing Deletions - Restore Records
OO Programming - A Caveat
OO Programming Model - DB Connection
OO Programming - DB Examples
CMS Open Source
CMS Joomla
CRM Download And Extract
CRM vTiger Install
CRM Modifying vTiger

About The PHP 5 Tutor
About The PHP 5 Tutor


[ Home \| Video Training CDs/DVD \| Site Map \| Resources \| Specialist Categories \| Specialist Categories 2 \| Specialist Categories 3 ]
UK & Europe Marrutt Software Training Bellbrook Industrial Estate Uckfield, East Sussex, TN22 1QL United Kingdom UK Tel: +44 (0) 1825 764057 UK Fax: +44 (0) 1825 768841	US & Canada Marrutt Software Training 244 5th Ave # 1877 New York, NY 10001 United States US Tel: 646-736-7932 US Fax: 646-895-7649