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