buchungen.php

<?php head("Buchungsübersicht - Konto " . $_GET['uid']);?>
<table border="0" width="100%" cellpadding="0" cellspacing="1" bgcolor="#303030">
<tr bgcolor="#f2f2f2">
<td align="center"><b>Buchungs Id</b></td>
<td align="center"><b>Datum</b></td>
<td align="center"><b>Zeit</b></td>
<td align="center"><b>FuCos</b></td>
<td align="center"><b>Verwendungszweck</b></td>
</tr>
<?php
$buchungen_lesen = db_query("SELECT * FROM " . $db_prefix . "_buchungen WHERE uid=" . $_GET['uid'] . " ORDER BY buchungszeit DESC LIMIT 250");
while ($buchung_schreiben = mysqli_fetch_array($buchungen_lesen)) {
    $buchcolor = '#000000';
    if ($buchung_schreiben['buchungsmenge'] < 0) $buchcolor = '#cc0000';

    ?>
<tr bgcolor="#fafafa">
<td align="left">&nbsp;'.$buchung_schreiben['buchungs_id'];?></td>
<td align="center">&nbsp;'.date("d.m.Y",$buchung_schreiben['buchungszeit']);?>&nbsp;</td>
<td align="center">&nbsp;'.date("H:i",$buchung_schreiben['buchungszeit']);?>&nbsp;</td>
<td align="right">&nbsp;<font color="'.$buchcolor;?>">'.number_format($buchung_schreiben['buchungsmenge'],2,",",".");?></font>&nbsp;</td>
<td align="left">&nbsp;'.$buchung_schreiben['verwendungszweck'];?></td>
</tr>
<?php
}

?>
</table>
<?php foot();?>