cubrid_connect_with_url

Description

The cubrid_connect_with_url() function tries to connect a database by using connection information passed with an url string argument. If the HA feature is enabled in PHP, you must specify connection information of the active server and connection information of the standby server, which is used for failover when failure occurs, in the url string argument of this function. If it has succeeded, the ID of connection handle is returned; if it fails, an error code is returned.

Syntax

resource cubrid_connect_with_url(string $conn_url[, string $db_user, string $db_password ])

• conn_url : A character string that contains server connection information
• db_user : A name of the database user
• db_password : A database user password

<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>]

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

<host> := HOSTNAME | IP_ADDR

<time> := SECOND

• host : A host name or IP address of the master database
• db_name : A name of the database
• autocommit=true/false : The database connection auto commit mode.
• althosts =standby_broker1_host, standby_broker2_host, . . . : 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.

• db_user : (IN) A name of the database user
• db_passwd : (IN) A database user password

Return Value

• Success : Connection identifier
• Failure : FALSE

Example

<?php

$con = cubrid_connect_with_url("cci:CUBRID:localhost:33000:demodb:dba::?autocommit=true");

?>