prepare("SELECT users.username, transactions.amount, transactions.timestamp FROM transactions JOIN users ON transactions.receiver_id = users.id WHERE transactions.sender_id = ? ORDER BY transactions.timestamp DESC");
$stmt->bind_param("i", $user_id);
$stmt->execute();
$stmt->bind_result($receiver, $amount, $timestamp);
echo "Transaktionshistorie
";
echo "| Empfänger | Betrag | Datum |
|---|
";
while ($stmt->fetch()) {
echo "| $receiver | $amount € | $timestamp |
";
}
echo "
";
$stmt->close();
$conn->close();
?>
Zurück