Mega Code Archive

 

Categories / Php / MySQL Database

 

Sqlite_fetch_array php

<?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 />";    }    sqlite_close($sqldb); ?>