给你一个例子:
----------------------------------------------------------------------
<?php
$dbString = "host=192.168.0.50 dbname=mydb user=root password=123456";
$db = pg_connect($dbString) or die('Can Not to connect the pg_server!');
$sql = "select * from users";
$result = pg_query($db,$sql);
$nums = pg_num_rows($result);
if($nums) echo 'true';
else echo 'false';
pg_close();
?>
----------------------------------------------------------------------
<?php
$dbString = "host=192.168.0.50 dbname=mydb user=root password=123456";
$db = pg_connect($dbString) or die('Can Not to connect the pg_server!');
$sql = "select * from users";
$result = pg_query($db,$sql);
$nums = pg_num_rows($result);
if($nums) echo 'true';
else echo 'false';
pg_close();
?>
如果pgsql支持top命令
select top 1 from users.select *是一种最糟糕的做法
PostgreSQL同样不支持top,可以使用limit。
$db_query_string = "SELECT COUNT(abc) FROM tablename WHERE abc = 'xxx';";
但却不知道如何取得 COUNT()的值
$db_query_string = "SELECT COUNT(abc) FROM tablename WHERE abc = 'xxx'";
$result = pg_query($db,$db_query_string);
$nums = pg_num_rows($result);
if($nums)
//表示有此数据
;
else
//无数据
;
$nums = pg_num_rows($result);替换成:
$count=pg_result($rec,0,0);完全搞定!