prepare("UPDATE reviews SET status = 1 WHERE id = ?")->execute([$id]);
header("Location: reviews.php?msg=approved");
exit();
}
// 2. HANDLE DELETE
if (isset($_GET['delete'])) {
$id = $_GET['delete'];
$pdo->prepare("DELETE FROM reviews WHERE id = ?")->execute([$id]);
header("Location: reviews.php?msg=deleted");
exit();
}
// 3. FETCH REVIEWS
// We join with products table to show the product name
$stmt = $pdo->query("
SELECT r.*, p.name as product_name
FROM reviews r
LEFT JOIN products p ON r.product_id = p.id
ORDER BY r.status ASC, r.created_at DESC
");
$reviews = $stmt->fetchAll();
?>
Manage Reviews