Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host = "localhost";
- $db = "baza";
- $user = "root";
- $pass = "";
- $conn = mysqli_connect($host, $user, $pass, $db)
- or die("Unable to connect");
- ?>
- <html lang="en" dir="ltr">
- <head>
- <meta charset="utf-8">
- <title>Cetvrti</title>
- </head>
- <body>
- <form method="get">
- <select name="odeljenja">
- <option>Izaberite odelenje: </option>
- <?php
- $sql = "SELECT odeljenje_id, odeljenje_naziv FROM odeljenja";
- $result = mysqli_query($conn, $sql);
- if($result->num_rows > 0) {
- while($row = mysqli_fetch_row($result))
- echo "<option value=\"" . $row[0] . "\">" . $row[1] . "</option>";
- }
- ?>
- </select>
- <button id="btn" type="submit" name="button">OK</button>
- </form>
- <br>
- <ul>
- <?php
- if (!empty($_GET["odeljenja"])) {
- $odeljenje = $_GET["odeljenja"];
- $sql = "SELECT zaposlen_ime, zaposlen_prezime FROM zaposleni
- JOIN o_z USING (zaposlen_id) JOIN odeljenja USING (odeljenje_id)
- WHERE odeljenje_id=$odeljenje";
- $result = mysqli_query($conn, $sql);
- if($result->num_rows > 0) {
- while($row = mysqli_fetch_row($result))
- echo "<li>" . $row[0] . " " . $row[1] . "</li>";
- }
- }
- ?>
- </ul>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement