sqlite - How to connect to a SQLite3 db with PHP

Question

I'm new to SQLite3 and PHP and was wondering whether and how I could connect to a SQLite3 database with PHP.

How would I get the data from the db and would it be possible to output them on a browser screen? I've been searching the web for a while now, but couldn't find anything.

Thank you.

Answer 1

<?php
$db = new SQLite3('mysqlitedb.db');

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

Taken from here: PHP: SQLite3::query - Manual