<?php include "database.php"; $db = new Database('test', 'root', 'root', '127.0.0.1'); $db->query('CREATE TABLE IF NOT EXISTS `test` ( `id` int(11) NOT NULL, `data` text NOT NULL )', array(), false); if (($error = $db->getError()) !== null) { var_dump($error); } $db->begin(); $db->query('DELETE FROM test WHERE id = :id', array(':id' => 2), false); $db->query('DELETE FROM test WHERE id = :id', array(':id' => 3), false); $db->end(); if (($error = $db->getError()) !== null) { var_dump($error); } $db->query('insert into test (data) values (:value)', array('value' => 'xxx'), false); if (($error = $db->getError()) !== null) { var_dump($error); } else { echo "last id:" . $db->lastId(); } $result = $db->query('select * from test'); var_dump($result);