|
<?php
$sqldb = sqlite_open("mydatabase.db");
$results = sqlite_query($sqldb, "SELECT * FROM employee");
while ($row = sqlite_fetch_array($results,SQLITE_BOTH)) {
echo "Name: $row[1] (Employee ID: ".$row['empid'].")<br />";
if (sqlite_has_more($results)) echo "Still more rows to go!<br />";
else echo "No more rows!<br />";
}
sqlite_close($sqldb);
?>
|