<table border="1">
<?php

$user="root";
$pass="usbw";

$dbh=new PDO(
        'mysql:host=127.0.0.1; port=3307; dbname=college7eindbaas',
        $user,
        $pass
);

$sql2 = 'SELECT * FROM `medewerker`';
$count2 = $dbh->exec($sql);

if($count2 < 1){

$sql="INSERT INTO medewerker (mnr, naam, telnr)
    VALUES      ('1', 'jansen', '0612345678'),
                ('2', 'de jong', '0623456789'),
                ('3', 'de vries', '0698765432'),
                ('4', 'vlak', '0687654321'),
                ('5', 'lam', '0612123434')";

 $daveisbaas = $dbh->prepare($sql);
 $daveisbaas ->execute ();

//print "er zijn ".$count." medewerkers toegevoegd aan de database.";
}
if(isset($_GET['mnr'])){
    $mnr = mysql_real_escape_string($_GET['mnr']);

    $sql_delete = "DELETE FROM `medewerker` WHERE `mnr` = '".$_GET['mnr']."'";
    $dbh->exec($sql_delete);
        print"Medewerker verwijderd!";
}


$sth = $dbh->prepare ("SELECT * FROM medewerker");
$sth->execute ();

$result = $sth->fetchAll(PDO::FETCH_ASSOC);

//print_r($result);

foreach($result as $row){
 ?>
    <tr>
        <td><a href="index.php?mnr=<?php print($row["mnr"]);?>">(<?php print($row["mnr"]);?></a></td>
        <td><?php print($row["naam"]);?></td>
        <td><?php print($row["telnr"]);?></td>
    </tr>
    <?php }

    ?>

</table>