pg_fetch_result(3) [php man page]

PG_FETCH_RESULT(3)														PG_FETCH_RESULT(3)

pg_fetch_result - Returns values from a result resource

SYNOPSIS

       string pg_fetch_result (resource  $result, int  $row, mixed  $field)

DESCRIPTION

       string pg_fetch_result (resource  $result, mixed  $field)

       pg_fetch_result(3) returns the value of a particular row and field (column) in a PostgreSQL result resource.

       Note

	       This function used to be called pg_result(3).

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, next row is fetched.

	      o $field
		-  A  string representing the name of the field (column) to fetch, otherwise an int representing the field number to fetch. Fields
		are numbered from 0 upwards.

RETURN VALUES

	Boolean is returned as "t" or "f". All other types, including arrays are returned as strings formatted in the same default PostgreSQL man-
       ner that you would see in the psql program. Database NULL values are returned as NULL.

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

EXAMPLES

       Example #1

	      pg_fetch_result(3) example

	      <?php
	      $db = pg_connect("dbname=users user=me") || die();

	      $res = pg_query($db, "SELECT 1 UNION ALL SELECT 2");

	      $val = pg_fetch_result($res, 1, 0);

	      echo "First field in the second row is: ", $val, "
";
	      ?>

	      The above example will output:

	      First field in the second row is: 2

SEE ALSO

       pg_query(3), pg_fetch_array(3).

PHP Documentation Group 													PG_FETCH_RESULT(3)

PG_FETCH_OBJECT(3)														PG_FETCH_OBJECT(3)

pg_fetch_object - Fetch a row as an object

SYNOPSIS

       object pg_fetch_object (resource  $result, [int	$row], [int  $result_type = PGSQL_ASSOC])

DESCRIPTION

       object pg_fetch_object (resource  $result, [int	$row], [string	$class_name], [array  $params])

       pg_fetch_object(3)  returns  an	object	with properties that correspond to the fetched row's field names. It can optionally instantiate an
       object of a specific class, and pass parameters to that class's constructor.

       Note

	      This function sets NULL fields to the PHP NULL value.

	Speed-wise, the function is identical to pg_fetch_array(3), and almost as fast as pg_fetch_row(3) (the difference is insignificant).

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.

	      o $result_type
		- Ignored and deprecated.

	      o $class_name
		- The name of the class to instantiate, set the properties of and return. If not specified, a stdClass object is returned.

	      o $params
		- An optional array of parameters to pass to the constructor for $class_name objects.

RETURN VALUES

	An object with one attribute for each field name in the result. 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_object(3) example

	      <?php

	      $database = "store";

	      $db_conn = pg_connect("host=localhost port=5432 dbname=$database");
	      if (!$db_conn) {
		echo "Failed connecting to postgres database $database
";
		exit;
	      }

	      $qu = pg_query($db_conn, "SELECT * FROM books ORDER BY author");

	      while ($data = pg_fetch_object($qu)) {
		echo $data->author . " (";
		echo $data->year . "): ";
		echo $data->title . "<br />";
	      }

	      pg_free_result($qu);
	      pg_close($db_conn);

	      ?>

SEE ALSO

       pg_query(3), pg_fetch_array(3), pg_fetch_assoc(3), pg_fetch_row(3), pg_fetch_result(3).

PHP Documentation Group 													PG_FETCH_OBJECT(3)