it just seems im doing the loop over and over, ive now got it to pull all the bottom level categories for each main category, which is what i wanted it to do, but it does look like too much code if im honest and reading through it there must be a better way of doing this, as you can tell im not the best at refactoring my code at the moment, im just getting my head around OOP, so this is what i have got
<?php switch ($_GET['sector']){
case "tactical":
$color='#045827';
break;
case "commercial":
$color='#6F1461';
break;
case "adventure":
$color='#97151D';
break;
case "maritime":
$color='#023A69';
break;
case "civil":
$color='#0893B2';
break;
} ?>
<?php $q="SELECT * FROM shop_categories where name='".ucfirst($_GET[sector])."'";
$c=$db->Select($q);
echo "<img src='".ROOT."images/categories/".$c[0]['thumbnail']."' alt='' title='' style='float:right' />"; ?>
<h2>Sector - <span style="color:<?=$color?>"><?=$_GET['sector']?></span></h2>
<?php
echo $c[0]['intro'];
?>
<div id="breaker"></div>
<?php
if (($_GET['record']=='0') || (!isset($_GET['record']))){
#as we are searching by sector the first thing we need to do is to pull all the subcategories of that sector out and show them, so for instance
#tactical has sub categories of MJM, PPE we need to show these with a small description of tactical and the cats under
#from there they click into the product list page and then into individual pages.
#first thing is to loop through all the categories and then we can work through them all and find the relevant bottom level cats
$q = "SELECT * FROM shop_categories";
$x = $db->Select($q);
if ($x){
#if there are some results we will loop through them all and add them to an array
foreach ( $x as $category){
#the parent category will only be 0 if its a top level category so no need to add
if ($category['parent'] != '0' ){
if ($category['parent'] == $_GET['parent']){
#if the category parent equals the current parent then we need to see if it has any children if it doesn't add it, else don't and loop down
$q = "SELECT id from shop_categories where parent = '".$category['id']."'";
$x = $db->Select($q);
if ($x) {
#dont add it as it has children
}
else {
#if the category parent equals the current parent and no children add it to the array
$categories[] = $category['id'];
}
} #end of if category = parent
else {
#next thing to do is go through and find the previous level category they belong to until they reach the parent then add them
$q = "SELECT * from shop_categories where id = ".$category['parent']."";
$x = $db->Select($q);
if ($x) {
$currentitem = $category['id'];
if ($x[0]['parent'] == '0'){
# this is the bottom category
}
else { #for if $x
#if the parent isnt 0 we need to find the level back
foreach ($x as $uplevel){
$q = "SELECT * from shop_categories where id = ".$uplevel['parent']."";
$z = $db->Select($q);
if ($z) {
if (($z[0]['parent'] == '0') && ($z[0]['id'] == $_GET['parent'])){
$categories[] = $currentitem;
}
}
}
}
}
else {
# there are not subs after this and we have reached the parent category
$categories[] = $uplevel['id'];
}
}
}
}
$_SESSION['categories'] = $categories;
}
else {
echo "<h1>No Current Categories</h1>";
}
# print_r($_SESSION);
if ($_SESSION['categories']){
echo "<ul id='itemlist'>";
foreach ($_SESSION['categories'] as $product){
$q= "SELECT * FROM shop_categories where id = '".$product."'";
#$q="SELECT *,shop_products.name as prodname FROM shop_products JOIN shop_product_images on shop_product_images.shop_products_id=shop_products.id JOIN shop_products_cats on shop_products.id=shop_products_cats.products_id JOIN shop_categories on shop_products_cats.products_categories_id = shop_categories.id where shop_categories.name ='".$_GET['sector']."' GROUP BY shop_products.id";
$x=$db->Select($q);
if ($x){
//create the list of categories here and the image list below;
foreach ($x as $item){
echo "<a href='".ROOT."$item[name]/sector_$item[name]/page_product/product_$item[products_id]/index.html'><li>".$item['name']."</li></a>";
}
}
}
echo "</ul><br /><br />";
}
}
#need to now use the array again and draw the images
//start of the displaying product Categories as images
/*$q= "SELECT * FROM shop_categories where parent = '".$_GET['parent']."'";
#$q="SELECT *,shop_products.name as prodname FROM shop_products JOIN shop_product_images on shop_product_images.shop_products_id=shop_products.id JOIN shop_products_cats on shop_products.id=shop_products_cats.products_id JOIN shop_categories on shop_products_cats.products_categories_id = shop_categories.id where shop_categories.parent ='".$_GET['parent']."' GROUP BY shop_products.id ";
$x=$db->Select($q); */
$size=sizeof($_SESSION['categories']);
//find out how many pages we require
$pages=$size/9;
if (isset($_GET['record'])){
$record = $_GET['record'];
if ($record == 0){
$end = 6;
}
else {
$end = $record + 9;
}
}
else {
$record = 0;
$end = 6;
}
$column = 0;
echo "<div class='row'>";
#loop through the array and pull the information
for ($i = $record; $i<$end; $i++){
$q = "SELECT * FROM shop_categories where id = ".$_SESSION['categories'][$i]."";
$x=$db->Select($q);
if ($x){
foreach ($x as $item){ ?>
<?php if ($column == '3'){ ?>
</div><div class='row'>
<?php $column = 0; } ?>
<?php #draw the information out onto the screen this being the titl and image associated with the section
?>
<div class='product'>
<h3><?=$item[name]?></h3>
<a href='<?=ROOT?><?=$item['name']?>/sector_<?=$sector?>/page_product/product_<?=$item[products_id]?>/index.html'><img src="<?=ROOT?>images/categories/<?=$item['thumbnail']?>" alt="<?=$item['title']?>" title="<?=$item['title']?>" style="height:135px;width:180px;"/></a>
<?php
}
?>
<div class="sectors">
<?php
#now we need to pull the categories each one belongs to
echo $q = "SELECT *
FROM shop_categories where name LIKE '".$item['name']."'
";
$x = $db->Select($q);
if ($x){
#if there are some results we will loop through them all and add them to an array
foreach ( $x as $category){
#the parent category will only be 0 if its a top level category so no need to add
if ($category['parent'] != '0' ){
if (($category['parent'] == '1') || ($category['parent'] == '2') || ($category['parent'] == '3') || ($category['parent'] == '4') || ($category['parent'] == '5')){
#if the category parent equals the current parent then we need to see if it has any children if it doesn't add it, else don't and loop down
$q = "SELECT id from shop_categories where parent = '".$category['id']."'";
$x = $db->Select($q);
if ($x) {
#dont add it as it has children
}
else {
#if the category parent equals the current parent and no children add it to the array
$categorylist[] = $category['parent'];
}
} #end of if category = parent
else {
#next thing to do is go through and find the previous level category they belong to until they reach the parent then add them
$q = "SELECT * from shop_categories where id = ".$category['parent']."";
$x = $db->Select($q);
if ($x) {
$currentitem = $category['id'];
if ($x[0]['parent'] == '0'){
# this is the bottom category
}
else { #for if $x
#if the parent isnt 0 we need to find the level back
foreach ($x as $uplevel){
$q = "SELECT * from shop_categories where id = ".$uplevel['parent']."";
$z = $db->Select($q);
if ($z) {
if (($z[0]['parent'] == '0') && ($z[0]['id'] == $_GET['parent'])){
$categorylist[] = $z[0]['id'];
}
}
}
}
}
else {
# there are not subs after this and we have reached the parent category
$categorylist[] = $uplevel['parent'];
}
}
}
}
#loop through the category list and take out the repeats
print_r($newcatlist);
#print_r($categorylist);
foreach ($categorylist as $image){
echo $image;
switch ($image){
case "1":
$sectorz="Tactical & Security";
$image="circletact.png";
break;
case "2":
$sectorz="Private/Corporate";
$image="circlepriv.png";
break;
case "3":
$sectorz="Emergency Services";
$image="circleemer.png";
break;
case "4":
$sectorz="Adventure";
$image="circleadv.png";
break;
case "5":
$sectorz="Maritime";
$image="circle.png";
break;
}
}
echo "<img src='images/framework/webshop/$image' alt='$sectorz' title='$sectorz' class='nobordercir' />";
}
/*$q="SELECT *
FROM shop_products_cats
JOIN shop_categories ON shop_categories.id = shop_products_cats.products_categories_id
JOIN shop_product_images
WHERE shop_products_cats.products_id = '".$item[products_id]."'
GROUP BY shop_products_cats.products_categories_id"; */
?>
</div><p><span>£<?=$item[price]?></span><a href='<?=ROOT?><?=$item['name']?>/sector_<?=$item['name']?>/page_product/product_<?=$item[products_id]?>/index.html'><img src="images/framework/webshop/side.png" alt="side Arrow" title="Side Arrow" class="noborder" /></a></p>
</div>
<?
}
$column++;
}
echo "</div>";
//if the size of the returned result is more than 6 then draw the navigation.
if ($size>6){ ?>
<div id="navigation">
<div class='block'>
<?php
//getting the correct color arrows depeding on sectors they are in
switch ($sector){
case "tactical":
$prev='prevtact.png';
$next='nexttact.png';
break;
case "civil":
$prev='prevpriv.png';
$next='nextpriv.png';
break;
case "commercial":
$prev='nextemer.png';
$next='prevemer.png';
break;
case "adventure":
$prev='prevadve.png';
$next='nextadve.png';
break;
case "maritime":
$prev='prevmarit.png';
$next='nextmarit.png';
break;
}
?>
<?php if (!isset($_GET['record'])|| $_GET['record']!='0' ){ ?>
<?php
if ($_GET['record']=='6'){
$lastpage=$_GET['record']-6;
}
else {
$lastpage=$_GET['record']-9;
} ?>
<a class='empty' href='<?=ROOT?><?=$sector?>/sector_<?=$sector?>/page_sector/record_<?=$lastpage?>/parent_<?=$_GET['parent']?>/index.html' ><img src="<?=ROOT?>images/framework/webshop/<?=$prev?>" alt="Previous" title="Previous" /></a>
<?} else {echo " ";}?>
</div>
<?php
//loop to create the pagination for the sector products
for ($i=0; $i<$pages; $i++){
if ($i=='1'){
$record = $i * 6;
}
else {
$record = $i * 9;
}
$number = $i + 1;
?>
<a class='boxes' href='<?=ROOT?><?=$sector?>/page_sector/sector_<?=$sector?>/record_<?=$record?>/parent_<?=$_GET['parent']?>/index.html' ><?=$number?></a>
<?} ?>
<?php if ($_GET['record'] + $end < $size){ ?>
<?php
if (!isset($_GET['record']) || ($_GET['record']=='0')){
$nextpage = $_GET['record'] + 6;
}else {
$nextpage = $_GET['record'] + 9;
}?>
<div class='block'><a class='empty' href='<?=ROOT?><?=$sector?>/page_sector/sector_<?=$sector?>/record_<?=$nextpage?>/parent_<?=$_GET['parent']?>/index.html' ><img src="<?=ROOT?>images/framework/webshop/<?=$next?>" alt="Next" title="Next" /></a></div>
<? }?>
</div>
<?}
else {
echo "No current Products";
}
?>
