Viewing file:  product.php (22.15 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?
include 'index_Include.php';
$Q = 1;
$Row = "SELECT * FROM product WHERE ";
if (isset($_GET[catalog_id])&&$_GET[catalog_id]!='') {
$catalog_id = $_GET[catalog_id];
if ($Q==1) {
$Row .= " (catalog_id = '$catalog_id')";
$Q++;
}
else{
$Row .= " AND ( catalog_id = '$catalog_id') ";
$Q++;
}
}
if (isset($_GET[product_status_id])&&$_GET[product_status_id]!='') {
$product_status_id = $_GET[product_status_id];
if ($Q==1) {
$Row .= " (product_status_id = '$product_status_id')";
$Q++;
}
else{
$Row .= " AND ( product_status_id = '$product_status_id') ";
$Q++;
}
}
if (isset($_GET[floor_id])&&$_GET[floor_id]!='') {
$floor_id = $_GET[floor_id];
if ($Q==1) {
$Row .= " (floor_id = '$floor_id')";
$Q++;
}
else{
$Row .= " AND ( floor_id = '$floor_id') ";
$Q++;
}
}
if (isset($_GET[zone_id])&&$_GET[zone_id]!='') {
$zone_id = $_GET[zone_id];
if ($Q==1) {
$Row .= " (zone_id = '$zone_id')";
$Q++;
}
else{
$Row .= " AND ( zone_id = '$zone_id') ";
$Q++;
}
}
if (isset($_GET[neighborhood_name])&&$_GET[neighborhood_name]!='') {
$neighborhood_name = $_GET[neighborhood_name];
if ($Q==1) {
$Row .= " (neighborhood_name = '$neighborhood_name')";
$Q++;
}
else{
$Row .= " AND ( neighborhood_name = '$neighborhood_name') ";
$Q++;
}
}
if (isset($_GET[stationairport_id])&&$_GET[stationairport_id]!='') {
$stationairport_id = $_GET[stationairport_id];
if ($Q==1) {
$Row .= " (stationairport_id = '$stationairport_id')";
$Q++;
}
else{
$Row .= " AND ( stationairport_id = '$stationairport_id') ";
$Q++;
}
}
if (isset($_GET[market_id])&&$_GET[market_id]!='') {
$market_id = $_GET[market_id];
$_SESSION['page'] = 'product.php?market_id='.$market_id.'';
if ($Q==1) {
$Row .= " (market_id = '$market_id')";
$Q++;
}
else{
$Row .= " AND ( market_id = '$market_id') ";
$Q++;
}
}
if (isset($_GET[province_id])&&$_GET[province_id]!='') {
$province_id = $_GET[province_id];
if ($Q==1) {
$Row .= " (province_id = '$province_id')";
$Q++;
}
else{
$Row .= " AND ( province_id = '$province_id') ";
$Q++;
}
}
if (isset($_GET[amphure_id])&&$_GET[amphure_id]!='') {
$amphure_id = $_GET[amphure_id];
if ($Q==1) {
$Row .= " (amphure_id = '$amphure_id')";
$Q++;
}
else{
$Row .= " AND ( amphure_id = '$amphure_id') ";
$Q++;
}
}
if (isset($_GET[district_id])&&$_GET[district_id]!='') {
$district_id = $_GET[district_id];
if ($Q==1) {
$Row .= " (district_id = '$district_id')";
$Q++;
}
else{
$Row .= " AND ( district_id = '$district_id') ";
$Q++;
}
}
if (isset($_GET[plot_name])&&$_GET[plot_name]!='') {
$plot_name = $_GET[plot_name];
if ($Q==1) {
$Row .= " (plot_name LIKE '%$plot_name%')";
$Q++;
}
else{
$Row .= " AND ( plot_name LIKE '%$plot_name%') ";
$Q++;
}
}
if (isset($_GET[product_zone])&&$_GET[product_zone]!='') {
$product_zone = $_GET[product_zone];
if ($Q==1) {
$Row .= " (product_zone LIKE '%$product_zone%')";
$Q++;
}
else{
$Row .= " AND ( product_zone LIKE '%$product_zone%') ";
$Q++;
}
}
if (isset($_GET[product_bedroom])&&$_GET[product_bedroom]!='') {
$product_bedroom = $_GET[product_bedroom];
if ($Q==1) {
$Row .= " (product_bedroom = '$product_bedroom')";
$Q++;
}
else{
$Row .= " AND ( product_bedroom = '$product_bedroom') ";
$Q++;
}
}
if (isset($_GET[product_bathroom])&&$_GET[product_bathroom]!='') {
$product_bathroom = $_GET[product_bathroom];
if ($Q==1) {
$Row .= " (product_bathroom = '$product_bathroom')";
$Q++;
}
else{
$Row .= " AND ( product_bathroom = '$product_bathroom') ";
$Q++;
}
}
if (isset($_GET[pricerange_id])&&$_GET[pricerange_id]!='') {
$pricerange_SL = " SELECT * FROM pricerange WHERE pricerange_id = '$_GET[pricerange_id]'";
$pricerange_QR = mysqli_query($con,$pricerange_SL);
$pricerange = mysqli_fetch_array($pricerange_QR);
if ($Q==1) {
$Row .= " ( product_price >= '$pricerange[pricerange_min]' ) ";
$Q++;
}
else{
$Row .= " AND ( product_price >= '$pricerange[pricerange_min]' ) ";
$Q++;
}
if ($Q==1) {
$Row .= " (product_price <= '$pricerange[pricerange_max]')";
$Q++;
}
else{
$Row .= " AND ( product_price <= '$pricerange[pricerange_max]') ";
$Q++;
}
}
if (isset($_GET[price_min])&&$_GET[price_min]!='') {
$price_min = $_GET[price_min];
if ($Q==1) {
$Row .= " (product_price >= '$price_min')";
$Q++;
}
else{
$Row .= " AND ( product_price >= '$price_min') ";
$Q++;
}
}
if (isset($_GET[price_max])&&$_GET[price_max]!='') {
$price_max = $_GET[price_max];
if ($Q==1) {
$Row .= " (product_price <= '$price_max')";
$Q++;
}
else{
$Row .= " AND ( product_price <= '$price_max') ";
$Q++;
}
}
if (isset($_GET[keyword])&&$_GET[keyword]!='') {
$keyword = $_GET['keyword'];
$keyword= str_replace("'","'",$keyword);
$keyword= str_replace("\"",""",$keyword);
if ($Q==1) {
$Row .= " ( product_search LIKE '%$keyword%' )";
$Q++;
}
else{
$Row .= " AND ( product_search LIKE '%$keyword%') ";
$Q++;
}
}
if ($Q==1) {
$Row = "SELECT * FROM product WHERE ".$product_web_sql."";
}
else{
$Row .= " AND (".$product_web_sql.") ";
$Q++;
}
$RowQuery = mysqli_query($con,$Row) or die ("Error Query [".$Row."]");
$Num_Rows = mysqli_num_rows($RowQuery);
$Per_page = 40; // Per page
$page = $_GET["page"];
if(!$_GET["page"]){
$page=1;
}
$Prev_page = $page-1;
$Next_page = $page+1;
$page_Start = (($Per_page*$page)-$Per_page);
if($Num_Rows<=$Per_page){
$Num_pages =1;
}
else if(($Num_Rows % $Per_page)==0){
$Num_pages =($Num_Rows/$Per_page) ;
}
else{
$Num_pages =($Num_Rows/$Per_page)+1;
$Num_pages = (int)$Num_pages;
}
$i=$page_Start+1;
$product_SL = $Row . " ORDER BY product_sort asc LIMIT $page_Start , $Per_page ";
$product_QR = mysqli_query($con,$product_SL);
?>
<!DOCTYPE html>
<html>
<head>
<?
if (isset($_GET[pricerange_id])&&$_GET[pricerange_id]!='') {
$pricerange_SL = " SELECT * FROM pricerange WHERE pricerange_id = '$_GET[pricerange_id]'";
$pricerange_QR = mysqli_query($con,$pricerange_SL);
$pricerange = mysqli_fetch_array($pricerange_QR);
?>
<title> <? echo $pricerange[pricerange_min]; ?> - <? echo $pricerange[pricerange_max]; ?> | <? echo $fixed[fixed_website]; ?> </title>
<meta name="description" content="<? echo $fixed[fixed_company]; ?> <? echo $fixed[fixed_topic]; ?>">
<meta name="keywords" content=" <? echo $pricerange[pricerange_min]; ?> - <? echo $pricerange[pricerange_max]; ?> ">
<meta name="author" content="<? echo $fixed[fixed_topic]; ?>">
<?
}
if (isset($_GET[catalog_id])&&trim($_GET[catalog_id])!='') {
$catalog_head_SL = " SELECT * FROM catalog WHERE catalog_id = '$_GET[catalog_id]'";
$catalog_head_QR = mysqli_query($con,$catalog_head_SL);
$catalog_head = mysqli_fetch_array($catalog_head_QR);
?>
<title> <? echo $catalog_head[catalog_name]; ?> | <? echo $fixed[fixed_website]; ?> </title>
<meta name="description" content="<? echo $fixed[fixed_company]; ?> <? echo $fixed[fixed_topic]; ?>">
<meta name="keywords" content="<? echo $catalog_head[catalog_name]; ?><? echo $catalog_head[catalog_detail]; ?> ">
<meta name="author" content="<? echo $fixed[fixed_topic]; ?>">
<?
}
if (isset($_GET[floor_id])&&trim($_GET[floor_id])!='') {
$floor_head_SL = " SELECT * FROM floor WHERE floor_id = '$_GET[floor_id]'";
$floor_head_QR = mysqli_query($con,$floor_head_SL);
$floor_head = mysqli_fetch_array($floor_head_QR);
?>
<title> <? echo $floor_head[floor_name]; ?> | <? echo $fixed[fixed_website]; ?> </title>
<meta name="description" content="<? echo $fixed[fixed_company]; ?> <? echo $fixed[fixed_topic]; ?>">
<meta name="keywords" content="<? echo $floor_head[floor_name]; ?><? echo $floor_head[floor_detail]; ?> ">
<meta name="author" content="<? echo $fixed[fixed_topic]; ?>">
<?
}
if (isset($_GET[product_status_id])&&trim($_GET[product_status_id])!='') {
$product_status_head_SL = " SELECT * FROM product_status WHERE product_status_id = '$_GET[product_status_id]'";
$product_status_head_QR = mysqli_query($con,$product_status_head_SL);
$product_status_head = mysqli_fetch_array($product_status_head_QR);
?>
<title> <? echo $product_status_head[product_status_name]; ?> | <? echo $fixed[fixed_website]; ?> </title>
<meta name="description" content="<? echo $fixed[fixed_company]; ?> <? echo $fixed[fixed_topic]; ?>">
<meta name="keywords" content="<? echo $product_status_head[product_status_name]; ?> ">
<meta name="author" content="<? echo $fixed[fixed_topic]; ?>">
<?
}
if (isset($_GET[province_id])&&trim($_GET[province_id])!='') {
$province_head_SL = " SELECT * FROM province WHERE province_id = '$_GET[province_id]'";
$province_head_QR = mysqli_query($con,$province_head_SL);
$province_head = mysqli_fetch_array($province_head_QR);
?>
<title> <? echo $province_head[province_name]; ?> | <? echo $fixed[fixed_website]; ?> </title>
<meta name="description" content="<? echo $fixed[fixed_company]; ?> <? echo $fixed[fixed_topic]; ?>">
<meta name="keywords" content="<? echo $province_head[province_name]; ?><? echo $province_head[province_detail]; ?> ">
<meta name="author" content="<? echo $fixed[fixed_topic]; ?>">
<?
}
if (isset($_GET[amphure_id])&&trim($_GET[amphure_id])!='') {
$amphure_head_SL = " SELECT * FROM amphure WHERE amphure_id = '$_GET[amphure_id]'";
$amphure_head_QR = mysqli_query($con,$amphure_head_SL);
$amphure_head = mysqli_fetch_array($amphure_head_QR);
?>
<title> <? echo $amphure_head[amphure_name]; ?> | <? echo $fixed[fixed_website]; ?> </title>
<meta name="description" content="<? echo $fixed[fixed_company]; ?> <? echo $fixed[fixed_topic]; ?>">
<meta name="keywords" content="<? echo $amphure_head[amphure_name]; ?><? echo $amphure_head[amphure_detail]; ?> ">
<meta name="author" content="<? echo $fixed[fixed_topic]; ?>">
<?
}
if (isset($_GET[district_id])&&trim($_GET[district_id])!='') {
$district_head_SL = " SELECT * FROM district WHERE district_id = '$_GET[district_id]'";
$district_head_QR = mysqli_query($con,$district_head_SL);
$district_head = mysqli_fetch_array($district_head_QR);
?>
<title> <? echo $district_head[district_name]; ?> | <? echo $fixed[fixed_website]; ?> </title>
<meta name="description" content="<? echo $fixed[fixed_company]; ?> <? echo $fixed[fixed_topic]; ?>">
<meta name="keywords" content="<? echo $district_head[district_name]; ?><? echo $district_head[district_detail]; ?> ">
<meta name="author" content="<? echo $fixed[fixed_topic]; ?>">
<?
}
if (isset($_GET[zone_id])&&trim($_GET[zone_id])!='') {
$zone_head_SL = " SELECT * FROM zone WHERE zone_id = '$_GET[zone_id]'";
$zone_head_QR = mysqli_query($con,$zone_head_SL);
$zone_head = mysqli_fetch_array($zone_head_QR);
?>
<title> <? echo $zone_head[zone_name]; ?> | <? echo $fixed[fixed_website]; ?> </title>
<meta name="description" content="<? echo $fixed[fixed_company]; ?> <? echo $fixed[fixed_topic]; ?>">
<meta name="keywords" content="<? echo $zone_head[zone_name]; ?> ">
<meta name="author" content="<? echo $fixed[fixed_topic]; ?>">
<?
}
if (isset($_GET[product_zone])&&trim($_GET[product_zone])!='') {
?>
<title> <? echo $product[product_zone]; ?> | <? echo $fixed[fixed_website]; ?> </title>
<meta name="description" content="<? echo $fixed[fixed_company]; ?> <? echo $fixed[fixed_topic]; ?>">
<meta name="keywords" content="<? echo $product[product_zone]; ?> ">
<meta name="author" content="<? echo $fixed[fixed_topic]; ?>">
<?
}
if (isset($_GET[stationairport_id])&&trim($_GET[stationairport_id])!='') {
$stationairport_head_SL = " SELECT * FROM stationairport WHERE stationairport_id = '$_GET[stationairport_id]'";
$stationairport_head_QR = mysqli_query($con,$stationairport_head_SL);
$stationairport_head = mysqli_fetch_array($stationairport_head_QR);
?>
<title> <? echo $stationairport_head[stationairport_name]; ?> | <? echo $fixed[fixed_website]; ?> </title>
<meta name="description" content="<? echo $fixed[fixed_company]; ?> <? echo $fixed[fixed_topic]; ?>">
<meta name="keywords" content="<? echo $stationairport_head[stationairport_name]; ?> ">
<meta name="author" content="<? echo $fixed[fixed_topic]; ?>">
<?
}
if (isset($_GET[plot_name])&&trim($_GET[plot_name])!='') {
?>
<title> <? echo $_GET[plot_name]; ?> | <? echo $fixed[fixed_website]; ?> </title>
<meta name="description" content="<? echo $fixed[fixed_company]; ?> <? echo $fixed[fixed_topic]; ?>">
<meta name="keywords" content="<? echo $_GET[plot_name]; ?><? echo $plot_name[catalog_detail]; ?> ">
<meta name="author" content="<? echo $fixed[fixed_topic]; ?>">
<?
}
if (isset($_GET[product_bedroom])&&trim($_GET[product_bedroom])!='') {
?>
<title> <? echo $_GET[product_bedroom]; ?> ห้องนอน | <? echo $fixed[fixed_website]; ?> </title>
<meta name="description" content="<? echo $fixed[fixed_company]; ?> <? echo $fixed[fixed_topic]; ?>">
<meta name="keywords" content="<? echo $_GET[product_bedroom]; ?> ห้องนอน ">
<meta name="author" content="<? echo $fixed[fixed_topic]; ?>">
<?
}
if (isset($_GET[product_bathroom])&&trim($_GET[product_bathroom])!='') {
?>
<title> <? echo $_GET[product_bathroom]; ?> ห้องน้ำ | <? echo $fixed[fixed_website]; ?> </title>
<meta name="description" content="<? echo $fixed[fixed_company]; ?> <? echo $fixed[fixed_topic]; ?>">
<meta name="keywords" content="<? echo $_GET[product_bathroom]; ?> ห้องน้ำ ">
<meta name="author" content="<? echo $fixed[fixed_topic]; ?>">
<?
}
if (isset($_GET[price_min])&&$_GET[price_min]!='') {
?>
<title> ราคาต่ำสุด : <? echo number_format($price_min); ?> | <? echo $fixed[fixed_website]; ?> </title>
<meta name="description" content="<? echo $fixed[fixed_company]; ?> <? echo $fixed[fixed_topic]; ?>">
<meta name="keywords" content="<? echo $fixed[fixed_company]; ?> <? echo $fixed[fixed_topic]; ?> ">
<meta name="author" content="<? echo $fixed[fixed_topic]; ?>">
<?
}
if (isset($_GET[price_max])&&$_GET[price_max]!='') {
?>
<title> ราคาสูงสุด : <? echo number_format($price_max); ?> | <? echo $fixed[fixed_website]; ?> </title>
<meta name="description" content="<? echo $fixed[fixed_company]; ?> <? echo $fixed[fixed_topic]; ?>">
<meta name="keywords" content="<? echo $fixed[fixed_company]; ?> <? echo $fixed[fixed_topic]; ?> ">
<meta name="author" content="<? echo $fixed[fixed_topic]; ?>">
<?
}
if (isset($_GET[keyword])&&$_GET[keyword]!='') {
?>
<title> ค้นหา : <? echo $keyword; ?> | <? echo $fixed[fixed_website]; ?> </title>
<meta name="description" content="<? echo $fixed[fixed_company]; ?> <? echo $fixed[fixed_topic]; ?>">
<meta name="keywords" content="<? echo $fixed[fixed_company]; ?> <? echo $fixed[fixed_topic]; ?> ">
<meta name="author" content="<? echo $fixed[fixed_topic]; ?>">
<?
}
if ($Q==1) {
?>
<title> อสังหาริมทรัพย์ทั้งหมด | <? echo $fixed[fixed_website]; ?> </title>
<meta name="description" content="<? echo $fixed[fixed_company]; ?> <? echo $fixed[fixed_topic]; ?>">
<meta name="keywords" content="<? echo $fixed[fixed_company]; ?> <? echo $fixed[fixed_topic]; ?> ">
<meta name="author" content="<? echo $fixed[fixed_topic]; ?>">
<?
}
?>
<? include 'index_head.php'; ?>
</head>
<body>
<? include 'index_navbar.php'; ?>
<div style="background-color: #f4f6f8;">
<div class="container" >
<div class="row">
<div class="col-md-12">
<div>
<? include 'index_search.php'; ?>
</div>
</div>
</div>
</div>
</div>
<div style="background-color: #f0f0f0;">
<div class="container between20">
<div class="row">
<div class="col-md-12 text-center">
<span class="page-topic color1 ">
<?
if (isset($_GET[pricerange_id])&&$_GET[pricerange_id]!='') {
$pricerange_SL = " SELECT * FROM pricerange WHERE pricerange_id = '$_GET[pricerange_id]'";
$pricerange_QR = mysqli_query($con,$pricerange_SL);
$pricerange = mysqli_fetch_array($pricerange_QR);
?>
ราคา <? echo number_format($pricerange[pricerange_min]); ?> - <? echo number_format($pricerange[pricerange_max]); ?>
<?
}
if (isset($_GET[market_id])&&trim($_GET[market_id])!='') {
$markettopic_SL = " SELECT * FROM market WHERE market_id = '$_GET[market_id]'";
$markettopic_QR = mysqli_query($con,$markettopic_SL);
$markettopic = mysqli_fetch_array($markettopic_QR);
?>
<? echo $markettopic[market_name]; echo " "; ?>
<?
}
if (isset($_GET[product_status_id])&&trim($_GET[product_status_id])!='') {
$product_statustopic_SL = " SELECT * FROM product_status WHERE product_status_id = '$_GET[product_status_id]'";
$product_statustopic_QR = mysqli_query($con,$product_statustopic_SL);
$product_statustopic = mysqli_fetch_array($product_statustopic_QR);
?>
<? echo $product_statustopic[product_status_name]; echo " "; ?>
<?
}
if (isset($_GET[plot_name])&&trim($_GET[plot_name])!='') {
?>
<? echo $_GET[plot_name]; echo " "; ?>
<?
}
if (isset($_GET[catalog_id])&&trim($_GET[catalog_id])!='') {
$catalogtopic_SL = " SELECT * FROM catalog WHERE catalog_id = '$_GET[catalog_id]'";
$catalogtopic_QR = mysqli_query($con,$catalogtopic_SL);
$catalogtopic = mysqli_fetch_array($catalogtopic_QR);
?>
<? echo $catalogtopic[catalog_name]; echo " "; ?>
<?
}
if (isset($_GET[floor_id])&&trim($_GET[floor_id])!='') {
$floortopic_SL = " SELECT * FROM floor WHERE floor_id = '$_GET[floor_id]'";
$floortopic_QR = mysqli_query($con,$floortopic_SL);
$floortopic = mysqli_fetch_array($floortopic_QR);
?>
<? echo $floortopic[floor_name]; echo " "; ?>
<?
}
if (isset($_GET[zone_id])&&trim($_GET[zone_id])!='') {
$zonetopic_SL = " SELECT * FROM zone WHERE zone_id = '$_GET[zone_id]'";
$zonetopic_QR = mysqli_query($con,$zonetopic_SL);
$zonetopic = mysqli_fetch_array($zonetopic_QR);
?>
<? echo $zonetopic[zone_name]; echo " "; ?>
<?
}
if (isset($_GET[product_zone])&&trim($_GET[product_zone])!='') {
?>
<? echo $_GET[product_zone]; echo " "; ?>
<?
}
if (isset($_GET[stationairport_id])&&trim($_GET[stationairport_id])!='') {
$stationairporttopic_SL = " SELECT * FROM stationairport WHERE stationairport_id = '$_GET[stationairport_id]'";
$stationairporttopic_QR = mysqli_query($con,$stationairporttopic_SL);
$stationairporttopic = mysqli_fetch_array($stationairporttopic_QR);
?>
<? echo $stationairporttopic[stationairport_name]; echo " "; ?>
<?
}
if (isset($_GET[province_id])&&trim($_GET[province_id])!='') {
$provincetopic_SL = " SELECT * FROM province WHERE province_id = '$_GET[province_id]'";
$provincetopic_QR = mysqli_query($con,$provincetopic_SL);
$provincetopic = mysqli_fetch_array($provincetopic_QR);
?>
<? echo $provincetopic[province_name]; echo " "; ?>
<?
}
if (isset($_GET[amphure_id])&&trim($_GET[amphure_id])!='') {
$amphuretopic_SL = " SELECT * FROM amphure WHERE amphure_id = '$_GET[amphure_id]'";
$amphuretopic_QR = mysqli_query($con,$amphuretopic_SL);
$amphuretopic = mysqli_fetch_array($amphuretopic_QR);
?>
<? echo $amphuretopic[amphure_name]; echo " "; ?>
<?
}
if (isset($_GET[district_id])&&trim($_GET[district_id])!='') {
$districttopic_SL = " SELECT * FROM district WHERE district_id = '$_GET[district_id]'";
$districttopic_QR = mysqli_query($con,$districttopic_SL);
$districttopic = mysqli_fetch_array($districttopic_QR);
?>
<? echo $districttopic[district_name]; echo " "; ?>
<?
}
if (isset($_GET[product_bedroom])&&trim($_GET[product_bedroom])!='') {
?>
<? echo $_GET[product_bedroom]; ?> ห้องนอน
<?
}
if (isset($_GET[product_bathroom])&&trim($_GET[product_bathroom])!='') {
?>
<? echo $_GET[product_bathroom]; ?> ห้องน้ำ
<?
}
if (isset($_GET[price_min])&&trim($_GET[price_min])!='') {
?>
ราคาต่ำสุด <? echo number_format($_GET[price_min]); ?>
<?
}
if (isset($_GET[price_max])&&trim($_GET[price_max])!='') {
?>
ราคาสูงสุด <? echo number_format($_GET[price_max]); ?>
<?
}
if (isset($_GET[keyword])&&$_GET[keyword]!='') {
?>
ค้นหา : <? echo $keyword; echo " "; ?>
<?
}
if ($Q==1) {
?>
อสังหาริมทรัพย์ทั้งหมด
<?
}
?>
<?
if ($Num_Rows=='0') { echo " (ไม่พบข้อมูล)"; }
else{
?>
<span class="size16 text-muted">
<? echo number_format($Num_Rows); ?> รายการ
</span>
<?
}
?>
</span>
</div>
</div>
</div>
</div>
<div class="container between20">
<div class="row">
<div class="col-md-12">
<div class="row">
<?
$MD=1;
while ($product = mysqli_fetch_array($product_QR)) {
if ($MD==1) {
?>
<div class="col-md-12">
<div class="row">
<?php
}
?>
<div class="col-md-3 col-xs-6">
<? include 'index_panel_product.php'; ?>
</div>
<?php
if ($MD==4) {
$MD=0;
?>
</div>
</div>
<?
}
$MD++;
}
if ($MD!=1) {
echo "</div></div>";
}
?>
</div>
<div class="row">
<div class="col-md-12 text-center">
<? include 'index_pagenum.php'; ?>
</div>
</div>
<div class="row margintop30" >
<div class="col-md-4">
<ul class="breadcrumb no-radius" >
<li>
<a onclick="goBack();" href="#">
กลับ
</a>
</li>
<li><a href="index.php">หน้าแรก</a></li>
<li class="active"><a href="product.php"> อสังหาริมทรัพย์ทั้งหมด </a></li>
</ul>
</div>
</div>
</div>
</div>
</div>
<!-- container -->
<? include 'index_footer.php'; ?>
</body>
</html>
|