pg_num_rows(3) [php man page]

PG_NUM_ROWS(3)															    PG_NUM_ROWS(3)

pg_num_rows - Returns the number of rows in a result

SYNOPSIS

       int pg_num_rows (resource  $result)

DESCRIPTION

       pg_num_rows(3) will return the number of rows in a PostgreSQL result resource.

       Note

	       This function used to be called pg_numrows(3).

PARAMETERS

	      o $result
		- PostgreSQL query result resource, returned by pg_query(3), pg_query_params(3) or pg_execute(3) (among others).

RETURN VALUES

	The number of rows in the result. On error, -1 is returned.

EXAMPLES

       Example #1

	      pg_num_rows(3) example

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

	      $rows = pg_num_rows($result);

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

	      The above example will output:

	      1 row(s) returned.

SEE ALSO

       pg_num_fields(3), pg_affected_rows(3).

PHP Documentation Group 													    PG_NUM_ROWS(3)

PG_FETCH_ROW(3) 														   PG_FETCH_ROW(3)

pg_fetch_row - Get a row as an enumerated array

SYNOPSIS

       array pg_fetch_row (resource  $result, [int  $row])

DESCRIPTION

       pg_fetch_row(3) fetches one row of data from the result associated with the specified $result resource.

       Note

	      This function sets NULL fields to the PHP NULL value.

PARAMETERS

	      o $result
		- PostgreSQL query result resource, returned by pg_query(3), pg_query_params(3) or pg_execute(3) (among others).

	      o $row
		- Row number in result to fetch. Rows are numbered from 0 upwards. If omitted or NULL, the next row is fetched.

RETURN VALUES

	An array, indexed from 0 upwards, with each value represented as a string. Database NULL values are returned as NULL.

       FALSE is returned if $row exceeds the number of rows in the set, there are no more rows, or on any other error.

EXAMPLES

       Example #1

	      pg_fetch_row(3) example

	      <?php

	      $conn = pg_pconnect("dbname=publisher");
	      if (!$conn) {
		echo "An error occurred.
";
		exit;
	      }

	      $result = pg_query($conn, "SELECT author, email FROM authors");
	      if (!$result) {
		echo "An error occurred.
";
		exit;
	      }

	      while ($row = pg_fetch_row($result)) {
		echo "Author: $row[0]  E-mail: $row[1]";
		echo "<br />
";
	      }

	      ?>

SEE ALSO

       pg_query(3), pg_fetch_array(3), pg_fetch_object(3), pg_fetch_result(3).

PHP Documentation Group 													   PG_FETCH_ROW(3)