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_category3.php

<?PHP
include '1Head.php';
include '2HeadMenu.php';

if (isset($_GET['c4'])) {
  $category4 = trim($_GET['c4']);
  $SQL_category4 = " AND product.ProductCategory4_ID = $category4";

$SQL_CHKCategory4 = "
    SELECT 
    product_category4.ProductCategory4_ID , product_category4.ProductCategory4_Name , 
    product_category4.ProductCategory3_ID , product_category3.ProductCategory3_Name , 
    product_category3.ProductCategory3_Detail , 
    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.ProductCategory4_ID = $category4
    ";
    $objQuery_CHKCategory4 = $objConnect->query($SQL_CHKCategory4);

while ($objResult_CHKCategory4 = mysqli_fetch_array($objQuery_CHKCategory4)) {
       $CHKCate4_ID = $objResult_CHKCategory4["ProductCategory4_ID"];
       $CHKCate3_ID = $objResult_CHKCategory4["ProductCategory3_ID"];
       $CHKCate4_Name = $objResult_CHKCategory4["ProductCategory4_Name"];
       $CHKCate3_Name = $objResult_CHKCategory4["ProductCategory3_Name"];
       $CHKCate2_Name = $objResult_CHKCategory4["ProductCategory2_Name"];
       $Head3_ProductCategory3Detail = $objResult_CHKCategory4["ProductCategory3_Detail"];

$SQL_category3 = " AND product.ProductCategory3_ID = $CHKCate3_ID";

if($Head3_ProductCategory3Detail == "<p>-</p>"){
        $Head3_ProductCategory3Detail = "";
      }
      $Head3_ProductCategory3Detail = urldecode($Head3_ProductCategory3Detail);

}

} else {
  $category4 = '';
  $SQL_category4 = '';
  $SQL_category3 = '';

$CHKCate4_ID = '';
  $CHKCate3_ID = '';

$CHKCate4_Name = '';
}

if (isset($_GET['c2'])) {
  $category2 = trim($_GET['c2']);
  $SQL_category2 = " AND product.ProductCategory2_ID = $category2 ";

$strSQL_category2 = "	
    SELECT ProductCategory2_ID , ProductCategory2_Name , ProductCategory2_Detail 
    FROM product_category2
    WHERE 
    ProductCategory2_ID = $category2
    ";
  $objQuery_data_category2 = $objConnect->query($strSQL_category2);
  while ($objResult_data_category2 = mysqli_fetch_array($objQuery_data_category2)) {
    $Data_ProductCategory2Name = $objResult_data_category2["ProductCategory2_Name"];
    $Category2_ProductCategory2Name = $Data_ProductCategory2Name;
    $ProductCategory2Detail = $objResult_data_category2["ProductCategory2_Detail"];
  }
} else {
  $category2 = '';
  $SQL_category2 = '';
  $Category2_ProductCategory2Name = '';
  $ProductCategory2Detail = '';
}

if (isset($_GET['c3'])) {
  $category3 = trim($_GET['c3']);
  $SQL_category3 = " AND product.ProductCategory3_ID = $category3";

$SQL_Category_Head3 = "
  SELECT 
  product_category3.ProductCategory3_ID , product_category3.ProductCategory3_Name , product_category3.ProductCategory2_ID,
  product_category3.ProductCategory3_Sort , product_category3.StatusProductCategory3_ID , product_category2.ProductCategory2_Name,
  product_category3.ProductCategory3_Detail
  FROM product_category3 
  INNER JOIN product_category2 ON product_category3.ProductCategory2_ID = product_category2.ProductCategory2_ID
  WHERE  
  product_category3.ProductCategory3_ID = $category3
  ORDER BY product_category3.ProductCategory3_Sort
  ";

$objQuery_Category_Head3 = $objConnect->query($SQL_Category_Head3);
  while ($objResult_Category_Head3 = mysqli_fetch_array($objQuery_Category_Head3)) {
    $Head3_ProductCategory2Name = $objResult_Category_Head3["ProductCategory2_Name"];
    $Head3_ProductCategory2ID = $objResult_Category_Head3["ProductCategory2_ID"];
    $Head3_ProductCategory3ID = $objResult_Category_Head3["ProductCategory3_ID"];
    $Head3_ProductCategory3Name = $objResult_Category_Head3["ProductCategory3_Name"];
    $Head3_ProductCategory3Detail = $objResult_Category_Head3["ProductCategory3_Detail"];

if($Head3_ProductCategory3Detail == "<p>-</p>"){
      $Head3_ProductCategory3Detail = "";
    }

$Head3_ProductCategory2Name = urldecode($Head3_ProductCategory2Name);
    $Head3_ProductCategory3Detail = urldecode($Head3_ProductCategory3Detail);
   
  }

} else {

if($CHKCate4_ID == ''){
    $category3 = '';   
  }else{
    $category3 = $CHKCate3_ID;    
    $Head3_ProductCategory3ID = $CHKCate3_ID;    
    $Head3_ProductCategory3Name =  $CHKCate3_Name;
    $Head3_ProductCategory2Name =  $CHKCate2_Name;
   
  }

}

