cubrid_connect_with_url

Establish the environment for connecting to CUBRID server

resource **cubrid_connect_with_url** string $conn_url string $userid string $passwd bool $new_link

The 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. cubrid_connect_with_url

::= 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

:= SECOND

<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_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:::";

conn_urlA character string that contains server connection information.

useridUser name for the database.

passwdUser password.

new_linkIf a second call is made to with the same arguments, no new connection will be established, but instead, the connection identifier of the already opened connection will be returned. The parameter modifies this behavior and makes always open a new connection, even if was called before with the same parameters.cubrid_connect_with_url``new_link``cubrid_connect_with_url``cubrid_connect_with_url

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

Voorbeeld: 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);
}
?>

Voorbeeld: 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);
}
?>

cubrid_connect``cubrid_pconnect``cubrid_pconnect_with_url``cubrid_disconnect``cubrid_close

Vorige ← cubrid_commit Volgende cubrid_connect →

cubrid_connect_with_url

cubrid_connect_with_url

Documentatie