samedi 7 mars 2015

Display SQLITE Query Results As Table Using PHP

Hello I am trying to display the results of a SQLITE query in a table in PHP unfortunately with no success. I am using XAMPP on OS X as my php server. My code is below



class DB extends SQLite3
{
function __construct( $file )
{
$this->open('Stock_Control.sqlite');
}
}
$db = new DB( 'Stock_Control.sqlite' );
$tablesquery = $db->query("SELECT Invoice_Number, Qty FROM Invoice");
while ($table = $tablesquery->fetchArray(SQLITE3_ASSOC))
{
echo $table['Invoice_Number'] . '<br />';
echo $table['Qty'] . '<br / >';
}

Aucun commentaire:

Enregistrer un commentaire