| Server IP : 104.21.73.108 / Your IP : 216.73.216.59 Web Server : Apache/2 System : Linux cat167-197.static.lnwhostname.com 5.10.0-20-amd64 #1 SMP Debian 5.10.158-2 (2022-12-13) x86_64 User : paphayomho ( 1042) PHP Version : 5.6.40 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/paphayomho/domains/paphayomhospital.go.th/public_html/new/ |
Upload File : |
<?php
require 'db.php';
checkLogin();
$result = $conn->query("SELECT * FROM hospital_activities ORDER BY id DESC");
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<link href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css" rel="stylesheet">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css">
</head>
<body>
<nav class="navbar navbar-dark bg-dark px-3">
<a class="navbar-brand">Hospital Admin</a>
<a href="logout.php" class="btn btn-outline-light btn-sm">Logout</a>
</nav>
<div class="container mt-4">
<div class="d-flex justify-content-between mb-3">
<h4>จัดการกิจกรรม</h4>
<a href="add.php" class="btn btn-success">+ เพิ่มกิจกรรมใหม่</a>
</div>
<table class="table table-bordered bg-white shadow-sm align-middle">
<thead class="table-light">
<tr>
<th>รูป</th>
<th>หัวข้อ</th>
<th>ประเภท</th>
<th>จัดการ</th>
</tr>
</thead>
<tbody>
<?php while($row = $result->fetch_assoc()):
$img_res = $conn->query("SELECT image_path FROM activity_images WHERE activity_id=".$row['id']." LIMIT 1");
$img = $img_res->fetch_assoc();
?>
<tr>
<td width="100">
<img src="uploads/<?= $img['image_path'] ?? 'no-image.jpg' ?>" width="80" height="80" style="object-fit:cover" class="rounded">
</td>
<td>
<strong><?= $row['title'] ?></strong><br>
<small class="text-muted"><?= $row['date_range'] ?></small>
</td>
<td><?= $row['footer_type'] ?></td>
<td>
<a href="edit.php?id=<?= $row['id'] ?>" class="btn btn-sm btn-warning"><i class="fa fa-edit"></i></a>
<a href="delete.php?id=<?= $row['id'] ?>" class="btn btn-sm btn-danger" onclick="return confirm('ยืนยัน?')"><i class="fa fa-trash"></i></a>
</td>
</tr>
<?php endwhile; ?>
</tbody>
</table>
</div>
</body>
</html>