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)');
50 $db->query('DROP TABLE IF EXISTS test2');
51 $db->query('CREATE TABLE test2(id INT) ENGINE=MyISAM');
53 $db->query('INSERT INTO test2(id) VALUES (1)');
55 $row = $db->query('SELECT COUNT(*) AS _num FROM test2')->fetch(PDO::FETCH_ASSOC);
59 $db->query('DROP TABLE IF EXISTS test2');
63 $db->query('DELETE FROM test');
69 $db->query('DELETE FROM test');
75 $db->query('DELETE FROM test');
81 $db->query('DELETE FROM test');
