$success_msg = ''; $error_msg = ''; // Handle review submission if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['submit_review'])) { $name = trim($_POST['customer_name'] ?? ''); $location = trim($_POST['location'] ?? ''); $rating = (int)($_POST['rating'] ?? 5); $review_text = trim($_POST['review_text'] ?? ''); if (empty($name) || empty($review_text) || $rating < 1 || $rating > 5) { $error_msg = 'Please fill out all required fields properly.'; } else { try { $stmt = $pdo->prepare("INSERT INTO reviews (customer_name, location, rating, review_text, status) VALUES (?, ?, ?, ?, 'pending')"); $stmt->execute([$name, $location, $rating, $review_text]); $success_msg = 'Thank you! Your review has been submitted and is pending approval.'; } catch (PDOException $e) { $error_msg = 'A system error occurred. Please try again later.'; } } } // Fetch approved reviews try { $stmt = $pdo->query("SELECT * FROM reviews WHERE status = 'approved' ORDER BY created_at DESC"); $reviews = $stmt->fetchAll(PDO::FETCH_ASSOC); } catch (PDOException $e) { $reviews = []; } ?>