Untitled

<!DOCTYPE html>
<html >
	<head>

		<title>De Chef Pizzeria</title>
		<!-- Hier wordt het css bestand aan het html bestand gekoppeld -->
		<link rel="stylesheet" href="layoutchef.css" type="text/css">
	</head>
	<body>
		<div class="header">
			<div class="container">

				<div class="header-heading"><img src="logo.png" alt="logo" style="height:100px;"></div>
			</div>
		</div>
		<div class="nav-bar">
			<div class="container">
				<ul class="nav">
					<li><a href="homechef.html">Home</a></li>
					<li><a href="overonschef.html">Over ons</a></li>
					<li><a href="menuchef.html">Menu</a></li>
					<li><a href="inloggenchef.html">Inloggen</a></li>
					<li><a href="registrerenchef.html">Registreren</a></li>
					<li><a href="contactchef.html">Contact</a></li>
				</ul>
			</div>
		</div>
		<div class="content">
			<div class="container">
				<div class="main">
					<h1>Admin pagina</h1>

<?php

	$dbhost = "localhost";
	$dbuser = "root";
	$dbpass= "";
	$dbname = "database";

	$db = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);

	if (mysqli_connect_errno()){
		die("connection failed: " .
			mysqli_connect_error(). "(" .
				mysqli_connect_errno().")");
	}
	$query = "SELECT*";
	$query .="FROM KLANT";
	$result = mysqli_query($db, $query);
		if(!$result){
				die("database query failed.");
	}

    echo "

<table border='5' width='50%' cellpadding='4'
cellspacing='3' >
		<tr>

			<th colspan='9'><BR><H3>Klant gegevens</H3></th>
		</tr>
		<tr>
			<th>Klant ID</th>
			<th>Voornaam</th>
			<th>Achternaam</th>
			<th>Adres</th>
			<th>Postcode</th>
			<th>Email</th>
			<th>Telefoonnummer</th>
			<th>Wachtwoord</th>
			<th>Actie</th>
		</tr>

    ";

		while($KLANT = mysqli_fetch_assoc($result)){

			echo "

            <tr>
            <td>" . $KLANT['KLANT_ID'] . "</td>
            <td>" . $KLANT['VOORNAAM'] . "</td>
            <td>" . $KLANT['ACHTERNAAM'] . "</td>
            <td>" . $KLANT['ADRES'] . "</td>
            <td>" . $KLANT['POSTCODE'] . "</td>
            <td>" . $KLANT['EMAIL'] . "</td>
            <td>" . $KLANT['TELEFOONNUMMER'] . "</td>
            <td>" . $KLANT['WACHTWOORD'] . "</td>
			<td><a href=\"adminpagina.html?KLANT_ID=".$KLANT['KLANT_ID']."\">
			Verwijder</a></td>;
            </tr>


			";

			/*
			echo $KLANT['KLANT_ID'];
			echo $KLANT['VOORNAAM'];
			echo $KLANT['ACHTERNAAM'];
			echo $KLANT['ADRES'];
			echo $KLANT['POSTCODE'];
			echo $KLANT['EMAIL'];
			echo $KLANT['TELEFOONNUMMER'];
			echo $KLANT['WACHTWOORD'];
			echo ("<td><a href=\"adminpagina.html?['KLANT_ID]."\">
			Verwijder</a></td>");
			echo "<br/>"; }
			*/
            }
?>


				</div>
			</div>
		</div><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/>
		<div class="footer">
			<div class="container">
				&copy; Copyright 2017
			</div>
		</div>
	</body>
</html>