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

<h3 class="text-center color-index2"> ค้นหาทรัพย์ </h3>

<?PHP
					$SQL_Category = "
		SELECT product_category.ProductCategory_ID, product_category.ProductCategory_Name,
		product_category.StatusProductCategory_ID, product_category.ProductCategory_Sort,
		status_productcategory.StatusProductCategory_Name,product_category.ProductCategory_img 
		FROM status_productcategory INNER JOIN product_category ON status_productcategory.StatusProductCategory_ID 
		= product_category.StatusProductCategory_ID
		WHERE product_category.StatusProductCategory_ID = 1 AND product_category.ProductCategory_ID != 39
		ORDER BY product_category.ProductCategory_Sort
		";
					$objQuery_Category = $objConnect->query($SQL_Category);

$SQL_Category2 = "
		SELECT product_category.ProductCategory_ID, product_category.ProductCategory_Name,
		product_category.StatusProductCategory_ID, product_category2.ProductCategory2_ID,
		product_category2.StatusProductCategory2_ID, product_category2.ProductCategory2_Sort,
		product_category2.ProductCategory2_Name
		FROM product_category2 INNER JOIN product_category 
		ON product_category2.ProductCategory_ID = product_category.ProductCategory_ID
		WHERE product_category2.StatusProductCategory2_ID = 1 AND product_category.ProductCategory_ID = 39
		ORDER BY product_category2.ProductCategory2_Sort
		";
					$objQuery_Category2 = $objConnect->query($SQL_Category2);

$SQL_Category2Nearby = "
		SELECT product_category.ProductCategory_ID, product_category.ProductCategory_Name,
		product_category.StatusProductCategory_ID, product_category2.ProductCategory2_ID,
		product_category2.StatusProductCategory2_ID, product_category2.ProductCategory2_Sort,
		product_category2.ProductCategory2_Name
		FROM product_category2 INNER JOIN product_category 
		ON product_category2.ProductCategory_ID = product_category.ProductCategory_ID
		WHERE product_category2.StatusProductCategory2_ID = 1 AND product_category.ProductCategory_ID = 40
		ORDER BY product_category2.ProductCategory2_Sort
		";
					$objQuery_Category2Nearby = $objConnect->query($SQL_Category2Nearby);

<div class="col-sm-3 col-md-3 col-lg-3 col-xl-3">
							<div class="mod_ossearch_right_co">
								<div class="labelfloatleft">
									<label class="font-large">
										หมวดหมู่ :
									</label>
								</div>

</div>
						</div>

<div class="col-sm-3 col-md-3 col-lg-3 col-xl-3">
							<div class="mod_ossearch_right_col">
								<div class="labelfloatleft">
									<label class="font-large">
										ประเภท :
									</label>
								</div>
								<select name="Category2" class="input-medium chosen">
									<option value="0">ทั้งหมด</option>

<?PHP
									while ($objResult_Category2 = mysqli_fetch_array($objQuery_Category2)) {
										$ProductCategoryID2 = $objResult_Category2["ProductCategory2_ID"];
										$ProductCategoryName2 = $objResult_Category2["ProductCategory2_Name"];
									?>
										<option value="<?= $ProductCategoryID2; ?>"><?= $ProductCategoryName2; ?></option>
									<?PHP } ?>
								</select>
							</div>
						</div>

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

</div>

<?PHP
					$SQL_province = "
						SELECT province_thaicreate.PROVINCE_ID, province_thaicreate.PROVINCE_CODE, province_thaicreate.PROVINCE_NAME, province_thaicreate.PROVINCE_NAME_ENG, province_thaicreate.GEO_ID FROM province_thaicreate 
						ORDER BY province_thaicreate.PROVINCE_NAME
						";
					$objQuery_province  = $objConnect->query($SQL_province);
					?>

<div class="mod_ossearch_right_co">
								<div class="labelfloatleft">
									<label class="font-large">
										จังหวัด :
									</label>
								</div>

<?PHP
										while ($objResult_province = mysqli_fetch_array($objQuery_province)) {

$ProvinceID = $objResult_province["PROVINCE_ID"];
											$ProvinceName = $objResult_province["PROVINCE_NAME"];

?>
											<option value="<?= $ProvinceID; ?>"><?= $ProvinceName; ?></option>
										<?PHP } ?>
									</select>
								</div>
							</div>

</div>

</div>

<div class="mod_ossearch_right_col">
								<div class="labelfloatleft">
									<label class="font-large">
										ห้องนอน :
									</label>
								</div>
								<select id="CategoryBedroom" name="CategoryBedroom" class="input-mini chosen" style="width:150px !important;">
									<option value="">ทั้งหมด</option>
									<option value="1">1+</option>
									<option value="2">2+</option>
									<option value="3">3+</option>
									<option value="4">4+</option>
									<option value="5">5+</option>
								</select>
							</div>

</div>

</div>
					</div>

<?PHP
							while ($objResult_Category2Nearby = mysqli_fetch_array($objQuery_Category2Nearby)) {
								$ProductCategoryID2Nearby = $objResult_Category2Nearby["ProductCategory2_ID"];
								$ProductCategoryName2Nearby = $objResult_Category2Nearby["ProductCategory2_Name"];
							?>
							<div class="col-sm-3 col-md-3 col-lg-3 col-xl-3">
								<div class="form-check">
									<input class="form-check-input" name="CategoryNearby<?=$ProductCategoryID2Nearby;?>" type="checkbox" value="<?= $ProductCategoryID2Nearby; ?>" id="flex<?=$ProductCategoryID2Nearby;?>">
									<label class="form-check-label pad-left-5 font-large" for="flex<?=$ProductCategoryID2Nearby;?>">
										<?= $ProductCategoryName2Nearby; ?>
									</label>
								</div>
								</div>

<?PHP } ?>
					</div>

</form>

</div>
		</div>

</div>
</div>

${this.title}

Code Editor : search.php