pg_num_rows

Returns the number of rows in a result (PHP 4 >= 4.2.0, PHP 5)
int pg_num_rows ( resource result )

Example 1956. pg_num_rows() example

<?php

$result = pg_query($conn, "SELECT 1");

$rows = pg_num_rows($result);


echo $rows . " row(s) returned.\n";
?>

The above example will output:

copy to clipboard

1 row(s) returned.

Code Examples / Notes » pg_num_rows

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!"; }

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 ;)

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"; }

pg_num_rows

Returns the number of rows in a result (PHP 4 >= 4.2.0, PHP 5) int pg_num_rows ( resource result )

Example 1956. pg_num_rows() example

Code Examples / Notes » pg_num_rows

Change Language

Returns the number of rows in a result (PHP 4 >= 4.2.0, PHP 5)
int pg_num_rows ( resource result )