<?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="3">';

    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>
-->