Chapter 7 MySQL and PHP

Table of Contents

7.1 Introduction to the MySQL PHP API

7.2 Overview of the MySQL PHP drivers

7.2.1 Introduction

7.2.2 Terminology overview

7.2.3 Choosing an API

7.2.4 Choosing a library

7.2.5 Concepts

7.3 MySQL Improved Extension

7.3.1 Overview

7.3.2 Quick start guide

7.3.3 Installing/Configuring

7.3.4 The mysqli Extension and Persistent Connections

7.3.5 Predefined Constants

7.3.6 Notes

7.3.7 The MySQLi Extension Function Summary

7.3.8 Examples

7.3.9 The mysqli class

7.3.10 The mysqli_stmt class

7.3.11 The mysqli_result class

7.3.12 The mysqli_driver class

7.3.13 The mysqli_warning class

7.3.14 The mysqli_sql_exception class

7.3.15 Aliases and deprecated Mysqli Functions

7.3.16 Changelog

7.4 MySQL Functions (PDO_MYSQL)

7.4.1 PDO_MYSQL DSN

7.5 Original MySQL API

7.5.1 Installing/Configuring

7.5.2 Changelog

7.5.3 Predefined Constants

7.5.4 Examples

7.5.5 MySQL Functions

7.6 MySQL Native Driver

7.6.1 Overview

7.6.2 Installation

7.6.3 Runtime Configuration

7.6.4 Incompatibilities

7.6.5 Persistent Connections

7.6.6 Statistics

7.6.7 Notes

7.6.8 Memory management

7.6.9 MySQL Native Driver Plugin API

7.7 Mysqlnd replication and load balancing plugin

7.7.1 Key Features

7.7.2 Limitations

7.7.3 On the name

7.7.4 Quickstart and Examples

7.7.5 Concepts

7.7.6 Installing/Configuring

7.7.7 Predefined Constants

7.7.8 Mysqlnd_ms Functions

7.7.9 Change History

7.8 Mysqlnd query result cache plugin

7.8.1 Key Features

7.8.2 Limitations

7.8.3 On the name

7.8.4 Quickstart and Examples

7.8.5 Installing/Configuring

7.8.6 Predefined Constants

7.8.7 mysqlnd_qc Functions

7.8.8 Change History

7.9 Mysqlnd user handler plugin

7.9.1 Security considerations

7.9.2 Documentation note

7.9.3 On the name

7.9.4 Quickstart and Examples

7.9.5 Installing/Configuring

7.9.6 Predefined Constants

7.9.7 The MysqlndUhConnection class

7.9.8 The MysqlndUhPreparedStatement class

7.9.9 Mysqlnd_uh Functions

7.9.10 Change History

7.10 Mysqlnd connection multiplexing plugin

7.10.1 Key Features

7.10.2 Limitations

7.10.3 About the name mysqlnd_mux

7.10.4 Concepts

7.10.5 Installing/Configuring

7.10.6 Predefined Constants

7.10.7 Change History

7.11 Mysqlnd Memcache plugin

7.11.1 Key Features

7.11.2 Limitations

7.11.3 On the name

7.11.4 Quickstart and Examples

7.11.5 Installing/Configuring

7.11.6 Predefined Constants

7.11.7 Mysqlnd_memcache Functions

7.11.8 Change History

7.12 Common Problems with MySQL and PHP

This chapter describes the PHP extensions and interfaces that can be used with MySQL.

For legal information, see the Legal Notices.

For help with using MySQL, please visit the MySQL Forums, where you can discuss your issues with other MySQL users.