pg_num_rows

说明

int pg_num_rows ( resource result )

pg_num_rows() 返回 PostgreSQL result 中的行的数目。result 参数是由 pg_query() 函数返回的查询结果资源号。如果出错则返回 -1。

注: 用 pg_affected_rows() 函数获得被 INSERT，UPDATE 和 DELETE 命令影响到的行的数目。

注: 本函数以前的名字为 pg_numrows()。

参见 pg_num_fields() 和 pg_affected_rows()。

add a note User Contributed Notes

php-docs (at) radev (dot) net
23-Mar-2005 11:16


Yet even simpler example:



$query = "SELECT * FROM atable";

$result = pg_query($query);



if (pg_num_rows($result)>0) {

  while($row=pg_fetch_object($result) {

    echo $row->first_column;

    echo $row->second_column;

    ....

    echo $row->last_column;

  }

}

else {

  echo "The query did not return any data!";

}

aron at lurie dot biz
03-Nov-2003 09:23


Simple example



$sql = "select * from YOURTABLE";

$result = pg_query($sql);

$rows = pg_num_rows($result);

for ($i = 0; $i < $rows; $i++)

{

   $data = pg_fetch_object($result, $i);

   echo "$data->COLUMNNAME";

}

flavio AT catalani.net
15-Jan-2003 02:39


simple pg_num_fields & pg_num_rows example.



$result = pg_query($conn, $string);



while($arr = pg_fetch_array ($result)) {

      for ($x=0;$x<=pg_num_fields($result);$x++)

            print $arr[$x] . " ";

      print "\n";

}



adapted (stolen) from php manual ;)

sean at seattleone dot com
22-Oct-2002 10:27


Simple Example:



$result = pg_query($conn_id, $query);

echo pg_num_rows($result);

add a note