Untitled


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">

<head>
  <title>Daniël & Tom</title>
  <meta name="description" content="free website template" />
  <meta name="keywords" content="enter your keywords here" />
  <meta http-equiv="content-type" content="text/html; charset=utf-8" />
  <meta http-equiv="X-UA-Compatible" content="IE=9" />
  <link rel="stylesheet" type="text/css" href="css/style.css" />
  <link href="css/portfolio.css" rel="stylesheet" type="text/css" />
  <link href="css/dark.css" rel="stylesheet" type="text/css" />
</head>

<body>
  <div id="main">
    <div id="header">
      <div id="welcome">
	    <h1><span>KOOK</span> SHOP</h1>
	  </div><!--end welcome-->
      <div id="menubar">
        <ul id="menu">
          <li><a href="index.php">Home</a></li>
          <li><a href="about.php">About</a></li>
          <li><a href="testimonials.php">Testimonials</a></li>
          <li class="current"><a href="producten.php">Producten</a></li>
          <li class="last"><a href="register.php">Register/login</a></li>
        </ul>
      </div><!--end menubar-->
    </div><!--end header-->

	<div id="site_content">

      <div id="text_content">
	  <h2>Recente producten</h2>
	  <!--  ditkom uitde datbase -->
<?php
 $servername = "localhost";
 $username = "root";
 $password = "usbw";
 $dbname = "kookshop";

 $conn = mysqli_connect($servername, $username, $password, $dbname);
 if (!$conn) {
	 die("Connection failed: " . mysqli_connect_error());
 }

$sql = "SELECT productnaam, productcategorie, productprijs FROM producten order by productcode desc limit 10";
$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {
	while($row = mysqli_fetch_assoc($result)) {
		echo "productnaam: " . $row["productnaam"]. " - Productcategorie: " . $row["productcategorie"]. " €" . $row["productprijs"]. "<br>";

	}
} else {
	echo "0 results";
}
mysqli_close($conn);
?>


	  </div><!--close text_content-->

      <div class="static_image">
	    <img width="500" height="450" src="CKVP2/product.jpg" alt="product" />
	  </div>

	</div><!--end site_content-->
  </div><!--end main-->

  <div id="footer">
    <div id="footer_container">
	  <div class="footer_container_box">
		<h4>Info</h4>
	    <p> Who are we?.</p>
		  <a href="about.php">Read more</a>
	  </div><!--close footer_container_box-->
      <div class="footer_container_box">
       <h4>Latest Testimonials</h4>
	    <p> Lees en deel verhalen over jezelf en je werkstukken.</p>
		  <a href="testimonials.php">Read more</a>
	  </div><!--close footer_container_box-->
      <div class="footer_container_boxl">
		<h4>Latest Products</h4>
	    <p> Zie hier de meest recente producten.</p>
		  <a href="producten.php">Read more</a>
	  </div><!--close footer_container_box1-->
	  <br style="clear:both"/>
	  <br />
    Website by Daniël & Tom
    </div><!--close footer_container-->
  </div><!--close footer-->

</body>
</html>