杭州汽车购票app (杭州汽车购票官网)

connect_error) {die("Connection failed: " . $conn->connect_error);}// Query the database for the number of available tickets$sql = "SELECT num_available FROM tickets WHERE departure='$departure' AND destination='$destination' AND date='$date' AND time='$time'";$result = $conn->query($sql);// Check if there are enough tickets availableif ($result->num_rows > 0) {$row = $result->fetch_assoc();if ($row['num_available'] >= $num_tickets) {// Update the database to reduce the number of available tickets$sql = "UPDATE tickets SET num_available=num_available-$num_tickets WHERE departure='$departure' AND destination='$destination' AND date='$date' AND time='$time'";$conn->query($sql);// Generate a confirmation code$confirmation_code = rand(100000, 999999);