PHP and MySQL

Current Status

Not Enrolled

Price

$19.95

Get Started

or

Course Content

Expand All

1 Getting Started with PHP and AppServ 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

1_1 PHP and AppServ

1_2 Downloading and Installing AppServ

1_3 Web Page Detection

2 Your First PHP Script 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

2_1 Writing Your First Script to Understand the PHP Syntax

2_2 Semicolon and Error Messages

2_3 Understanding Parsing PHP Statements

2_4 Saving .phps for Files Sharing

2_5 Finding PHP Information

3 Variables and Contants 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

3_1 Upper/lower case usage, statements, semicolons and white spaces

3_2 Constants, Variables and Functions

3_4 Class, Expression, Priority of Operators and Variable Variables

3_5 SuperGlobal; comparison between constants and variables

3_6 Summary for Chapter 3

4 Strings 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

4_1 Variables Interpolation, Single/Double- Quoted String & HEREDOC

4_2 String Printing

4_3 Access Single Character

4_4 String Trim

4_5 Encode and Escape Character

4_6 String Operation and Searching

4_7 Regular Expression

4_8 Summary for Chapter 4

5 Arrays 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

5_1 Indexed and Associative Array

5_2 Elements in a Array

5_3 Multi-Dimentional Arrays

5_4 Array Arrangement

5_5 Array Searching

6 Objects-Oriented Programming 10 Topics

Expand

Lesson Content

0% Complete 0/10 Steps

6_2 Defining a Class

6_3 Creating an Object

6_4 Creating an Object

6_5 Class Method

6_6 Data Encapsulation

6_7 Data Inheritance

6_8 Data Polymorphism

6_9 Class Inspection

6_10 Object Serialization

7 Forms, Cookies and Sessions 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

7_1 Variables and Server Information

7_2 Form Processing

8 Flow Controls 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

8_1 IF Construct

8_2 Using Switch for Multiple Decision

8_4 FOR and FOREACH Loop

8_5 EXIT Command

9 Functions 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

9_1 Call Function

9_2 Define Function

9_3 Function Parameter

9_4 Scope of Variables

9_5 Default Parameter

9_6 Variable number of Parameter

9_7 Return Value

9_8 Variable and Anonymous Function

10 MySQL Database Application 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

10_1 MySQL Operational Mode

10_2 Starting PHP MyADMIN

10_3 Changing Password in PHP MyAdmin

10_4 Understanding SQL Syntax

10_5 Creating Tables and Inserting Table Data

10_6 Data Reading Syntax

10_7 Data Modifying Syntax

10_8 Data Deleting Syntax and Summary

11 Using PHP to conect to MySQL database 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

11_1 Connecting to SQL

11_2 Executing MySQL Function

11_3 Another MySQL Executing Function

11_4 Fetching Autonumber of Newly Inserted Data

11_5 Fetching Data from a Return Array

12 PHP and E-mail 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

12_2 Using Outlook as Mail Server

12_3 Sending mail by PHP

13 PHP Application 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

13 PHP Application – Online Ordering System