Het volgende:
<?php require_once('webwinkel_connect.php');/*moet je vervangen voor je database connection*/ ?>
<?php
if(empty($_GET['Artikel']) && empty($_GET['Merk'])){
header("Location: index.php");
}/*dit kan je weglaten, tenzij je delen opsplitst in artikelen en merken*/
$currentPage = $_SERVER["PHP_SELF"];
$maxRows_get_products = 10;/*hier kan je invullen hoeveel producten er moeten worden weergegeven*/
$pageNum_get_products = 0;
if (isset($_GET['pageNum_get_products'])) {
$pageNum_get_products = $_GET['pageNum_get_products'];
}
$startRow_get_products = $pageNum_get_products * $maxRows_get_products;
mysql_select_db($database_webwinkel_connect, $webwinkel_connect);
$query_get_products = "SELECT Product.Name, Product.Description, Product.`path`, Product.ID FROM Product WHERE artikel='".$_GET['Artikel']."' AND merk='".$_GET['Merk']."'";
$query_limit_get_products = sprintf("%s LIMIT %d, %d", $query_get_products, $startRow_get_products, $maxRows_get_products);
$get_products = mysql_query($query_limit_get_products, $webwinkel_connect) or die(mysql_error());
$row_get_products = mysql_fetch_assoc($get_products);
if (isset($_GET['totalRows_get_products'])) {
$totalRows_get_products = $_GET['totalRows_get_products'];
} else {
$all_get_products = mysql_query($query_get_products);
$totalRows_get_products = mysql_num_rows($all_get_products);
}
$totalPages_get_products = ceil($totalRows_get_products/$maxRows_get_products)-1;
$queryString_get_products = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_get_products") == false &&
stristr($param, "totalRows_get_products") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_get_products = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_get_products = sprintf("&totalRows_get_products=%d%s", $totalRows_get_products, $queryString_get_products);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://
www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">;
<html xmlns="http://
www.w3.org/1999/xhtml">;
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<?php if ($totalRows_get_products > 0) { // Show if recordset not empty ?>
<table width="70%">
<?php do { ?>
<tr>
<td width="27%">
<img src="<?php echo $row_get_products['path']; ?>" width="100" height="100" align="left" border="0"/></td>
<td width="73%" align="left" valign="top"><strong><?php echo $row_get_products['Name']; ?></strong>
<br /><br />
<?php echo $row_get_products['Description']; ?>
<br /><br />vanaf € <?php
$id= $row_get_products['ID'];
$query_get_price = "SELECT Maat.Prijs FROM Maat WHERE Maat.Id='$id'";
$get_price = mysql_query($query_get_price, $webwinkel_connect) or die(mysql_error());
$row_get_price = mysql_fetch_assoc($get_price);
echo $row_get_price['Prijs'];
?>
<hr />
</td>
</tr>
<?php } while ($row_get_products = mysql_fetch_assoc($get_products)); ?>
</table>
<?php } // Show if recordset not empty ?>
<?php if ($totalRows_get_products == 0) { // Show if recordset empty ?>
<table>
<tr><td>Geen producten gevonden</td></tr>
</table>
<?php } // Show if recordset empty ?>
<table border="0" width="50%" align="center">
<tr>
<td width="23%" align="center"><?php if ($pageNum_get_products > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_get_products=%d%s", $currentPage, 0, $queryString_get_products); ?>">First</a>
<?php } // Show if not first page ?>
<?php if ($pageNum_get_products == 0) { // Show if first page ?>
First
<?php } // Show if first page ?>
</td>
<td width="31%" align="center"><?php if ($pageNum_get_products > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_get_products=%d%s", $currentPage, max(0, $pageNum_get_products - 1), $queryString_get_products); ?>">Previous</a>
<?php } // Show if not first page ?>
<?php if ($pageNum_get_products == 0) { // Show if first page ?>
Previous
<?php } // Show if first page ?>
</td>
<td width="23%" align="center"><?php if ($pageNum_get_products < $totalPages_get_products) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_get_products=%d%s", $currentPage, min($totalPages_get_products, $pageNum_get_products + 1), $queryString_get_products); ?>">Next</a>
<?php } // Show if not last page ?>
<?php if ($pageNum_get_products >= $totalPages_get_products) { // Show if last page ?>
Next
<?php } // Show if last page ?>
</td>
<td width="23%" align="center"><?php if ($pageNum_get_products < $totalPages_get_products) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_get_products=%d%s", $currentPage, $totalPages_get_products, $queryString_get_products); ?>">Last</a>
<?php } // Show if not last page ?>
<?php if ($pageNum_get_products >= $totalPages_get_products) { // Show if last page ?>
Last
<?php } // Show if last page ?></td>
</tr>
</table>
</body>
</html>
<?php
mysql_free_result($get_products);
?>
Je moet de database gegevens vervangen door die van jou, ook de query moet je aanpassen, en de layout.
