prepare("UPDATE reviews SET status = 1 WHERE id = ?")->execute([intval($_GET['approve'])]); admin_set_flash('success', 'Review approved'); header('Location: ' . ADMIN_PATH . 'pages/reviews.php'); exit; } if (isset($_GET['reject'])) { $db->prepare("UPDATE reviews SET status = 0 WHERE id = ?")->execute([intval($_GET['reject'])]); admin_set_flash('success', 'Review rejected'); header('Location: ' . ADMIN_PATH . 'pages/reviews.php'); exit; } if (isset($_GET['delete'])) { $db->prepare("DELETE FROM reviews WHERE id = ?")->execute([intval($_GET['delete'])]); admin_set_flash('success', 'Review deleted'); header('Location: ' . ADMIN_PATH . 'pages/reviews.php'); exit; } $reviews = $db->query("SELECT r.*, p.name as product_name, p.thumbnail, p.slug FROM reviews r LEFT JOIN products p ON r.product_id = p.id ORDER BY r.created_at DESC")->fetchAll(); ?>

All Reviews ()

Product Customer Rating Review Status Date Actions

...