<?php

$db = new SQLiteDatabase("server-php-sqlite-demo.db");
$res = $db->unbufferedQuery("SELECT * FROM foo LIMIT 1");
// fetch the number of fields
$n_fields = $res->numFields();
$i = 0;
while ($i < $n_fields) {
    // retrieve individual fields
    $field_name = $res->fieldName($i++);
    echo $field_name."\n";
}

?>