- MySQLi Tutorial
- MySQLi - Home
- MySQLi - Introduction
- MySQLi - PHP Syntax
- MySQLi - Connection
- MySQLi - Create Database
- MySQLi - Drop Database
- MySQLi - Select Database
- MySQLi - Create Tables
- MySQLi - Drop Tables
- MySQLi - Insert Query
- MySQLi - Select Query
- MySQLi - Where Clause
- MySQLi - Update Query
- MySQLi - Delete Query
- MySQLi - Like Clause
- MySQLi - Sorting Results
- MySQLi - Using Joins
- MySQLi - Handling NULL Values
- Obtaining & Using MySQLi Metadata
- MySQL
- MySQL - Installation
- MySQL - Administration
- MySQL - Data Types
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQLi Useful Resources
- MySQLi - Useful Functions
- MySQLi - Quick Guide
- MySQLi - Useful Resources
- MySQLi - Discussion
MySQLi - Rollback
Syntax
bool mysqli_rollback ( mysqli $link [, int $flags [, string $name ]] )
Definition and Usage
It removes the named savepoint from the set of savepoints of the current transaction.
Example
Try out following example −
<?php $servername = "localhost:3306"; $username = "root"; $password = ""; $dbname = "TUTORIALS"; $tmp = NULL; $conn = new mysqli($servername, $username, $password, $dbname); if (!$conn->real_connect($servername, $username, $password, $dbname)) { die('Connect Error (' . mysqli_connect_errno() . ') '. mysqli_connect_error()); } echo 'Success... ' . mysqli_get_host_info($conn) . "\n"; mysqli_query($conn, "CREATE TABLE tutorials_test1 LIKE tutorials_auto"); mysqli_query($conn, "ALTER TABLE tutorials_test1 Type = InnoDB"); mysqli_query($conn, "INSERT INTO tutorials_test1 SELECT * FROM id LIMIT 50"); mysqli_commit($conn); mysqli_query($conn, "DELETE FROM tutorials_test1"); if ($result = mysqli_query($conn, "SELECT COUNT(*) FROM tutorials_test1")) { $row = mysqli_fetch_row($result); printf("%d rows in table tutorials_test1.\n", $row[0]); mysqli_free_result($result); } mysqli_rollback($conn); if ($result = mysqli_query($conn, "SELECT COUNT(*) FROM tutorials_test1")) { $row = mysqli_fetch_row($result); printf("%d rows in table tutorials_test1 (after rollback).\n", $row[0]); mysqli_free_result($result); } mysqli_query($conn, "DROP TABLE tutorials_test1"); $conn->close(); ?>
The sample output of the above code should be like this −
Success... localhost:3306 via TCP/IP 0 rows in table tutorials_test1. 0 rows in table tutorials_test1 (after rollback).
mysqli_useful_functions.htm
Advertisements