|
sqlite_unbuffered_query
Execute a query that does not prefetch and buffer all data
(PHP 5, PECL sqlite:1.0-1.0.3)
Object oriented style (method): SQLiteDatabase { sqlite_unbuffered_query() is identical to sqlite_query() except that the result that is returned is a sequential forward-only result set that can only be used to read each row, one after the other. This function is ideal for generating things such as HTML tables where you only need to process one row at a time and don't need to randomly access the row data.
Note:
Functions such as sqlite_seek(), sqlite_rewind(), sqlite_next(), sqlite_current(), and sqlite_num_rows() do not work on result handles returned from sqlite_unbuffered_query(). Parameters
Note:
Two alternative syntaxes are supported for compatibility with other database extensions (such as MySQL). The preferred form is the first, where the dbhandle parameter is the first parameter to the function. Return Values
Returns a result handle or sqlite_unbuffered_query() returns a sequential forward-only result set that can only be used to read each row, one after the other.
See Also
Code Examples / Notes » sqlite_unbuffered_queryradley25
Always use this over the sqlite_fetch_* functions if possible as it's much faster.
ofbuker
<?php ob_start(); echo "<title>Members</title>"; sqlite_unbuffered_query($query,"select * from members"); while(sqlite_fetch_object($rows,$query)){ echo $rows->membername; echo " "; } ob_end_flush(); ?> |
Change Languagesqlite_array_query sqlite_busy_timeout sqlite_changes sqlite_close sqlite_column sqlite_create_aggregate sqlite_create_function sqlite_current sqlite_error_string sqlite_escape_string sqlite_exec sqlite_factory sqlite_fetch_all sqlite_fetch_array sqlite_fetch_column_types sqlite_fetch_object sqlite_fetch_single sqlite_fetch_string sqlite_field_name sqlite_has_more sqlite_has_prev sqlite_key sqlite_last_error sqlite_last_insert_rowid sqlite_libencoding sqlite_libversion sqlite_next sqlite_num_fields sqlite_num_rows sqlite_open sqlite_popen sqlite_prev sqlite_query sqlite_rewind sqlite_seek sqlite_single_query sqlite_udf_decode_binary sqlite_udf_encode_binary sqlite_unbuffered_query sqlite_valid |