(PHP 5 >= 5.3.0)
SQLite3::query — Executes an SQL query
Executes an SQL query, returning an SQLite3Result object if the query returns results.
The SQL query to execute.
Returns an SQLite3Result object if the query returns results. Otherwise, returns TRUE if the query succeeded, FALSE on failure.
Пример #1 SQLite3::query() example
<?php
$db = new SQLite3('mysqlitedb.db');
$results = $db->query('SELECT bar FROM foo');
while ($row = $results->fetchArray()) {
var_dump($row);
}
?>