|
Последние активные темы форума |
|
maxdb_rollback
(no version information, might be only in CVS) maxdb_rollback -- Rolls back current transaction
Descriptionbool maxdb_rollback ( resource link ) Rollbacks the current transaction for the database specified by the
link parameter.
Return valuesВозвращает TRUE в случае успешного завершения или FALSE в случае возникновения ошибки.
Example
Пример 1. Процедурный стиль
<?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). |
|