Rechtsonder staat 'Pagina: 1 2'. Dit staat naast de laatste afbeelding, maar ik wil dit helemaal onderaan hebben (onder de laatste rij met afbeeldingen. Het lijkt mij dat ik gewoon een break moet toevoegen zoals ik dat in html ook doe. Maar het lukt mij op geen enkele manier.
Wil iemand mij hiermee helpen?
De PHP-code is:
<?php
//ini_set ('display_errors', 1);
//error_reporting (E_ALL);
session_start();
ob_start();
include('../functions/database.php');
$link = mysql_connect($hst, $usr, $pwd) or die(mysql_error().'<br />verbindingsfout<br />');
mysql_select_db($db) or die('Er is een fout opgetreden bij het verbinden met de database.');
?>
<?php
include('../functions/assortiment.php');
$showprod = 1;
$maxperpage = (isset($_GET['maxperpage']) ? $_GET['maxperpage'] : 20);
if (isset($_GET['cat']))
{
$cat = $_GET['cat'];
}
if (isset($_GET['subcat']))
{
$subcat = $_GET['subcat'];
}
?>
<!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" xml:lang="nl" lang="nl">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Assortiment | Pro Horeca - Groothandel in sfeer</title>
<link href="/pivotx/templates/css.css" rel="stylesheet" type="text/css" media="screen" />
<meta name="keywords" content="prohoreca, groothandel, servetten, tafelaankleding, porselein, glaswerk,
nederland, kaarsen, horeca inrichting, gelderland, palmer, villeroy en boch, duni, prolin, meubilair" />
<meta name="description" content="Pro Horeca: daar krijgen tafels kleur van! Wij zijn dé groothandel op het gebied van hoogwaardige tafelaankleding en totaalinrichting. Laat u bij ons inspireren." />
<link rel="stylesheet" type="text/css" href="../pivotx/extensions/fancybox/jquery.fancybox-1.3.4.css" media="screen" />
<link rel="shortcut icon" href="/pivotx/templates/images/favicon.ico" />
<script language="JavaScript" src="/pivotx/templates/validator/validatorv31.js" type="text/javascript"></script>
<script type="text/javascript" src="/pivotx/extensions/fancybox/jquery.mousewheel-3.0.4.js"></script>
<script type="text/javascript" src="/pivotx/includes/js/jquery-1.5.min.js"></script>
<script type="text/javascript" src="/pivotx/extensions/fancybox/jquery.fancybox-1.3.4.js"></script>
<script type="text/javascript" src="/pivotx/templates/fancytransitions/jqFancyTransitions.1.8.min.js"></script>
<script type="text/javascript">
<!--
jQuery(document).ready(function() {
jQuery("a.fancybox").fancybox({ padding: 10, margin: 20,'titlePosition': 'outside', 'transitionIn': 'fade', 'transitionOut': 'fade', 'centerOnScroll': true, 'overlayShow': true, 'overlayOpacity': 0.7, 'opacity': false, 'speedIn': 300, 'speedOut': 300, 'changeSpeed': 300, 'showCloseButton': true, 'cyclic': false, 'titleFormat': null});
jQuery("a.fancytube").fancybox({ padding: 0, autoScale: false, centerOnScroll: true, 'transitionIn': 'none', 'transitionOut': 'none', 'overlayShow': true, 'overlayOpacity': 0.7, 'hideOnContentClick': true, 'titlePosition': 'outside', 'showCloseButton': false });
jQuery("a.fancytext").fancybox({ padding: 5, autoScale: true, centerOnScroll: true, 'transitionIn': 'none', 'transitionOut': 'none', 'overlayShow': true, 'overlayOpacity': 0.7, 'titlePosition': 'outside', 'showCloseButton': true, 'cyclic': false });
jQuery("a.fancyframe").fancybox({ padding: 3, autoScale: false, centerOnScroll: true, 'transitionIn': 'none', 'transitionOut': 'none', 'overlayShow': true, 'overlayOpacity': 0.7, 'width': '75%', 'height': '75%', 'type': 'iframe', 'titlePosition': 'outside', 'showCloseButton': true });
jQuery("a.fancyflash").fancybox({ padding: 0, autoScale: false, 'transitionIn': 'none', 'transitionOut': 'none', 'showCloseButton': true });
});
// -->
</script>
</head>
<body>
<div id="wrapper">
<div id="header"></div>
<div id="navigation">
<ul>
<li><a href="/over" title="Over Pro Horeca">Over Pro Horeca</a></li>
<li><a href="/contact" title="Contact">Contact</a></li>
</ul></div>
<div id="navigation2">
<ul>
<li><a href="http://www.prohoreca.nl" title="Voorpagina">Voorpagina</a></li>
<li><a href="/assortiment" title="Assortiment">Assortiment</a></li>
<li><a href="/totaalinrichting" title="Totaalinrichting">Totaalinrichting</a></li>
<li><a href="/advies" title="Advies">Advies</a></li>
</ul>
</div>
<div id="header2">
<img src="pivotx/templates/images/header1.png" />
<img src="pivotx/templates/images/header2.png" />
<img src="pivotx/templates/images/header3.png" />
<img src="pivotx/templates/images/header4.png" />
</div>
<script type="text/javascript">
$('#header2').jqFancyTransitions({ width: 930, height: 300, effect: 'curtain' });
</script>
<div id="mainbreedfoto">
<h1>Assortiment</h1><br />
<div id="assortiment">
<?php
if (isset($cat)) {
if (isset($_GET['showprod']) && $cat > 0) {
$q = "SELECT COUNT(*) AS totaal FROM produkten WHERE subcat = ".$subcat." AND vis = 1";
$rs = mysql_query($q);
$aantalprod = (mysql_num_rows($rs) > 0 ? mysql_fetch_object($rs)->totaal : 0);
// Selectievelden
echo '<form action="?page=assortiment" method="get">';
echo '<fieldset>';
echo '<input type="hidden" name="page" value="assortiment" />';
echo '<input type="hidden" name="cat" value="'.$cat.'" />';
echo '<input type="hidden" name="subcat" value="'.$subcat.'" />';
echo '<input type="hidden" name="showprod" value="'.$showprod.'" />';
echo 'Weergave per pagina : toon ';
echo '<select name="maxperpage" onchange="this.form.submit();">';
for ($i = 20; $i <= 100; $i += 20)
{
echo '<option value="'.$i.'"';
echo ($i == $maxperpage ? ' selected="selected"' : '');
echo '>'.$i.'</option>'."\n";
}
echo '</select>';
echo ' produkten<br />';
echo 'Aantal gevonden producten: '.$aantalprod;
echo '</fieldset>';
echo '</form><br />';
// Pagina's
$numpages = $aantalprod / $maxperpage;
echo '<div>';
if ($numpages > 0)
{
echo 'Pagina: ';
}
for ($x = 0; $x < $numpages; $x++)
{
$y = $x + 1;
$z = $x * $maxperpage;
echo '<a href="?page=assortiment&showprod=1&cat='.$cat.'&subcat='.$subcat.'&offset='.$z.'" style="text-decoration:none;">'.$y.'</a> ';
}
echo '</div><br />';
// Icoon output
$offset = (isset($_GET['offset']) ? $_GET['offset'] : 0);
$q = "SELECT * FROM produkten WHERE subcat=".$subcat." AND vis=1 ORDER BY volgorde ASC LIMIT ".$maxperpage." OFFSET ".$offset;
$rs = mysql_query($q);
$float_clear = array();
$counter = 1;
for ($i = 5; $i <= 100; $i += 5)
{
$float_clear[] = $i;
}
while ($row = mysql_fetch_object($rs))
{
$pafbeelding = ($row->afbeelding != '' ? $row->afbeelding : $root.'/buttons/noimg100.jpg');
echo '<div class="prodList">';
echo showthumb($pafbeelding);
echo $row->naam.'';
echo '</div>';
if (in_array($counter, $float_clear))
{
echo '<div class="floatClear">';
echo '<!-- Valid Filler -->';
echo '</div>';
}
$counter++;
}
$restu = 'showprod=1&cat='.$cat.'&subcat='.$subcat;
if ($numpages > 0)
{
echo 'Pagina: ';
}
for ($x = 0; $x < $numpages; $x++)
{
$y = $x + 1;
$z = $x * $maxperpage;
echo '<a href="?page=assortiment&showprod=1&cat='.$cat.'&subcat='.$subcat.'&offset='.$z.'" style="text-decoration:none;">'.$y.'</a> ';
}
echo '</div>';
}
else if (isset($cat) && $cat > 0) {
$q = "SELECT categorie.*, catdesc.* FROM categorie LEFT JOIN catdesc ON catdesc.id=categorie.child WHERE categorie.parent=".$cat." AND categorie.tonen = 1 ORDER BY categorie.volgorde";
$rs = mysql_query($q);
while ($row = mysql_fetch_object($rs)) {
$button = ($row->button != '' ? $row->button : '/buttons/noimg75.jpg');
echo '<div class="categorieList">';
echo '<a href="?page=assortiment&showprod=1&cat='.$cat.'&subcat='.$row->child.'">';
echo '<img src="'.$root.'/'.$button.'" alt="Categorie Knop" /><br />';
echo $row->descr;
echo '</a>';
echo '</div>';
}
}
else {
echo '<div class="categorieList">';
echo 'Er is een fout opgetreden, de ingevoerde categorie bestaat niet (meer).';
echo '</div>';
}
}
else {
$q = "SELECT categorie.*, catdesc.* FROM categorie LEFT JOIN catdesc ON catdesc.id=categorie.child WHERE categorie.parent=0 AND categorie.tonen = 1 ORDER BY categorie.volgorde";
$rs = mysql_query($q);
while ($row = mysql_fetch_object($rs)) {
$button = ($row->button != '' ? $row->button : '/buttons/noimg75.jpg');
echo '<div class="categorieList">';
echo '<a href="?page=assortiment&cat='.$row->child.'">';
echo '<img src="'.$root.'/'.$button.'" alt="Categorie Knop" /><br />';
echo $row->descr;
echo '</a>';
echo '</div>';
}
}
?>
</div><div class="floatClear">
<!-- Valid Filler -->
</div>