Htaccess    html   Php    javascript   Asp   css    maths  Past Questions  Practice Tests Online

pdo rollback function syntax tag tutorial 2013





Alert! Connect with 10,000 Chating Online. Join Now

Php pdo rollback () function

Write your php code

 
<?php ?>

Php Result


Your code below



(no version information, might be only in CVS)

PDO::rollBack --  Rolls back a transaction

Syntax

bool PDO::rollBack ( void )

Warning

This function is EXPERIMENTAL. The behaviour of this function, the name of this function, and anything else documented about this function may change without notice in a future release of PHP. Use this function at your own risk.

When issued against databases that support transactions, PDO::rollBack() rolls back any work in progress and and returns the connection state to autocommit mode.

You must issue PDO::beginTransaction() to set the connection state to manual commit mode before issuing PDO::rollBack() has any effect.

Examples

Example 1. Roll back a transaction

<?php
/* Begin a transaction, turning off autocommit */
$dbh->beginTransaction();

/* Change the database schema and data */
$sth = $dbh->exec("DROP TABLE fruit");
$sth = $dbh->exec("UPDATE dessert
    SET name = 'hamburger'"
);

/* Recognize mistake and roll back changes */
$dbh->rollBack();

/* Database connection is now back in autocommit mode */
?>

See Also

PDO::beginTransaction()
PDO::commit()

Php pdo rollback Function syntax tag

pdo rollback php code on this is provided for your study purpose, it will guide you to know how create and design a website using php. use it to practice and train your self online



Php pdo rollback syntax tutorial

php tutorial guide and code design are for easy learning and programming. The code practice section provided at the top is for practising of this syntax. Use the code section up to practice your php programming online. Learning php is very easy, all you need is to use the examples on this site and practice them to perfect your skills.


Function index

Variables

Expressions

Operators

Control-Structures

Cookies

Array

Date & Time

Directory function

File

Image

Operators

Form data handling

Mathematics operators

Mail

Php Mysql

Network Functions

Strings

php tutorial guides,functions, classes, code examples and tags for creating simple dynamic site to mysql database driven sites
 
 
Htaccess    html   Php    javascript   Asp   css    maths  Past Questions  Practice Tests Online