CUBRID_SET_DB_PARAMETER(3) 1 CUBRID_SET_DB_PARAMETER(3)
cubrid_set_db_parameter - Sets the CUBRID database parameters
SYNOPSIS
bool cubrid_set_db_parameter (resource $conn_identifier, int $param_type, int $param_value)
DESCRIPTION
The cubrid_set_db_parameter(3) function is used to set the CUBRID database parameters. It can set the following CUBRID database parame-
ters:
o PARAM_ISOLATION_LEVEL
o PARAM_LOCK_TIMEOUT
Note
The auto-commit mode can be set by using cubrid_set_autocommit(3).
PARAMETERS
o $conn_identifier
- The CUBRID connection. If the connection identifier is not specified, the last link opened by cubrid_connect(3) is assumed.
o $param_type
-Database parameter type.
o $param_value
-Isolation level value (1-6) or lock timeout (in seconds) value.
RETURN VALUES
TRUE on success.
FALSE on failure.
EXAMPLES
Example #1
cubrid_get_db_parameter(3) example
<?php
$conn = cubrid_connect("localhost", 33000, "demodb", "dba");
$params = cubrid_get_db_parameter($conn);
var_dump($params);
cubrid_set_autocommit($conn, CUBRID_AUTOCOMMIT_TRUE);
cubrid_set_db_parameter($conn, CUBRID_PARAM_ISOLATION_LEVEL, 2);
$params_new = cubrid_get_db_parameter($conn);
var_dump($params_new);
cubrid_disconnect($conn);
?>
The above example will output:
array(4) {
["PARAM_ISOLATION_LEVEL"]=>
int(3)
["PARAM_LOCK_TIMEOUT"]=>
int(-1)
["PARAM_MAX_STRING_LENGTH"]=>
int(1073741823)
["PARAM_AUTO_COMMIT"]=>
int(0)
}
array(4) {
["PARAM_ISOLATION_LEVEL"]=>
int(2)
["PARAM_LOCK_TIMEOUT"]=>
int(-1)
["PARAM_MAX_STRING_LENGTH"]=>
int(1073741823)
["PARAM_AUTO_COMMIT"]=>
int(1)
}
SEE ALSO
cubrid_get_db_parameter(3), cubrid_set_autocommit(3).
PHP Documentation Group CUBRID_SET_DB_PARAMETER(3)
