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

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

<div class="">
    <nav data-depth="2" class="hidden-sm-down bg-index5 plr5 ptb2 mb2 color-index3">
      <h1 class="h1"><?= $text15; ?> : Products</h1>
    </nav>
</section>
</div>

<?PHP
if (isset($_GET['controller'])) {
  $controller = trim($_GET['controller']);
} else {
  $controller = "0";
}

$controller = htmlspecialchars($controller);

$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.Product_Name LIKE '%$controller%' OR
product.Product_Detail LIKE '%$controller%' OR
product.Product_Detail2 LIKE '%$controller%'
ORDER BY product.ProductCategory_ID
";
$objQuery_Product = $objConnect->query($SQL_Product);
$Count_Product = mysqli_num_rows($objQuery_Product);

if ($Count_Product == 0) {
} else {

<?PHP
        $count = 0;
        while ($objResult_Product = mysqli_fetch_array($objQuery_Product)) {
          $count++;
          $ProductID = $objResult_Product["Product_ID"];
          $ProductCategoryName1 = $objResult_Product["ProductCategory_Name"];
          $ProductCategoryName2 = $objResult_Product["ProductCategory2_Name"];
          $ProductCategoryName3 = $objResult_Product["ProductCategory3_Name"];
          $ProductVisitors = $objResult_Product["Product_Visitors"];
          $detail_ProductCategory2ID = $objResult_Product["ProductCategory2_ID"];
          $detail_ProductCategory3ID = $objResult_Product["ProductCategory3_ID"];
          $ProductFile = $objResult_Product["Product_File"];

//echo "ProductFile".$ProductFile;

$ProductName = $objResult_Product["Product_Name"];
          $ProductPrice = $objResult_Product["Product_Price"];
          $ProductDetail3 = $objResult_Product["Product_Detail3"];
          $ProductDetail2 = $objResult_Product["Product_Detail2"];
          $ProductDetail = $objResult_Product["Product_Detail"];

$ProductImg = $objResult_Product["Product_Img"];
          $ProductUnit = $objResult_Product["Product_Unit"];
          $ProductDate = $objResult_Product["Product_Date"];
          $ProductTime = $objResult_Product["Product_Time"];
          $NewformatProductPrice =  number_format((float) $ProductPrice, 2, '.', ',');

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

// echo $count;
        ?>

<div class="col-xl-4 col-lg-4 col-md-4 div-center">            
              <div class="blog-index1">
              <a href="product_detail.php?ID=<?= $ProductID; ?>">
                <img src="model/upload/img/IMGProduct/<?= $ProductImg; ?>" alt="<?= $ProductName; ?>"
                 class="img-fluid img-index2 " >                 
              </a>      
              
              <h2 class="h2 text-center">
                <a href="product_detail.php?ID=<?= $ProductID; ?>" ><?= $ProductName; ?></a>
              </h2>
        </div>

</div>

<?PHP 
            if($count == 3){
              $count = 0;
              echo '</div> <div class="row">';
            }
          ?>

<?PHP } ?>

</div>
    </div>

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

${this.title}

Code Editor : search.php