Untitled

<<?php
$servername = "localhost";
$username = "s113484_keuze";
$password = "RkVFl8qk";
$dbname = "s113484_keuze";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// sql to delete a record
$sql = "Select * from leerlingen";
$result = $conn->query($sql);


?>
<html>
<head>
<style>
table {
  font-family: arial, sans-serif;
  border-collapse: collapse;
  width: 100%;
}

td, th {
  border: 1px solid #dddddd;
  text-align: left;
  padding: 8px;
}

tr:nth-child(even) {
  background-color: #dddddd;
}
</style>
</head>

<body>
<?php foreach($row = $result->fetch_assoc()): ?>

<table>
	<tr>
		<th>Voornaam</th>
		<th>Achternaam</th>
		<th>klas</th>
		<th>Profiel</th>
		<th>Commentaar</th>
		<th>Datum</th>
	</tr>
	<tr>
		<td><?php echo $row['voornaam']; ?></td>
		<td><?php echo $row['achternaam'];?></td>
		<td><?php echo $row['klas'];?></td>
		<td><?php echo $row['profiel'];?></td>
		<td><?php echo $row['tijd'];?></td>
	</tr>
	<?php endforeach; ?>
</table>
</body>
</html>
<?php

$conn->close();
?>