Lines Matching refs:conn
12 $conn = pg_connect($conn_str);
14 pg_query($conn, 'CREATE SCHEMA phptests');
16 pg_query($conn, 'CREATE TABLE phptests.foo (id INT, id2 INT)');
17 pg_query($conn, 'INSERT INTO phptests.foo VALUES (1,2)');
18 pg_query($conn, 'INSERT INTO phptests.foo VALUES (2,3)');
20 pg_query($conn, 'CREATE TABLE phptests.bar (id4 INT, id3 INT)');
21 pg_query($conn, 'INSERT INTO phptests.bar VALUES (4,5)');
22 pg_query($conn, 'INSERT INTO phptests.bar VALUES (6,7)');
25 var_dump(pg_select($conn, 'foo', array('id' => 1)));
28 var_dump(pg_select($conn, 'phptests.foo', array('id' => 1)));
31 var_dump(pg_select($conn, 'phptests.bar', array('id' => 1)));
34 var_dump(pg_select($conn, 'phptests.bar', array('id4' => 4)));
37 var_dump(pg_select($conn, 'phptests.bar', array('id4' => 4), 0, PGSQL_NUM));
39 pg_query($conn, 'DROP TABLE phptests.foo');
40 pg_query($conn, 'DROP TABLE phptests.bar');
41 pg_query($conn, 'DROP SCHEMA phptests');
