prepare("INSERT INTO reviews (patient_name, review_text, rating) VALUES (?, ?, ?)"); $stmt->bind_param("ssi", $name, $text, $rating); $stmt->execute(); header("Location: reviews.php"); } // Handle Delete if (isset($_GET['delete'])) { $id = $_GET['delete']; $conn->query("DELETE FROM reviews WHERE id=$id"); header("Location: reviews.php"); } ?> Manage Reviews

Add Patient Review

query("SELECT * FROM reviews ORDER BY id DESC"); while($row = $result->fetch_assoc()) { echo '
'; echo '

' . $row['patient_name'] . '

'; echo '

'; for($i=0; $i<$row['rating']; $i++) { echo '★'; } echo '

'; echo '

"' . $row['review_text'] . '"

'; echo 'Delete'; echo '
'; } ?>