pg_send_query
pg_send_query sends a query or queries asynchronously to the connection. Unlike pg_query, it can send multiple queries at once to PostgreSQL and get the results one by one using pg_get_result.
Script execution is not blocked while the queries are executing. Use pg_connection_busy to check if the connection is busy (i.e. the query is executing). Queries may be cancelled using pg_cancel_query.
Although the user can send multiple queries at once, multiple queries cannot be sent over a busy connection. If a query is sent while the connection is busy, it waits until the last query is finished and discards all its results.
Parameters
- connection
-
An PgSql\Connection instance.
- query
-
The SQL statement or statements to be executed.
Data inside the query should be properly escaped.
Return Values
Returns true on success, false or 0 on failure. Use pg_get_result to determine the query result.
Changelog
| Version | Description |
| 8.1.0 | The connection parameter expects an PgSql\Connection instance now; previously, a resource was expected. |