{source}
<?php
$mysqli = new mysqli("rdbms.strato.de", "U2004907", "tikli19104", "DB2004907");
if ($mysqli->connect_errno) {
die("Verbindung fehlgeschlagen: " . $mysqli->connect_error);
}
$id = 100;
$sql = "SELECT * FROM la4ev_spende WHERE sp_jahr='2012' ORDER BY id DESC"; if (!$result = $mysqli->query($sql)) { echo "Sorry, the website is experiencing problems."; exit; }
mysqli_set_charset($mysqli, "utf8mb4_unicode_ci");
?>
</br>
<table width="670" border="0" cellpadding="0" cellspacing="0">
<tr>
<th width="80" align="left">Datum</th>
<th width="250" align="left">Spender</th>
<th width="340" align="left">Aktion / Spende für</th>
<th width="100" align="right">Betrag</th>
</tr>
<?php
while($row = mysqli_fetch_object($result)) { echo "<tr>"; echo "<td>",$row->sp_datum,"</td>"; echo "<td>",$row->sp_spender,"</td>"; echo "<td>",$row->sp_aktion,"</td>"; echo "<td align=\"right\">",$row->sp_betrag," EUR</td>\n"; echo "</tr>"; } echo "</table>";
mysqli_close($mysqli);
?>
{/source}