|
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();
}
// Fetch all projects
$sql = "SELECT * FROM projects ORDER BY project_date DESC";
$result = $conn->query($sql);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>All Projects - Beyondlimits</title>
<link rel="shortcut icon" type="image/png" href="../NEWIMAGES/BEYONDLIMITS LOGO.png" />
<link rel="stylesheet" href="./assets/css/styles.min.css" />
<style>
.project-card img {
height: 200px;
object-fit: cover;
}
</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 active" 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 -->
<div class="body-wrapper">
<!-- Header -->
<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" id="navbarNav">
<ul class="navbar-nav flex-row ms-auto align-items-center justify-content-end">
<li class="nav-item dropdown">
<a class="nav-link" href="javascript:void(0)" id="drop2" data-bs-toggle="dropdown" aria-expanded="false">
<img src="./assets/images/profile/user-1.jpg" alt="" width="35" height="35" class="rounded-circle">
</a>
<div class="dropdown-menu dropdown-menu-end dropdown-menu-animate-up" aria-labelledby="drop2">
<div class="message-body">
<a href="javascript:void(0)" class="dropdown-item">
<i class="ti ti-user"></i> My Profile
</a>
<a href="logout.php" class="btn btn-outline-primary mx-3 mt-2 d-block">Logout</a>
</div>
</div>
</li>
</ul>
</div>
</nav>
</header>
<!-- End Header -->
<div class="container-fluid py-6 mt-5">
<h3 class="text-center mt-4 text-primary">All Projects</h3>
<div class="container mt-4">
<div class="card shadow-sm border-0">
<div class="card-body">
<h4 class="text-primary mb-4">Project List</h4>
<div class="table-responsive">
<table class="table table-bordered table-hover align-middle">
<thead class="table-primary text-center">
<tr>
<th>#</th>
<th>Project Image</th>
<th>Project Name</th>
<th>Description</th>
<th>Project Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<?php if ($result->num_rows > 0): ?>
<?php $count = 1; ?>
<?php while ($row = $result->fetch_assoc()): ?>
<tr>
<td class="text-center"><?= $count++ ?></td>
<td class="text-center">
<img src="uploads/<?= htmlspecialchars($row['project_image']) ?>" alt="Image" width="80" height="60" style="object-fit:cover;">
</td>
<td><?= htmlspecialchars($row['project_name']) ?></td>
<td><?= nl2br(htmlspecialchars($row['project_description'])) ?></td>
<td><?= htmlspecialchars($row['project_date']) ?></td>
<td class="text-center">
<a href="edit_project.php?id=<?= $row['id'] ?>" class="btn btn-sm btn-warning">Edit</a>
<a href="delete_project.php?id=<?= $row['id'] ?>" class="btn btn-sm btn-danger" onclick="return confirm('Are you sure to delete this project?');">Delete</a>
</td>
</tr>
<?php endwhile; ?>
<?php else: ?>
<tr>
<td colspan="5" class="text-center">No projects found.</td>
</tr>
<?php endif; ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- Scripts -->
<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>