PHP mysql_pconnect() Function
Complete PHP MySQL Reference
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
Syntax
mysql_pconnect(server,user,pwd,clientflag)
|
Parameter |
Description |
server |
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" |
user |
Optional. Specifies the username to log in with. Default
value is the name of the user that owns the server process |
pwd |
Optional. Specifies the password to log in with. Default is
"" |
clientflag |
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.
Example
<?php
$con = mysql_pconnect("localhost","mysql_user","mysql_pwd");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
?>
|
Complete PHP MySQL Reference
|