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

参见

相关文章
php cubrid 函数 bind variables to a prepared statement as parametersphp cubrid 函数 close a database connectionphp cubrid 函数 returns the cubrid database parametersphp cubrid 函数 bind a lob object or a string as a lob object to a prepared statement as parametersphp cubrid 函数 sets the cubrid database parametersphp ibm db2 函数 returns or sets the autocommit state for a database connectionphp frontbase 函数 sets or retrieves the password for a frontbase databasephp firebird/interbase 函数 close a connection to an interbase databasephp imap 函数 sets flags on messagesphp ming 函数 sets the swf versionphp mysql xdevapi 函数 bind prepared statement variables as parametersphp oci8 函数 returns the next child statement resource from a parent statement resource that has oracle database 12c implicit result setsphp oci8 函数 sets the action namephp oci8 函数 sets a millisecond timeout for database callsphp oci8 函数 sets the database operationphp oci8 函数 sets the database editionphp postgresql 函数 submits a request to create a prepared statement with the given parameters and waits for completionphp ps 函数 sets certain parametersphp ps 函数 sets position for text outputphp paradox 函数 closes a paradox database
关注编程学问公众号