PHP Mysql Tutorials, Function, mysql_unbuffered

Topic

What is mysql_unbuffered_query() function in PHP?
How does mysql_unbuffered_query() works?

Explanation

Mysql function mysql_unbuffered_query() send an SQL query to MySQL, without fetching and buffering the result rows

Syntax

resource mysql_unbuffered_query(string query [, resource link_identifier])

Returns the query handle for SELECT queries, TRUE/FALSE for other queries, or FALSE on failure.

mysql_unbuffered_query() sends a SQL query to MySQL, without fetching and buffering the result rows automatically, as mysql_query() does. This saves a considerable amount of memory with SQL queries that produce large result sets.

It executes the query and returns a resource pointing to the result of the query while MySQL is still working, which means you can start reading the result before the query has finished. When using multiple DB-connects, you have to specify the optional parameter link_identifier.

You cannot use mysql_num_rows() and mysql_data_seek() on a result set returned from mysql_unbuffered_query().

Example:

<?php

$link = mysql_pconnect("mysql_host", "mysql_user", "mysql_password")
or die ("Could not connect");

//select database

if (!mysql_select_db("my_database", $link)) {
echo " ERROR NO: " . mysql_errno($link) . "\n";
}

$sql="select * from my_table";
$result =mysql_unbuffered_query($sql,$link);

// start working with data

while ($row = mysql_fetch_assoc($result)) {
echo $row["field1"];
}
?>

RESULT:

Scripts
Tutorials
Code
Tools

See also: mysql_query().

mysql_unbuffered_query() function for PHP