| Payee |
Due Date |
Amount |
Account |
Cleared |
Repeating |
Repeat Amount |
Edit |
connect();
if ( ! $conn ) {
Write('Error! Connection to database failed!
');
}
// else {
// echo 'Database connected!
';
// }
if ( $conn ) {
$sql = 'SELECT id,payee,due_date,amount,account,cleared,repeating,repeat_amount FROM bills';
$q = $conn->query($sql);
$q->setFetchMode(PDO::FETCH_ASSOC);
while ($row = $q->fetch()) {
Write("");
Write("| {$row['payee']} | ");
Write("{$row['due_date']} | ");
Write("{$row['amount']} | ");
Write("{$row['account']} | ");
Write("{$row['cleared']} | ");
Write("{$row['repeating']} | ");
Write("{$row['repeat_amount']} | ");
Write(" | ");
Write("
");
}
}
?>