prepare( "SELECT b.*, s.show_time, m.title FROM bookings b JOIN shows s ON s.id = b.show_id JOIN movies m ON m.id = s.movie_id WHERE b.booking_code = ?" ); $stmt->execute([$code]); $booking = $stmt->fetch(); if (!$booking) { $message = 'No booking found for that code.'; } elseif ($booking['checked_in']) { $message = 'Guest already checked in.'; } else { $update = $pdo->prepare("UPDATE bookings SET checked_in = 1, checked_in_at = NOW() WHERE id = ?"); $update->execute([$booking['id']]); $message = 'Check-in successful for ' . $booking['customer_name'] . '.'; $booking['checked_in'] = 1; } } } ?> <?= h($projectName) ?> — Staff check-in

Staff check-in

Latest scan result

Scan a ticket to see details here.

Guest

Movie

Seats