PHP : Function Reference : PostgreSQL Functions : pg_cancel_query PHP Examples Tutorials References

Example 1903. pg_cancel_query() 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";

  

  // Cancel the currently running query.  Will be the second query if it is

  // still running.

  pg_cancel_query($dbconn);
?>

The above example will output:

copy to clipboard

First call to pg_get_result(): Resource id #3

Resource id #3 has 3 records

pg_cancel_query

Cancel an asynchronous query (PHP 4 >= 4.2.0, PHP 5)
bool pg_cancel_query ( resource connection )

Example 1903. pg_cancel_query() example

Change Language

pg_cancel_query

Cancel an asynchronous query (PHP 4 >= 4.2.0, PHP 5) bool pg_cancel_query ( resource connection )

Example 1903. pg_cancel_query() example

Change Language

Cancel an asynchronous query (PHP 4 >= 4.2.0, PHP 5)
bool pg_cancel_query ( resource connection )