PHP.nl

pg_get_notify

pg_get_notify

Gets SQL NOTIFY message

 **pg_get_notify** PgSql\Connection $connection int $mode

gets notifications generated by a
SQL command. To receive notifications,

the SQL command must be issued. pg_get_notify``NOTIFY``LISTEN

connection``mode

An containing the message name and backend PID. If supported by the server, the array also contains the server version and the payload. Otherwise if no is waiting, then false is returned. array``NOTIFY``NOTIFY

Voorbeeld: PostgreSQL NOTIFY message

<?php 
$conn = pg_pconnect("dbname=publisher");
if (!$conn) {
  echo "An error occurred.\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);
}
?>

pg_get_pid

Vorige ← pg_free_result Volgende pg_get_pid →

Documentatie