Manual do PHP
Anterior |  | Próxima

# 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

Retorna `TRUE` em caso de sucesso ou `FALSE` em falhas.

## See also

maxdb_commit() maxdb_autocommit()

## Example

Exemplo 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).

Anterior | Principal | Próxima
maxdb_report | Acima | maxdb_rpl_parse_enabled