Lines Matching refs:query
22 $row = $db->query("SELECT COUNT(*) AS _num FROM {$table}")->fetch(PDO::FETCH_ASSOC);
25 $db->query("INSERT INTO {$table}(id, label) VALUES (100, 'z')");
27 $row = $db->query("SELECT COUNT(*) AS _num FROM {$table}")->fetch(PDO::FETCH_ASSOC);
33 $row = $db->query("SELECT COUNT(*) AS _num FROM {$table}")->fetch(PDO::FETCH_ASSOC);
38 $db->query("INSERT INTO {$table}(id, label) VALUES (100, 'z')");
39 $db->query("CREATE TABLE {$table2}(id INT)");
51 $db->query("DROP TABLE IF EXISTS {$table2}");
52 $db->query("CREATE TABLE {$table2}(id INT) ENGINE=MyISAM");
54 $db->query("INSERT INTO {$table2}(id) VALUES (1)");
56 $row = $db->query("SELECT COUNT(*) AS _num FROM {$table2}")->fetch(PDO::FETCH_ASSOC);
60 $db->query("DROP TABLE IF EXISTS {$table2}");
64 $db->query("DELETE FROM {$table}");
70 $db->query("DELETE FROM {$table}");
76 $db->query("DELETE FROM {$table}");
82 $db->query("DELETE FROM {$table}");
