PHP Sqlite3 (not PDO!) transactions? -


is possible use transactions (and rollbacks) sqlite3 drivers in php? havn't found infos here: http://de2.php.net/manual/en/book.sqlite3.php

i dont want use pdo...

thanks help

yes, transactions , rollbacks possible without pdo. astonishing how difficult find example explains how accomplish this. had dig ready code find out.

$db=new mydb("database.db", sqlite3_open_readwrite);  $db->exec('begin;');  $stmt=$db->prepare('update table set name = :name id = :id'); $stmt->bindvalue(':id', $id, sqlite3_integer); $stmt->bindvalue(':name', $name, sqlite3_text); $stmt->execute();  $db->exec('commit;'); 

source logic: sombra2eternity, source 'mydb': php.net


Comments

Popular posts from this blog

c# - Send Image in Json : 400 Bad request -

jquery - Fancybox - apply a function to several elements -

An easy way to program an Android keyboard layout app -