Commonly Used MySQL Functions

This section provides a list of commonly used MySQL functions.

Once MySQL module, php_mysql.dll, is loaded into PHP, it offers a large number functions to help you to access MySQL servers and perform database related tasks. Some commonly used MySQL functions are:

Last update: 2015.

Table of Contents

 About This Book

 PHP Installation on Windows Systems

 Integrating PHP with Apache Web Server

 charset="*" - Encodings on Chinese Web Pages

 Chinese Characters in PHP String Literals

 Multibyte String Functions in UTF-8 Encoding

 Input Text Data from Web Forms

 Input Chinese Text Data from Web Forms

 MySQL - Installation on Windows

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

 MySQL - Sending Non-ASCII Text to MySQL

 Retrieving Chinese Text from Database to Web Pages

 Input Chinese Text Data to MySQL Database

 References

 PDF Printing Version