prepare("SELECT slug FROM libraries WHERE id = ?"); $stmt_slug->execute([$library_id]); $result = $stmt_slug->fetch(PDO::FETCH_ASSOC); if ($result && !empty($result['slug'])) { $new_url = '/library_details/' . $result['slug']; header("HTTP/1.1 301 Moved Permanently"); header("Location: " . $new_url); exit(); } } } elseif (isset($_GET['slug']) && !empty($_GET['slug'])) { $slug = filter_input(INPUT_GET, 'slug', FILTER_SANITIZE_FULL_SPECIAL_CHARS); } else { header('Location: /index.php'); exit(); } // --- UNIFIED DATA FETCHING --- if ($slug) { $stmt_library = $conn->prepare("SELECT * FROM libraries WHERE slug = ? AND status = 'approved'"); $stmt_library->execute([$slug]); $library = $stmt_library->fetch(PDO::FETCH_ASSOC); } elseif ($library_id) { // This part is mainly for old ID-based URLs before redirection $stmt_library = $conn->prepare("SELECT * FROM libraries WHERE id = ? AND status = 'approved'"); $stmt_library->execute([$library_id]); $library = $stmt_library->fetch(PDO::FETCH_ASSOC); } if (!$library) { http_response_code(404); die("

404 Not Found

The library you are looking for does not exist.

