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
|