PHP Manual: Executes an SQL query

Description

public SQLite3Resultfalse SQLite3::query(string $query)

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

query: The SQL query to execute.

Return Values

Returns an SQLite3Result object, or false on failure.

Examples

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);
}
?>