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);
58 $row = $db->query("SELECT COUNT(*) AS _num FROM {$table}")->fetch(PDO::FETCH_ASSOC);
61 $db->query("INSERT INTO {$table} (id, label) VALUES (100, 'z')");
63 $row = $db->query("SELECT COUNT(*) AS _num FROM {$table}")->fetch(PDO::FETCH_ASSOC);
68 $db->query('ROLLBACK');
69 $row = $db->query("SELECT COUNT(*) AS _num FROM {$table}")->fetch(PDO::FETCH_ASSOC);
76 $db->query("DELETE FROM {$table} WHERE id = 100");
77 $db->query('ROLLBACK');
78 $row = $db->query("SELECT COUNT(*) AS _num FROM {$table}")->fetch(PDO::FETCH_ASSOC);
82 $db->query("DELETE FROM {$table} WHERE id = 100");
83 $db->query('COMMIT');
85 $row = $db->query("SELECT COUNT(*) AS _num FROM {$table}")->fetch(PDO::FETCH_ASSOC);
96 $db->query('DROP TABLE IF EXISTS pdo_mysql_attr_autocommit');