//echo $SQL_category4;
//echo $SQL_category3 ;

if (isset($_GET['orderby'])) {
  $orderby_CHK = trim($_GET['orderby']);
} else {
  $orderby_CHK = '';
}

if (isset($_GET['search'])) {
  $search_name = trim($_GET['search']);
  $sql_search_name = ' AND product.Product_Name LIKE "%' . $search_name . '%"';
} else {
  $search_name = '';
  $sql_search_name = '';
}

$sql_sort = " ORDER BY product_category.ProductCategory_Name ASC";

$SQL_Product_All_Page = "	
  SELECT product.Product_ID, product.ProductCategory_ID, product_category.ProductCategory_Name, product.ProductCategory2_ID, product_category2.ProductCategory2_Name, product.ProductCategory3_ID, product_category3.ProductCategory3_Name, product.StatusProduct_ID, product.Member_ID, product.Member_ID, product.Product_Name, product.Product_Num, product.Product_Unit, product.Product_Price, product.Product_Detail, product.Product_PVScore, product.Product_Img, product.Product_Time, product.Product_Date, product.Product_Visitors, product.Product_Detail2, product.Product_Detail3, product.Product_Color
  FROM product
  INNER JOIN product_category ON product.ProductCategory_ID = product_category.ProductCategory_ID
  INNER JOIN product_category2 ON product.ProductCategory2_ID = product_category2.ProductCategory2_ID
  INNER JOIN product_category3 ON product.ProductCategory3_ID = product_category3.ProductCategory3_ID
  WHERE 
  product.StatusProduct_ID = 1 AND 
  product.ProductCategory_ID = $ProductCategory_ID
  $sql_search_name
  $SQL_category2
  $SQL_category3
  $SQL_category4
  $sql_sort
  ";

$objQuery_Product_All_Page = $objConnect->query($SQL_Product_All_Page);
$CheckNum_Product_All_Page = mysqli_num_rows($objQuery_Product_All_Page);

</ol>
    </nav>

