PHP.nl

cubrid_pconnect_with_url

cubrid_pconnect_with_url

Open a persistent connection to CUBRID server

resource **cubrid_pconnect_with_url** string $conn_url string $userid string $passwd

Establishes a persistent connection to a CUBRID server.

acts very much like
with two major differences.

cubrid_pconnect_with_url``cubrid_connect_with_url

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 ( or will not close links established by ). cubrid_close``cubrid_disconnect``cubrid_pconnect_with_url

This type of link is therefore called 'persistent'.

::= CUBRID::<db_name>:<db_user>:<db_password>:[?]

::= [&]

::= alhosts=<alternative_hosts>[ &rctime=

::= login_timeout=<milli_sec>

::= query_timeout=<milli_sec>

::= disconnect_on_query_timeout=true|false

<alternative_hosts> ::= <standby_broker1_host>: [,<standby_broker2_host>:]

:= HOSTNAME | IP_ADDR

<milli_sec> := MILLI SECOND

Opmerking: > 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?:?login_timeout=100";

Passwords that contain  or  may be
passed as a separate parameter.

?``:

$url = "CUBRID:localhost:33000:tbd:::?login_timeout=100";

$conn = cubrid_pconnect_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:::";

conn_urlA character string that contains server connection information.

useridUser name for the database.

passwdUser password.

Connection identifier, when process is successful,return.falseforfailure.

Voorbeeld: url without properties example

<?php
$conn_url = "CUBRID:127.0.0.1:33000:demodb:dba::";
$con = cubrid_pconnect_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);
}
?>

Voorbeeld: url with properties example

<?php
$conn_url = "CUBRID:127.0.0.1:33000:demodb:dba::?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);
}
?>

cubrid_connect``cubrid_connect_with_url``cubrid_pconnect``cubrid_disconnect``cubrid_close

Vorige ← cubrid_num_rows Volgende cubrid_pconnect →

Documentatie