<?php
$db = new sqlite_db(dirname(__FILE__)."/db.sqlite");
$res = $db->query("SELECT * FROM auth_tbl");
/* return number of rows selected */
echo "Rows Fetched: " . $res->num_rows() . "<br />\n";
/* determine the number of columns in the result set */
echo "Columns per row " . ($n_cols = $res->num_fields()) . "<br />\n";
for ($i = 0; $i < $n_cols; $i++) {
/* fetch column names */
echo "Column Names: " . $res->field_name($i) . "<br />\n";
}
?>