Lines Matching refs:db
10 $db = new PDO("firebird:dbname=$test_base",$user,$password) or die;
11 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
13 $db->exec("CREATE TABLE ddl (id INT NOT NULL PRIMARY KEY, text BLOB SUB_TYPE 1)");
14 $db->exec("CREATE GENERATOR gen_ddl_id");
15 $db->exec("CREATE TRIGGER ddl_bi FOR ddl BEFORE INSERT AS
18 $db->setAttribute(PDO::ATTR_AUTOCOMMIT,0);
20 $db->beginTransaction();
21 var_dump($db->exec("INSERT INTO ddl (text) VALUES ('bla')"));
22 var_dump($db->exec("UPDATE ddl SET text='blabla'"));
23 $db->rollback();
25 $db->beginTransaction();
26 var_dump($db->exec("DELETE FROM ddl"));
27 $db->commit();
29 unset($db);
