Untitled

<?php
ini_set( 'display_errors', 'On' );
error_reporting( E_ALL );
?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <title>Dodawanie uzytownikow do intranetu</title>
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.css">
    <style type="text/css">
        .wrapper{
            width: 500px;
            margin: 0 auto;
        }
    </style>
</head>
<body>
    <div class="wrapper">
        <div class="container-fluid">
            <div class="row">
                <div class="col-md-12">
                    <div class="page-header">
                        <h2>Dodawanie uzytkownika do intranetu</h2>
                    </div>
                    <p>Please fill this form and submit to add employee record to the database.</p>
                    <form action="insert.php" method="post">

                        <div class="form-group">
                                <label>ID</label>
                            <input type="text" name="id" class="form-control">
                        </div>

                        <div class="form-group">
                            <label>id_opiekun</label>
                            <input type="text" name="id_opiekun" class="form-control">
                        </div>

                        <div class="form-group">
                            <label>Imie</label>
                            <input type="text" name="imie" class="form-control">
                        </div>
                        <div class="form-group">
                            <label>nazwisko</label>
                            <input type="text" name="nazwisko" class="form-control">
                        </div>
                        <div class="form-group">
                            <label>Adres Email</label>
                            <input type="email" name="email" class="form-control">
                        </div>
                        <div class="form-group">
                            <label>Numer Wewnetrzny</label>
                            <input type="number" name="nr_wew" class="form-control">
                        </div>
                        <div class="form-group">
                            <label>Nr GG</label>
                            <input type="number" name="nr_gg" class="form-control">
                        </div>
                        <div class="form-group">
                            <label>NR Kom</label>
                            <input type="number" name="nr_kom" class="form-control">
                        </div>
                        <div class="form-group">
                            <label>Stanowisko:</label>
                            <select class="form-control" id="stanowiska" name="stanowiska" class="form-control">
                                <?php
                                    include 'db.php';

                                    // Create connection
                                    $conn = new mysqli($servername, $username, $password, $dbname);
                                    // Check connection
                                    if ($conn->connect_error) {
                                        die("Connection failed: " . $conn->connect_error);
                                    }

                                    $sql = "SELECT * from stanowiska";
                                    $result = $conn->query($sql);
                                    $wypad_z_bazy = $row["nazwa"];

                                    if ($result->num_rows > 0) {
                                        // output data of each row
                                        while($row = $result->fetch_assoc()) {
                                            echo '<option>'.$row["nazwa"].'</option>';
                                        }
                                    } else {
                                        echo "0 results";
                                    }
                                    $conn->close();
                                    ?>
                                    </select>

                        </div>
                        <div class="form-group">
                            <label>Oddzial</label>
                            <select id="oddzial" name="oddzial" class="form-control">
                                <option value="1">Targowek (02)</option>
                                <option value="2">Wola (WW)</option>
                                <option value="3">Krakoww (03)</option>
                                <option value="4">Koszalin (04)</option>
                                <option value="5">Katowice (05)</option>
                                <option value="4">Stara Wies (06)</option>

                        </div>


                        <!--<div class="form-group">
                           <label>Generuj Stopke</label>
                           <form action='' method='post'>

                            <select id="stanowiska" name="myselectbox" class="form-control">
                                <option name="myoption1" value="myoption1">myoption1</option>
                                <option name="myoption2" value="myoption2">myoption2</option>
                                <option name="myoption3" value="myoption3">myoption3</option>
                                <option name="myoption4" value="myoption4">myoption4</option>
                            </select>
                            <input type='submit' value='submit'/>
                            </form>
                       </div>
                        <div class="form-group">
                           <label>Wyswietlaj</label>
                            <input type="number" name="wyswietlaj" class="form-control">
                       </div>
                        <div class="form-group">
                           <label>stopka</label>
                            <input type="text" name="stopka_html" class="form-control">
                       </div>
                        <div class="form-group">
                           <label>nie Personalna</label>
                            <input type="number" name="nie_personalna" class="form-control">
                       </div>-->

                        <input type="submit" class="btn btn-primary" name="submit" value="Dodaj">
                    </form>
                </div>
            </div>
        </div>
    </div>
</body>
</html>