CUBRID_GET_QUERY_TIMEOUT(3) 1 CUBRID_GET_QUERY_TIMEOUT(3)cubrid_get_query_timeout - Get the query timeout value of the requestSYNOPSIS
int cubrid_get_query_timeout (resource $req_identifier)
DESCRIPTION
The cubrid_get_query_timeout(3) function is used to get the query timeout of the request.
PARAMETERS
o $req_identifier
-Request identifier.
RETURN VALUES
Success: the query timeout value of the current request. Units of msec.
Failure: FALSE
EXAMPLES
Example #1
cubrid_get_query_timeout(3) example
<?php
$host = "localhost";
$port = 33000;
$db = "demodb";
$conn =
cubrid_connect_with_url("CUBRID:$host:$port:$db:::?login_timeout=50000&query_timeout=5000&disconnect_on_query_timeout=yes");
$req = cubrid_prepare($conn, "SELECT * FROM code");
$timeout = cubrid_get_query_timeout($req);
var_dump($timeout);
cubrid_set_query_timeout($req, 1000);
$timeout = cubrid_get_query_timeout($req);
var_dump($timeout);
cubrid_close($conn);
?>
The above example will output:
int(5000)int(1000)SEE ALSO cubrid_set_query_timeout(3).
PHP Documentation Group CUBRID_GET_QUERY_TIMEOUT(3)
Check Out this Related Man Page
CUBRID_CONNECT_WITH_URL(3) 1 CUBRID_CONNECT_WITH_URL(3)cubrid_connect_with_url - Establish the environment for connecting to CUBRID serverSYNOPSIS
resource cubrid_connect_with_url (string $conn_url, [string $userid], [string $passwd], [bool $new_link = false])
DESCRIPTION
The cubrid_connect_with_url(3) function is used to establish the environment for connecting to your server by using connection information
passed with an url string argument. If the HA feature is enabled in CUBRID, you must specify the connection information of the standby
server, which is used for failover when failure occurs, in the url string argument of this function. If the user name and password is not
given, then the "PUBLIC" connection will be made by default.
<url> ::= CUBRID:<host>:<db_name>:<db_user>:<db_password>:[?<properties>]
<properties> ::= <property> [&<property>]
<properties> ::= alhosts=<alternative_hosts>[ &rctime=<time>]
<properties> ::= login_timeout=<milli_sec>
<properties> ::= query_timeout=<milli_sec>
<properties> ::= disconnect_on_query_timeout=true|false
<alternative_hosts> ::= <standby_broker1_host>:<port> [,<standby_broker2_host>:<port>]
<host> := HOSTNAME | IP_ADDR
<time> := SECOND
<milli_sec> := MILLI SECOND
ohost : A host name or IP address of the master database
odb_name : A name of the database
odb_user : A name of the database user
odb_password : A database user password
o 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
o 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.
o login_timeout : Timeout value (unit: msec.) for database login. The default value is 0, which means infinite postponement.
o query_timeout : Timeout value (unit: msec.) for query request. Upon timeout, a message to cancel requesting a query transferred to
server is sent. The return value can depend on the disconnect_on_query_timeout configuration; even though the message to cancel a
request is sent to server, that request may succeed.
o disconnect_on_query_timeout : Configures a value whether to immediately return an error of function being executed upon timeout.
The default value is false.
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 pass-
word that is invalid to use as connection URL because it contains " ?:".
$url = "CUBRID:localhost:33000:tdb:dba:12?:?login_timeout=100";
Passwords that contain ? or : may be passed as a separate parameter.
$url = "CUBRID:localhost:33000:tbd:::?login_timeout=100";
$conn = cubrid_connect_with_url($url, "dba", "12?");
If user or password is empty,you can't delete " :",the following is an example.
$url = "CUBRID:localhost:33000:demodb:::";
PARAMETERS
o $conn_url
-A character string that contains server connection information.
o $userid
-User name for the database.
o $passwd
-User password.
o $new_link
-If a second call is made to cubrid_connect_with_url(3) with the same arguments, no new connection will be established, but
instead, the connection identifier of the already opened connection will be returned. The $new_link parameter modifies this behav-
ior and makes cubrid_connect_with_url(3) always open a new connection, even if cubrid_connect_with_url(3) was called before with
the same parameters.
RETURN VALUES
Connection identifier, when process is successful.
FALSE, when process is unsuccessful.
EXAMPLES
Example #1
cubrid_connect_with_url(3) url without properties example
<?php
$conn_url = "CUBRID:localhost:33000:demodb:dba::";
$con = cubrid_connect_with_url($conn_url);
if ($con) {
echo "connected successfully";
cubrid_execute($con, "create table person(id int,name char(16))");
$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(3) url with properties example
<?php
$conn_url = "CUBRID:127.0.0.1:33000:demodb:dba::?login_timeout=100"
$con = cubrid_connect_with_url ($conn_url);
if ($con) {
echo "connected successfully";
cubrid_execute($con, "create table person(id int,name char(16))");
$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);
}
?>
SEE ALSO cubrid_connect(3), cubrid_pconnect(3), cubrid_pconnect_with_url(3), cubrid_disconnect(3), cubrid_close(3).
PHP Documentation Group CUBRID_CONNECT_WITH_URL(3)