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

<?PHP
					$SQL_Category1 = "
					SELECT product_category.ProductCategory_ID , product_category.ProductCategory_Name,
					product_category.StatusProductCategory_ID
					FROM product_category
					WHERE product_category.StatusProductCategory_ID = 1 AND product_category.ProductCategory_ID NOT IN (39,40)
					ORDER BY product_category.ProductCategory_Name
					";

$number = 0;
					$objQuery_Category1 = $objConnect->query($SQL_Category1);
					while ($objResult_Category1 = mysqli_fetch_array($objQuery_Category1)) {
						$number++;
						$ProductCategoryID1 = $objResult_Category1["ProductCategory_ID"];
						$ProductCategoryName1 = $objResult_Category1["ProductCategory_Name"];

if($number % 2 == 0){
							//Even
							$CHKEvenOdd = "investpropwrap";
							$CHKfeatured = "descriptionfeatured bg-index1";
						}
						else{
							//Odd
							$CHKEvenOdd = "featuredpropwrap";
							$CHKfeatured = "descriptionfeatured bg-white";
						}

$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.ProductCategory_ID = $ProductCategoryID1
							ORDER BY product.Product_Sort 
							";
							// DESC

$objQuery_Product = $objConnect->query($SQL_Product);
							$CountProduct = mysqli_num_rows($objQuery_Product);

if( $CountProduct <= 0){
							}else{
					?>
						<div id='<?=$CHKEvenOdd;?>' class='qx-section'>
							<div class="qx-container">
								<div class="qx-rows">
									<div id='qx-row-34137' class='qx-row-wrap'>
										<div class='qx-row'>
											<div id="qx-column-15138" class="qx-column">
												<div class="qx-col-wrap">
													<div class="qx-elements-wrap">
													
														<div class="qx-element-wrap">
															<div id="qx-heading-60142" class="qx-element qx-element-heading-v2" qx-scrollspy="cls:qx-animation-slide-top-medium;repeat:ture;">
																<h3> <span> <?= $ProductCategoryName1; ?> </span> </h3>
															</div>
														</div>

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

$ProductID = $objResult_Product["Product_ID"];
																		$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_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_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);

?>
																		<div class="col-md-4 col-xs-6 element_property">
																			<div class="image_property" style="margin-left:0px !important;">

<a href="product-detail.php?ID=<?=$ProductID;?>" title="<?= $ProductName; ?>">
																						<img src="model/upload/img/IMGProduct/<?= $ProductImg; ?>" data-original="/model/upload/img/IMGProduct/<?= $ProductImg; ?>" class="img-prop oslazy" alt="<?= $ProductName; ?>" />
																					</a>
																			</div>

<?PHP
																					while ($objResult_producttag2 = mysqli_fetch_array($objQuery_producttag2)) {

$tagName2 = $objResult_producttag2["ProductCategory2_Name"];

?>
																						<div class="proptypemod"><?= $tagName2; ?></div>
																					<?PHP } ?>

<a href="product-detail.php?ID=<?=$ProductID;?>" title="<?= $ProductName; ?>"><?= $ProductName; ?></a>

</h3>
																					</div>
																					<div class="addresswrap moduleelement">
																						<i class="fas fa-map-marker-alt"></i>
																						<?= $ProductDetail2; ?>
																					</div>

<div class="proppriceslide moduleelement">
																						<span class="pricesale">
																							<?= $ProductPrice_format; ?></span> /
																						<span id="mthpayment"><?= $ProductUnit; ?></span>

</div>

<div class="propcategory moduleelement hidden-xs">
																						<span class='propcateg'>
																							<?PHP
																							while ($objResult_producttag = mysqli_fetch_array($objQuery_producttag)) {

$tagName = $objResult_producttag["ProductCategory2_Name"];

?>
																								<a href="product-detail.php?ID=<?=$ProductID;?>"><?= $tagName; ?></a>
																							<?PHP } ?>
																						</span>

<?PHP
																						if ($ProductDetail3 == "-") {
																							$ProductDetail3 = "";
																							$ProductDetail3_square = "";
																						} else {
																							$ProductDetail3 = $ProductDetail3;
																							$ProductDetail3_square = "<i class='fas fa-square'></i>";
																						}
																						?>
																						<span class="additional_information">
																							<?= $ProductDetail3_square; ?> <?= $ProductDetail3; ?>
																						</span>

</div>

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

</div>

</div>
														</div>

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

${this.title}

Code Editor : detail_product.php