#!/usr/local/bin/php
$con = pg_connect("user=username password=yourpassword bname=databasename");
if (!$con) {
echo "connect failed";
exit;
}
$res = pg_exec($con,"insert into tbl1 (tim,memo) values('now','by PHP')");
if (!$res) {
echo "command failed";
exit;
}
pg_freeresult($res);
$res = pg_exec($con,"select id,tim,memo from tbl1 order by id");
if (!$res) {
echo "select failed";
exit;
}
$N = pg_numrows($res);
for ($I=0;$I<$N;$I++) {
echo pg_result($res,$I,"id");
echo " ";
echo pg_result($res,$I,"tim");
echo " ";
echo pg_result($res,$I,"memo");
echo "
\n";
}
pg_freeresult($res);
pg_close($con);
?>