Sets the CUBRID database parameters


(PECL CUBRID >= 8.4.0)

cubrid_set_db_parameterSets 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

Замечание:

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.

Примеры

Пример #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($connCUBRID_AUTOCOMMIT_TRUE);
cubrid_set_db_parameter($connCUBRID_PARAM_ISOLATION_LEVEL2);

$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) } 

Смотрите также