SQLite3 :: SQLite3::query

PHP Portal » PHP Handbuch » SQLite3::query

SQLite3::query

(PHP 5 >= 5.3.0)

SQLite3::query — Executes an SQL query

public SQLite3Result SQLite3::query ( string $query )

Executes an SQL query, returning an SQLite3Result object if the query returns results.

Returns an SQLite3Result object if the query returns results. Otherwise, returns TRUE if the query succeeded, FALSE on failure.

Beispiel #1 SQLite3::query() example

PHP Code

1
2
3
4
5

$db = new SQLite3('mysqlitedb.db');
$results = $db->query('SELECT bar FROM foo');
while ($row = $results->fetchArray()) {
    var_dump($row);
}