Gecko [ myeducation.co.th ]

Name	Size	Permission
Structure	[ DIR ]	drwxr-xr-x
admin	[ DIR ]	drwxr-xr-x
assets	[ DIR ]	drwxr-xr-x
assets-new	[ DIR ]	drwxr-xr-x
font	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
model	[ DIR ]	drwxr-xr-x
1Head.php	6.88 KB	-rw-r--r--
2HeadMenu.php	11.58 KB	-rw-r--r--
3Footer.php	6.72 KB	-rw-r--r--
4End.php	581 B	-rw-r--r--
BannerCoverAll.php	1.83 KB	-rw-r--r--
aboutus.php	2.18 KB	-rw-r--r--
contact-us.php	2.49 KB	-rw-r--r--
content.php	4.77 KB	-rw-r--r--
detail.php	699 B	-rw-r--r--
detail_RecommendedProjects.php	5.09 KB	-rw-r--r--
detail_about.php	1.8 KB	-rw-r--r--
detail_banner.php	3.66 KB	-rw-r--r--
detail_consult.php	2.43 KB	-rw-r--r--
detail_news.php	5.29 KB	-rw-r--r--
detail_ourteam.php	2.96 KB	-rw-r--r--
detail_product.php	9.33 KB	-rw-r--r--
index.php	156 B	-rwxr-xr-x
news.php	3.68 KB	-rw-r--r--
our-services.php	3.84 KB	-rw-r--r--
package.json	14.21 KB	-rw-r--r--
product-detail.php	7.41 KB	-rw-r--r--
project-detail.php	17.72 KB	-rw-r--r--
project.php	3.68 KB	-rw-r--r--
properties.php	17.79 KB	-rw-r--r--
properties_detail.php	2.16 KB	-rw-r--r--
search.php	9.99 KB	-rw-r--r--

Code Editor : product-detail.php

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

$ProductID = trim($_GET['ID']);

$SQL_Product = "		
	SELECT product.Product_ID, product.ProductCategory_ID, product_category.ProductCategory_Name,
	product.ProductCategory2_ID, product.ProductCategory3_ID, product.StatusProduct_ID,product.Member_ID,
	status_product.StatusProduct_Name, member.Member_ID, member.Member_NameEN, member.Position_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_Sort
	FROM product
	INNER JOIN product_category ON product.ProductCategory_ID = product_category.ProductCategory_ID
	INNER JOIN status_product ON product.StatusProduct_ID = status_product.StatusProduct_ID
	INNER JOIN member ON product.Member_ID = member.Member_ID
	WHERE product.StatusProduct_ID = 1 AND product.Product_ID = $ProductID
	ORDER BY product.Product_ID 
	";

