cubrid_pconnect_with_url
(PECL CUBRID >= 8.3.1)
cubrid_pconnect_with_url — Open a persistent connection to CUBRID server
Описание
resource cubrid_pconnect_with_url
( string $conn_url
[, string $userid
[, string $passwd
]] )
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>:......
- host : A host name or IP address of the master database
- db_name : A name of the database
- db_user : A name of the database user
- db_password : A database user password
- autocommit : The database connection auto-commit mode
- alhosts: Specifies the broker information of the standby server, which is used for failover when it is impossible to connect to the active server. You can specify multiple brokers for failover, and the connection to the brokers is attempted in the order listed in alhosts
- rctime : An interval between the attempts to connect to the active broker in which failure occurred. After a failure occurs, the system connects to the broker specified by althosts (failover), terminates the transaction, and then attempts to connect to the active broker of the master database at every rctime. The default value is 600 seconds.
Список параметров
-
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.
Примеры
Пример #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);
}
?>
Пример #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);
}
?>