Gecko [ myeducation.co.th ]

Name	Size	Permission
Structure	[ DIR ]	drwxr-xr-x
admin	[ DIR ]	drwxr-xr-x
assets	[ DIR ]	drwxr-xr-x
assets2	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
lasery	[ DIR ]	drwxr-xr-x
model	[ DIR ]	drwxr-xr-x
modules	[ DIR ]	drwxr-xr-x
.htaccess	1.2 KB	-rw-r--r--
0language.php	1.91 KB	-rwxr-xr-x
1Head.php	20.57 KB	-rwxr-xr-x
2HeadMenu.php	14.78 KB	-rwxr-xr-x
2banner.php	4.68 KB	-rwxr-xr-x
3Footer.php	10.82 KB	-rwxr-xr-x
4End.php	5.74 KB	-rwxr-xr-x
about.php	12.83 KB	-rw-r--r--
contact.php	6.64 KB	-rwxr-xr-x
detail.php	11.99 KB	-rwxr-xr-x
download.php	9.8 KB	-rwxr-xr-x
index.php	173 B	-rwxr-xr-x
news-details.php	5.92 KB	-rwxr-xr-x
news.php	5.83 KB	-rwxr-xr-x
product.php	16.06 KB	-rwxr-xr-x
product_category.php	8.7 KB	-rwxr-xr-x
product_category3.php	14.71 KB	-rwxr-xr-x
product_category4.php	5.26 KB	-rwxr-xr-x
product_contact.php	1.87 KB	-rwxr-xr-x
product_detail.php	24.13 KB	-rwxr-xr-x
product_detail_More_products.p...	7.61 KB	-rwxr-xr-x
product_left_cat.php	7.23 KB	-rwxr-xr-x
search.php	4.3 KB	-rwxr-xr-x
service.php	3.8 KB	-rwxr-xr-x
topic-product.php	1.82 KB	-rwxr-xr-x

Code Editor : product_left_cat.php

<?PHP

$SQL_Category = "
          SELECT ProductCategory2_ID , ProductCategory_ID , ProductCategory2_Name , StatusProductCategory2_ID
          FROM product_category2
          WHERE StatusProductCategory2_ID = 1 AND ProductCategory_ID = $ProductCategory_ID
          ORDER BY ProductCategory2_Sort
          ";
          $objQuery_Category = $objConnect->query($SQL_Category);

while ($objResult_Category = mysqli_fetch_array($objQuery_Category)) {
            $ProductCategory2Name =  $objResult_Category["ProductCategory2_Name"];
             $ProductCategory2ID =  $objResult_Category["ProductCategory2_ID"];

$SQL_Category3 = "
      SELECT product_category3.ProductCategory3_ID , product_category3.ProductCategory3_Name , product_category3.ProductCategory3_Sort,
      product_category3.StatusProductCategory3_ID , product_category3.ProductCategory2_ID
      FROM product_category3
      WHERE product_category3.StatusProductCategory3_ID = 1 AND product_category3.ProductCategory2_ID = $ProductCategory2ID
      ORDER BY product_category3.ProductCategory3_Sort  
      ";
            $objQuery_Category3 = $objConnect->query($SQL_Category3);
            $objQuery_Category3_2 = $objConnect->query($SQL_Category3);

while ($objResult_Category3_2 = mysqli_fetch_array($objQuery_Category3_2)) {
              $ProductCategory3ID2 =  $objResult_Category3_2["ProductCategory3_ID"];
            }

if($ProductCategory2ID  == 198){
              $LinkHref = 'product_category3.php?c3='.$ProductCategory3ID2.'';
            }else if ($ProductCategory2ID  == 193) { 
              $LinkHref = 'product_category3.php?c3='.$ProductCategory3ID2.'';
            } else{
              $LinkHref = 'product_category.php?c2='.$ProductCategory2ID.'';
            }

<?PHP
                  while ($objResult_Category3 = mysqli_fetch_array($objQuery_Category3)) {
                    $ProductCategory3ID =  $objResult_Category3["ProductCategory3_ID"];
                    $ProductCategory3Name =  $objResult_Category3["ProductCategory3_Name"];

$SQL_Category4 = "
                    SELECT product_category4.ProductCategory4_ID,product_category4.ProductCategory3_ID,product_category4.ProductCategory4_Name,
                    product_category4.StatusProductCategory4_ID,product_category4.ProductCategory4_Img,
                    product_category4.ProductCategory4_Date,product_category4.ProductCategory4_Time , product_category3.ProductCategory3_Name,
                    product_category3.ProductCategory2_ID , product_category2.ProductCategory2_Name , product_category2.ProductCategory_ID,
                    product_category.ProductCategory_Name
                    FROM product_category4
                    INNER JOIN product_category3 ON product_category4.ProductCategory3_ID = product_category3.ProductCategory3_ID
                    INNER JOIN product_category2 ON product_category3.ProductCategory2_ID = product_category2.ProductCategory2_ID
                    INNER JOIN product_category ON product_category2.ProductCategory_ID = product_category.ProductCategory_ID
                    WHERE product_category4.StatusProductCategory4_ID = 1 AND
                    product_category4.ProductCategory3_ID = $ProductCategory3ID
                    ORDER BY product_category.ProductCategory_Name
                    ";              
                    $objQuery_Category4_CHK = $objConnect->query($SQL_Category4);	     
                    $Count_Category_Head = mysqli_num_rows($objQuery_Category4_CHK);     
                    
                    if($Count_Category_Head >=1){
                      $href_link = "product_category4.php";
                    }else{
                      $href_link = "product_category3.php";
                    }

<?PHP 
                          while($objResult_Category4_CHK = mysqli_fetch_array($objQuery_Category4_CHK)) {
                            $Head_CHK_ProductCategory4Name = $objResult_Category4_CHK["ProductCategory4_Name"];
                            $Head_CHK_ProductCategory4ID = $objResult_Category4_CHK["ProductCategory4_ID"];
                        ?>
                          <li data-depth="<?=$ProductCategory3ID;?>">
                            <a class="category-sub-link" href="product_category3.php?c4=<?= $Head_CHK_ProductCategory4ID; ?>"> <?=$Head_CHK_ProductCategory4Name;?> </a>                          
                          </li>
                          <?PHP } ?>   
                        </ul>
                      </div>

</li>

<?PHP } ?>

</ul>
              </div>

</li>

<?PHP } ?>

</ul>
      </li>
    </ul>
  </div>

<!-- <div id="banery">
    <p><img src="../img/cms/cat8-online.png" alt="" width="369" height="216" /></p>
    <p></p>
    <p><br /><img src="../img/cms/cat9-katalog.png" alt="" width="369" height="218" /></p>
    <p></p>
    <p></p>
    <p><br /><img src="../img/cms/przelewy24.png" alt="" width="271" height="274" /></p>
  </div>

<div class="igk-homefile">
    <a href="https://www.cormak.pl/zamow-katalog" title="Pobierz lub Zamów Bezpłatny Katalog">
      <div class="heading-wrapper">
        <h4>Pobierz lub Zam&oacute;w Bezpłatny Katalog</h4>
        <div class="image-wrapper">
          <img src="../modules/igk_homefiles/images/GOf8VyKRDB.png" class="img-fluid" alt="Pobierz lub Zamów Bezpłatny Katalog">
        </div>
      </div>
      <div class="subheading-wrapper">
        <p>Zam&oacute;w katalog w wersji drukowanej</p>
      </div>
    </a>
  </div> -->

${this.title}

Code Editor : product_left_cat.php