function ap_clients($ap) { $result = @pg_select($dbconn, "ap_clients", array("mac" => "{$ap}")); if (!$result) { $result = @pg_select($dbconn, "ap_clients", array("ip" => "{$ap}")); if (!$result) { echo "Erro AP não encontrado!\n"; return false; } } pg_close($dbconn); print $result[0]["num_clients"]; }
<?php error_reporting(E_ALL); include 'config.inc'; $db = pg_connect($conn_str); $fields = array('num' => '1234', 'str' => 'ABC', 'bin' => 'XYZ'); $ids = array('num' => '1234'); $res = pg_select($db, $table_name, $ids) or print "Error\n"; var_dump($res); echo pg_select($db, $table_name, $ids, PGSQL_DML_STRING) . "\n"; echo "Ok\n";
function p_select($table,$array,$options=NULL){ // Experimental // pg_select to select from a table the values in array that match ? $result = ($options == NULL ? pg_select($this->db, $table, $array) : pg_select($this->db,$table,$array,$options)); return $result? $result:false; }
<?php include 'config.inc'; $conn = pg_connect($conn_str); pg_query('CREATE SCHEMA phptests'); pg_query('CREATE TABLE phptests.foo (id INT, id2 INT)'); pg_insert($conn, 'foo', array('id' => 1, 'id2' => 1)); pg_insert($conn, 'phptests.foo', array('id' => 1, 'id2' => 2)); var_dump(pg_insert($conn, 'phptests.foo', array('id' => 1, 'id2' => 2), PGSQL_DML_STRING)); var_dump(pg_select($conn, 'phptests.foo', array('id' => 1))); pg_query('DROP TABLE phptests.foo'); pg_query('DROP SCHEMA phptests');
<?php include 'config.inc'; $conn = pg_connect($conn_str); pg_query('CREATE SCHEMA phptests'); pg_query('CREATE TABLE phptests.foo (id INT, id2 INT)'); pg_query('INSERT INTO phptests.foo VALUES (1,2)'); pg_query('INSERT INTO phptests.foo VALUES (2,3)'); pg_query('CREATE TABLE phptests.bar (id4 INT, id3 INT)'); pg_query('INSERT INTO phptests.bar VALUES (4,5)'); pg_query('INSERT INTO phptests.bar VALUES (6,7)'); /* Inexistent table */ var_dump(pg_select($conn, 'foo', array('id' => 1))); /* Existent column */ var_dump(pg_select($conn, 'phptests.foo', array('id' => 1))); /* Testing with inexistent column */ var_dump(pg_select($conn, 'phptests.bar', array('id' => 1))); /* Existent column */ var_dump(pg_select($conn, 'phptests.bar', array('id4' => 4))); pg_query('DROP TABLE phptests.foo'); pg_query('DROP TABLE phptests.bar'); pg_query('DROP SCHEMA phptests');
public function select_db($dbName) { $this->dbname = $dbName; @pg_select($this->link, $dbName); }