 |  |
Chapter 18. MySQL PHP API Reference
Contents:
In this chapter, we list the functions that allow you to access the MySQL DBMS from PHP. We begin by discussing two database-specific data types used in many of these functions. The functions are then presented alphabetically with descriptions, and each includes an example code fragment. An introduction to PHP and examples of using PHP to access a MySQL DBMS are presented in Chapter 11. This chapter is based on Version 4.1.2, which was the version of PHP available at the time this book was written, but some differences between versions are discussed.
18.1. Data Types
The following PHP data types are specialized types for database access:
- cresource
- A connection resource handle. An integer returned from the functions mysql_connect( ), and mysql_pconnect( ). Both functions are used to establish a connection to a MySQL DBMS, and are described later in this chapter. The connection resource handle is used as a parameter to several functions (such as mysql_select_db( ), mysql_query( ), and mysql_affected_rows( )) to determine or change aspects of the connection.
- qresource
- A query resource handle. An integer returned from functions such as mysql_query(), mysql_list_fields(), mysql_list_dbs(), and mysql_unbuffered_query(). These functions are used to execute a query through a connection resource handle, and are described later in this chapter. A query resource handle is used as a parameter to several functions (such as mysql_fetch_array(), mysql_tablename(), and mysql_num_rows()) to retrieve a query's output or information about the query.
|  | |
| 17.2. Functions |  | 18.2. Functions |
Copyright © 2003 O'Reilly & Associates. All rights reserved.