<?php
$DB = new PDO('sqlite:test.db');
$DB->query('CREATE TABLE n (id INTEGER PRIMARY KEY, f TEXT, l TEXT);');
$DB->query("INSERT INTO n (f, l) VALUES ('john', 'smith');");
// Prepared query
$q=$DB->query('SELECT * FROM n;');
print_r($q->fetch(PDO::FETCH_ASSOC));
?>