Lines Matching refs:conn
14 $conn = pg_connect($conn_str);
16 pg_query($conn, "CREATE SCHEMA {$schema_name}");
18 pg_query($conn, "CREATE TABLE {$table_name} (id INT, id2 INT)");
19 pg_query($conn, "CREATE TABLE {$schema_name}.{$table_name} (id INT, id2 INT)");
21 pg_insert($conn, $table_name, array('id' => 1, 'id2' => 1));
22 pg_insert($conn, $table_name, array('id' => 1, 'id2' => 2));
23 pg_insert($conn, $table_name, array('id' => 1, 'id2' => 2));
24 pg_insert($conn, $table_name, array('id' => 3, 'id2' => 3));
26 pg_insert($conn, "{$schema_name}.{$table_name}", array('id' => 1, 'id2' => 1));
27 pg_insert($conn, "{$schema_name}.{$table_name}", array('id' => 1, 'id2' => 2));
28 pg_insert($conn, "{$schema_name}.{$table_name}", array('id' => 2, 'id2' => 3));
29 pg_insert($conn, "{$schema_name}.{$table_name}", array('id' => 2, 'id2' => 3));
31 pg_delete($conn, $table_name, array('id' => 1, 'id2' => 0));
32 pg_delete($conn, $table_name, array('id' => 1, 'id2' => 2));
33 var_dump(pg_delete($conn, $table_name, array('id' => 1, 'id2' => 2), PGSQL_DML_STRING));
35 pg_delete($conn, "{$schema_name}.{$table_name}", array('id' => 2, 'id2' => 1));
36 pg_delete($conn, "{$schema_name}.{$table_name}", array('id' => 2, 'id2' => 3));
37 var_dump(pg_delete($conn, "{$schema_name}.{$table_name}", array('id' => 2, 'id2' => 3), PGSQL_DML_S…
39 var_dump(pg_fetch_all(pg_query($conn, "SELECT * FROM {$table_name}")));
40 var_dump(pg_fetch_all(pg_query($conn, "SELECT * FROM {$schema_name}.{$table_name}")));
43 pg_delete($conn, 'bar', array('id' => 1, 'id2' => 2));
44 var_dump(pg_delete($conn, 'bar', array('id' => 1, 'id2' => 2), PGSQL_DML_STRING));
53 $conn = pg_connect($conn_str);
55 pg_query($conn, "DROP TABLE IF EXISTS {$table_name}");
56 pg_query($conn, "DROP TABLE IF EXISTS {$schema_name}.{$table_name}");
57 pg_query($conn, "DROP SCHEMA IF EXISTS {$schema_name}");
