Untitled

<html>
<head>
    <title>Opdracht 1</title>
</head>
<body>
    <?php
        $servername = "localhost";
        $username = "root";
        $password = "usbw";
        $dbname = "Personeel";

        $conn = new mysqli($servername, $username, $password, $dbname);

        if ($conn->connect_error) {
            die("Connection failed: " . $conn->connect_error);
        }

        $sql = "SELECT persid, naam FROM medewerker";
        $result = $conn->query($sql);

        if ($result->num_rows > 0) {
            while($row = $result->fetch_assoc()) {
                echo "Personeel Id: " . $row["persid"]. " - Personeel naam: " . $row["naam"]. " " ."<br>";
            }
        } else {
            echo "0 results";
        }
        $conn->close();
    ?>
</body>