PHP 6 and MySQL Web Programming Language DVD Training Course – Amazing eLearning
PHP 6 and MySQL Web Programming Language DVD Training Course

PHP 6 and MySQL Web Programming Language DVD Training Course

Regular price
Sale price
Shipping calculated at checkout.

PHP 6 and MySQL Step-By-Step Training Course with Sample Codes 

Amazing eLearning presents the best self-study training course for PHP 6 and MySQL. This is an instructional program that offers a quick and easy method for harnessing the vast potential of the PHP scripting language, MySQL database and their applications.  You will spend your time studying and learning the material by using our sample codes. In addition, your schedule is your own. You can study as quickly or slowly you need to. By the time you are ready to find a better job, launch a new project, or take the exam. You will have all the tools, experience and knowledge needed for success.


  • Step-by-step instructional program
  • Sample codes included for practice
  • Flash-based interactive training
  • Full screen for maximum viewing
  • Easy to follow narrated instructions
  • Player controls for easy Navigation
  • Learn faster than reading a book

Table of contents

Lesson 1: PHP at a glance
1.1 What’s PHP and its Advantages
1.2 Apache Server
1.3 My SQL database
1.4 Build Apache + PHP + MySQL under windows
1.5 APPSERV installation
1.6 Web page detection

Lesson 2: Basic Syntax
2.1 Basic PHP syntax
2.2 PHP statements
2.3 PHP error messages
2.4 echo in PHP
2.5 PHP and HTML
2.6 .PHPS files
2.7 escape symbols
2.8 PHP Information page

Lesson 3: Variables and Constants
3.1 Upper case and lower case usage
3.2 Statements and semicolons
3.3 Whitespaces
3.4 Constants and their syntax
3.5 Variable names
3.6 Function names
3.7 Class names
3.8 Types of data: Integer, Float, String, Boolean, Array, Object, Resource, and Null
3.9 Expressions and operators
3.10 Number of operands
3.11 Priority of operators
3.12 Variables and variable variables
3.13 Superglobals
3.14 Similarities and differences between constants and variables

Lesson 4: String
4.1 string constants
4.2 variable interpolation
4.3 single quotes strings
4.4 double quotes strings
4.5 HEREDOC strings
4.6 printing strings
4.7 accessing single characters
4.8 string trim
4.9 encoding, decoding and escape characters
4.10 string searching operations
4.11 regular expressions

Lesson 5: Arrays
5.1 Indexed Array and Associative Array
5.2 Array Creation & Array Identification
5.3 Array Elements Processing
5.4 Multidimensional Arrays
5.5 Extracting Array Elements Value
5.6 Conversion between Arrays and Variables
5.7 Array Sorting
5.8 Array searching

Lesson 6: Objects-Oriented Programming
6.1 OOP Basics
6.2 Define “ Class ”
6.3 Create “Objects “
6.4 Create Objects Initial Value
6.5 Methods of Class
6.6 Data Encapsulation
6.7 Data Inheritance
6.8 Data Polymorphism
6.9 Class Inspection
6.10 Object Inspection
6.11 Object Serialization

Lesson 7: Forms, Cookies and Sessions
7.1 Variables
7.2 Server Information
7.3 Form Processing
7.4 Set Response Header

Lesson 8: Flow Control
8.1 IF Construct
8.2 SWITCH Function
8.3 WHILE Loop
8.4 FOR Loop
8.5 FOREACH Loop
8.6 EXIT Command

Lesson 9: Functions
9.1 Function Introduction
9.2 Function Call
9.3 Function Definition
9.4 Function Parameters (Passed by Value, Passed by Reference);
9.5 Valid Variable Range (Global Variables, Static Variables);
9.6 Default Parameter
9.7 Changeable Parameter Number
9.8 Return Value
9.9 Variable Function
9.10 Anonymous Function
Lesson 9: A PHP 6 Unicode
9.11 Unicode in PHP 6

Lesson 10: MySQL Database Application
10.1 MySQL Operational Mode
10.2 Start PHP MyADMIN
10.3 Modify Password by PHPMY ADMIN
10.4 Where to Use SQL Syntaxes?
10.5 SQL related syntax
10.6 How to Create Tables?
10.7 Syntaxes Correlated to Database and Tables;
10.8 Column Data Access Syntax
10.9 Data Reading Syntax
10.10 Data Modifying Syntax
10.11 Data Deleting Syntax
10.12 Others Syntax

Lesson 11: Using PHP to connect to mySQL Database
11.1 connect to MySQL using mysql_connect()
11.2 The MySQL syntax executing function, mysql_db_query()
11.3 Another MySQL executing function, mysql_query()
11.4 fetch the Autonumber of the newly inserted data using mysql_insert_id()
11.6 fetch data from a returned array with mysql_fetch_array(), mysql_fetch_row(), and mysql_fetch_assoc()

Lesson 12: PHP and E-Mail
12.1 E-MAIL Operating Principles
12.2 Clients Setting of OUTLOOK
12.3 Sending Mail by PHP

Lesson 13: PHP Application – online ordering system
13.1 Create a simple online order system

Total training time: ~24 hours
Content: CD-ROM disc (sealed in a DVD-case)

System Requirements: 
Platform:  Windows 10, 8, 7 and Vista
Processor: Pentium 133 Mhz or higher 
Hard drive space: 10MB
CD-ROM Drive speed: 24X