(mysql.info) php
Info Catalog
(mysql.info) c
(mysql.info) apis
(mysql.info) perl
22.3 MySQL PHP API
==================
Menu
* php-problems Common Problems with MySQL and PHP
* php-mysql-mysqli Enabling Both `mysql' and `mysqli' in PHP
PHP is a server-side, HTML-embedded scripting language that may be used
to create dynamic Web pages. It is available for most operating systems
and Web servers, and can access most common databases, including MySQL.
PHP may be run as a separate program or compiled as a module for use
with the Apache Web server.
PHP actually provides two different MySQL API extensions:
* `mysql': Available for PHP versions 4 and 5, this extension is
intended for use with MySQL versions prior to MySQL 4.1. This
extension does not support the improved authentication protocol
used in MySQL 5.0, nor does it support prepared statements or
multiple statements. If you wish to use this extension with MySQL
5.0, you will likely want to configure the MySQL server to use the
`--old-passwords' option (see old-client). This extension
is documented on the PHP Web site at `http://php.net/mysql'.
* `mysqli' - Stands for `MySQL, Improved'; this extension is
available only in PHP 5. It is intended for use with MySQL 4.1.1
and later. This extension fully supports the authentication
protocol used in MySQL 5.0, as well as the Prepared Statements and
Multiple Statements APIs. In addition, this extension provides an
advanced, object-oriented programming interface. You can read the
documentation for the `mysqli' extension at
`http://php.net/mysqli'. A helpful article can be found at
`http://www.zend.com/php5/articles/php5-mysqli.php'.
If you're experiencing problems with enabling both the `mysql' and the
`mysqli' extension when building PHP on Linux yourself, see
php-mysql-mysqli.
The PHP distribution and documentation are available from the PHP Web
site (http://www.php.net/). MySQL provides the `mysql' and `mysqli'
extensions for the Windows operating system for MySQL versions as of
5.0.18 on `http://dev.mysql.com/downloads/connector/php/'. You can
find information why you should preferably use the extensions provided
by MySQL on that page.
Info Catalog
(mysql.info) c
(mysql.info) apis
(mysql.info) perl
automatically generated byinfo2html