Reiside andmed PHP kaudu

ID Nimi Sihtkoht Kuupäev Lennujaam Aviafirma Hind (€) Hotell Ekskursioon
1Egbert MichieliFontanges Airport2025-09-25Iokea AirportIberia2.99Baltic Horizon Hoteljah
2Garwood HulcoopIn Salah Airport2025-09-25Hutchinson County AirportKLM Royal Dutch Airlines79.99Nordic Star Hoteljah
3Darya MitkinRivers Airport2025-09-25Guanacaste AirportAir France1.99Nordic Star Hoteljah
4Diane DonnellAlbert J Ellis Airport2025-09-25Atizapan De Zaragoza AirportAmerican Airlines3.29Nordic Star Hotelei
5Estella GartenfeldYelizovo Airport2025-09-25São Filipe AirportSAS Scandinavian2.99Seaside Palace Resortjah
6Mufinella VillaKandi Airport2025-09-25Lanzarote AirportAvianca2.49Baltic Horizon Hoteljah
7Bernete GoldbournBarinas Airport2025-09-25Benin AirportAir New Zealand2.99Baltic Horizon Hoteljah
8Jenni RosleOshima Airport2025-09-25Kalpowar AirportSouthwest Airlines4.79Nordic Star Hoteljah
9Donetta EtchellsNaha Airport2025-09-25Woodward FieldSingapore Airlines2.49Nordic Star Hoteljah
10Clarissa BurghallKalpowar Airport2025-09-25Port Harcourt International AirportSAS Scandinavian3.99Tallinn Grand Innjah
11Kassie ScholesTarin Kowt Airport2025-09-25Termal AirportSouth African Airways1.99Baltic Horizon Hotelei
12Karon SillitoeKey West International Airport2025-09-25Ardmore AirportAir New Zealand99.99Baltic Horizon Hotelei
13Zaccaria RoutledgeBoone County Airport2025-09-25Ndolo AirportAir Canada4.99Tallinn Grand Innei
14Bret GheorgheGode Airport2025-09-25New Ishigaki AirportSouth African Airways59.99Nordic Star Hotelei
15Ashlin EckhGral. Bernardo O´Higgins Airport2025-09-25Juína AirportBritish Airways5.49Baltic Horizon Hotelei
16Elianora GremainCorcoran Airport2025-09-25Yorke Island AirportAlitalia35.99Nordic Star Hoteljah
17Willyt FranklinGarden Point Airport2025-09-25Namtu AirportUnited Airlines49.95Baltic Horizon Hoteljah
18Gerrilee JendrickeSan Andros Airport2025-09-25Bob Sikes AirportBritish Airways2.49Baltic Horizon Hotelei
19Fern JefferdRAF Marham2025-09-25Ulgii Mongolei AirportThai Airways3.49Tallinn Grand Innjah
20Isa ZaplePort Stanley Airport2025-09-25Alexander Bay AirportLufthansa79.99Tallinn Grand Innjah
21Sena StatePlymouth City Airport2025-09-25Malta International AirportLATAM Airlines4.99Baltic Horizon Hotelei
22Kirstin SellstromYap International Airport2025-09-25São Borja AirportAir New Zealand6.99Tallinn Grand Innei
23Kata PinneyHuesca/Pirineos Airport2025-09-25Owen Roberts International AirportThai Airways3.89Baltic Horizon Hotelei
24Garey DerellKeglsugl Airport2025-09-25Basongo AirportKorean Air2.99Nordic Star Hotelei
25Luis LethbyTaean Airport2025-09-25Srednekolymsk AirportDelta Air Lines3.59Seaside Palace Resortei
26Felike SteaneMinden-Tahoe Airport2025-09-25Sundsvall-Härnösand AirportKorean Air299.99Nordic Star Hotelei
27Noemi SermanBarra Airport2025-09-25Longdongbao AirportBritish Airways59.99Tallinn Grand Innei
28Yance SwansboroughSebba Airport2025-09-25Gebe AirportSAS Scandinavian5.99Nordic Star Hotelei
29Gerti FairpoRivière-du-Loup Airport2025-09-25Sevilla AirportLufthansa4.99Tallinn Grand Innei
30Jed MorcombeKaolack Airport2025-09-25Cotulla-La Salle County AirportAmerican Airlines3.29Nordic Star Hotelei
31dd2025-10-17dd2djah
32ww2025-10-09ww2sei

