<?php

if (!$bd = new SQLiteDatabase('database.sqlite', 0666, $error))
    die($error);
$sql = "SELECT * FROM table_name";
$data = $db->query($sql);
$data_count = $data->numRows();
if ($data_count != 0) {
    for ($i=0; $i<$data_count; $i++) {
        echo "$data->fieldName($i)";
    }
    while ($tuple = $data->fetch()) {
        echo "$tuple['name']<br>";
        echo "$tuple['description']<br>";
        echo "$tuple['prize']<br>";
    }
}
unset($bd);

?>

How to use the SQLite Objetct Oriented Interface

PHP