pg_field_num(3) [php man page]

PG_FIELD_NUM(3) 														   PG_FIELD_NUM(3)

pg_field_num - Returns the field number of the named field

SYNOPSIS

       int pg_field_num (resource  $result, string  $field_name)

DESCRIPTION

       pg_field_num(3) will return the number of the field number that corresponds to the $field_name in the given PostgreSQL $result resource.

       Note

	       This function used to be called pg_fieldnum(3).

PARAMETERS

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

	      o $field_name
		- The name of the field.

RETURN VALUES

	The field number (numbered from 0), or -1 on error.

EXAMPLES

       Example #1

	      Getting information about fields

	      <?php
		$dbconn = pg_connect("dbname=publisher") or die("Could not connect");

		$res = pg_query($dbconn, "select author, year, title from authors where author = 'Orwell'");

		echo "Column 'title' is field number: ", pg_field_num($res, 'title');
	      ?>

	      The above example will output:

	      Column 'title' is field number: 2

SEE ALSO

       pg_field_name(3).

PHP Documentation Group 													   PG_FIELD_NUM(3)

PG_FIELD_IS_NULL(3)													       PG_FIELD_IS_NULL(3)

pg_field_is_null - Test if a field is SQL NULL

SYNOPSIS

       int pg_field_is_null (resource  $result, int  $row, mixed  $field)

DESCRIPTION

       int pg_field_is_null (resource  $result, mixed  $field)

       pg_field_is_null(3) tests if a field in a PostgreSQL result resource is SQL NULL or not.

       Note

	       This function used to be called pg_fieldisnull(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, current row is fetched.

	      o $field
		- Field number (starting from 0) as an integer or the field name as a string.

RETURN VALUES

	Returns 1 if the field in the given row is SQL NULL, 0 if not.	FALSE is returned if the row is out of range, or upon any other error.

EXAMPLES

       Example #1

	      pg_field_is_null(3) example

	      <?php
		$dbconn = pg_connect("dbname=publisher") or die ("Could not connect");
		$res = pg_query($dbconn, "select * from authors where author = 'Orwell'");
		if ($res) {
		    if (pg_field_is_null($res, 0, "year") == 1) {
			echo "The value of the field year is null.
";
		    }
		    if (pg_field_is_null($res, 0, "year") == 0) {
			echo "The value of the field year is not null.
";
		  }
	       }
	      ?>

PHP Documentation Group 												       PG_FIELD_IS_NULL(3)