PHPのお勉強！

PHP TOP
PHP 8.4.2 Released!

    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

    注意:

    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 を、失敗した場合に false を返します。

    例

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

    参考

    Found A Problem?

    Learn How To Improve This Page • Submit a Pull Request • Report a Bug
    ＋add a note

    User Contributed Notes

    There are no user contributed notes for this page.
    To Top