Like us and Save! Join our Mailing List and Save!
FULL CONTACT INFO

PHP & MySQL Tutorial

A professionally created, self-study video training course
Includes 16 hours of easy to follow PHP & MySQL video tutorials presented by an industry expert.
The training is delivered to your desktop allowing you to learn at a time that suits you and at your own pace.
You can start learning online right away. Sample PHP & MySQL tutorial videos by clicking a blue link below:
  • Tutor: Doug Bierer
  • Duration: 16 hours
  • Video lessons: 142
  • Product code: 01748
  • In stock: YES
  • Available on: DVD & Download
  • Work files included: YES
  • Works on: MS Windows PC & Mac
  • Also Recommended: MySQL 5 Tutorial
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 Doug Bierer, 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 fifteen 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, working with date and time functions, advanced techniques such as sending emails using PHP and creating images with the GD libraries and so much more. Throughtout the course, Doug makes frequent reference to pre-written PHP and MySQL code that is included with the DVD and online purchase meaning Doug's instruction is easy to keep pace with.

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 and discover how effective this practical teaching guide is...
What Our Customers Are Saying

"I have been recently been using your Photoshop training to demonstrate techniques to my students. I've been trying to persuade them to purchase it themselves, as I believe it to be an excellent training tool, and the best instructional CD on this subject to date by far! Not only is it easy to follow and presented clearly, but it is also a bargain."Joe Doyle Vista Community College, Berkeley, CA
COMPLETE COURSE CONTENTS
We hope you enjoyed the free lessons. To view the complete contents, including all lessons below & above, please purchase the course via DVD or Download.
Paid Content
Section

Get all lessons with purchase
Getting Started
What The Course Covers
Course Setup Using XAMPP
Installing XAMPP On Windows
Installing MAMP On The Mac
Installing XAMPP On Linux
Configuring PHP And MySQL
Configuring Apache
Using Editors And IDEs
Saving Your Code
Searching PHP And MySQL Documentation
Getting Help And Verifying XAMPP Status
Setup And Finding Course Files
Lab: Building A New Website
Solution: Building A New Website

Understanding The Basics
Creating Variables In PHP
Assigning Different Data Types
Performing Arithmetic Operations
Adding Comments To The Code
Assigning Constant Values
Using The printf Command To Format A String
Understanding The substr Command
Working With Strings
Debugging An Application
Lab: Mixing HTML And PHP
Solution: Mixing HTML And PHP

Working With Arrays
Working With Numeric Keys
Working With Associative Arrays
Assigning Values To Arrays
Creating A Multidimensional Array
Searching Arrays
Sorting Arrays
Removing Values From Arrays
Measuring Array Differences
Merging Arrays
Lab: Using An Array To Generate A Drop Down Menu
Solution: Using An Array To Generate A Drop Down Menu

Creating Control Structures: Looping And Branching
Comparing Values
Using if, else, And elseif
Using switch
Setting Up A for Loop
Configuring while And do while Loops
Using A foreach Loop
Branching With continue, break, And goto
Lab: Using Loops To Display Rows Of Data On A Web Page
Solution: Using Loops To Display Rows Of Data On A Web Page

Managing The Code: Functions
Using Built-In Functions
Creating Your Own Functions
Returning Values
Defining Mandatory And Optional Parameters
Using Parameters By Reference
Handling A Variable Number Of Parameters
Understanding Global Variables
Lab: Creating A Function Which Paginates Rows Of Data
Solution: Creating A Function Which Paginates Rows Of Data

Managing The Code: Object-Oriented Programming
Defining Classes
Adding Properties
Creating Methods
Determining The Visibility Level
Building Classes By Inheritance
Handling Exceptions
Introducing The MVC (Model-View-Controller) Design Pattern
Lab: Building An MVC Website Using OOP
Solution: Building An MVC Website Using OOP

Managing The Code: External Libraries
Loading Code With include
Loading Code With require
Loading Code Once Only
PHP Extensions And PECL
PHP Libraries And PEAR
Lab: Downloading An External Library
Solution: Downloading An External Library

Managing Files
Using The f* Family
Using The *file* Family
Understanding Streams
Updating The Error_Log
Parsing Directory Structures
Lab: Reading A CSV File
Solution: Reading A CSV File

Managing A MySQL Database
Understanding RDBMS Terminology
Command Line Access
Using phpMyAdmin
Configuration
Creating A Database
Managing Tables - Lesson 1
Managing Tables - Lesson 2
Understanding Indexes And Relationships
Establishing Relationships And Constraints
Lab: Defining Tables And Relationships For A Website
Solution: Defining Tables And Relationships For A Website

Understanding Structured Query Language (SQL)
Retrieving Data Using SELECT
Adding Data Using INSERT
Editing Data Using UPDATE
Removing Data Using DELETE
Performing Advanced Queries Using JOIN
Lab: Creating Select, Insert, Update, And Delete SQL Statements
Solution: Creating Select, Insert, Update, And Delete SQL Statements

