<?
require("class_pgsql.inc.php");
// opening connection
$pgsql=new pgsql("test","localhost","test","password_for_test","5432");
// creating table
$sql="CREATE TABLE table_test (
id integer,
field1 varchar,
field2 varchar);";
$mysql->query($sql);
// inserting some datas
for ($i=0;$i<5;$i++) {
$pgsql->insert("table_test",array('id','field1','field2'),array("data ".$i,"other data ".$i));
// display content of table
print_r($pgsql->query("SELECT * FROM table_test ORDER BY field1"));
// an update to the table, for id=3
$pgsql->update("table_test",array('field1','field2'),array('aaa','bbb'),"id=3");
// display a field for id=4, if SELECT return no line, "none" return
echo $pgsql->select_value("SELECT field2 FROM table_test WHERE (id=4)","none");
// delete a line, for id=2
$pgsql->delete("table_test","id=2");
// display content of table
print_r($pgsql->query("SELECT * FROM table_test ORDER BY field1"));
?>
|