courses / products
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
SUBSCRIBE
Subscribe to Receive Special Offers & New Release Updates
100% Satisfaction Guaranteed

CareerVision is committed to providing our customers with the best service and products available.

We back our training products with a 100% Satisfaction or Your Money Back Guarantee, so you can buy worry free. More....



FAST UK DELIVERY
Order Today, Learn Tomorrow!

Pay as You Learn

SECURE PAYMENT
PROCESSING


We Accept All Major Credit Cards, PayPal and Google Checkout

Credit Cards Accepted
PayPal Accepted



Follow us on Facebook

PHP & MySQL

 
Bookmark and Share
PHP & MySQL
Single DVD £79.00  £63.00 + VAT
Buy Now
Instant Download £79.00  £63.00 + VAT
Buy Now
 

 

PACKAGE INCLUDES

 •  Format: DVD or Instant Download
 •  Duration: 10.7 Hours (155 lessons)
 •  Instructor: Robert J Tucker
 •  Platform: Windows PC or Mac
 

COURSE INTRODUCTION

In this Beginners PHP / MySQL tutorial video by expert author Robert J. Tucker, you will learn the fundamentals of PHP and MySQL.  Instead of your standard "this is a variable" type training however, Robert teaches you how to actually apply PHP and MySQL in real world scenarios.

This PHP / MySQL Tutorial takes you through building a CRM (customer relationship management) application, and through this teaches you how to leverage the power of PHP and MySQL. You will learn about variables, standard PHP functions such as date/time, arithmetic and comparison functions, as well as advanced techniques such as sending emails and creating images using the GD libraries.  You will also learn how to create databases and tables, and manage your data in MySQL.

By the completion of this PHP training video, you will be fully capable of creating a CRM application, and have all the groundwork laid for creating your own fully featured PHP/MySQL websites and applications.  This tutorial video comes complete with extensive work files, and a special website created just to support this training video.


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 guide you 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.
 •  Course works on PC and Mac.
 •  Alternative to a boring book or manual and expensive training courses,
        seminars & 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.


 

COURSE OUTLINE

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
Into To phpMyAdmin
External Helpful Resources
Exercises

Our First Look At MySQL And PHP
Connecting To A MySQL Database - Part 1
Connecting To A MySQL Database - Part 2
Our First MySQL Query - Part 1
Our First MySQL Query - Part 2
Creating A MySQL Database
Create MySQL Tables - Part 1
Create MySQL Tables - Part 2
Database Structure
Inserting Data In MySQL
Updating MySQL Tables
Updating MySQL Tables - Example
MySQL Delete Command
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

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




 

 
 
Print Image Printer friendly version   
Top of page
A-Z COURSE LIST   PROVIDERS   CBT TRAINING  CVISION NEWS  CONTACT US   SITEMAP  

MCITP Training Courses  MCPD Training Courses  MCTS Training Courses
MCITP Database Developer Training Courses  MCITP Database Administrator Training Courses
Flash Tutorials & Training Courses  MCSE CBT Training Adobe Photoshop Tutorials & CBT Training Microsoft Certification Training

CareerVision
61 Caroline Street, Birmingham, B3 1UF, UK
Tel: 0121 248 2400, Fax: 0121248 2800,
Email: sales@cvision.co.uk |Web: www.cvision.co.uk

red arrow Website design by Aimpro UK red arrow Terms