<HTML ><HEAD ><TITLE >pg_send_query</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK REL="HOME" TITLE="PHP Manual" HREF="index.html"><LINK REL="UP" TITLE="PostgreSQL functions" HREF="ref.pgsql.html"><LINK REL="PREVIOUS" TITLE="pg_select" HREF="function.pg-select.html"><LINK REL="NEXT" TITLE="pg_set_client_encoding" HREF="function.pg-set-client-encoding.html"><META HTTP-EQUIV="Content-type" CONTENT="text/html; charset=ISO-8859-1"></HEAD ><BODY CLASS="refentry" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >PHP Manual</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="function.pg-select.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="function.pg-set-client-encoding.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><H1 ><A NAME="function.pg-send-query" ></A >pg_send_query</H1 ><DIV CLASS="refnamediv" ><A NAME="AEN77918" ></A ><P > (PHP 4 >= 4.2.0)</P >pg_send_query -- Send asynchronous query </DIV ><DIV CLASS="refsect1" ><A NAME="AEN77921" ></A ><H2 >Description</H2 >bool <B CLASS="methodname" >pg_send_query</B > ( resource connection, string query)<BR ></BR >bool <B CLASS="methodname" >pg_send_query</B > ( string query)<BR ></BR ><P > <B CLASS="function" >pg_send_query()</B > send asynchronous query to the <TT CLASS="parameter" ><I >connection</I ></TT >. Unlike <A HREF="function.pg-query.html" ><B CLASS="function" >pg_query()</B ></A >, it can send multiple query to PostgreSQL and get the result one by one using <A HREF="function.pg-get-result.html" ><B CLASS="function" >pg_get_result()</B ></A >. Script execution is not blocked while query is executing. Use <A HREF="function.pg-connection-busy.html" ><B CLASS="function" >pg_connection_busy()</B ></A > to check connection is busy (i.e. query is executing). Query may be canceled by calling <A HREF="function.pg-cancel-query.html" ><B CLASS="function" >pg_cancel_query()</B ></A >. </P ><P > Although user can send multiple query at once, user cannot send multiple query over busy connection. If query is sent while connection is busy, it waits until last query is finished and discards all result. </P ><P > See also <A HREF="function.pg-query.html" ><B CLASS="function" >pg_query()</B ></A >, <A HREF="function.pg-cancel-query.html" ><B CLASS="function" >pg_cancel_query()</B ></A >, <A HREF="function.pg-get-result.html" ><B CLASS="function" >pg_get_result()</B ></A > and <A HREF="function.pg-connection-busy.html" ><B CLASS="function" >pg_connection_busy()</B ></A > </P ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="function.pg-select.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="function.pg-set-client-encoding.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >pg_select</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="ref.pgsql.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >pg_set_client_encoding</TD ></TR ></TABLE ></DIV ></BODY ></HTML >