<!DOCTYPE html>
<html lang="et">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Reisid PHP kaudu</title>
    <link rel="stylesheet" href="style.css">
    <style>
        pre.code {
            background-color: #222;
            color: #0f0;
            padding: 1em;
            border-radius: 10px;
            overflow-x: auto;
            white-space: pre-wrap;
            display: none;
        }
        form {
            margin-bottom: 15px;
        }
    </style>
</head>
<body>
    <h1>Reiside andmed PHP kaudu</h1>

    <a href="index.html"><button>Tagasi avalehele</button></a>

    <form method="get">
        <label for="nimi">Otsi nime järgi:</label>
        <input type="text" name="nimi" id="nimi" value="<?php echo htmlspecialchars($_GET['nimi'] ?? ''); ?>">

        <label for="aviafirma">Otsi aviafirma järgi:</label>
        <input type="text" name="aviafirma" id="aviafirma" value="<?php echo htmlspecialchars($_GET['aviafirma'] ?? ''); ?>">

        <button type="submit">Otsi</button>
        <a href="reis.php"><button type="button">Näita kõiki</button></a>
    </form>

    <?php
    $jsonFile = 'reis.json';

    if (!file_exists($jsonFile)) {
        echo "<p class='error'>Viga: faili <strong>reis.json</strong> ei leitud!</p>";
        exit;
    }

    $jsonData = file_get_contents($jsonFile);
    $data = json_decode($jsonData, true);

    if ($data === null || !isset($data['reisid'])) {
        echo "<p class='error'>JSON fail on vigane või tühi.</p>";
        exit;
    }

    $reisid = $data['reisid'];

    // Фильтрация
    $nimiFilter = strtolower($_GET['nimi'] ?? '');
    $aviaFilter = strtolower($_GET['aviafirma'] ?? '');

    if ($nimiFilter || $aviaFilter) {
        $reisid = array_filter($reisid, function($r) use ($nimiFilter, $aviaFilter) {
            return str_contains(strtolower($r['nimi']), $nimiFilter)
                && str_contains(strtolower($r['aviafirma']), $aviaFilter);
        });
    }

    if (count($reisid) === 0) {
        echo "<p>Ühtegi reisi ei leitud.</p>";
    } else {
        echo "<table>";
        echo "<tr>
                <th>ID</th>
                <th>Nimi</th>
                <th>Sihtkoht</th>
                <th>Kuupäev</th>
                <th>Lennujaam</th>
                <th>Aviafirma</th>
                <th>Hind (€)</th>
                <th>Hotell</th>
                <th>Ekskursioon</th>
              </tr>";

        foreach ($reisid as $reis) {
            echo "<tr>";
            echo "<td>" . htmlspecialchars($reis['id']) . "</td>";
            echo "<td>" . htmlspecialchars($reis['nimi']) . "</td>";
            echo "<td>" . htmlspecialchars($reis['sihtkoht']) . "</td>";
            echo "<td>" . htmlspecialchars($reis['kuupaev']) . "</td>";
            echo "<td>" . htmlspecialchars($reis['lennujaam']) . "</td>";
            echo "<td>" . htmlspecialchars($reis['aviafirma']) . "</td>";
            echo "<td>" . htmlspecialchars($reis['hind']) . "</td>";
            echo "<td>" . htmlspecialchars($reis['hotell']) . "</td>";
            echo "<td>" . htmlspecialchars($reis['ekskursioon']) . "</td>";
            echo "</tr>";
        }

        echo "</table>";
    }
    ?>

    <br>
    <button onclick="toggleCode()">Näita PHP koodi</button>

    <pre class="code" id="phpCode">
<?php
echo htmlspecialchars(file_get_contents(__FILE__));
?>
    </pre>

    <script>
        function toggleCode() {
            const pre = document.getElementById('phpCode');
            pre.style.display = pre.style.display === 'block' ? 'none' : 'block';
        }
    </script>
</body>
</html>