1#@!#!123s

32759 1#@!#!123s

: / home / aissorg / public_html / admin / php /

Filename : fetch-donation-history.php

back

<?php
include('../include/config.php');

if (isset($_POST['customer_name'])) {
    $customer_name = mysqli_real_escape_string($con, $_POST['customer_name']);
    
    $sql = "SELECT amount, pan_number, donation_date FROM donations WHERE name = '$customer_name' ORDER BY donation_date DESC";
    $result = mysqli_query($con, $sql);

    if (mysqli_num_rows($result) > 0) {
        while ($row = mysqli_fetch_assoc($result)) {
            echo "<tr>";
            echo "<td>" . $row['donation_date'] . "</td>";
            echo "<td>$" . number_format($row['amount'], 2) . "</td>";
            echo "</tr>";
        }
    } else {
        echo "<tr><td colspan='3'>No donations found.</td></tr>";
    }
}
?>