PHP 6 and MySQL Step-By-Step Training Course with Sample Codes
Extra bonus: Introduction to SQL
 

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.

Feature:

• 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

7.5 COOKIE

7.6 SESSION

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

Reference – Introduction to SQL

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

System Requirements:
Platform: Windows Vista / XP / 2000 / 9x / NT
Processor: Pentium 133 Mhz or higher
RAM: 32MB
Hard drive space: 10MB
CD-ROM Drive speed: 24X

Technical Support: support@computerlearningpro.com