Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.4.1 | 



cubrid_pconnect

Description

The cubrid_pconnect function configures the persistent connection to a database server.

The cubrid_pconnect function is working similar to the cubrid_connect function but there are two differences as follows:

  • When the cubrid_pconnect function is executed, it looks for a persistent link with the same host, port number, database name, and user name and returns an existing connection identifier if it exists.
  • The connection made by the cubrid_pconnect function is maintained although the cubrid_close or cubrid_disconnect function is called.
Syntax

resource cubrid_pconnect( string $host, int $port, string $dbname[, string $userid[, string $passwd]] )

  • host : IP address and host name of the Broker Server
  • port : Port number of the Broker Server (BROKER_PORT defined in $CUBRID/conf/cubrid_broker.conf)
  • dbname : Database name
  • userid : Database user name
  • passwd : Database user password
Return Value
  • Success : Connection identifier
  • Failure : FALSE
Example

<?php

printf("%-30s %s ", "CUBRID PHP Version:", cubrid_version());

 

printf(" ");

 

$conn = cubrid_pconnect("localhost", 33000, "demodb");

 

if (!$conn) { die('Connect Error ('. cubrid_error_code() .')' . cubrid_error_msg()); }

 

$db_params = cubrid_get_db_parameter($conn);

 

while (list($param_name, $param_value) = each($db_params)) { printf("%-30s %s ", $param_name, $param_value); }

 

printf(" ");

 

$server_info = cubrid_get_server_info($conn);

$client_info = cubrid_get_client_info();

 

printf("%-30s %s ", "Server Info:", $server_info);

printf("%-30s %s ", "Client Info:", $client_info);

 

printf(" ");

 

$charset = cubrid_get_charset($conn);

 

printf("%-30s %s ", "CUBRID Charset:", $charset);

 

cubrid_disconnect($conn);

?>

 

The above example will output:

CUBRID PHP Version: 8.4.1.0001

 

PARAM_ISOLATION_LEVEL 3

LOCK_TIMEOUT 0

MAX_STRING_LENGTH 1073741823

PARAM_AUTO_COMMIT 0

 

Server Info: 8.4.1.0508

Client Info: 8.4.1

CUBRID Charset: iso8859-1