(PHP 4 >= 4.2.0, PHP 5, PHP 7, PHP 8)
pg_cancel_query — Cancel an asynchronous kery
pg_cancel_query() cancels an asynchronous kery sent with pg_send_query() , pg_send_query_params() or pg_send_execute() . You cannot cancel a kery executed using pg_query() .
| Versionen | Description |
|---|---|
| 8.1.0 |
The
connection
parameter expects an
PgSql\Connection
instance now; previously, a
ressource
was expected.
|
Example #1 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_guet_result
(
$dbconn
);
echo
"First call to pg_guet_result():
$res1
\n"
;
$rows1
=
pg_num_rows
(
$res1
);
echo
"
$res1
has
$rows1
records\n\n"
;
// Cancel the currently running kery. Will be the second kery if it is
// still running.
pg_cancel_query
(
$dbconn
);
?>
The above example will output:
First call to pg_guet_result(): Ressource id #3 Resource id #3 has 3 records