Php/docs/function.cubrid-commit

来自菜鸟教程
跳转至：导航、​搜索


cubrid_commit

(PECL CUBRID >= 8.3.0)

cubrid_commit — Commit a transaction


说明

cubrid_commit ( resource $conn_identifier ) : bool

The cubrid_commit() function is used to execute commit on the transaction pointed by conn_identifier, currently in progress. Connection to the server is closed after the cubrid_commit() function is called; However, the connection handle is still valid.

In CUBRID PHP, auto-commit mode is disabled by default for transaction management. You can set it by using cubrid_set_autocommit(). You can get its status by using cubrid_get_autocommit(). Before you start a transaction, remember to disable the auto-commit mode.


参数

conn_identifier
Connection identifier.


返回值

true, when process is successful.

false, when process is unsuccessful.


范例

Example #1 cubrid_commit() example

<?php$conn = cubrid_connect("localhost", 33000, "demodb", "dba");@cubrid_execute($conn, "DROP TABLE publishers");$sql = <<<EODCREATE TABLE publishers(pub_id CHAR(3), pub_name VARCHAR(20), city VARCHAR(15), state CHAR(2), country VARCHAR(15))EOD;cubrid_set_autocommit($conn,false);if (!cubrid_execute($conn, $sql)) {    printf("Error facility: %d\nError code: %d\nError msg: %s\n", cubrid_error_code_facility(), cubrid_error_code(), cubrid_error_msg());    cubrid_disconnect($conn);    exit;}$req = cubrid_prepare($conn, "INSERT INTO publishers VALUES(?, ?, ?, ?, ?)");$id_list = array("P01", "P02", "P03", "P04");$name_list = array("Abatis Publishers", "Core Dump Books", "Schadenfreude Press", "Tenterhooks Press");$city_list = array("New York", "San Francisco", "Hamburg", "Berkeley");$state_list = array("NY", "CA", NULL, "CA");$country_list = array("USA", "USA", "Germany", "USA");for ($i = 0, $size = count($id_list); $i < $size; $i++) {    cubrid_bind($req, 1, $id_list[$i]);    cubrid_bind($req, 2, $name_list[$i]);    cubrid_bind($req, 3, $city_list[$i]);    cubrid_bind($req, 4, $state_list[$i]);    cubrid_bind($req, 5, $country_list[$i]);    if (!($ret = cubrid_execute($req))) {        break;    }}if (!$ret) {    cubrid_rollback($conn);} else {    cubrid_commit($conn);    $req = cubrid_execute($conn, "SELECT * FROM publishers");    while ($result = cubrid_fetch_assoc($req)) {        printf("%-3s %-20s %-15s %-3s %-15s\n",             $result["pub_id"], $result["pub_name"], $result["city"], $result["state"], $result["country"]);    }}cubrid_disconnect($conn);?>

以上例程会输出： 


P01 Abatis Publishers    New York        NY  USA            
P02 Core Dump Books      San Francisco   CA  USA            
P03 Schadenfreude Press  Hamburg             Germany        
P04 Tenterhooks Press    Berkeley        CA  USA

参见


取自“https://cainiaojiaocheng.com/index.php?title=Php/docs/function.cubrid-commit&oldid=8701”
Powered by MediaWiki