|
Server : Apache System : Linux gains.enterpriseappscloud.com 4.18.0-553.62.1.lve.el8.x86_64 #1 SMP Mon Jul 21 17:50:35 UTC 2025 x86_64 User : beyondlimi ( 2438) PHP Version : 7.4.33 Disable Function : allow_url_include, show_source, symlink, system, passthru, exec, popen, pclose, proc_open, proc_terminate,proc_get_status, proc_close, proc_nice, allow_url_fopen, shell-exec, shell_exec, fpassthru, base64_encodem, escapeshellcmd, escapeshellarg, crack_check,crack_closedict, crack_getlastmessage, crack_opendict, posix_kill, posix_mkfifo, posix_setpgid, posix_setsid, posix_setuid, dl, escap, phpinfo Directory : /home/beyondlimi/domains/beyondlimits.org.in/private_html/admin/ |
Upload File : |
<?php
session_start();
include 'db.php';
if (!isset($_SESSION['admin'])) {
header("Location: index.php");
exit();
}
$sql = "SELECT * FROM donations ORDER BY created_at DESC";
$result = $conn->query($sql);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>All Donations - Beyondlimits Admin</title>
<link rel="shortcut icon" type="image/png" href="../NEWIMAGES/BEYONDLIMITS LOGO.png" />
<link rel="stylesheet" href="./assets/css/styles.min.css" />
<style>
.table th,
.table td {
vertical-align: middle !important;
font-size: 15px;
}
</style>
</head>
<body>
<div class="page-wrapper" id="main-wrapper" data-layout="vertical" data-navbarbg="skin6"
data-sidebartype="full" data-sidebar-position="fixed" data-header-position="fixed">
<!-- Sidebar Start -->
<aside class="left-sidebar">
<div>
<div class="brand-logo d-flex align-items-center justify-content-between">
<a href="dashboard.php" class="text-nowrap logo-img">
<img src="../NEWIMAGES/BEYONDLIMITS LOGO.png" class="img-fluid" alt="Logo" />
</a>
<div class="close-btn d-xl-none d-block sidebartoggler cursor-pointer" id="sidebarCollapse">
<i class="ti ti-x fs-6"></i>
</div>
</div>
<nav class="sidebar-nav scroll-sidebar" data-simplebar="">
<ul id="sidebarnav">
<li class="nav-small-cap">
<iconify-icon icon="solar:menu-dots-linear" class="nav-small-cap-icon fs-4"></iconify-icon>
<span class="hide-menu">Menu</span>
</li>
<li class="sidebar-item">
<a class="sidebar-link" href="dashboard.php">
<i class="ti ti-layout-dashboard"></i>
<span class="hide-menu">Dashboard</span>
</a>
</li>
<li class="sidebar-item">
<a class="sidebar-link" href="addproject.php">
<i class="ti ti-plus"></i>
<span class="hide-menu">Add Project</span>
</a>
</li>
<li class="sidebar-item">
<a class="sidebar-link " href="allprojects.php">
<i class="ti ti-eye"></i>
<span class="hide-menu">View Projects</span>
</a>
</li>
<li class="sidebar-item">
<a class="sidebar-link" href="./all_donations.php" aria-expanded="false">
<i class="ti ti-currency-rupee"></i>
<span class="hide-menu">All Donations</span>
</a>
</li>
</ul>
</nav>
</div>
</aside>
<!-- Sidebar End -->
<!-- Main Wrapper Start -->
<div class="body-wrapper">
<header class="app-header">
<nav class="navbar navbar-expand-lg navbar-light">
<ul class="navbar-nav">
<li class="nav-item d-block d-xl-none">
<a class="nav-link sidebartoggler" id="headerCollapse" href="javascript:void(0)">
<i class="ti ti-menu-2"></i>
</a>
</li>
</ul>
<div class="navbar-collapse justify-content-end px-0">
<ul class="navbar-nav flex-row ms-auto align-items-center justify-content-end">
<li class="nav-item dropdown">
<a class="nav-link" href="#" id="drop2" data-bs-toggle="dropdown" aria-expanded="false">
<img src="./assets/images/profile/user-1.jpg" width="35" height="35" class="rounded-circle" alt="Admin">
</a>
<div class="dropdown-menu dropdown-menu-end">
<a href="logout.php" class="btn btn-outline-primary mx-3 mt-2 d-block">Logout</a>
</div>
</li>
</ul>
</div>
</nav>
</header>
<div class="container-fluid mt-5">
<h3 class="mb-4 text-primary text-center">Donor Contributions</h3>
<div class="card shadow-sm">
<div class="card-body">
<div class="table-responsive">
<table class="table table-bordered table-hover align-middle text-center">
<thead class="table-primary">
<tr>
<th>#</th>
<th>Donor Name</th>
<th>Email</th>
<th>Phone</th>
<th>Purpose</th>
<th>Amount (₹)</th>
<th>Payment ID</th>
<th>Date</th>
</tr>
</thead>
<tbody>
<?php if ($result->num_rows > 0): ?>
<?php $count = 1; ?>
<?php while ($row = $result->fetch_assoc()): ?>
<tr>
<td><?= $count++ ?></td>
<td><?= htmlspecialchars($row['name']) ?></td>
<td><?= htmlspecialchars($row['email']) ?></td>
<td><?= htmlspecialchars($row['phone']) ?></td>
<td><?= htmlspecialchars($row['purpose']) ?></td>
<td><?= number_format($row['amount'], 2) ?></td>
<td><?= htmlspecialchars($row['payment_id']) ?></td>
<td><?= date("d M Y, h:i A", strtotime($row['created_at'])) ?></td>
</tr>
<?php endwhile; ?>
<?php else: ?>
<tr>
<td colspan="8">No donations found.</td>
</tr>
<?php endif; ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
<!-- Main Wrapper End -->
</div>
<script src="./assets/libs/jquery/dist/jquery.min.js"></script>
<script src="./assets/libs/bootstrap/dist/js/bootstrap.bundle.min.js"></script>
<script src="./assets/js/sidebarmenu.js"></script>
<script src="./assets/js/app.min.js"></script>
</body>
</html>