PHP: MySQL Coding. In 8 Hours.

The length of this book is around 200 pages; you may not complete reading this book in 8 hours!

About This Book
"PHP MySQL in 8 hours" is a textbook for high school and college students; it covers all essential PHP MySQL language knowledge. You can learn complete primary skills of PHP MySQL programming fast and easily.
The textbook includes a lot of practical examples for beginners and includes exercises for the college final exam, the engineer certification exam, and the job interview exam.
“PHP MySQL in 8 hours” is a useful textbook for beginners. The straightforward definitions, the plain examples, the elaborate explanations and the neat layout feature this helpful and educative book. You will be impressed by its distinctive and tidy writing style. Reading this book is a great enjoyment!

This book is only suitable for programming beginners, high school students and college students; it is not for the experienced programmers.

Table of Contents

Chapter 1
What is PHP?
Install PHP & MySQL
Hello World Program
Comments
PHP Reserved Words
Variables
Data Types
Escaping Characters
Functions
Function with Arguments
Variable Scope
Multiple Arguments
Hands-on Project: Calculation

Chapter 2
Conditional Operator
Arithmetical Operators
Logical Operators
Assignment Operators
Comparison Operators
If Statement
If-else Statement
Switch Statement
For Loop
While Loop
Do-While Loop
Break Statement
Continue Statement
Return Statement
Hands-on Project: One to Ten

Chapter 3
Create an Array
Show array element values
Get the Size of Array
Array keys & Values
Iterate Array
Add Array Elements
Remove Array Elements
Merge Array
Extract Array
Sort Array
Hands-on Project: Start with Zero

Chapter 4
Create a Form
Text Inputs
Password Inputs
Submit Input
Reset Inputs
Textarea Inputs
Radio Inputs
Checkbox Inputs
Form Works with PHP (1)
Form Works with PHP (2)
Hands-on Project: Radio’s Colors

Chapter 5
Date & Time
String Process
Redirection of Browser
Visitor Browser Information
Cookie
Session
Session Usage
Open a File
Write a File
Read a File
Close a File
Hands-on Project: Extract Sth.

Chapter 6
Class Definition
Object Declaration
Class & Object
$this -> variable
Constructor (1)
Constructor (2)
Destructor
Extend Class
Inheritance Example
Class::method ( )
Hands-on Project: Appointment

Chapter 7
What is MySQL?
MySQL Data Type
Column Modifiers
phpMyAdmin
Show Databases
Create a Database
Select a Database
Create a table
Show Table
Insert Data to Table
Browse Table
Alter a table
Update Data
Select Queries
Database Commands
Table Commands
Field Modifiers
Operation Commands
Hands-on Project: Set Database

Chapter 8
Require a File
Include a File
Connect MySql Server
Select Database
Insert Table Data
Alter Table Structure
Update Table Data (1)
Update Table Data (2)
Retrieve Table Data
mysqli_fetch_row( )
mysqli_fetch_assoc( )
mysqli_fetch_array( )
mysqli_num_rows( )
mysqli_close( )
mysqli_xxx_xxx ( ) Summary
Hands-on Project: Work Together

PHP Questions & Answers
Questions
Answers