<?php $host = "host=192.168.2.5"; $port = "port=5866"; $dbname = "dbname=test"; $credentials = "user=test password=test";
$db = pg_connect("$host $port $dbname $credentials"); if(!$db){ echo "Error : Unable to open database <br/>"; } else { echo "Opened database successfully <br/>"; }
//创建数据表 $sql ="CREATE TABLE IF NOT EXISTS COMPANY (". "ID INT PRIMARY KEY NOT NULL,". "NAME TEXT NOT NULL,". "AGE INT NOT NULL,". "ADDRESS CHAR(50)," . "SALARY REAL". ");";
$ret = pg_query($db, $sql); if(!$ret){ echo pg_last_error($db); exit; } else { echo "Table created successfully <br/>"; } //插入数据 $sql ="INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)". "VALUES (1, 'Paul', 32, 'California', 20000.00 );". "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)". "VALUES (2, 'Allen', 25, 'Texas', 15000.00 );". "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)". "VALUES (3, 'Teddy', 23, 'Norway', 20000.00 );". "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)". "VALUES (4, 'Mark', 25, 'Rich-Mond ', 65000.00 );";
$ret = pg_query($db, $sql); if(!$ret){ echo pg_last_error($db); exit; } else { echo "Records created successfully <br/>"; }
//查询数据 $sql ="SELECT * from COMPANY;";
$ret = pg_query($db, $sql); if(!$ret){ echo pg_last_error($db); exit; } while($row = pg_fetch_row($ret)){ echo "ID = ". $row[0] . "\n"; echo "NAME = ". $row[1] ."\n"; echo "ADDRESS = ". $row[2] ."\n"; echo "SALARY = ".$row[4] ."<br/>"; } echo "Operation done successfully<br/>"; pg_close($db); ?>
|