Lines Matching refs:query
20 $row = $db->query('SELECT COUNT(*) AS _num FROM test')->fetch(PDO::FETCH_ASSOC);
23 $db->query("INSERT INTO test(id, label) VALUES (100, 'z')");
25 $row = $db->query('SELECT COUNT(*) AS _num FROM test')->fetch(PDO::FETCH_ASSOC);
31 $row = $db->query('SELECT COUNT(*) AS _num FROM test')->fetch(PDO::FETCH_ASSOC);
36 $db->query("INSERT INTO test(id, label) VALUES (100, 'z')");
37 $db->query('DROP TABLE IF EXISTS test2');
38 $db->query('CREATE TABLE test2(id INT)');
41 $row = $db->query('SELECT COUNT(*) AS _num FROM test')->fetch(PDO::FETCH_ASSOC);
47 $db->query('DROP TABLE IF EXISTS test2');
48 $db->query('CREATE TABLE test2(id INT) ENGINE=MyISAM');
50 $db->query('INSERT INTO test2(id) VALUES (1)');
52 $row = $db->query('SELECT COUNT(*) AS _num FROM test2')->fetch(PDO::FETCH_ASSOC);
56 $db->query('DROP TABLE IF EXISTS test2');
60 $db->query('DELETE FROM test');
66 $db->query('DELETE FROM test');
72 $db->query('DELETE FROM test');
78 $db->query('DELETE FROM test');
