作者TheOnlyWay (====ONLYway)
看板PHP
标题[请益] php connect postgreSQL
时间Sun May 20 00:49:50 2007
php code :
<?php
$fileptr = fopen("./param_connexion", "r") or die("open error");
$connexion = fgets($fileptr, 100);
fclose($fileptr);
$conn = pg_connect($connexion) or die("could not connect");
$sql = "select nextval('port')";
//$sql = "select * from port";
$res = pg_query($conn,$sql);
if($res)
{
echo "true";
}
else
{
echo "false";
}
?>
========== 其中 param_connexion 是我连线的基本组态(内容如下) ==========
host=localhost port=5432 dbname=videostream user=administrator
password=administrator
========== 其中 port 是 序列数(SQL 内容如下) ===========
CREATE SEQUENCE port
INCREMENT 4
MINVALUE 25000
MAXVALUE 65000
START 25408
CACHE 1
CYCLE;
ALTER TABLE port OWNER TO antonio;
GRANT ALL ON TABLE port TO antonio;
GRANT SELECT ON TABLE port TO administrator;
Q: if SQL query is -----> $sql = "select * from port"
$res return value is true
if SQL query is -----> $sql = "select nextval('port')";
$res return value is false
plz ...tell me why...
thanks
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 220.132.113.65
※ 编辑: TheOnlyWay 来自: 220.132.113.65 (05/20 00:51)