PHP/MySQL Database/sqlite fetch array
sqlite_fetch_array-2.php
<source lang="html4strict">
<?php
$sqldb = sqlite_open("mydatabase.db"); $results = sqlite_query($sqldb, "SELECT * FROM employee"); while (list($empid, $name) = sqlite_fetch_array($results)) { echo "Name: $name (Employee ID: $empid)
"; } sqlite_close($sqldb);
?>
</source>
sqlite_fetch_array.php
<source lang="html4strict">
<?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"].")
"; } sqlite_close($sqldb);
?>
</source>