SQLite3::query
PHP function
Edit on GitHub ✎
(PHP 5 >= 5.3.0, PHP 7, PHP 8)
Executes an SQL query
Description
SQLite3::query(string $query): SQLite3Result|false
Executes an SQL query, returning an SQLite3Result object. If the query does not yield a result (such as DML statements) the returned SQLite3Result object is not really usable. Use SQLite3::exec for such queries instead.
Parameters
queryThe SQL query to execute.
Return Values
Returns an SQLite3Result object, Falseforfailure.
Examples
SQLite3::query() example
php
<?php
$db = new SQLite3('mysqlitedb.db');
$results = $db->query('SELECT bar FROM foo');
while ($row = $results->fetchArray()) {
var_dump($row);
}
?>