Go Home"); } $library_id = $library['id']; // Ensure library_id is set correctly from fetched data $slug = $library['slug']; // --- (The rest of your PHP logic for eligibility, reviews, etc. remains the same) --- $can_submit_review = false; $has_already_reviewed = false; $is_student_logged_in = isset($_SESSION['student_id']); if ($is_student_logged_in) { $student_id = $_SESSION['student_id']; $stmt_check_booking = $conn->prepare("SELECT 1 FROM bookings WHERE student_id = ? AND library_id = ? UNION SELECT 1 FROM previous_bookings WHERE student_id = ? AND library_id = ? LIMIT 1"); $stmt_check_booking->execute([$student_id, $library_id, $student_id, $library_id]); if ($stmt_check_booking->fetch()) { $can_submit_review = true; } $stmt_check_reviewed = $conn->prepare("SELECT 1 FROM reviews WHERE student_id = ? AND library_id = ? LIMIT 1"); $stmt_check_reviewed->execute([$student_id, $library_id]); if ($stmt_check_reviewed->fetch()) { $has_already_reviewed = true; } } // Check if user is fully eligible to write a review $is_eligible_for_review = $is_student_logged_in && $can_submit_review && !$has_already_reviewed; // ################################################################## // ### UPDATED REVIEW SUBMISSION LOGIC ### // ################################################################## if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['submit_review'])) { // 1. Check eligibility again on the server side (IMPORTANT!) if (!$is_eligible_for_review) { $_SESSION['error_message'] = "You are not eligible to submit a review for this library."; header('Location: ' . $_SERVER['REQUEST_URI']); exit(); } // 2. Get data from the form $rating = filter_input(INPUT_POST, 'rating', FILTER_VALIDATE_INT); $review_text = trim(filter_input(INPUT_POST, 'review_text', FILTER_SANITIZE_FULL_SPECIAL_CHARS)); $student_id = $_SESSION['student_id']; // 3. Validate rating if ($rating === false || $rating < 1 || $rating > 5) { $_SESSION['error_message'] = "Please select a valid star rating."; header('Location: ' . $_SERVER['REQUEST_URI']); exit(); } // Get student's name from session or database $student_name = $_SESSION['student_name'] ?? 'Anonymous Student'; // 4. Insert the review into the database using a transaction $conn->beginTransaction(); try { $stmt_insert_review = $conn->prepare( "INSERT INTO reviews (library_id, student_id, user_name, rating, review_text, created_at) VALUES (?, ?, ?, ?, ?, NOW())" ); $stmt_insert_review->execute([$library_id, $student_id, $student_name, $rating, $review_text]); // 5. Update the library's average rating and count $stmt_update_lib = $conn->prepare( "UPDATE libraries SET rating_count = (SELECT COUNT(*) FROM reviews WHERE library_id = ?), rating_average = (SELECT AVG(rating) FROM reviews WHERE library_id = ?) WHERE id = ?" ); $stmt_update_lib->execute([$library_id, $library_id, $library_id]); $conn->commit(); // 6. Set success message and redirect $_SESSION['success_message'] = "Thank you! Your review has been submitted successfully."; header('Location: ' . $_SERVER['REQUEST_URI']); exit(); } catch (Exception $e) { $conn->rollBack(); $_SESSION['error_message'] = "An error occurred while submitting your review. Please try again."; header('Location: ' . $_SERVER['REQUEST_URI']); exit(); } } // ################################################################## // --- DATA FETCHING FOR PAGE --- $stmt_shifts = $conn->prepare("SELECT shift_name, start_time, end_time, price FROM shifts WHERE library_id = ? AND status = 'active' ORDER BY start_time ASC"); $stmt_shifts->execute([$library_id]); $shifts = $stmt_shifts->fetchAll(PDO::FETCH_ASSOC); $stmt_reviews = $conn->prepare("SELECT r.*, s.photo, s.gender FROM reviews r LEFT JOIN students s ON r.student_id = s.id WHERE r.library_id = ? ORDER BY r.created_at DESC"); $stmt_reviews->execute([$library_id]); $reviews = $stmt_reviews->fetchAll(PDO::FETCH_ASSOC); $related_libraries = []; if (!empty($library['city'])) { $stmt_related = $conn->prepare("SELECT * FROM libraries WHERE city = ? AND id != ? AND status = 'approved' LIMIT 3"); $stmt_related->execute([$library['city'], $library_id]); $related_libraries = $stmt_related->fetchAll(PDO::FETCH_ASSOC); } // --- HELPER DATA & FUNCTIONS --- $starting_price = $library['fee_monthly']; if (!empty($shifts)) { $shift_prices = array_column($shifts, 'price'); if (!empty($shift_prices)) { $starting_price = min($shift_prices); } } $amenities_map = [ 'has_wifi' => ['icon' => 'fas fa-wifi', 'title' => 'Free Wi-Fi'], 'has_ac' => ['icon' => 'fas fa-snowflake', 'title' => 'Fully AC'], 'has_power_outlets' => ['icon' => 'fas fa-plug', 'title' => 'Charging Plug'], 'has_parking' => ['icon' => 'fas fa-car', 'title' => 'Parking Available'], 'has_restrooms' => ['icon' => 'fas fa-restroom', 'title' => 'Clean Toilets'], 'has_water' => ['icon' => 'fas fa-tint', 'title' => 'RO Purified Water'], 'has_lockers' => ['icon' => 'fas fa-lock', 'title' => 'Personal Lockers'], 'has_discussion_room' => ['icon' => 'fas fa-users', 'title' => 'Discussion Room'] ]; $shift_icons = ['Morning' => 'fas fa-sun', 'Good Noon' => 'fas fa-cloud-sun', 'Evening' => 'fas fa-cloud-sun', 'Day' => 'fas fa-sun', 'Night' => 'fas fa-moon']; $gallery_photos = []; if (!empty($library['main_image'])) { $gallery_photos[] = 'uploads/' . htmlspecialchars($library['main_image']); } if (!empty($library['gallery_photos'])) { $decoded_gallery = json_decode($library['gallery_photos'], true); if (is_array($decoded_gallery)) { foreach ($decoded_gallery as $photo) { $gallery_photos[] = 'uploads/' . htmlspecialchars($photo); } } } if (empty($gallery_photos)) { $gallery_photos[] = 'https://placehold.co/1200x400/FF6B35/FFFFFF?text=Padzo'; } // ################################################################## // ### SEO VARIABLES GENERATION ### // ################################################################## $seo_title = htmlspecialchars($library['name']) . ' in ' . htmlspecialchars($library['city']) . ' | Padzo'; $seo_description = 'Explore ' . htmlspecialchars($library['name']) . ' in ' . htmlspecialchars($library['city']) . ', located at ' . htmlspecialchars($library['address']) . '. Check details and book your seat on Padzo.'; $seo_keywords = htmlspecialchars($library['name']) . ', ' . htmlspecialchars($library['name']) . ' in ' . htmlspecialchars($library['city']) . ', library in ' . htmlspecialchars($library['city']) . ', study space in ' . htmlspecialchars($library['city']) . ', reading room ' . htmlspecialchars($library['city']) . ', padzo'; $canonical_url = 'https://padzo.in/library_details/' . $slug; $og_image = 'https://padzo.in/https://placehold.co/1200x630/FF6B35/FFFFFF?text=Padzo'; if (!empty($library['main_image'])) { $og_image = 'https://padzo.in/uploads/' . htmlspecialchars($library['main_image']); } // ################################################################## function render_library_card($lib) { $image_url = 'https://placehold.co/500x280/FF6B35/FFFFFF?text=Padzo'; if (!empty($lib['main_image'])) { $image_url = 'uploads/' . htmlspecialchars($lib['main_image']); } $opening_hours = ($lib['opening_time'] === null || $lib['closing_time'] === null) ? '24 Hours' : date('g A', strtotime($lib['opening_time'])) . ' - ' . date('g A', strtotime($lib['closing_time'])); $link_url = !empty($lib['slug']) ? '/library_details/' . htmlspecialchars($lib['slug']) : '/library_details?id=' . $lib['id']; ?>

Popular