Building Chinese Web Sites using PHP

It can be used as a tutorial guide for beginners. Topics include installing PHP and Tomcat; creating PHP pages; displaying pages in Chinese; saving Chinese characters to MySQL database; fetching Chinese characters from MySQL database.

Table of Contents

About This Book

PHP Installation on Windows Systems

Download and Install PHP 5.2.2 on Windows

Running PHP Scripts

Integrating PHP with Apache Web Server

Downloading Apache 2.2.4 Binary for Windows

Installing Apache 2.2.4 on Windows Systems

Publishing HTML Documents as Web Pages

Configuring Apache for PHP CGI Scripts

Publishing PHP Scripts as Web Pages

charset="*" - Encodings on Chinese Web Pages

Chinese Character Set Encoding Options

HTML Document Travel Path

Chinese Web Pages with UTF-8 Encoding

Chinese Web Pages with GB18030 Encoding

Chinese Web Pages with Big5 Encoding

UTF-8 Encoding Pages with GB18030 Characters

Chinese Characters in PHP String Literals

String Data Type, Literals and Functions

String Literal Travel Path

Chinese Character String with UTF-8 Encoding

Chinese Character String with GB18030 Encoding

Chinese Character String with Big5 Encoding

UTF-8 Encoding Pages with Big5 Characters

Multibyte String Functions in UTF-8 Encoding

php_mbstring.dll - Multibyte String Functions

mb_strlen() - Counting Multibyte Characters

List of Multibyte String Functions

Input Text Data from Web Forms

Steps and Components Involved

Processing Web Form Input in ASCII

Processing Web Form Input in Latin1

Entering Latin1 Characters with Alt Keycodes

Testing Latin1 Alt Keycodes with IE

Processing Web Form Input in UTF-8

Outputting Form Default Input Text in UTF-8

Testing Alt Keycodes with IE on a UTF-8 Web Page

Input Chinese Text Data from Web Forms

Steps and Components Involved

Processing Chinese Input on Web Forms in UTF-8

Processing Chinese Input on Web Forms in GB18030

Processing Chinese Input on Web Forms in Big5

Copying and Pasting Chinese Input to UTF-8 Web Forms

Copying and Pasting Chinese Input to GB18030 Web Forms

Copying and Pasting Chinese Input to Big5 Web Forms

MySQL - Installation on Windows

MySQL 5.0 Download, Installation and Start

mysqladmin - MySQL Admin Tool

mysql - Command Line Tool

Creating Database and User with MySQL Monitor

Creating a Test Table - Comment

MySQL - Connecting PHP to Database

php_mysql.dll - Configuring PHP to Use MySQL Module

Commonly Used MySQL Functions

mysql_connect() - Creating MySQL Connections

INSERT INTO - Inserting New Records

SELECT - Running Database Queries

UPDATE - Modifying Database Records

MySQL - Character Set and Encoding

Specifying Character Set for Text Columns

Creating a Table with Multiple Character Sets

Checking Character Set Setting

Storing ASCII Characters in Non-ASCII Columns

Storing Non-ASCII Characters with Encoded Bytes

Transmitting Non-ASCII Characters between PHP and MySQL

Viewing Character Set Variables

Non-ASCII Test Result Analysis

Fetching Non-ASCII Text from MySQL

MySQL - Sending Non-ASCII Text to MySQL

Sending Non-ASCII Text to MySQL in Latin1 Encoding

Sending Non-ASCII Text to MySQL in UTF8 Encoding

Sending Non-ASCII Text to MySQL in GBK Encoding

Sending Non-ASCII Text to MySQL in Big5 Encoding

Sending Non-ASCII Text to MySQL in Multiple Encoding

Summary - Sending and Fetching Non-ASCII Text

Retrieving Chinese Text from Database to Web Pages

Steps and Application Components Involved

MySQL-Retrieve-Chinese-Text--to-Web-ASCII

MySQL-Retrieve-Chinese-Text-to-Web-Chinese

MySQL-Retrieve-Chinese-Text-to-Web-UTF-8

MySQL-Retrieve-Chinese-Text-to-Web-GBK

MySQL-Retrieve-Chinese-Text-to-Web-Big5

MySQL-Retrieve-Chinese-Text-to-Web-Summary

Input Chinese Text Data to MySQL Database

Steps and Application Components Involved

Inputting Chinese Text to MySQL Database in UTF-8

Inputting Chinese Text to MySQL Database in GBK

Inputting Chinese Text to MySQL Database in Big5

Summary

References