+
+
+
(PHP 4, PHP 5)
mysql_pconnect — Open a persistent connection to a MySQL server
+
+
+
+
+
Description
+
+ resource 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
+ ]]]] )
+
+
+
+
+
+ mysql_pconnect() acts very much like
+ mysql_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_CLIENT_COMPRESS,
+ MYSQL_CLIENT_IGNORE_SPACE or
+ MYSQL_CLIENT_INTERACTIVE.
+
+
+
+
+
+
+
+
+
+
+
+
Return Values
+
+ Returns a MySQL persistent link identifier on success, or FALSE on
+ failure.
+
+
+
+
+
+
+
+
+
Notes
+
+ Note
+
+ Note, that these kind of links only work if you are using
+ a module version of PHP. See the
+ Persistent
+ Database Connections section for more information.
+
+
+ Warning
+
+ Using persistent connections can require a bit of tuning of your Apache
+ and MySQL configurations to ensure that you do not exceed the number of
+ connections allowed by MySQL.
+
+
+
+ Note
+
+ You can suppress the error message on failure by prepending
+ a @
+ to the function name.
+
+
+
+
+
+
+
