Lines Matching refs:test
17 $db->exec('CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10), grp VARCHAR(10))');
18 $db->exec('INSERT INTO test VALUES(1, \'A\', \'Group1\')');
19 $db->exec('INSERT INTO test VALUES(2, \'B\', \'Group1\')');
20 $db->exec('INSERT INTO test VALUES(3, \'C\', \'Group2\')');
21 $db->exec('INSERT INTO test VALUES(4, \'D\', \'Group2\')');
37 $select1 = $db->prepare('SELECT grp, id FROM test');
38 $select2 = $db->prepare('SELECT id, val FROM test');
39 $derived = $db->prepare('SELECT id, val FROM test', array(PDO::ATTR_STATEMENT_CLASS=>array('Derived…
57 function test($id,$val='N/A')
66 var_dump($select1->fetchAll(PDO::FETCH_FUNC|PDO::FETCH_GROUP, 'test'));
69 var_dump($select2->fetchAll(PDO::FETCH_FUNC, 'test'));
89 test(1,N/A)
90 test(2,N/A)
91 test(3,N/A)
92 test(4,N/A)
121 test(1,A)
122 test(2,B)
123 test(3,C)
124 test(4,D)