search.php

<?php
include 'includes/db.php';
include 'includes/header.php';

$flights = [];

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $origin = $_POST['origin'];
    $destination = $_POST['destination'];

    $sql = "SELECT * FROM flights WHERE origin LIKE '%$origin%' AND destination LIKE '%$destination%' ";
    $result = $conn->query($sql);

    while ($row = $result->fetch_assoc()) {
        $flights[] = $row;
    }
}
?>

<div class="container mt-5">
<link rel="stylesheet" type="text/css" href="Assets/C.css">
    <h2>Cari Tiket</h2>
    <form method="POST">
        <div class="form-row">
            <div class="form-group col-md-4">
                <label>Asal</label>
                <input type="text" name="origin" class="form-control">
            </div>
            <div class="form-group col-md-4">
                <label>Tujuan</label>
                <input type="text" name="destination" class="form-control">
            </div>
        </div>
        <button type="submit" class="btn btn-primary">Cari</button>
    </form>

    <?php if (!empty($flights)): ?>
    <table class="table table-bordered mt-4">
        <thead>
            <tr>
                <th>Asal</th>
                <th>Tujuan</th>
                <th>Tanggal Keberangkatan</th>
                <th>Harga</th>
                <th>Kursi Tersedia</th>
                <th>Aksi</th>
            </tr>
        </thead>
        <tbody>
            <?php foreach ($flights as $flight): ?>
            <tr>
                <td><?= $flight['origin']; ?></td>
                <td><?= $flight['destination']; ?></td>
                <td><?= $flight['departure_date']; ?></td>
                <td>Rp <?= number_format($flight['price'], 2, ',', '.'); ?></td>
                <td><?= $flight['seats']; ?></td>
                <td>
                    <?php if ($flight['seats'] > 0): ?>
                        <a href="booking.php?flight_id=<?= $flight['id']; ?>" class="btn btn-primary btn-sm">Pesan</a>
                    <?php else: ?>
                        <span class="text-danger">Penuh</span>
                    <?php endif; ?>
                </td>
            </tr>
            <?php endforeach; ?>
        </tbody>
    </table>
    <?php endif; ?>
</div>
<?php include 'includes/\footer.php'; ?>