Php/docs/function.cubrid-set-db-parameter
cubrid_set_db_parameter
(PECL CUBRID >= 8.4.0)
cubrid_set_db_parameter — Sets the CUBRID database parameters
说明
cubrid_set_db_parameter
( resource $conn_identifier
, int $param_type
, int $param_value
) : bool
The cubrid_set_db_parameter() function is used to set the CUBRID database parameters. It can set the following CUBRID database parameters:
PARAM_ISOLATION_LEVEL
PARAM_LOCK_TIMEOUT
Note:
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 cubrid_connect() is assumed.
param_type
- Database parameter type.
param_value
- Isolation level value (1-6) or lock timeout (in seconds) value.
返回值
true
on success.
false
on failure.
范例
Example #1 cubrid_get_db_parameter() 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() - Returns the CUBRID database parameters
- cubrid_set_autocommit() - Set autocommit mode of the connection