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

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

<?PHP
if ($set_page_language == 1) {
  $ProductCategory_ID = 37;
  $topic1 = "สินค้าของเรา";
} else if ($set_page_language == 2) {
  $ProductCategory_ID = 38;
  $topic1 = "Products";
}

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 = '';
}

if (isset($_GET['c3'])) {
  $category3 = trim($_GET['c3']);
  $SQL_category3 = " AND product.ProductCategory3_ID = $category3";
} else {
  $category3 = '';
  $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 = '';
}

//echo $orderby_CHK;
if ($orderby_CHK == "sort_15") {
  $sql_sort = " ORDER BY product.Product_ID DESC ";
} else if ($orderby_CHK == "sort_16") {
  $sql_sort = " ORDER BY product.Product_Visitors DESC ";
} else if ($orderby_CHK == "sort_17") {
  $sql_sort = " ORDER BY product.Product_Price ASC ";
} else if ($orderby_CHK == "sort_18") {
  $sql_sort = " ORDER BY product.Product_Price DESC ";
} else if ($orderby_CHK == "sort_19") {
  $sql_sort = " ORDER BY product.Product_Name ASC ";
} else if ($orderby_CHK == "sort_20") {
  $sql_sort = " ORDER BY product.Product_Name DESC ";
} else {
  $sql_sort = " ORDER BY product_category.ProductCategory_Name ASC";
}

// echo $sql_sort;
//echo !empty($orderby_CHK['sort_16']) ?? 'selected';

$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, 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
      WHERE 
      product.StatusProduct_ID = 1 AND 
      product.ProductCategory_ID = $ProductCategory_ID
      $sql_search_name
      $SQL_category2
      $SQL_category3
      $sql_sort
      ";

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

//echo $orderby_CHK;
//  $_SESSION['ses_orderby'] = $orderby_CHK;
//  $sesorderby = $_SESSION['ses_orderby'];
//  echo $sesorderby;

<section id="wrapper">
  <?PHP  include 'topic-product.php';  ?>
  <div class="container">
  <?PHP
          $CategoryContent_ID = 46;
          $CategoryContentLanguage_ID = 101;

include 'Structure/Structure_Content_Loop.php';
          while ($objResult_content = mysqli_fetch_array($objQuery_content)) {
            $ContentID = $objResult_content["Content_ID"];
            $ContentName = $objResult_content["Content_Name"];
            $ContentContent1 = $objResult_content["Content_Content1"];
            $ContentContent2 = $objResult_content["Content_Content2"];
            $ContentContent3 = $objResult_content["Content_Content3"];
            $ContentContent4 = $objResult_content["Content_Content4"];
            $ContentContent5 = $objResult_content["Content_Content5"];
            $ContentNumber = $objResult_content["Content_Number"];
            $ContentDate = $objResult_content["Content_Date"];
            $ContentTime = $objResult_content["Content_Time"];
            $ContentContent1 = urldecode($ContentContent1);
            $ContentContent2 = urldecode($ContentContent2);
            $ContentContent3 = urldecode($ContentContent3);
            $ContentContent4 = urldecode($ContentContent4);
            $ContentContent5 = urldecode($ContentContent5);
            include 'Structure/Structure_Content_check.php';
            $SQL_Content_Img = "
            SELECT ContentImg_ID , Content_ID, ContentImg_Name , ContentImg_Sort
            FROM content_img
            WHERE Content_ID = $ContentID
            ORDER BY ContentImg_Sort ASC 			
            ";
            $objQuery_Content_Img = $objConnect->query($SQL_Content_Img);

?>
            <?PHP
            while ($objResult_Content_Img = mysqli_fetch_array($objQuery_Content_Img)) {
              $CIMG_ContentImgName = $objResult_Content_Img["ContentImg_Name"];
            ?>
              <div class="block-category card card-block hidden-sm-down">
                
                <div id="category-description" class="text-muted">
                  <img src="model/upload/img/IMG_Home/<?= $CIMG_ContentImgName; ?>" alt="<?= $ContentContent1; ?>" style="height: 300px;object-fit: cover;width: 100%;">
                </div>

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

<!-- <nav data-depth="2" class="breadcrumb hidden-sm-down">
      <ol itemscope itemtype="http://schema.org/BreadcrumbList">

<li itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem">
          <a itemprop="item" href="#">
            <span itemprop="name">Products</span>
          </a>
          <meta itemprop="position" content="1">
        </li>

</ol>
    </nav> -->

<div class="row bg-index4 mb2">
      <?PHP include 'product_left_cat.php';    ?>
      <div id="content-wrapper" class="left-column right-column col-md-9">
        <section id="main">        
          <div class="text-sm-center hidden-md-up">
            <h1 class="h1">Products</h1>
          </div>

<?PHP
                 $SQL_Category = "
                SELECT ProductCategory2_ID , ProductCategory_ID , ProductCategory2_Name ,
                 StatusProductCategory2_ID , ProductCategory2_IMG , ProductCategory2_IMG_Cover
                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"];          
                $ProductCategory2IMGCover =  $objResult_Category["ProductCategory2_IMG_Cover"];
                $ProductCategory2IMG =  $objResult_Category["ProductCategory2_IMG"];

$CHKIMGCategoryCover = "model/upload/img/IMG_Category/$ProductCategory2IMGCover";
                 $CHKIMGCategory = "model/upload/img/IMG_Category/$ProductCategory2IMG";

//  echo '<br/>IMG Cover : '.$CHKIMGCategoryCover;
                //  echo '<br/>IMG : '.$CHKIMGCategory;

$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 . '';
                      }
                ?>

<li class="col-xl-4 col-lg-6 col-md-12" style="padding: 10px;">
                  <div class="category-miniature">
                    <h2 class="h2">
                      <a href="<?= $LinkHref; ?>" style="font-size: 15px;"><?= $ProductCategory2Name; ?></a>
                    </h2>

</a>
                  </div>
                </li>

<?PHP if ($ProductCategory2ID  != 193 and $ProductCategory2ID  != 198) { ?>
                  <?PHP } ?>
                  
              <?PHP } ?>

</ul>
          </div>

<?PHP
                  while ($objResult_Product_All_Page = mysqli_fetch_array($objQuery_Product_All_Page)) {
                    $objResult_ProductName1 = $objResult_Product_All_Page["ProductCategory_Name"];
                    $objResult_ProductName = $objResult_Product_All_Page["ProductCategory2_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"];
                    $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);
                    $ProductDetail3 = urldecode($ProductDetail3);

?>
                    <article class="product-miniature js-product-miniature product_show_list">
                      <div class="thumbnail-container">

<div class="product-description-wrapper">
                          <div class="igk-tutorial-icon" title="Zawiera film instruktażowy">
                            <img src="model/upload/img/IMGProduct/<?= $ProductImg ?>" alt="<?= $ProductName; ?>" class="img-fluid">
                          </div>

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

<?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>

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

</div>

</div>

</section>

</div>

</div>
  </div>

</section>

<?PHP

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

${this.title}

Code Editor : product.php