File: D:/HostingSpaces/SBogers25/superbedrukt.nl/wwwroot/productDetail.php
<?php
$q_cat = sprintf("SELECT kms_categories.categorie_name, kms_categories.url FROM kms_categories WHERE kms_categories.url='%s'", $pagina);
$r_cat = mysql_query($q_cat);
$rec_cat = mysql_fetch_array($r_cat);
$q_subcat = sprintf("SELECT kms_subcategories.subcategorie_id, kms_subcategories.subcategorie_name, kms_subcategories.url FROM kms_subcategories WHERE kms_subcategories.url='%s'", $subpagina);
$r_subcat = mysql_query($q_subcat);
$rec_subcat = mysql_fetch_array($r_subcat);
$q_article = sprintf("SELECT kms_articles.article_id, kms_articles.article_name, kms_articles.article_number, kms_articles.brand_id, kms_articles.gender_id, kms_articles.description, kms_articles.size_from, kms_articles.size_to, kms_articles.image_dir, kms_articles.url, kms_articles.sort_order, kms_brands.brand_name, kms_genders.gender_name FROM kms_articles INNER JOIN kms_brands ON kms_articles.brand_id = kms_brands.brand_id INNER JOIN kms_genders ON kms_articles.gender_id = kms_genders.gender_id WHERE kms_articles.url='%s'", $sub_subpagina);
$r_article = mysql_query($q_article);
$rec_article = mysql_fetch_array($r_article);
$q_kleuren = sprintf("SELECT kms_colors.color_name, kms_colors.icon_dir FROM kms_colors WHERE kms_colors.article_id='%s'", $rec_article['article_id']);
$r_kleuren = mysql_query($q_kleuren);
?>
<div id="headerBreadcrump">
<div class="dotLineTop"></div>
<div class="textLeft"><a href="/">Home</a><span class="slash">/</span><a href="/<?php echo($rec_cat['url']."/".$rec_subcat['url']); ?>"><?php echo(html_entity_decode($rec_subcat['subcategorie_name'])); ?></a><span class="slash">/</span><a class="active" href="/<?php echo($rec_cat['url']."/".$rec_subcat['url']."/".$rec_article['url']); ?>"><?php echo(html_entity_decode($rec_article['article_name'])); ?></a></div>
<div class="textRight"><a href="/<?php if($_SESSION['subpagina_nummer'] > 1){ echo($rec_cat['url']."/".$rec_subcat['url']."/".$_SESSION['subpagina_nummer']); }else{ echo($rec_cat['url']."/".$rec_subcat['url']); } ?>">Terug naar het overzicht</a></div>
<div class="clear_both"></div>
<div class="dotLineBottom"></div>
</div>
<div id="leftSide">
<div id="belMeTerug" class="width281">
<?php include("belMeTerug.php"); ?>
</div>
<div id="searchBlock" class="width281">
<?php include("searchBlock.php"); ?>
</div>
</div>
<div id="rightSide">
<div id="mainContent">
<div id="mainLeft">
<div class="productDetail width475">
<div class="topBackgr"></div>
<div class="contentBlock">
<div class="divContent">
<h1><?php echo(html_entity_decode($rec_article['article_name'])); ?></h1>
<div class="image">
<img alt="<?php echo(html_entity_decode($rec_article['article_name'])); ?>" src="/article_images/<?php echo($rec_article['image_dir']); ?>/image.jpg" width="295" />
<div class="artikelnr"><?php echo(html_entity_decode($rec_article['article_number'])); ?></div>
</div>
<div class="productInfo">
<h2 class="klein">Merk</h2>
<p><?php echo(html_entity_decode($rec_article['brand_name'])); ?></p>
<h2 class="klein">Geslacht</h2>
<p><?php echo(html_entity_decode($rec_article['gender_name'])); ?></p>
<h2 class="klein">Categorie</h2>
<p><?php echo(html_entity_decode($rec_subcat['subcategorie_name'])); ?></p>
<h2 class="klein">Maten</h2>
<p><?php echo($rec_article['size_from']." - ".$rec_article['size_to']); ?></p>
</div>
<div class="omschrijving">
<h2>Omschrijving</h2>
<?php echo(html_entity_decode($rec_article['description'])); ?>
</div>
<div class="kleuren">
<h2>Beschikbare kleuren</h2>
<ul>
<?php while($rec_kleuren = mysql_fetch_array($r_kleuren)){?>
<li><img src="/article_images/<?php echo($rec_article['image_dir']."/kleur_".$rec_kleuren['icon_dir']); ?>.jpg" alt="<?php echo(html_entity_decode($rec_kleuren['color_name'])); ?>" /></li>
<?php } ?>
</ul>
</div>
</div>
</div>
<div class="bottomPinkBackgr">
<div class="bottomContent">
<a href="/bestellen" title="Product bestellen en bedrukken">Dit product bestellen en bedrukken</a>
</div>
</div>
</div>
</div>
<div id="mainRight">
<?php include("rightSide.php"); ?>
<div id="contactBlockProductDetail" class="width236">
<div class="topBackgr"></div>
<div class="contentBlock">
<div class="divContent">
<h2>Reclame Drukwerk</h2>
<h3>Susan van Mierlo</h3>
<p>Neem contant op voor meer informatie en het plaatsen van bestellingen.<br /><br />
<a href="/contact" title="Neem contact op met Super">Contact <span>»</span></a></p>
</div>
</div>
<div class="bottomPinkBackgrNr"><span class="telefoon">06 - 13 72 77 01</span></div>
</div>
</div>
</div>
<div id="subContent">
<div id="productDetailMenu">
<?php
if($rec_article['sort_order'] == 1){ ?>
<a class="arrowLeft grijs"></a>
<?php }else{
$prev_order = $rec_article['sort_order'] - 1;
$q_article_prev = sprintf("SELECT kms_articles.url FROM kms_articles WHERE kms_articles.subcategorie_id='%s' AND kms_articles.sort_order='%s'", $rec_subcat['subcategorie_id'], $prev_order);
$r_article_prev = mysql_query($q_article_prev);
$rec_article_prev = mysql_fetch_array($r_article_prev); ?>
<a class="arrowLeft" href="/<?php echo($rec_cat['url']."/".$rec_subcat['url']."/".$rec_article_prev['url']); ?>" title="Vorige artikel"></a>
<?php } ?>
<?php
$q_article_count = sprintf("SELECT COUNT(kms_articles.article_id) as totaal_artikelen FROM kms_articles WHERE kms_articles.subcategorie_id='%s'", $rec_subcat['subcategorie_id']);
$r_article_count = mysql_query($q_article_count);
$rec_article_count = mysql_fetch_array($r_article_count);
if($rec_article['sort_order'] == $rec_article_count['totaal_artikelen']){ ?>
<a class="arrowRight grijs"></a>
<?php }else{
$next_order = $rec_article['sort_order'] + 1;
$q_article_next = sprintf("SELECT kms_articles.url FROM kms_articles WHERE kms_articles.subcategorie_id='%s' AND kms_articles.sort_order='%s'", $rec_subcat['subcategorie_id'], $next_order);
$r_article_next = mysql_query($q_article_next);
$rec_article_next = mysql_fetch_array($r_article_next); ?>
<a class="arrowRight" href="/<?php echo($rec_cat['url']."/".$rec_subcat['url']."/".$rec_article_next['url']); ?>" title="Volgende artikel"></a>
<?php } ?>
<div class="clear_both"></div>
<div class="dotLine"></div>
<h2>Gerelateerde producten</h2>
</div>
<ul class="overviewProducts">
<?php
$order_nummers;
$new_order = 1;
$nieuwe_totaal = $rec_article_count['totaal_artikelen'] - $rec_article['sort_order'];
for ($nummer = 1; $nummer <= $rec_article['sort_order'] + 6; $nummer++) {
if($nummer <= $nieuwe_totaal){
$order_nummers[$nummer] = $rec_article['sort_order'] + $nummer;
}else{
$order_nummers[$nummer] = $new_order;
$new_order++;
}
if($order_nummers[$nummer] == $rec_article['sort_order']){
$order_nummers[$nummer] = "";
}
}
$q_rel = sprintf("SELECT kms_articles.article_name, kms_articles.article_number, kms_articles.image_dir, kms_articles.url FROM kms_articles WHERE kms_articles.subcategorie_id='%s' AND (kms_articles.sort_order='%s' OR kms_articles.sort_order='%s'
OR kms_articles.sort_order='%s' OR kms_articles.sort_order='%s' OR kms_articles.sort_order='%s' OR kms_articles.sort_order='%s') ORDER BY kms_articles.article_id DESC", $rec_subcat['subcategorie_id'],
$order_nummers[1], $order_nummers[2], $order_nummers[3], $order_nummers[4], $order_nummers[5], $order_nummers[6]);
$r_rel = mysql_query($q_rel);
$rel_counter = 0;
while($rec_rel = mysql_fetch_array($r_rel)){ ?>
<li class="<?php if($rel_counter % 3 == 0){ echo("first"); } ?> width236">
<div class="topBackgr"></div>
<div class="contentBlock">
<div class="divContent">
<div class="name">
<a href="/<?php echo($rec_cat['url']."/".$rec_subcat['url']."/".$rec_rel['url']); ?>" title="<?php echo(html_entity_decode($rec_rel['article_name'])); ?>"><span class="nameSpan"><?php echo(html_entity_decode($rec_rel['article_name'])); ?></span><span class="arrows">»</span></a>
</div>
<div class="image">
<img src="/article_images/<?php echo($rec_rel['image_dir']); ?>/thumb.jpg" width="125" alt="<?php echo(html_entity_decode($rec_rel['article_name'])); ?>"/>
<div class="artikelnr"><?php echo(html_entity_decode($rec_rel['article_number'])); ?></div>
</div>
<div class="meerInfo">meer info</div>
</div>
</div>
<div class="bottomBackgr"></div>
</li>
<?php } ?>
</ul>
</div>
</div>
<div id="footerBreadcrump">
<div class="dotLine"></div>
<div class="textLeft"><a href="/">Home</a><span class="slash">/</span><a href="/<?php echo($rec_cat['url']."/".$rec_subcat['url']); ?>"><?php echo(html_entity_decode($rec_subcat['subcategorie_name'])); ?></a><span class="slash">/</span><a class="active" href="/<?php echo($rec_cat['url']."/".$rec_subcat['url']."/".$rec_article['url']); ?>"><?php echo(html_entity_decode($rec_article['article_name'])); ?></a></div>
<div class="textRight"><a href="/<?php echo($rec_cat['url']."/".$rec_subcat['url']); ?>">Terug naar het overzicht</a></div>
</div>