PHP: Hypertext Preprocessor (original) (raw)

mysql_pconnect

(PHP 4, PHP 5)

mysql_pconnect — Open a persistent connection to a MySQL server

Description

mysql_pconnect(
string $server = ini_get("mysql.default_host"),
string $username = ini_get("mysql.default_user"),
string $password = ini_get("mysql.default_password"),
int $client_flags = 0
): resource

mysql_pconnect() acts very much likemysql_connect() with two major differences.

First, when connecting, the function would first try to find a (persistent) link that's already open with the same host, username and password. If one is found, an identifier for it will be returned instead of opening a new connection.

Second, the connection to the SQL server will not be closed when the execution of the script ends. Instead, the link will remain open for future use (mysql_close() will not close links established by mysql_pconnect()).

This type of link is therefore called 'persistent'.

Parameters

server

The MySQL server. It can also include a port number. e.g. "hostname:port" or a path to a local socket e.g. ":/path/to/socket" for the localhost.

If the PHP directive mysql.default_host is undefined (default), then the default value is 'localhost:3306'

username

The username. Default value is the name of the user that owns the server process.

password

The password. Default value is an empty password.

client_flags

The client_flags parameter can be a combination of the following constants: 128 (enable LOAD DATA LOCAL handling),[MYSQL_CLIENT_SSL](mysql.constants.php#constant.mysql-client-ssl), [MYSQL_CLIENT_COMPRESS](mysql.constants.php#constant.mysql-client-compress), [MYSQL_CLIENT_IGNORE_SPACE](mysql.constants.php#constant.mysql-client-ignore-space) or**[MYSQL_CLIENT_INTERACTIVE](mysql.constants.php#constant.mysql-client-interactive)**.

Return Values

Returns a MySQL persistent link identifier on success, or [false](reserved.constants.php#constant.false) on failure.

Notes

Note:

Note, that these kind of links only work if you are using a module version of PHP. See thePersistent Database Connections section for more information.

Warning