Lines Matching refs:query
21 $row = $db->query('SELECT @@autocommit AS _autocommit')->fetch(PDO::FETCH_ASSOC);
29 $row = $db->query('SELECT @@autocommit AS _autocommit')->fetch(PDO::FETCH_ASSOC);
34 if (!$db->query('SET autocommit = 1'))
41 if (!$db->query('SET autocommit = 0'))
47 $row = $db->query('SELECT @@autocommit AS _autocommit')->fetch(PDO::FETCH_ASSOC);
58 $row = $db->query('SELECT COUNT(*) AS _num FROM test')->fetch(PDO::FETCH_ASSOC);
61 $db->query("INSERT INTO test(id, label) VALUES (100, 'z')");
63 $row = $db->query('SELECT COUNT(*) AS _num FROM test')->fetch(PDO::FETCH_ASSOC);
68 $db->query('ROLLBACK');
69 $row = $db->query('SELECT COUNT(*) AS _num FROM test')->fetch(PDO::FETCH_ASSOC);
76 $db->query('DELETE FROM test WHERE id = 100');
77 $db->query('ROLLBACK');
78 $row = $db->query('SELECT COUNT(*) AS _num FROM test')->fetch(PDO::FETCH_ASSOC);
82 $db->query('DELETE FROM test WHERE id = 100');
83 $db->query('COMMIT');
85 $row = $db->query('SELECT COUNT(*) AS _num FROM test')->fetch(PDO::FETCH_ASSOC);
