connect_error) {
die(“Connection failed: ” . $conn->connect_error);
}
// ===== HANDLE REVIEW SUBMISSION =====
if(isset($_POST[‘review_submit’])){
$name = $_POST[‘r_name’];
$rating = $_POST[‘rating’];
$comment = $_POST[‘comment’];
$sql = “INSERT INTO reviews (name, rating, comment, status) VALUES (‘$name’,’$rating’,’$comment’,’pending’)”;
$conn->query($sql);
}
?>
Customer Reviews
Google Reviews
Customer Feedback
query(“SELECT * FROM reviews WHERE status=’approved’ ORDER BY id DESC”);
while($row = $result->fetch_assoc()){
?>
Leave a Review
query(“UPDATE reviews SET status=’approved’ WHERE id=$id”);
}
$pending = $conn->query(“SELECT * FROM reviews WHERE status=’pending'”);
echo “
Pending Reviews
“;
while($row = $pending->fetch_assoc()){
echo “
“;
echo $row[‘name’].” – “.$row[‘comment’];
echo ”
Approve“;
echo “
“;
}
}
?>
