(PECL CUBRID >= 8.3.1)
cubrid_pconnect_with_url — Open a persistent connection to CUBRID server
$conn_url
[, string $userid
[, string $passwd
]] )Establishes a persistent connection to a CUBRID server.
cubrid_pconnect_with_url() acts very much like cubrid_connect_with_url() 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, port, dbname and userid. 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 (cubrid_close() or cubrid_disconnect() will not close links established by cubrid_pconnect_with_url()).
This type of link is therefore called 'persistent'.
<url> ::= CUBRID:<host>:<db_name>:<db_user>:<db_password>:[?<properties>] <properties> ::= <property> [&<property>] <properties> ::= autocommit=<autocommit_mode> <alternative_hosts> ::= <standby_broker1_host>:<port> [,<standby_broker2_host>:<port>] <host> := HOSTNAME | IP_ADDR <time> := SECOND
or <url> ::= cci:CUBRID:<host>:<db_name>:......
Note:
? and : that are used as identifiers in PHP connection URL can't be included in the password. The following is an example of a password that is invalid to use as connection URL because it contains "?:".
$url = "CUBRID:localhost:33000:tdb:dba:12?:?autocommit=off";
Passwords that contain ? or : may be passed as a seperate parameter.
$url = "CUBRID:localhost:33000:tbd:::?autocommit=off"; $conn = cubrid_connect_with_url ($url, "dba", "12?");
conn_url
A character string that contains server connection information.
userid
User name for the database.
passwd
User password.
Connection identifier, when process is successful.
FALSE
, when process is unsuccessful.
Example #1 cubrid_connect_with_url() url without properties example
<?php
$conn_url = "CUBRID:127.0.0.1:33000:demodb:dba:123456:?autocommit=off"
$con = cubrid_pconnect_with_url ($conn_url);
if ($con) {
echo "connected successfully";
$req =cubrid_execute($con, "insert into person values(1,'James')");
if ($req) {
cubrid_close_request ($req);
cubrid_commit ($con);
} else {
cubrid_rollback ($con);
}
cubrid_disconnect ($con);
}
?>
Example #2 cubrid_connect_with_url() url with properties example
<?php
$conn_url = "CUBRID:127.0.0.1:33000:demodb:dba:123456:?autocommit=off&althost=10.34.63.132:33088&rctime=100"
$con = cubrid_connect_with_url ($conn_url);
if ($con) {
echo "connected successfully";
$req =cubrid_execute($con, "insert into person values(1,'James')");
if ($req) {
cubrid_close_request ($req);
cubrid_commit ($con);
} else {
cubrid_rollback ($con);
}
cubrid_disconnect ($con);
}
?>