cubrid_get_db_parameter

Description

The cubrid_get_db_parameter() function returns the CUBRID system parameters. It returns the CUBRID system parameters or it returns FALSE on failure. It returns an associative array with the values for the following parameters:

• PARAM_ISOLATION_LEVEL : In CUBRID PHP, you can set the level of transaction isolation by using cubrid_set_db_parameter() function, isolation_level in the $CUBRID/conf/cubrid.conf or the SET TRANSACTION statement. For levels of isolation supported by CUBRID, refer SET TRANSACTION ISOLATION LEVEL on the manual.
• PARAM_LOCK_TIMEOUT : CUBRID provides the lock timeout feature, which sets the waiting time for the lock until the transaction lock setting is allowed. You can set lock timeout by using cubrid_set_db_parameter() function, parameter lock_timeout_in_secs in the $CUBRID/conf/cubrid.conf file or the SET TRANSACTION statement (in seconds). The default value of the lock_timeout_in_secs parameter is -1, which means the application client will wait indefinitely until the transaction lock is allowed.
• PARAM_MAX_STRING_LENGTH : The maximum string length of a parameter
• PARAM_AUTO_COMMIT : In CUBRID PHP, an auto-commit mode is enabled by default for transaction management. If you want to start a transaction, you should set auto-commit mode to off by using the cubrid_set_autocommit() function. And auto commit modes can be applied only for SELECT statements by setting broker parameters.

Syntax

array cubrid_get_db_parameter ( resource $conn_identifier )

• conn_identifier : Connection identifier previously obtained from a call to cubrid_connect()

Return Value

• Success : An associative array with CUBRID system parameters
• Failure : FALSE

Example

<?php

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

printf("\n");

$conn = cubrid_connect("localhost", 33088, "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\n", $param_name, $param_value);

}

printf("\n");

$server_info = cubrid_get_server_info($conn);

$client_info = cubrid_get_client_info();

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

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

printf("\n");

$charset = cubrid_get_charset($conn);

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

cubrid_disconnect($conn);

?>

The above example will output:

CUBRID PHP Version:                 8.3.1.0005

PARAM_ISOLATION_LEVEL               3

LOCK_TIMEOUT                        -1

MAX_STRING_LENGTH                   1073741823

PARAM_AUTO_COMMIT                   0

Server Info:                        8.3.1.0173

Client Info:                        8.3.1

CUBRID Charset:                     iso8859-1

See Also

• cubrid_set_db_parameter