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

<?PHP
if ($set_page_language == 1) {
  $ProductCategory_ID = 37;
} else if ($set_page_language == 2) {
  $ProductCategory_ID = 38;
}

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

// 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, status_product.StatusProduct_Name, product.Member_ID, status_product.StatusProduct_Name, product.Member_ID, member.Member_NameEN, member.Position_ID, position.Position_Name, 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_category3 
// INNER JOIN (product_category2
// INNER JOIN (product_category 
// INNER JOIN (status_product 
// INNER JOIN (product 
// INNER JOIN (position 
// INNER JOIN member 
// ON position.Position_ID = member.Position_ID) 
// ON product.Member_ID = member.Member_ID) 
// ON status_product.StatusProduct_ID = product.StatusProduct_ID) 
// ON product_category.ProductCategory_ID = product.ProductCategory_ID) 
// ON product_category2.ProductCategory2_ID = product.ProductCategory2_ID) 
// ON product_category3.ProductCategory3_ID = product.ProductCategory3_ID

$SQL_Product = "	
SELECT DISTINCT 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 , product.Product_File
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_category2
ORDER BY ProductCategory_Name
";

$objQuery_Product = $objConnect->query($SQL_Product);
  $objQuery_Product2 = $objConnect->query($SQL_Product);
  $objQuery_Product3 = $objConnect->query($SQL_Product);
  $CheckNum_Product = mysqli_num_rows($objQuery_Product);  
  $CountProduct3 = mysqli_num_rows($objQuery_Product);

if($CountProduct3 !=0){

while ($objResult_Product3 = mysqli_fetch_array($objQuery_Product3)) {
      $objResult_ProductName2 = $objResult_Product3["ProductCategory2_Name"];
    }
?>

<div class="product_carousel product_column5 owl-carousel">
        <?PHP
        while ($objResult_Product = mysqli_fetch_array($objQuery_Product)) {
          $objResult_ProductName1 = $objResult_Product["ProductCategory_Name"];
          $objResult_ProductName = $objResult_Product["ProductCategory2_Name"];
          $ProductCategory2ID = $objResult_Product["ProductCategory2_ID"];
          $ProductName = $objResult_Product["Product_Name"];
          $ProductPrice = $objResult_Product["Product_Price"];
          $ProductDetail3 = $objResult_Product["Product_Detail3"];
          $ProductDetail = $objResult_Product["Product_Detail"];
          $ProductID = $objResult_Product["Product_ID"];
          $IMG_More_ProductImg = $objResult_Product["Product_Img"];
          $NewformatProductPrice =  number_format((float) $ProductPrice, 0, '.', ',');

$ProductName = urldecode($ProductName);
          $ProductDetail = urldecode($ProductDetail);
          $ProductDetail3 = urldecode($ProductDetail3);

if($ProductName == "-"){
            $ProductName = "" ;
          }else{
            $ProductName = urldecode($ProductName);
          }

?>
          <div class="single_product">

<div class="images-container">
              <div class="product-cover product-cover-index1">
                <img class="js-qv-product-cover object-contain" src="model/upload/img/IMGProduct/<?= $IMG_More_ProductImg; ?>" alt="<?= $ProductName; ?>" title="<?= $ProductName; ?>" itemprop="image">
                <div class="layer hidden-sm-down" data-toggle="modal" data-target="#product-modal<?= $ProductID; ?>">
                  <i class="material-icons zoom-in"></i>
                </div>
              </div>
            </div>

<?PHP
      while ($objResult_Product2 = mysqli_fetch_array($objQuery_Product2)) {
        $IMG_More_ProductImg2 = $objResult_Product2["Product_Img"];
        $ProductID2 = $objResult_Product2["Product_ID"];
        $ProductName2 = $objResult_Product2["Product_Name"];
        $ProductName2 = urldecode($ProductName2);
      ?>
        <div class="modal fade js-product-images-modal" id="product-modal<?= $ProductID2; ?>">
          <div class="modal-dialog" role="document">
            <div class="modal-content">

<div class="modal-header">
                <h5 class="modal-title"><?= $ProductName2; ?></h5>
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                  <span aria-hidden="true">&times;</span>
                </button>
              </div>

<a href="product_detail.php?ID=<?= $ProductID; ?>&Name=<?= $ProductName; ?>">
                  <img class="js-modal-product-cover product-cover-modal " width="100%" src="model/upload/img/IMGProduct/<?= $IMG_More_ProductImg2; ?>" alt="><?= $ProductName; ?>" title="><?= $ProductName; ?>" itemprop="image">
                </a>

</div>
            </div>
          </div>
        </div>
      <?PHP } ?>

</div>
  </section>
</div>

<?PHP } ?>
<script src="assets2/js/vendor/jquery-3.4.1.min.js"></script>
<script src="assets2/js/owl.carousel.min.js"></script>
<script src="assets2/js/plugins.js"></script>
<script src="assets2/js/main.js"></script>

${this.title}

Code Editor : product_detail_More_products.php