serwerowe_mendela/Lekcja_02/index.php

<!DOCTYPE html>
<html lang="pl">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Lekcja 2</title>
    <style>
        * {
            margin: 0;
            padding: 0;
            box-sizing: border-box;
        }
        table {
            border-collapse: collapse;
        }
        th {
            border-right: 1px solid black;
            border-bottom: 1px solid black;
            padding: .5em;
        }
        th:last-child {
            border-right: none;
        }
        td {
            border-right: 1px solid black;
            border-bottom: 1px solid black;
            padding: .5em;
        }
        td:first-child {
            text-align: center;
        }
        td:last-child {
            border-right: none;
        }
        td > img {
            max-width: 48px;
        }
    </style>
</head>
<body>
    <pre>
    <?php
        include('config.php');

        $conn = mysqli_connect($host, $user, $pass, $dbnm);

        $kraje_q = mysqli_query($conn, "SELECT id, kraj, plik FROM flagi");
        $kraje = mysqli_fetch_all($kraje_q, MYSQLI_ASSOC);

        $stopy_q = mysqli_query($conn, "SELECT id, nazwa from stopy");
        $stopy = mysqli_fetch_all($stopy_q, MYSQLI_ASSOC);
    ?>
    </pre>
    <br>
    <table>
        <tr>
            <th></th>
            <th>nominał</th>
            <th>nr kat.</th>
            <th>stop</th>
            <th>rok</th>
            <th></th>
        </tr>
        <?php
            $wejscia = mysqli_query($conn, "SELECT `main`.`id` AS main_id, `flagi`.`plik`, `flagi`.`kraj`, `main`.`nominal`, `main`.`nr_kat`, `stopy`.`nazwa` AS `stop`, `main`.`rok` FROM `main` LEFT JOIN `flagi` ON `main`.`flaga` = `flagi`.`id` LEFT JOIN `stopy` ON `main`.`stop` = `stopy`.`id`");

            $update_id = -1;
            if(isset($_GET["update_id"])) { $update_id = intval($_GET["update_id"]); }

            while($row = mysqli_fetch_assoc($wejscia)) {
                if($update_id == $row["main_id"]) {
                    echo "<form action='update.php' method='post'>";
                    echo "<input type='hidden' name='id_u' value='" . $update_id . "'>";
                    echo "<tr>";
                    // select
                    echo "<td><select name='kraj_u'>";
                    foreach($kraje_q as $kraj) {
                        if($kraj["kraj"] == $row["kraj"]) {
                            echo "<option value='" . $kraj["id"] . "' selected>" . $kraj["kraj"] . "</option>";
                        } else {
                            echo "<option value='" . $kraj["id"] . "'>" . $kraj["kraj"] . "</option>";
                        }
                    }
                    echo "</select></td>";

                    // input nominal
                    echo '<td><input type="text" name="nominal_u" id="nominal_u" value="' . $row["nominal"] . '"></td>';

                    // nr kat
                    echo '<td><input type="text" name="nr_u" id="nr_u" value="' . $row["nr_kat"] . '"></td>';

                    // stop
                    echo "<td><select name='stop_u'>";
                    foreach($stopy_q as $stop) {
                        if($stop["nazwa"] == $row["stop"]) {
                            echo "<option value='" . $stop["id"] . "' selected>" . $stop["nazwa"] . "</option>";
                        } else {
                            echo "<option value='" . $stop["id"] . "'>" . $stop["nazwa"] . "</option>";
                        }
                    }
                    echo "</select></td>";

                    // rok
                    echo '<td><input type="number" name="rok_u" id="rok_u" value="' . $row["rok"] . '"></td>';

                    // submit
                    echo '<td><input type="image" src="gfx/faja.png" alt="Aktualizuj"></td>';

                    echo "</tr>";
                    echo "</form>";
                } else {
                    echo "<tr>";
                    echo "<td><img onclick='window.location = `./?update_id=" . $row["main_id"] . "`' src='gfx/" . $row["plik"] . "' alt='" . $row["kraj"] . "'></td>";
                    echo "<td>" . $row["nominal"] . "</td>";
                    echo "<td>" . $row["nr_kat"] . "</td>";
                    echo "<td>" . $row["stop"] . "</td>";
                    echo "<td>" . $row["rok"] . "</td>";
                    echo "<td><a href='delete.php?id=" . $row["main_id"] . "'><img src='gfx/u.gif' alt='Usuń'></a></td>";
                    echo "</tr>";
                }
            }
        ?>
        <tr>
            <th colspan="6">Dodawanie rekordu</th>
        </tr>
        <form action="insert.php" method="post">
            <tr>
                <td>
                    <select name="kraj_d" id="kraj_d">
                        <?php
                            foreach($kraje_q as $kraj) {
                                echo "<option value='" . $kraj["id"] . "'>" . $kraj["kraj"] . "</option>";
                            }
                        ?>
                    </select>
                </td>
                <td>
                    <input type="text" name="nominal_d" id="nominal_d">
                </td>
                <td>
                    <input type="text" name="nr_d" id="nr_d">
                </td>
                <td>
                    <select name="stop_d" id="stop_d">
                        <?php
                            foreach($stopy_q as $stop) {
                                echo "<option value='" . $stop["id"] . "'>" . $stop["nazwa"] . "</option>";
                            }
                        ?>
                    </select>
                </td>
                <td>
                    <input type="number" name="rok_d" id="rok_d">
                </td>
                <td>
                    <input type="image" src="gfx/faja.png" alt="Dodaj">
                </td>
            </tr>
        </form>
    </table>

    <?php
        mysqli_close($conn);
    ?>
</body>
</html>