Editing: /home/goacom/6club.princedev.shop/service/view_issues.php
<?php // Start session to check if the user is logged in session_start(); // Check if the admin is logged in, if not redirect to login page if (!isset($_SESSION['admin_id'])) { header('Location: index.php'); // Redirect to login page if not logged in exit(); } // Admin ID stored in session $admin_id = $_SESSION['admin_id']; // Rest of your code for viewing issue details... require 'db_connection.php'; $query = "SELECT * FROM issues ORDER BY created_at DESC"; $stmt = $pdo->query($query); $issues = $stmt->fetchAll(); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>View Issues</title> <link rel="stylesheet" href="styles.css"> </head> <body> <div class="sidebar"> <ul> <li><a href="dashboard.php">Dashboard</a></li> <li><a href="view_issues.php">View Issues</a></li> </ul> </div> <div class="content"> <h1>View All Issues</h1> <table> <thead> <tr> <th>Issue ID</th> <th>Account ID</th> <th>Issue</th> <th>Status</th> <th>Actions</th> </tr> </thead> <tbody> <?php foreach ($issues as $issue): ?> <tr> <td><?php echo $issue['id']; ?></td> <td><?php echo $issue['account_id']; ?></td> <td><?php echo $issue['issue']; ?></td> <td><?php echo $issue['status']; ?></td> <td><a href="view_issue.php?id=<?php echo $issue['id']; ?>">View</a></td> </tr> <?php endforeach; ?> </tbody> </table> </div> </body> </html>
💾 Save