PHP mysql_pconnect() Function
Definition and Usage
The mysql_pconnect() function opens a persistent MySQL connection.
This function returns the connection on success, or FALSE and an error on failure. You can hide the error output by adding an '@' in front of the function name.
mysql_pconnect() is much like mysql_connect(), but with two major differences:
- This function will try to find a connection that's already open, with the same host, username and password. If one is found, this will be returned instead of opening a new connection
- The connection will not be closed when the execution of the script ends (mysql_close() will not close connection opened by mysql_pconnect()). It will stay open for future use
||Optional. Specifies the server to connect to (can also include a port number. e.g. "hostname:port" or a path to a local socket for the localhost). Default value is "localhost:3306"
||Optional. Specifies the username to log in with. Default value is the name of the user that owns the server process
||Optional. Specifies the password to log in with. Default is ""
||Optional. Can be a combination of the following constants:
- MYSQL_CLIENT_SSL - Use SSL encryption
- MYSQL_CLIENT_COMPRESS - Use compression protocol
- MYSQL_CLIENT_IGNORE_SPACE - Allow space after function names
- MYSQL_CLIENT_INTERACTIVE - Allow interactive timeout seconds of inactivity before closing the connection
Tips and Notes
Tip: To establish a non-persistent MySQL connection, use mysql_connect() instead.
$con = mysql_pconnect("localhost","mysql_user","mysql_pwd");
die('Could not connect: ' . mysql_error());