MySQL and PHP

Abstract This manual 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 either the MySQL Forums or MySQL Mailing Lists, where you can discuss your issues with other MySQL users. For additional documentation on MySQL products, including translations of the documentation into other languages, and downloadable versions in variety of formats, including HTML and PDF formats, see the MySQL Documentation Library. Document generated on: 2017-09-12 (revision: 53901)

Table of Contents Preface and Legal Notices ............................................................................................................... xiii 1 Introduction to the MySQL PHP API ................................................................................................ 1 2 Overview of the MySQL PHP drivers ............................................................................................... 3 2.1 Introduction .......................................................................................................................... 3 2.2 Terminology overview ........................................................................................................... 3 2.3 Choosing an API .................................................................................................................. 4 2.4 Choosing a library ................................................................................................................ 6 2.5 Concepts .............................................................................................................................. 7 2.5.1 Buffered and Unbuffered queries ................................................................................ 7 2.5.2 Character sets ........................................................................................................... 8 3 MySQL Improved Extension ........................................................................................................... 11 3.1 Overview ............................................................................................................................ 14 3.2 Quick start guide ................................................................................................................ 18 3.2.1 Dual procedural and object-oriented interface ............................................................ 18 3.2.2 Connections ............................................................................................................. 20 3.2.3 Executing statements ............................................................................................... 22 3.2.4 Prepared Statements ............................................................................................... 26 3.2.5 Stored Procedures ................................................................................................... 33 3.2.6 Multiple Statements ................................................................................................. 38 3.2.7 API support for transactions ..................................................................................... 39 3.2.8 Metadata ................................................................................................................. 40 3.3 Installing/Configuring ........................................................................................................... 42 3.3.1 Requirements .......................................................................................................... 42 3.3.2 Installation ............................................................................................................... 42 3.3.3 Runtime Configuration .............................................................................................. 44 3.3.4 Resource Types ...................................................................................................... 46 3.4 The mysqli Extension and Pe