   #PHP Manual PostgreSQL functions pg_fetch_row pg_field_name

   PHP Manual
   Prev  Next
   ______________________________________________________________________

                               pg_field_is_null

   (PHP 4 >= 4.2.0)
   pg_field_is_null -- Test if a field is NULL

Description

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

   pg_field_is_null() tests if a field is NULL or not. It returns 1 if
   the field in the given row is NULL. It returns 0 if the field in the
   given row is NOT NULL. Field can be specified as column index (number)
   or fieldname (string). Row numbering starts at 0.

   Example 1. pg_field_is_null() 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.\n";
           }
           if (pg_field_is_null($res, 0, "year") == 0) {
               echo "The value of the field year is not null.\n";
         }
      }
   ?>

     Note: This function used to be called pg_fieldisnull().
   ______________________________________________________________________

   Prev         Home          Next
   pg_fetch_row  Up  pg_field_name
