Learning PHP MySQL Tutorial DVD - Video Training


These training classes use broadcast quality audio and video to deliver concise and informative training right to your desktop. The course is presented via an intuitive, easy-to-use interface, allowing you to learn at your own pace.
These Learning PHP MySQL Tutorials break even the most complex subjects down into easy to follow segments, following along is simple. Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of training.
- Learn PHP MySQL from a professional trainer from your own desk.
- Suitable for beginners to advanced users. ideal for users who learn faster when shown.
- Visual training method, offering users increased retention and accelerated learning.
- Breaks even the most complex applications down into simplistic steps.
Adobe CS5 Discounted Bundle
Customer Testimonials
01. Intro To Beginners PHP
- Intro - What This Course Covers Demo
- What We Need Demo
02. Getting Started
- Introducing XAMPP Demo
- Downloading XAMPP Demo
- XAMPP - Installing Demo
- XAMPP - Setting Up Demo
- Setting Up A PHP Editor - bluefish Demo
- Introduction To bluefish Demo
- The bluefish Interface Demo
- bluefish Summary Demo
- Downloading PHP Snippets Demo
- Using PHP Snippets Demo
- PHP Comments Demo
- Our First PHP Page Demo
- Intro To MySQL Databases Demo
- Into To phpMyAdmin Demo
- External Helpful Resources Demo
- Exercises Demo
03. Our First Look At MySQL And PHP
- Connecting To A MySQL Database - Part 1 Demo
- Connecting To A MySQL Database - Part 2 Demo
- Our First MySQL Query - Part 1 Demo
- Our First MySQL Query - Part 2 Demo
- Creating A MySQL Database Demo
- Create MySQL Tables - Part 1 Demo
- Create MySQL Tables - Part 2 Demo
- Database Structure Demo
- Inserting Data In MySQL Demo
- Updating MySQL Tables Demo
- Updating MySQL Tables - Example Demo
- MySQL Delete Command Demo
- Intro To Variables And Operators Demo
- Arithmetic Operators Demo
- Assignment Operators Demo
- Comparison Operators Demo
- Introduction To Arrays Demo
- Numeric Arrays Demo
- Associative Arrays Demo
- Multi-Dimensional Arrays Demo
- Creating And Working With Arrays Demo
- Creating Arrays From A Text File Demo
- Lesson Review Demo
04. Outputting And Processing Data
- 0401 Hiding Sensitive Data
- 0402 Including Sensitive Data
- 0403 PHP Echo And Quotes - Part 1
- 0404 PHP Echo And Quotes - Part 2
- 0405 Formatting Using sprintf
- 0406 Outputting Tabular Data
- 0407 Outputting Data And Time
- 0408 Introduction To Loops
- 0409 do...while Loops
- 0410 Repetition - for Loops
- 0411 Repetition - foreach Loops
- 0412 MySQL Select
- 0413 Formatting Outputted MySQL Data
- 0414 MySQL Joins - Overview
- 0415 MySQL Joins
- 0416 MySQL Where And Order By
05. Dealing With Variables
- 0501 Intro To Sending Variables
- 0502 Using Variables With GET
- 0503 Using Variables With POST
- 0504 Inserting Sent Data In A Database
- 0505 Updating A Database With Sent Data - Part 1
- 0506 Updating A Database With Sent Data - Part 2
- 0507 Redirection In PHP
- 0508 Creating A List - Example
- 0509 Styling The List - Example
- 0510 What We Have learned
06. Inserting And Using Database Data
- 0601 Using One Page To Process Forms - Part 1
- 0602 Using One Page To Process Forms - Part 2
- 0603 Multi Part Forms
- 0604 Save And Return POST and GET
- 0605 Save And Return INSERT
- 0606 Save And Return UPDATE
- 0607 Normalization
- 0608 Simple Drop Downs
- 0609 Complex Drop Downs
- 0610 Revised Form - The Code
- 0611 Revised Form - The Result
- 0612 Lesson Review
07. MySQL Joins
- 0701 MySQL Join Types - Examples
- 0702 MySQL Join Diagrams
- 0703 Creating Nested Lists
- 0704 MySQL Nested Processing
- 0705 Styling Our Lists
- 0706 Intro To Functions
- 0707 Included Files
08. PHP Errors And Security
- 0801 Introduction To Security And Errors
- 0802 Error Types - Databases
- 0803 PHP Error Types
- 0804 Custom Error Testing
- 0805 Create A Login Page
- 0806 Passwords For Login
- 0807 Protecting Pages
- 0808 Using Cookies - Theory
- 0809 Using Cookies - Practice
- 0810 Access Levels - Basic Restriction
- 0811 Access Levels - Restrict Fields
- 0812 Managing Users - Structure
- 0813 Managing Users - Create New
- 0814 Audit Trails - Access Function
- 0815 Audit Trails - Logging Logins
- 0816 Errors And Security - Review
09. Building A Template Page
- 0901 PHP Templates
- 0902 Building Our PHP Template CSS/HTML
- 0903 Creating Template Menu
- 0904 Create Template Login Script
- 0905 Template Logout Script
- 0906 CMS Switch Statement
- 0907 Building Our CMS
- 0908 Setting up our CMS Content
- 0909 Complete CMS Module
- 0910 Review And Exercise
10. PHP Functions
- 1001 Function Structure
- 1002 Built In Functions Maths And Strings
- 1003 Built In Functions Date And Time
- 1004 Custom Functions
- 1005 Format With Functions
- 1006 Email Address Checking
- 1007 Database Functions
- 1008 Array Functions - sort And unique
- 1009 Array Functions - search, slice And merge
- 1010 Server Variables
- 1011 Browser Detection
11. Using External Files, And Images
- 1101 Reading Text Files
- 1102 Writing Text Files
- 1103 Working With Image Files - exif
- 1104 Creating Image Files With GD Library
- 1105 Managing Images With GD Library
- 1106 Resizing Images With PHP
- 1107 Uploading Files - Overview
- 1108 Uploading Files - In Action
- 1109 Remote File Parsing
12. Email With PHP
- 1201 Email With PHP And MySQL
- 1202 Sendmail SMTP Server
- 1203 Sendmail mail Function
- 1204 PHP mail CC And BCC
- 1205 HTML email Content
- 1206 Email Out - Hiding SMTP Address
- 1207 Email Out - Embedded Form
- 1208 Logging Sent Email
13. Real Life PHP Introduction
- 1301 Real Life Introduction
- 1302 Building PHP Tools - Button Maker
- 1303 Building PHP Tools - Embedded Tool
- 1304 Managing Deletions - Suspension Fields
- 1305 Managing Deletions - Suspend Record
- 1306 Managing Deletions - Restore Records
- 1307 OO Programming - A Caveat
- 1308 OO Programming Model - DB Connection
- 1309 OO Programming - DB Examples
- 1310 CMS Open Source
- 1311 CMS Joomla
- 1312 CRM Download And Extract
- 1313 CRM vTiger Install
- 1314 CRM Modifying vTiger
14. About The Author
- 1401 About The Author
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. Close »
| Publisher: | InfiniteSkills - SKU: 01600 |
| Duration: | 10.75 hours - 155 lessons |
| Date Released: | 2010-08-21 |
| Platform: | Windows PC or Mac |
| Format : | Download or DVD-ROM |
| Price: | ![]() |
$99.95 | ![]() |
£63.99 | ![]() |
€74.99 |
This course is also available in multi-user format which is ideal for corporate users, schools and universities. The multi-user training loads directly onto your own server and delivers training to multiple users over your own network. It's easy to install and can be integrated into existing learning systems or used as a stand alone solution. Additional information...
| Cost Per 10 User Licence: | |||||
![]() |
$500.00 | ![]() |
£320.1 | ![]() |
€375.15 |
More Information
All InfiniteSkills Training DVDs come with a 100% money back guarantee. If your not happy with your Training DVD just contact our sales department within 30 days of purchase for a refund.
Learning Adobe Photoshop Lightroom 4
Learning CSS3
Learning MySQL 5
Learning Oracle 11g

Got An iPad, Why Not View All Our Free Movies? Keep up to date with all our new and current releases, right from your iPad, just download our free App directly from Apple and you're set to go. Content will be added automatically as new titles are released. It's easy to use, it's Portable and it's FREE
john w.
Infinite Skills Inc
T: 858-866-9147.
Email :











simon m.