cubrid_set_db_parameter

(PECL CUBRID >= 8.4.0)

cubrid_set_db_parameter — Sets the CUBRID database parameters

说明

bool cubrid_set_db_parameter ( resource $conn_identifier , int $param_type , int $param_value )

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