CHAPTER 6 – SQLite – Other Querying Functions

The singleQuery() method is one of many specialized functions for data retrieval. They are added for performance rea- sons, and there are a few more than we've already seen (see Table 6.10). Table 6.10 Query Functions and Methods Function Name Returns Description sqlite_query() handle Executes a simple query. $sqlite->query() sqlite_unbuffered_query() handle Executes a query, but does not $sqlite->unbufferedQuery() buffer the result in the client. $sqlite->queryExec() boolean Executes a chained query (multiple sqlite_exec() queries separated by a ;) without result. $sqlite->arrayQuery() data Execute a query and returns an sqlite_array_query() array with all rows and columns in a two-dimensional array. $sqlite->singleQuery() data Executes a query and returns the sqlite_single_query() first column of the first returned record.