<?php echo date('d-m-Y H:i:s'); ?>
<!-- <meta http-equiv="refresh" content="0;URL=phpmyadmin/index.php" /> -->

<form>
<input type="button" value="PHPMYADMIN" onclick="window.location.href='phpmyadmin'" />
</form>

<?php

$servername = "localhost";
$username = "root";
$password = "0snata";
$dbname = "auzvono";

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

$sql = "SELECT vreme FROM prof";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    echo '<select name="listbox" size="20">';

    while($row = $result->fetch_assoc()) {
        echo '<option value="'.$row["vreme"].'" selected>'.$row["vreme"].'</option>';
    }
    echo '</select>';
} else {
    echo "Nema rezultata";
}
$conn->close();

?>

<!--
<p>List Box - Single Select<br>
<select name="listbox" size="3">
<option value="Option 1" selected>Option 1</option>
<option value="Option 2">Option 2</option>
<option value="Option 3">Option 3</option>
<option value="Option 4">Option 4</option>
<option value="Option 5">Option 5</option>
</select>
</p>
-->

<p>Sati<br>
<select name="select">
<option value="06" selected>06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="10">20</option>
</select>
</p>

<p>Minuti<br>
<select name="select">
<option value="00" selected>00</option>
<option value="05">05</option>
<option value="10">10</option>
<option value="15">15</option>
<option value="20">20</option>
<option value="25">25</option>
<option value="30">30</option>
<option value="35">35</option>
<option value="40">40</option>
<option value="45">45</option>
<option value="50">50</option>
<option value="55">55</option>
</select>
</p>

<input type="submit" class="button" name="unos" value="Unos" />
<input type="submit" class="button" name="brisanje" value="Brisanje" />