Lines Matching refs:query
20 $row = $db->query('SELECT @@autocommit AS _autocommit')->fetch(PDO::FETCH_ASSOC);
28 $row = $db->query('SELECT @@autocommit AS _autocommit')->fetch(PDO::FETCH_ASSOC);
33 if (!$db->query('SET autocommit = 1'))
40 if (!$db->query('SET autocommit = 0'))
46 $row = $db->query('SELECT @@autocommit AS _autocommit')->fetch(PDO::FETCH_ASSOC);
57 $row = $db->query('SELECT COUNT(*) AS _num FROM test')->fetch(PDO::FETCH_ASSOC);
60 $db->query("INSERT INTO test(id, label) VALUES (100, 'z')");
62 $row = $db->query('SELECT COUNT(*) AS _num FROM test')->fetch(PDO::FETCH_ASSOC);
67 $db->query('ROLLBACK');
68 $row = $db->query('SELECT COUNT(*) AS _num FROM test')->fetch(PDO::FETCH_ASSOC);
75 $db->query('DELETE FROM test WHERE id = 100');
76 $db->query('ROLLBACK');
77 $row = $db->query('SELECT COUNT(*) AS _num FROM test')->fetch(PDO::FETCH_ASSOC);
81 $db->query('DELETE FROM test WHERE id = 100');
82 $db->query('COMMIT');
84 $row = $db->query('SELECT COUNT(*) AS _num FROM test')->fetch(PDO::FETCH_ASSOC);
