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