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