pg_get_result

(PHP 4 >= 4.2.0, PHP 5)

pg_get_result — Get asynchronous query result

Açıklama

resource pg_get_result ([ resource $connection ] )

pg_get_result() gets the result resource from an asynchronous query executed by pg_send_query(), pg_send_query_params() or pg_send_execute().

pg_send_query() and the other asynchronous query functions can send multiple queries to a PostgreSQL server and pg_get_result() is used to get each query's results, one by one.

Değiştirgeler

connection: PostgreSQL database connection resource.

Dönen Değerler

The result resource, or FALSE if no more results are available.

Örnekler

Örnek 1 pg_get_result() example


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

  if (!pg_connection_busy($dbconn)) {
      pg_send_query($dbconn, "select * from authors; select count(*) from authors;");
  }
  
  $res1 = pg_get_result($dbconn);
  echo "First call to pg_get_result(): $res1\n";
  $rows1 = pg_num_rows($res1);
  echo "$res1 has $rows1 records\n\n";
  
  $res2 = pg_get_result($dbconn);
  echo "Second call to pg_get_result(): $res2\n";
  $rows2 = pg_num_rows($res2);
  echo "$res2 has $rows2 records\n";
?>

Yukarıdaki örneğin çıktısı:

First call to pg_get_result(): Resource id #3
Resource id #3 has 3 records

Second call to pg_get_result(): Resource id #4
Resource id #4 has 1 records

Ayrıca Bakınız

pg_send_query() - Sends asynchronous query

add a note User Contributed Notes pg_get_result

Marko Tiikkaja 25-Oct-2008 11:14


william at 25thandClement dot com said: "There is no way to poll/wait for a notification to come in. .."

Yes, there is. If there is a query in progress, pg_get_result() will block and return the result of that query when it's complete.

william at 25thandClement dot com 27-Jan-2005 08:03


There is no way to poll/wait for a notification to come in. You either have to enter a busy loop or sleep. Both options are horrible. It would be nice for PHP to provide access to PQsocket so one could select() on the socket connection. This is how it's done from C or Perl.

add a note