pg_cancel_query
(PHP 4 >= 4.2.0, PHP 5, PHP 7)
pg_cancel_query - 取消异步查询
描述
bool pg_cancel_query ( resource $connection )
pg_cancel_query()取消与pg_send_query(),pg_send_query_params()或pg_send_execute()一起发送的异步查询。您不能取消使用pg_query()执行的查询。
参数
connection
PostgreSQL数据库连接资源。
返回值
成功返回TRUE
或失败时返回FALSE
。
例子
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_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);
?>
上面的例子将输出:
First call to pg_get_result(): Resource id #3
Resource id #3 has 3 records
← pg_affected_rows
pg_client_encoding →
本文档系腾讯云开发者社区成员共同维护,如有问题请联系 cloudcommunity@tencent.com