   #PHP Manual PostgreSQL functions pg_free_result pg_get_pid

   PHP Manual
   Prev  Next
   ______________________________________________________________________

                                 pg_get_notify

   (PHP 4 >= 4.3.0)
   pg_get_notify -- Ping database connection

Description

   array pg_get_notify ( resource connection [, int result_type])

   pg_get_notify() gets notify message sent by NOTIFY SQL command. To
   receive notify messages, LISTEN SQL command must be issued. If there
   is notify message on the connection, array contains message name and
   backend PID is returned. If there is no message, FALSE is returned.

   See also pg_get_pid()

   Example 1. PostgreSQL NOTIFY message
   <?php
   $conn = pg_pconnect("dbname=publisher");
   if (!$conn) {
       echo "An error occured.\n";
       exit;
   }
   // Listen 'author_updated' message from other processes
   pg_query($conn, 'LISTEN author_updated;');
   $notify = pg_get_notify($conn);
   if (!$notify) {
       echo "No messages\n";
   } else {
       print_r($notify);
   }
   ?>
   ______________________________________________________________________

   Prev           Home       Next
   pg_free_result  Up  pg_get_pid