$objQuery_Product = $objConnect->query($SQL_Product);
$CountProduct = mysqli_num_rows($objQuery_Product);
while ($objResult_Product = mysqli_fetch_array($objQuery_Product)) {

$ProductID = $objResult_Product["Product_ID"];
	$ProductCategoryName = $objResult_Product["ProductCategory_Name"];
	$ProductName = $objResult_Product["Product_Name"];
	$ProductDetail = $objResult_Product["Product_Detail"];
	$ProductDetail2 = $objResult_Product["Product_Detail2"];
	$ProductDetail3 = $objResult_Product["Product_Detail3"];
	$ProductImg = $objResult_Product["Product_Img"];
	$ProductPrice = $objResult_Product["Product_Price"];
	$ProductUnit = $objResult_Product["Product_Unit"];

$ProductName = urldecode($ProductName);
	$ProductDetail = urldecode($ProductDetail);
	$ProductDetail2 = urldecode($ProductDetail2);
	$ProductDetail3 = urldecode($ProductDetail3);
	$ProductPrice_format = number_format($ProductPrice);

$sql_string_producttag2 = "
	SELECT product_tag.ProductTag_ID, product_tag.ProductCategory2_ID, product_category2.ProductCategory2_Name, 
	product_tag.ProductTag_Date, product_tag.ProductTag_Time , product_category2.ProductCategory_ID
	FROM product_tag 
	INNER JOIN product_category2 ON product_tag.ProductCategory2_ID = product_category2.ProductCategory2_ID
	INNER JOIN product_category ON product_category2.ProductCategory_ID = product_category.ProductCategory_ID
	WHERE product_tag.Product_ID = $ProductID AND product_category2.ProductCategory_ID = 39
	";
	$objQuery_producttag2 = $objConnect->query($sql_string_producttag2);
	$objQuery_producttag2D = $objConnect->query($sql_string_producttag2);

$sql_string_producttag = "
	SELECT product_tag.ProductTag_ID, product_tag.ProductCategory2_ID, product_category2.ProductCategory2_Name, 
	product_tag.ProductTag_Date, product_tag.ProductTag_Time , product_category2.ProductCategory_ID
	FROM product_tag 
	INNER JOIN product_category2 ON product_tag.ProductCategory2_ID = product_category2.ProductCategory2_ID
	INNER JOIN product_category ON product_category2.ProductCategory_ID = product_category.ProductCategory_ID
	WHERE product_tag.Product_ID = $ProductID AND product_category2.ProductCategory_ID = 40
	";
	$objQuery_producttag = $objConnect->query($sql_string_producttag);

$SQL_Img = "
	SELECT product_img.ProductImg_ID, product_img.Product_ID, product_img.ProductImg_Name, 
	product_img.ProductImg_Date, product_img.ProductImg_Time, product_img.ProductImg_Sort, product_img.ProductImg_Status
	FROM product_img
	WHERE product_img.Product_ID = '$ProductID'
	ORDER BY product_img.ProductImg_Sort
	";
	$objQuery_Img = $objConnect->query($SQL_Img);

.grow {
			transition: all .2s ease-in-out;
		}

.grow:hover {
			transform: scale(1.2);
		}

.owl-stage-outer {
			padding: 10px;
		}
	</style>

<?PHP
						while ($objResult_Img = mysqli_fetch_array($objQuery_Img)) {
							$ImgHomeImg = $objResult_Img["ProductImg_Name"];
							$ImgHomeSort = $objResult_Img["ProductImg_Sort"];
							$DataBase_ID = $objResult_Img["ProductImg_ID"];
							$HomeID = $objResult_Img["Product_ID"];
						?>

<?PHP
						}
						?>
					</div>

<div class="alert alert-dark alert-index1" role="alert">
						<div class="ma-b-2" ><strong> ที่ตั้ง : </strong> <?= $ProductDetail2; ?> </div>
						<div class="ma-b-2" ><strong> หมวดหมู่ : </strong> <?= $ProductCategoryName; ?> </div>
						<div class="ma-b-2" > <strong> ประเภท : </strong> 						
						<?PHP
						while ($objResult_producttag2D = mysqli_fetch_array($objQuery_producttag2D)) {
							$tagName2D = $objResult_producttag2D["ProductCategory2_Name"];
						?>
							<div class="proptypemod"><?= $tagName2D; ?></div>
						<?PHP } ?>
						</div>

<div class="ma-b-2"> <strong> พื้นที่รอบข้าง และ พื้นที่ใกล้เคียง : </strong> 								
							<?PHP
							while ($objResult_producttag = mysqli_fetch_array($objQuery_producttag)) {
								$tagName = $objResult_producttag["ProductCategory2_Name"];
							?>
								<div class="proptypemod"><?= $tagName; ?></div>
							<?PHP } ?>
						</div>
					
					</div>

</div>

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

$('.owl-carousel').owlCarousel({
				loop: true,
				margin: 10,
				nav: true,
				responsive: {
					0: {
						items: 1
					},
					600: {
						items: 1
					},
					1000: {
						items: 1
					}
				}
			});

});
	</script>

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

${this.title}

Code Editor : product-detail.php