Using PHP To Interact With A MySQL Database
Understanding The Different MySQL Database Extensions
Reading Data From A Table
Writing Data To A Table
Updating Data In A Table
Deleting Data From A Table
Reading Data From Multiple Tables
Lab: Display Products And Members Using PHP And MySQL
Solution: Display Products And Members Using PHP And MySQL

Using Regular Expressions
Understanding The Three Regular Expression Command Sets
Defining Basic Patterns
Using preg_match For Form Validation
Finding All Matches With preg_match_all
Using preg_replace For Intelligent Search And Replace
Lab: Using Regular Expressions To Validate Form Data
Solution: Using Regular Expressions To Validate Form Data

Managing Email
Sending Mail Using mail
Using External Mail Libraries
Adding An Attachment To Email
Sending Email Using SMTP
Lab: Using PHP To Send A Confirmation Email
Solution: Using PHP To Send A Confirmation Email

Working With Date And Time
Understanding Timestamps
Using The date Command
Using The DateTime Class
Performing Date Arithmetic
Lab: Capturing Date Of Birth Using DateTime
Solution: Capturing Date Of Birth Using DateTime

Managing Web Operations
Reading Inbound Information From Built-In Global Variables
Handling Cookies
Managing Sessions
Setting Headers And Performing Redirection
Reading Incoming Header Information
Using Output Buffering
Deploying An Application To A Website
Lab: Using Cookies And Sessions To Implement A Shopping Cart
Solution: Using Cookies And Sessions To Implement A Shopping Cart - Lesson 1
Solution: Using Cookies And Sessions To Implement A Shopping Cart - Lesson 2

Building Web Forms
Capturing Form Data
Understanding Form Input Elements
Working With Select Tags
Defining Checkboxes And Radio Buttons
Handling File Uploads
Securing Form Data: Inbound Filtering
Securing Form Data: Form Data Validation
Securing Form Data: Output Escaping
Lab: Integrating Form Data With The Database
Solution: Integrating Form Data With The Database

About The Tutor
About The PHP 5 Author
Purchase Info
The DVD and Download options include the same training contents and both priced as below:
PRICE
CURRENCY
   
   
Item(s):
For both purchase options you receive 142 PHP & MySQL training videos (listed left), lasting a total of 16 hours and the working files.

Worldwide
Shipping
Delivery Details
Download Course downloadable when payment processed (within one hour average)

CD/DVDs No shipping charges. Please allow 2-3 days for UK, Europe, US & Canada. 3-5 days rest of world.
|
Need to Train Multiple Users?
This PHP & MySQL course is available in multi-user format ideal for corporate users, schools and universities.

The course loads directly onto your server and delivered to multiple users over your network.

An unlimited number of users can access the training with a pre-determined number viewing the tuition at any one time.

Training Multiple Users

Load onto your server
Deliver on your network or existing learning management system


USING THE SAME EXCELLENT CONTENT AS SINGLE USER COURSES
For companies and educational establishments wanting multi user access to training resources, we offer this PHP & MySQL course to do just that.
Now you can integrate training or technical support within your own computer network, or allow employees or students to gain access to training and support from home or any other location that they can gain access to your organizations network.

EASILY VIEWED OVER A NETWORK
The courses can be played over a LAN using a standard browser such as Microsoft Internet Explorer, Safari or Firefox.
The movies are viewed using Adobe Flash (same method as YouTube) and are slightly compressed in order to not clog the network.
All advanced and the "for dummies" courses are available via this multi user solution and can be copied directly to a hard disk for faster access and the access page may be customized, if needed, using a html editor.

ADDITIONAL USERS AND TITLES CAN BE ADDED
More than one title can exist on your server and the supplied player will automatically show titles that are available.
Simply purchase more user licences (supplied as files) and drop them into the folder. This will automatically increase the number of users allowed onto the system. All purchases are backed up by excellent after-sales support team and easy to follow instruction manual.
You can order multi user online or speak to our knowledgeable sales team.
PRICE
(Per 10 user concurrent licence)
Closely Related Courses
We recommend the Beginners SQL Tutorial
See our complete range of MYSQL and PHP Video Tutorials
Prove Your Capabilities
Once a course is completed you can download a free certificate.

This certifies that you have started from the beginners level, have now viewed all instruction. The certificate advises you now possess essential skills and an in-depth knowledge of PHP & MySQL. Show your boss or potential employer!
Weekly Specials
    Get 10% Off Today! Join our Email Newsletter
     
This Weeks Special Offer
See the new and discounted
AutoCAD 2015 for Mac
Recommended courses to watch next
Real World PHP Programming: The Basics | PHP Project Solutions | PHP 5 Programming | Macromedia Dreamweaver 8 Advanced | UML | Programming Ruby | XML for Beginners | Assembly Language Tutorial | C++ Beginner to Advanced Bundle
A recent customer speaks out...
"I thank you so much for the Training CD's. I've pushed my working knowledge considerably. I would recommend your materials to anybody. Thank you again for a great support relationship with Marrutt."Daniel Kiermaier, FL