cubrid_unbuffered_query(3) php man page | unix.com

Man Page: cubrid_unbuffered_query

Operating Environment: php

Section: 3

CUBRID_UNBUFFERED_QUERY(3)						 1						CUBRID_UNBUFFERED_QUERY(3)

cubrid_unbuffered_query - Perform a query without fetching the results into memory

SYNOPSIS
resource cubrid_unbuffered_query (string $query, [resource $conn_identifier])
DESCRIPTION
This function performs a query without waiting for that all query results have been complete. It will return when the results are being generated.
PARAMETERS
o $query -A SQL query. o $conn_identifier -The CUBRID connection. If the connection identifier is not specified, the last connection opened by cubrid_connect(3) is assumed.
RETURN VALUES
For SELECT, SHOW, DESCRIBE or EXPLAIN statements returns a request identifier resource on success. For other type of SQL statements, UPDATE, DELETE, DROP, etc, returns TRUE on success. FALSE on failure.
NOTES
Note The benefits of cubrid_unbuffered_query(3) come at a cost: you cannot use cubrid_num_rows(3) and cubrid_data_seek(3) on a result set returned from cubrid_unbuffered_query(3).
EXAMPLES
Example #1 cubrid_unbuffered_query(3) example <?php $link = cubrid_connect("localhost", 30000, "demodb", "dba", ""); if (!$link) { die('Could not connect.'); } $query = "select * from code"; $result = cubrid_unbuffered_query($query, $link); while ($row = cubrid_fetch($result)) { var_dump($row); } cubrid_close_request($result); cubrid_disconnect($link); ?> PHP Documentation Group CUBRID_UNBUFFERED_QUERY(3)
Related Man Pages
cubrid_execute(3) - php
mssql_query(3) - php
cubrid_num_rows(3) - php
cubrid_affected_rows(3) - php
cubrid_data_seek(3) - php
Similar Topics in the Unix Linux Community
hii
Optimizing query
How to limit output
SQL select all but not if it is already in an other column
Passing value of variable to a query within shell script