<?php echo date('d-m-Y H:i:s');
$servername = "localhost";
$username = "root";
$password = "0snata";
$dbname = "auzvono";
    $conn = new mysqli($servername, $username, $password, $dbname);
    if ($conn->connect_error) {
        die("Greska: " . $conn->connect_error);
    }
    $sql = "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'auzvono';";
	$result = $conn->query($sql);
    while($row = $result->fetch_array()) {
	$broj = $row[0]-1;}
$sql = "SELECT profil FROM profil";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
	while($row = $result->fetch_assoc()) {
    $trprof = $row["profil"];}}
    $conn->close();
echo '<form action="novprofil.php">
<input type="submit" class="button" name="novprofil" value="Nov profil" />
</form>
<form action="brisanjeprofila.php">
<input type="submit" class="button" name="brisanjeprofila" value="Brisanje profila" />
</form>
<form action="zamena.php" method="POST">
Profili:
<select name="profili">';
for ($x = 1; $x <= $broj; $x++) {
	if($x != $trprof){
    echo "<option value =\"".$x."\">Profil ".$x."</option>";
}}
echo '</select>
<input type="submit" class="button" name="zamena" value="Zamena" />
</form>
Profil ';
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Greska: " . $conn->connect_error);
}

echo $trprof;

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

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

if ($result->num_rows > 0) {
    echo '<form action="obrisi.php" method="POST">
    <select name="listbox" size="20">';
    while($row = $result->fetch_assoc()) {
        echo '<option value="'.$row["vreme"].'" selected>'.$row["vreme"].'</option>';
    }
    echo '</select>
    <br>
    <input type="submit" class="button" name="brisanje" value="Brisanje" />
    </form>';
} else {
    echo "<br><br>Prazno";
}
$conn->close();

echo '<form action="dodaj.php" method="POST">
Sati<br>
<select name="sati">
<option value="06">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>
<br>Minuti<br>
<select name="minuti">
<option value="00">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>
<br><input type="submit" class="button" name="unos" value="Unos" />
</form>';