Lines Matching refs:query
21 $row = $db->query('SELECT COUNT(*) AS _num FROM test')->fetch(PDO::FETCH_ASSOC);
24 $db->query("INSERT INTO test(id, label) VALUES (100, 'z')");
26 $row = $db->query('SELECT COUNT(*) AS _num FROM test')->fetch(PDO::FETCH_ASSOC);
32 $row = $db->query('SELECT COUNT(*) AS _num FROM test')->fetch(PDO::FETCH_ASSOC);
37 $db->query("INSERT INTO test(id, label) VALUES (100, 'z')");
38 $db->query('DROP TABLE IF EXISTS test2');
39 $db->query('CREATE TABLE test2(id INT)');
51 $db->query('DROP TABLE IF EXISTS test2');
52 $db->query('CREATE TABLE test2(id INT) ENGINE=MyISAM');
54 $db->query('INSERT INTO test2(id) VALUES (1)');
56 $row = $db->query('SELECT COUNT(*) AS _num FROM test2')->fetch(PDO::FETCH_ASSOC);
60 $db->query('DROP TABLE IF EXISTS test2');
64 $db->query('DELETE FROM test');
70 $db->query('DELETE FROM test');
76 $db->query('DELETE FROM test');
82 $db->query('DELETE FROM test');
