Vielen Dank für Ihre Spende und die damit verbundene Hilfe für unsere Fellnasen.
{source}
<?php
$mysqli = new mysqli("rdbms.strato.de", "U2004907", "tikli19104", "DB2004907");
$mysqli->set_charset("utf8");
$mysqli->query ( "SET NAMES 'utf8'" );
$mysqli->query ( "SET CHARACTER SET 'utf8'" );
if ($mysqli->connect_errno) {
die("Verbindung fehlgeschlagen: " . $mysqli->connect_error);
}
$id = 100;
$sql = "SELECT * FROM la4ev_spende WHERE sp_jahr='2018' ORDER BY id DESC";
if (!$result = $mysqli->query($sql)) {
echo "Sorry, the website is experiencing problems.";
exit;
}
mysqli_set_charset($mysqli, "utf8");
?>
<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}