Gecko [ myeducation.co.th ]

Name	Size	Permission
Structure	[ DIR ]	drwxr-xr-x
UserFiles	[ DIR ]	drwxr-xr-x
admin	[ DIR ]	drwxr-xr-x
css	[ DIR ]	drwxr-xr-x
fonts	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
model	[ DIR ]	drwxr-xr-x
1Head.php	8.88 KB	-rw-r--r--
2HeadMenu.php	2.27 KB	-rw-r--r--
2banner.php	105 B	-rw-r--r--
2banner_mo.php	9.16 KB	-rw-r--r--
2banner_pc.php	3.81 KB	-rw-r--r--
3Footer.php	227 B	-rw-r--r--
4End.php	1.39 KB	-rw-r--r--
about.php	3.46 KB	-rw-r--r--
banner_next_country.php	3.1 KB	-rw-r--r--
banner_next_student_reviews.ph...	3.13 KB	-rw-r--r--
call_contact_mo.php	16.06 KB	-rw-r--r--
call_contact_pc.php	4.2 KB	-rw-r--r--
city.php	7.28 KB	-rw-r--r--
contact.php	5.92 KB	-rw-r--r--
country.php	5.72 KB	-rw-r--r--
detail.php	284 B	-rw-r--r--
detail_gallery.php	4.28 KB	-rw-r--r--
detail_mo.php	39.4 KB	-rw-r--r--
detail_promotion.php	3.01 KB	-rw-r--r--
detail_student_reviews.php	2.89 KB	-rw-r--r--
detail_tip.php	3.56 KB	-rw-r--r--
footer_mo.php	6.66 KB	-rw-r--r--
footer_pc.php	6.79 KB	-rw-r--r--
gallery.php	7.37 KB	-rw-r--r--
head_footer_3.php	3.59 KB	-rw-r--r--
hotpromotion.php	6.83 KB	-rw-r--r--
index.php	171 B	-rw-r--r--
index_country.php	121 B	-rw-r--r--
index_country_mo.php	4.38 KB	-rw-r--r--
index_country_pc.php	4 KB	-rw-r--r--
index_gallery.php	9.77 KB	-rw-r--r--
index_hot_promotion.php	9.2 KB	-rw-r--r--
index_student_reviews.php	9.87 KB	-rw-r--r--
index_video.php	4.54 KB	-rw-r--r--
shool.php	4.71 KB	-rw-r--r--
student_reviews.php	6.77 KB	-rw-r--r--
tip.php	7.84 KB	-rw-r--r--

Code Editor : shool.php

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

if (empty($_GET['ID'])) {
  $Product_ID  = 0;
} else {
  $Product_ID = trim($_GET['ID']);
}

if (empty($_GET['N'])) {
  $ProductCategory_Name  = 0;
} else {
  $ProductCategory_Name = trim($_GET['N']);
}

if ($Product_ID == 0) {
  $Chk_SQL = "";
} else {
  $Chk_SQL = "
  AND
  product.Product_ID = $Product_ID AND 
  product.Product_Name = '$ProductCategory_Name'
  ";
}

$Str_SQL = "
  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 , product.Product_Document
  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 $Chk_SQL
  ORDER BY product.Product_ID DESC
  ";
$objQuery = $objConnect->query($Str_SQL);

$SQL_tag = "
SELECT product_tag.ProductTag_ID , product_tag.ProductCategory2_ID , product_category2.ProductCategory2_Name,
product_tag.Product_ID
FROM product_tag 
INNER JOIN product_category2 ON product_tag.ProductCategory2_ID = product_category2.ProductCategory2_ID
WHERE Product_ID = $Product_ID
ORDER BY product_category2.ProductCategory2_Name ASC
";
$objQuery_tag = $objConnect->query($SQL_tag);

<?PHP
while ($objResult_Product = mysqli_fetch_array($objQuery)) {

$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"];
  $ProductDetail2 = $objResult_Product["Product_Detail2"];
  $ProductDetail = $objResult_Product["Product_Detail"];
  $ProductID = $objResult_Product["Product_ID"];
  $ProductDocument = $objResult_Product["Product_Document"];
  $ProductDate = $objResult_Product["Product_Date"];
  $NewformatProductPrice =  number_format((float) $ProductPrice, 2, '.', ',');

if ($ProductDetail2  == "<p>-</p>") {
    $CHK_ProductDetail2 = "";
  } else {
    $CHK_ProductDetail2 =  $ProductDetail2;
  }

$Detail = str_replace('http://myeducation.co.th/',"",$CHK_ProductDetail2);

if ($ProductDetail3  == "-" or $ProductDetail3  == "DETAIL3") {
    $CHK_ProductDetail3 = "";
  } else {
    $CHK_ProductDetail3 =  $ProductDetail3;
  }

$sql_img_list = "
			SELECT ProductImg_ID , Product_ID , ProductImg_Name , ProductImg_Date , ProductImg_Time
			ProductImg_Sort , ProductImg_Status
			FROM product_img
			WHERE Product_ID = '$ProductID'
			";
  $objQuery_imglist = $objConnect->query($sql_img_list);
  $objQuery_imglist2 = $objConnect->query($sql_img_list);
  $CHK_imglist = mysqli_num_rows($objQuery_imglist);

?>
  <section style="background: #ebebeb;">
    <div class="container" style="padding-top: 0px;padding-bottom: 120px;padding: 40px;">
      
      <div class="section-content">
        <div class="row">
          <div class="col-md-12">
            <h2 class="title text-white" style="color: #0b1592!important;font-size: 26px;font-weight: 600;text-align: center;"><?= $ProductName; ?></h2>
            <hr style="border-bottom: 4px solid #FF9800;">

<?PHP
}
?>

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

${this.title}

Code Editor : shool.php