File manager

File manager - Edit - /home/webapp68.cm.in.th/u68319090003/Final/Final/admin/manage_comments.php

Back
<?php session_start(); if (!isset($_SESSION['user_id']) \|\| $_SESSION['role'] != 'admin') { header("Location: login.php"); exit(); } include(__DIR__ . '/../config/db.php'); // อัปเดตสถานะ Approve if (isset($_GET['approve'])) { $comment_id = intval($_GET['approve']); $stmt = $conn->prepare("UPDATE comments SET is_approved=1 WHERE id=?"); $stmt->bind_param("i", $comment_id); $stmt->execute(); $stmt->close(); header("Location: manage_comments.php"); exit(); } // ลบ comment if (isset($_GET['delete'])) { $comment_id = intval($_GET['delete']); $stmt = $conn->prepare("DELETE FROM comments WHERE id=?"); $stmt->bind_param("i", $comment_id); $stmt->execute(); $stmt->close(); header("Location: manage_comments.php"); exit(); } // ดึง comment ทั้งหมด $sql = "SELECT c.id, c.author_name, c.comment, c.is_approved, c.created_at, a.title as article_title FROM comments c JOIN articles a ON c.article_id = a.id ORDER BY c.created_at DESC"; $comments = $conn->query($sql); ?> <!DOCTYPE html> <html lang="th"> <head> <meta charset="UTF-8"> <title>จัดการความคิดเห็น</title> <link href="https://fonts.googleapis.com/css2?family=Prompt:wght@400;600&display=swap" rel="stylesheet"> <style> {margin:0;padding:0;box-sizing:border-box;font-family:'Prompt',sans-serif;} body{background:#f0f3f9;color:#333;} / Header / .header{ background:linear-gradient(90deg,#36d1dc,#5b86e5); color:#fff;padding:20px;text-align:center; border-bottom-left-radius:20px;border-bottom-right-radius:20px; box-shadow:0 4px 15px rgba(0,0,0,0.2); } .header h2{font-size:24px;margin-bottom:5px;} .header .links{margin-top:8px;} .header .links a{ color:#fff;background:rgba(0,0,0,0.2); padding:6px 14px;border-radius:20px; margin:0 5px;text-decoration:none;font-size:14px; transition:0.3s; } .header .links a:hover{background:rgba(0,0,0,0.35);} / Container / .container{max-width:1100px;margin:30px auto;padding:0 15px;} / Table / table{width:100%;border-collapse:separate;border-spacing:0 12px;} th{background:#e7ecfa;color:#444;font-weight:600;padding:12px;border-radius:8px;text-align:left;} td{ background:#fff;padding:14px 12px;border-radius:8px; box-shadow:0 2px 6px rgba(0,0,0,0.08); vertical-align:top; } tr:hover td{background:#fdfdfd;} / Badge / .badge{ padding:5px 12px;border-radius:20px;font-size:13px; font-weight:600;display:inline-block; } .badge.success{background:#d4edda;color:#155724;} .badge.pending{background:#fff3cd;color:#856404;} / Buttons / .btn{ display:inline-block;padding:7px 14px;margin:3px 2px; border-radius:25px;color:#fff;text-decoration:none;font-size:14px; transition:0.3s; } .approve{background:#28a745;} .approve:hover{background:#218838;} .delete{background:#e74c3c;} .delete:hover{background:#c0392b;} / Responsive */ @media(max-width:768px){ table,thead,tbody,tr,th,td{display:block;width:100%;} th{display:none;} td{ margin-bottom:12px; padding:12px; } td:before{ content:attr(data-label); font-weight:600;display:block;margin-bottom:6px;color:#555; } } </style> </head> <body> <div class="header"> <h2>ระบบจัดการความคิดเห็น</h2> <div class="links"> <a href="admin_dashboard.php">← กลับสู่ Dashboard</a> <a href="../admin/logout.php">ออกจากระบบ</a> </div> </div> <div class="container"> <table> <thead> <tr> <th>ID</th> <th>ข่าว</th> <th>ผู้แสดงความคิดเห็น</th> <th>ความคิดเห็น</th> <th>สถานะ</th> <th>วันที่</th> <th>จัดการ</th> </tr> </thead> <tbody> <?php while($c = $comments->fetch_assoc()): ?> <tr> <td data-label="ID"><?php echo $c['id']; ?></td> <td data-label="ข่าว"><?php echo htmlspecialchars($c['article_title']); ?></td> <td data-label="ชื่อ"><?php echo htmlspecialchars($c['author_name']); ?></td> <td data-label="ความคิดเห็น"><?php echo nl2br(htmlspecialchars($c['comment'])); ?></td> <td data-label="สถานะ"> <?php if($c['is_approved']): ?> <span class="badge success">อนุมัติแล้ว</span> <?php else: ?> <span class="badge pending">รออนุมัติ</span> <?php endif; ?> </td> <td data-label="วันที่"><?php echo $c['created_at']; ?></td> <td data-label="จัดการ"> <?php if(!$c['is_approved']): ?> <a class="btn approve" href="manage_comments.php?approve=<?php echo $c['id']; ?>">อนุมัติ</a> <?php endif; ?> <a class="btn delete" href="manage_comments.php?delete=<?php echo $c['id']; ?>" onclick="return confirm('ยืนยันลบความคิดเห็นนี้?')">ลบ</a> </td> </tr> <?php endwhile; ?> </tbody> </table> </div> </body> </html>

| ver. 1.4 | Github | . | PHP 7.4.33 | Generation time: 0.76 | proxy | phpinfo | Settings