Untitled

<!DOCTYPE html>
<html>
<head>
    <meta charset="windows-1250">
    <title>Zadatak labos</title>
    <style>
        table, td, th { border: 1px solid gray; }
    </style>
</head>
<body>
<?php

$server = "localhost";
$username = "root";
$password = "";
$dbname = "radionica";


$conn = mysqli_connect($server, $username, $password, $dbname);

if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

mysqli_query($conn, "SET CHARACTER SET cp1250");

$sql = "SELECT nazivMjesto, pbrMjesto FROM mjesto";
$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {

    while($row = mysqli_fetch_assoc($result)) {
        echo "<h2>". $row["nazivMjesto"] . "</h2>";

        $query = "SELECT imeKlijent, prezimeKlijent FROM klijent WHERE pbrKlijent =".$row['pbrMjesto'];
        $result2 = mysqli_query($conn, $query);

        if (mysqli_num_rows($result2) > 0) {
            echo "<table>
            <tr>
                <td>Ime klijenta</td>
                <td>Prezime klijenta</td>
            </tr>";

            while($row2 = mysqli_fetch_assoc($result2)) {
                echo "<tr><td>".$row2['imeKlijent']."</td><td>".$row2['prezimeKlijent']."</td></tr>";
            }
            echo "</table>";
        }
        else{
            echo "<div>Nema klijenata u ovom mjestu.</div>";
        }

    }
}
mysqli_close($conn);
?>
</body>
</html>