cubrid_pconnect_with_url

설명

cubrid_pconnect_with_url 함수는 데이터베이스 서버로의 영구적인(persistent) 연결을 설정한다.

cubrid_pconnect_with_url 함수는 cubrid_connect_with_url 함수와 동작이 유사하며, 다음 2가지의 차이가 있다.

구문

resource cubrid_pconnect_with_url( string $conn_url[, string $userid[, string $passwd]] )

 

<conn_url> ::= [cci:]CUBRID:<host>:<db_name>:<db_user>:<db_password>:[?<properties>]

<properties> ::= <property> [&<property>]

<property> ::= autocommit=<autocommit_mode>

<property> ::= althosts=<alternative_hosts> [ &rctime=<time>]

<property> ::= login_timeout=<milli_sec>

<property> ::= query_timeout=<milli_sec>

<property> ::= disconnect_on_query_timeout=true|false

 

<alternative_hosts> ::= <host>:<port>[, <host>:<port>]

<host> := HOSTNAME | IP_ADDR

 

<time> := SECOND

<milli_sec> := MILLISECOND

리턴 값
예제

Example #1 cubrid_pconnect_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_pconnect_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_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);

}

?>