PHP 手冊
前一頁 |  | 下一頁

# maxdb_rollback

(no version information, might be only in CVS)

maxdb_rollback -- Rolls back current transaction

## Description

bool maxdb_rollback ( resource link )

Rollbacks the current transaction for the database specified by the link parameter.

## Return values

成功回傳`TRUE`失敗回傳`FALSE`。

## See also

maxdb_commit() maxdb_autocommit()

## Example

範例 1. Procedural style

`<?php
$link = maxdb_connect("localhost", "MONA", "RED");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s\n", maxdb_connect_error());
exit();
}
/* disable autocommit */
maxdb_autocommit($link, FALSE);
maxdb_query($link, "CREATE TABLE temp.mycity LIKE hotel.city");
maxdb_query($link, "INSERT INTO temp.mycity SELECT * FROM hotel.city");
/* commit insert */
maxdb_commit($link);
/* delete all rows */
maxdb_query($link, "DELETE FROM temp.mycity");
if ($result = maxdb_query($link, "SELECT COUNT(*) FROM temp.mycity")) {
$row = maxdb_fetch_row($result);
printf("%d rows in table mycity.\n", $row[0]);
/* Free result */
maxdb_free_result($result);
}
/* Rollback */
maxdb_rollback($link);
if ($result = maxdb_query($link, "SELECT COUNT(*) FROM temp.mycity")) {
$row = maxdb_fetch_row($result);
printf("%d rows in table mycity (after rollback).\n", $row[0]);
/* Free result */
maxdb_free_result($result);
}
/* Drop table myCity */
maxdb_query($link, "DROP TABLE temp.mycity");
maxdb_close($link);
?>`

The above examples would produce the following output:

    0 rows in table mycity.
    25 rows in table mycity (after rollback).

前一頁 | 內容 | 下一頁
maxdb_report | 上一層 | maxdb_rpl_parse_enabled