<?PHP  if($CHKCate4_ID == ''){ ?>

<?PHP
              $SQL_Category4 = "
              SELECT product_category4.ProductCategory4_ID , product_category4.ProductCategory4_Name , 
              product_category4.StatusProductCategory4_ID , product_category4.ProductCategory3_ID FROM product_category4 
              WHERE product_category4.StatusProductCategory4_ID = 1 AND product_category4.ProductCategory3_ID = $category3
              ORDER BY product_category4.ProductCategory4_Name
              ";
              $objQuery_Category4 = $objConnect->query($SQL_Category4);
             $CheckNum_Category4 = mysqli_num_rows($objQuery_Category4);      
              ?>

<?PHP 
                     while ($objResult_Category4 = mysqli_fetch_array($objQuery_Category3)) {
                      $ProductCategory4ID =  $objResult_Category3["ProductCategory4_ID"];
                      $ProductCategory4Name =  $objResult_Category3["ProductCategory4_Name"];
                      $ProductCategory4IMG =  $objResult_Category3["ProductCategory4_Img"];
      
                      $ProductCategory4Name = urldecode($ProductCategory4Name);
                    ?>
                  <li class="col-xl-4 col-lg-6 col-md-12" style="padding: 10px;">
                  <div class="category-miniature">
                    <h2 class="h2">
                      <a href="product_category.php?c3=<?= $ProductCategory4ID; ?>" style="font-size: 15px;"><?= $ProductCategory4Name; ?></a>
                    </h2>
                    <a href="product_category.php?c3=<?= $ProductCategory4ID; ?>">
                      <img src="model/upload/img/IMG_Category/<?= $ProductCategory4IMG; ?>" alt="#" class="img-fluid" style="height: 250px;width: 100%;object-fit: cover;">
                    </a>
                  </div>
                </li>
               <?PHP } ?>    
            </ul>
          </div>

<section id="products">          
              <div id="js-product-list">
                <div class="products row">
                  <?PHP
                  while ($objResult_Product_All_Page = mysqli_fetch_array($objQuery_Product_All_Page)) {
                    $objResult_ProductName1 = $objResult_Product_All_Page["ProductCategory_Name"];
                    $objResult_ProductName2 = $objResult_Product_All_Page["ProductCategory2_Name"];
                    $objResult_ProductName3 = $objResult_Product_All_Page["ProductCategory3_Name"];

$ProductCategory2ID = $objResult_Product_All_Page["ProductCategory2_ID"];
                    $ProductName = $objResult_Product_All_Page["Product_Name"];
                    $ProductPrice = $objResult_Product_All_Page["Product_Price"];
                    $ProductDetail3 = $objResult_Product_All_Page["Product_Detail3"];
                    $ProductDetail2 = $objResult_Product_All_Page["Product_Detail2"];
                    $ProductDetail = $objResult_Product_All_Page["Product_Detail"];
                    $ProductID = $objResult_Product_All_Page["Product_ID"];
                    $ProductImg = $objResult_Product_All_Page["Product_Img"];
                    $NewformatProductPrice =  number_format((float) $ProductPrice, 0, '.', ',');

$ProductName = urldecode($ProductName);
                    $ProductDetail = urldecode($ProductDetail);
                    $ProductDetail2 = urldecode($ProductDetail2);
                    $ProductDetail3 = urldecode($ProductDetail3);
                    
                  ?>
                    <article class="product-miniature js-product-miniature product_show_list">
                      <div class="thumbnail-container">

<a href="product_detail.php?ID=<?= $ProductID; ?>&Name=<?= $ProductName; ?>" class="thumbnail product-thumbnail">
                            <img src="model/upload/img/IMGProduct/<?= $ProductImg ?>" alt="<?= $ProductName; ?>">
                          </a>

<?PHP if($ProductName != "-"){ ?>
                            <h1 class="font-index1 product-title" itemprop="name">
                              <a href="product_detail.php?ID=<?= $ProductID; ?>&Name=<?= $ProductName; ?>"><?= $ProductName; ?></a>
                            </h1>
                          <?PHP } ?>

<?PHP if($ProductPrice != 0){ ?>

<div class="product-price-and-shipping">
                              <div class="row">
                                <div class="col-xs-6">
                                  <p>
                                    <span class="price-label">
                                    Price
                                    </span>
                                    <span class="price-final-netto">
                                    <?= $NewformatProductPrice; ?> THB
                                    </span>
                                  </p>
                                </div>
          
                              </div>
                            </div>
                            <?PHP } ?>

<?PHP if($ProductDetail != "<p>-</p>"){ ?>
                              <div class="product-description-short">
                                <?= $ProductDetail; ?>
                              </div>
                            <?PHP } ?>
                          </div>
                        </div>
                        <ul class="product-flags">
                        </ul>
                      </div>
                    </article>
                  <?PHP } ?>
                </div>            
            </div>     
          </section>

</div>
        <div class="clearfix"></div>
      </div>
    </div>
  </section>

<?PHP
include '3Footer.php';
include '4End.php';
?>

${this.title}

Code Editor : product_category3.php