cubrid_set_db_parameter
cubrid_set_db_parameter
Sets the CUBRID database parameters
bool **cubrid_set_db_parameter** resource $conn_identifier int $param_type int $param_value
The function is used to set
the CUBRID database parameters. It can set the following CUBRID database
parameters:
cubrid_set_db_parameter
PARAM_ISOLATION_LEVEL``PARAM_LOCK_TIMEOUT> Opmerking: > The auto-commit mode can be set by using
.
cubrid_set_autocommit
conn_identifier
The CUBRID connection. If the connection identifier is not specified,
the last link opened by is assumed.
cubrid_connect
param_typeDatabase parameter type.
param_valueIsolation level value (1-6) or lock timeout (in seconds) value.
return.success
Voorbeeld: 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);
?>
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)
}
cubrid_get_db_parameter``cubrid_set_autocommit