PHP mysql_unbuffered_query() Function
 Complete PHP MySQL Reference
Definition and Usage
The mysql_unbuffered_query() function executes a query on a MySQL database.
Unlike mysql_query(), this function does not fetch and buffer the recordset
automatically. This saves some memory with large SQL queries, and you can start working on the result set
immediately after the first row has been retrieved.
This function returns the query handle for SELECT queries,
TRUE/FALSE for other queries, or FALSE on failure.
Syntax
mysql_unbuffered_query(query,connection)
|
| Parameter |
Description |
| query |
Required. Specifies the SQL query to send (should not end
with a semicolon) |
| connection |
Optional. Specifies the MySQL connection. If not specified,
the last connection opened by mysql_connect() or mysql_pconnect() is used. |
Tips and Notes
Note: The benefits of mysql_unbuffered_query() come at a cost: You
cannot use mysql_num_rows() and mysql_data_seek() on a result set returned from
mysql_unbuffered_query().
Example
<?php
$con = mysql_connect("localhost","mysql_user","mysql_pwd");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
// Large query
$sql = "SELECT * FROM Person";
mysql_unbuffered_query($sql,$con);
// start working with data
mysql_close($con);
?>
|
Complete PHP MySQL Reference
Whether you're new to XML or already an advanced user, the user-friendly views
and powerful entry helpers, wizards, and debuggers in XMLSpy are designed to
meet your XML and Web services development needs from start to finish.
- XML editor
- Graphical XML Schema / DTD editors
- XSLT 1.0/2.0 editor, debugger, profiler
- XQuery editor, debugger, profiler
- Support for Office Open XML (OOXML)
- Graphical WSDL editor & SOAP debugger
- Java, C#, C++ code generation
- And much more!
Download a fully functional free 30-day trial today!
|
