Viewing file: product_detail.php (26.81 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?
include 'index_Include.php'; $_SESSION['page'] = 'product.php';
if (isset($_GET[product_id])){ $_SESSION[product_id] = $_GET[product_id]; }
$product_SL = " SELECT * FROM product WHERE product_id = '$_SESSION[product_id]' AND ".$product_web_sql.""; $product_QR = mysqli_query($con,$product_SL); $product = mysqli_fetch_array($product_QR);
$product_id = $product[product_id]; $product_name = $product[product_name];
if (trim($_SERVER[HTTP_ACCEPT_LANGUAGE])!='') { $view = session_id(); $view_date = date('Y-m-d');
$sql = "select * from view where view_sesion = '$view' AND product_id = '$product[product_id]' "; $result = mysqli_query($con,$sql); $Check_Online = mysqli_num_rows($result);
if($Check_Online == 0 ){ $view = "INSERT INTO `view` (`view_sesion`,`product_id`,`view_id`, `view_date`, `view_ip`, `view_time`, `view_browser`, `view_language`) VALUES ('$view','$product[product_id]',NULL,'$view_date','$_SERVER[REMOTE_ADDR] ', NOW(),'$_SERVER[HTTP_USER_AGENT]','$_SERVER[HTTP_ACCEPT_LANGUAGE]')"; $viewQuery = mysqli_query($con,$view); } }
?>
<!DOCTYPE html> <html> <head> <title> <? echo $product[product_name]; ?> </title> <meta name="keywords" content=" <? echo $product[product_name]; ?>"> <meta name="description" content=" <? echo $product[product_detail]; ?> "> <meta name="author" content=" <? echo $product[product_name]; ?>"> <? include 'index_head.php'; ?>
<meta property="og:image" content="http://<? echo $fixed[fixed_website]; ?>/Files/product_photo/<? echo $product[product_photo]; ?>" /> <meta property="og:title" content="<? echo $product[product_name]; ?>" /> <meta property="og:description"content="<? echo $product[product_detail]; ?>"/> </head> <body> <? include 'index_navbar.php'; ?> <div style="background-color: #f0f0f0;"> <div class="container between20"> <div class="row"> <div class="col-md-12 text-center"> <span class="page-topic color1 "> <? echo $product[product_name]; ?> </span> </div> </div> </div> </div> <div class="container between20"> <div class="row"> <div class="col-md-12 resize text-center"> <p class="size18 text-muted"> <span class="glyphicon glyphicon-map-marker"></span> <? $province_SL = " SELECT * FROM province WHERE province_id = '$product[province_id]'"; $province_QR = mysqli_query($con,$province_SL); $province = mysqli_fetch_array($province_QR); if (isset($province[province_id])||$province[province_id]!='') { ?> <span> <? echo $province[province_name]; ?> </span> <? } $amphure_SL = " SELECT * FROM amphure WHERE amphure_id = '$product[amphure_id]'"; $amphure_QR = mysqli_query($con,$amphure_SL); $amphure = mysqli_fetch_array($amphure_QR); if (isset($amphure[amphure_id])||$amphure[amphure_id]!='') { ?> <span> <? echo $amphure[amphure_name]; ?> </span> <? } $district_SL = " SELECT * FROM district WHERE district_id = '$product[district_id]'"; $district_QR = mysqli_query($con,$district_SL); $district = mysqli_fetch_array($district_QR); if (isset($district[district_id])||$district[district_id]!='') { ?> <span> <? echo $district[district_name]; ?> </span> <? } ?> </p> </div> </div> <div class="row "> <div class="col-md-8 paddingbottom15"> <div id="custom_carousel" class="carousel slide" data-ride="carousel" data-interval="false"> <div class="carousel-inner "> <div class="item active"> <div class="img60"> <img style="cursor: zoom-in;" id="myImgmain<?php echo $product[product_id]; ?>" src="Files/product_photo/<?php echo $product[product_photo]; ?>" /> </div> </div> <div id="myModal" class="w3-modal"> <span class="zoom-close w3-close">×</span> <img class="w3-modal-content w3-close" id="img01"> </div> <script> var w3modal = document.getElementById("myModal"); var img = document.getElementById("myImgmain<?php echo $product[product_id]; ?>"); var modalImg = document.getElementById("img01"); img.onclick = function(){ w3modal.style.display = "block"; modalImg.src = this.src; } var span = document.getElementsByClassName("w3-close")[0]; span.onclick = function() { w3modal.style.display = "none"; }
window.onclick = function(event) { if (event.target == w3modal) { w3modal.style.display = "none"; } } </script>
<? $product_picture_SL = " SELECT * FROM product_picture WHERE product_id = '$product_id' ORDER BY product_picture_sort ASC"; $product_picture_QR = mysqli_query($con,$product_picture_SL); $product_picture_Row = mysqli_num_rows($product_picture_QR); $i=1; while ($product_picture = mysqli_fetch_array($product_picture_QR)) { $i++; ?> <div class="item"> <div class="img60"> <img style="cursor: zoom-in;" id="myImg<?php echo $product_picture[product_picture_id]; ?>" src="Files/product_picture_photo/<?php echo $product_picture[product_picture_photo]; ?>" /> </div> </div> <div id="myModal" class="w3-modal"> <span class="zoom-close w3-close">×</span> <img class="w3-modal-content w3-close" id="img01"> </div> <script> var w3modal = document.getElementById("myModal"); var img = document.getElementById("myImg<?php echo $product_picture[product_picture_id]; ?>"); var modalImg = document.getElementById("img01"); img.onclick = function(){ w3modal.style.display = "block"; modalImg.src = this.src; } var span = document.getElementsByClassName("w3-close")[0]; span.onclick = function() { w3modal.style.display = "none"; }
window.onclick = function(event) { if (event.target == w3modal) { w3modal.style.display = "none"; } } </script> <?php } ?> </div> <a class="left carousel-control" href="#custom_carousel" data-slide="prev"> <span class="glyphicon glyphicon-chevron-left"></span> <span class="sr-only">Previous</span> </a> <a class="right carousel-control" href="#custom_carousel" data-slide="next"> <span class="glyphicon glyphicon-chevron-right"></span> <span class="sr-only">Next</span> </a> </div>
<div class="row hidden-xs hidden-sm"> <div class="col-md-12"> <div class="controls"> <ul class="nav"> <div class="row"> <div class="col-md-2 "> <li data-target="#custom_carousel" data-slide-to="0" class="active"> <a href="#"> <div class="img90 margintop15" > <img src="Files/product_photo/<?php echo $product[product_photo]; ?>" class="full " > </div> </a> </li> </div> <? $product_picture_SL = " SELECT * FROM product_picture WHERE product_id = '$product_id' ORDER BY product_picture_sort ASC"; $product_picture_QR = mysqli_query($con,$product_picture_SL); $product_picture_Row = mysqli_num_rows($product_picture_QR); $product_picture_Number =1; while ($product_picture = mysqli_fetch_array($product_picture_QR)) { ?> <div class="col-md-2 "> <li data-target="#custom_carousel" data-slide-to="<? echo $product_picture_Number; ?>"> <a href="#"> <div class="img90 margintop15" > <img src="Files/product_picture_photo/<?php echo $product_picture[product_picture_photo]; ?>" class="full " > </div> </a> </li> </div> <? $product_picture_Number++; } ?> </div> </ul> </div> </div> </div> </div> <!-- 6 --> <div class="col-md-4">
<div class="row"> <div class="col-md-12"> <div class="panel panel-default boxsha2 no-border " > <div class="panel-body">
<?
$product_status_panel_SL = " SELECT * FROM product_status WHERE product_status_id = '$product[product_status_id]'"; $product_status_panel_QR = mysqli_query($con,$product_status_panel_SL); $product_status_panel = mysqli_fetch_array($product_status_panel_QR); if (isset($product_status_panel[product_status_id])) { if ($product_status_panel[product_status_name]=='ว่าง') { ?> <span class=" hide1 btn btn-success margintop15" style="padding: 3px 5px;margin-top: 2px;"> สถานะ <? echo $product_status_panel[product_status_name]; ?> </span> <? } if ($product_status_panel[product_status_name]=='จอง') { ?> <span class=" hide1 btn btn-danger margintop15" style="padding: 3px 5px;margin-top: 2px;"> สถานะ <? echo $product_status_panel[product_status_name]; ?> </span> <? } ?>
<? } ?>
<? $floor_SL = " SELECT * FROM floor WHERE floor_id = '$product[floor_id]'"; $floor_QR = mysqli_query($con,$floor_SL); $floor = mysqli_fetch_array($floor_QR); if (!isset($floor[floor_id])||$floor[floor_id]=='') { } else{ ?> <p class="btn btn-main2 margintop15" style="padding: 3px 5px;"> <?echo $floor[floor_name]; ?> </p> <? } ?>
<? $market_panel_SL = " SELECT * FROM market WHERE market_id = '$product[market_id]'"; $market_panel_QR = mysqli_query($con,$market_panel_SL); $market_panel = mysqli_fetch_array($market_panel_QR); if (isset($market_panel[market_id])) { ?> <p class="btn btn-main2 margintop15" style="padding: 3px 5px;"> <? echo $market_panel[market_word]; ?> </p> <? } ?> <? $catalog_panel_SL = " SELECT * FROM catalog WHERE catalog_id = '$product[catalog_id]'"; $catalog_panel_QR = mysqli_query($con,$catalog_panel_SL); $catalog_panel = mysqli_fetch_array($catalog_panel_QR); if (isset($catalog_panel[catalog_id])) { ?> <p class="btn btn-main2 margintop15" style="padding: 3px 5px;"> <? echo $catalog_panel[catalog_name]; ?> </p> <? } if (isset($product[product_bedroom])&&trim($product[product_bedroom])!=''&&trim($product[product_bedroom])!='0') { ?> <p class="btn btn-main2 margintop15" style="padding: 3px 5px;"> <? echo $product[product_bedroom]; ?> <i class="fa fa-bed"></i> </p> <? } if (isset($product[product_bathroom])&&trim($product[product_bathroom])!=''&&trim($product[product_bathroom])!='0') { ?> <p class="btn btn-main2 margintop15" style="padding: 3px 5px;"> <? echo $product[product_bathroom]; ?> <i class="fa fa-bath"></i> </p> <? } // -- if (isset($product[product_code])&&trim($product[product_code])!='') { ?> <p class=" size17 margintop15"> <? echo " <span class='bold'> รหัสทรัพย์สิน : </span> "; echo $product[product_code]; ?> </p> <? } // -- if (isset($product[features_name])&&trim($product[features_name])!='') { ?> <p class=" size17 margintop15"> <? echo " "; echo $product[features_name]; ?> </p> <? }
if (isset($product[product_price])&&trim($product[product_price])!=''&&trim($product[product_price])!='0') {
?> <p class=" size17 bold"> <? if (isset($product[product_rebate])&&trim($product[product_rebate])!=''&&trim($product[product_rebate])!='0') { ?> <span class="color1" style="text-decoration:line-through"> <? echo number_format($product[product_rebate]); ?> </span> <? } ?> <? echo number_format($product[product_price]); ?> <? if (isset($product[product_charges])&&trim($product[product_charges])!=''&&trim($product[product_charges])!='0') { echo " "; echo $product[product_charges]; } ?> </p> <? } $zone_panel_SL = " SELECT * FROM zone WHERE zone_id = '$product[zone_id]'"; $zone_panel_QR = mysqli_query($con,$zone_panel_SL); $zone_panel = mysqli_fetch_array($zone_panel_QR); if (isset($zone_panel[zone_id])) { ?> <p class="size17"> <? echo " <span class='bold'> เขต : </span> "; echo $zone_panel[zone_name]; ?> </p> <? } if (isset($product[product_zone])&&trim($product[product_zone])!='') { ?> <p class="size17"> <? echo " <span class='bold'> โซนหรือถนน : </span> "; echo $product[product_zone]; ?> </p> <? } if (isset($product[product_detail])&&trim($product[product_detail])!='') { ?> <p class=" size17"> <? echo " <span class='bold'> บ้านเลขที่ : </span> "; echo $product[product_detail]; ?> </p> <? } if (isset($product[product_area])&&trim($product[product_area])!='') { ?> <p class=" size17"> <? echo " <span class='bold'> พื้นที่ใช้สอย : </span> "; echo $product[product_area]; ?> ตารางวา </p> <? } if (isset($product[product_estate_rai])&&trim($product[product_estate_rai])!='') { ?> <p class=" size17"> <? echo "<span class='bold'> เนื้อที่ : </span> "; ?> <? if (isset($product[product_estate_rai])&&trim($product[product_estate_rai])!='') { echo $product[product_estate_rai]; echo " ไร่ "; } if (isset($product[product_estate_ngan])&&trim($product[product_estate_ngan])!='') { echo $product[product_estate_ngan]; echo " งาน "; } if (isset($product[product_estate_wa])&&trim($product[product_estate_wa])!='') { echo $product[product_estate_wa]; echo " ตารางวา "; } ?> </p> <? } if (isset($product[product_link])&&trim($product[product_link])!='') { ?> <p class=" size17" style="overflow: hidden;"> <? echo " <span class='bold'> เดินทางไปบ้านหลังนี้ : </span> "; ?> <? if (isset($_SESSION['member_online_id']) && trim($_SESSION['member_online_id'])!="") { ?> <a href="http://<? echo $product[product_link]; ?>" target="_blank" > <span class="glyphicon glyphicon-new-window"> <? echo $product[product_link]; ?> </span> </a> <? } else{ ?> สำหรับสมาชิกเท่านั้น <? } ?> </p> <? } if (isset($product[product_owner])&&trim($product[product_owner])!='') { ?> <p class=" size17"> <? echo " <span class='bold'> เจ้าของทรัพย์ : </span> "; echo $product[product_owner]; ?> </p> <? } if (isset($product[product_condition])&&trim($product[product_condition])!='') { ?> <p class=" size17"> <? echo " <span class='bold'> ผู้ขาย : </span> "; echo $product[product_condition]; ?> </p> <? } ?> </div> </div> </div> </div>
<? $salesteam_SL = " SELECT * FROM salesteam WHERE salesteam_id = '$product[salesteam_id]'"; $salesteam_QR = mysqli_query($con,$salesteam_SL); $salesteam = mysqli_fetch_array($salesteam_QR); if (isset($salesteam[salesteam_id])&&$salesteam[salesteam_id]!='') { ?> <div style="padding: 0px 30%;"> <a target="_blank" href="salesteam.php?salesteam_id=<? echo $salesteam[salesteam_id]; ?>"> <? if (isset($salesteam[salesteam_photo])&&trim($salesteam[salesteam_photo])) { ?> <div class="img100" > <img style="border-radius: 500px;" class="boxsha4 full" src="Files/salesteam_photo/<? echo $salesteam[salesteam_photo]; ?>" /> </div> <? } else{ ?> <div class="img100 bg1" style=" border-radius: 500px !important;"> <div style="position: absolute;top: 45%;text-align: center; -webkit-text-stroke: 0.5px white;color: white;font-size: 15px;width: 100%;"> <?if($_SESSION[Language]== "Thailand"){ echo $salesteam[salesteam_name]; } else if($salesteam[salesteam_name_eng]!=''){ echo $salesteam[salesteam_name_eng]; }else{ echo $salesteam[salesteam_name];} ?> </div> </div> <? } ?> </a> </div> <div class="text-center"> <p style="font-size: 18px;" class="hide2 color1 marginbottom4"> <? echo $salesteam[salesteam_name]; ?> </p> <p class="text-black"> <? $salesteam_tel= str_replace("-","",$salesteam[salesteam_tel]); ?> <a style="font-size: 18px;" target="_blank" href="tel:<? echo $salesteam_tel; ?>"> <span class="glyphicon glyphicon-earphone"></span> <? echo $salesteam[salesteam_tel]; ?> </a> </p> </div> <? } ?>
</div> </div> <!-- row --> <!-- row --> <div class="row margintop30"> <div class="col-md-8 "> <? $gallery_SL = " SELECT * FROM gallery WHERE gallery_code = 'product_id$product[product_id]' ORDER BY gallery_sort IS NULL ASC, gallery_sort ASC"; $gallery_QR = mysqli_query($con,$gallery_SL); $gallery_Row = mysqli_num_rows($gallery_QR); if (isset($product[product_review])&&trim($product[product_review]!='')||$gallery_Row>0) { ?> <div class="panel panel-default boxsha2 no-border " > <div class="panel-body"> <div class="row Review paddingbottom15"> <div class="col-md-12 margintop10"> <p class="page-topic "> <?php echo $product[product_name]; ?> </p> <p> <hr> </p> </div> <div class="col-md-12"> <p class="page-topic "> รายละเอียด : </p> </div> <div class="col-md-12 Review"><?php echo $product[product_review]; ?></div> <div class="col-md-12"> <? while ($gallery = mysqli_fetch_array($gallery_QR)) { ?> <? if (isset($gallery[gallery_photo])&&trim($gallery[gallery_photo])!='') { ?> <div class="margintop15"> <img src="Files/gallery_photo/<?php echo $gallery[gallery_photo]; ?>" class="full " /> </div> <? } ?> <? if (isset($gallery[gallery_video])&&trim($gallery[gallery_video])!='') { ?> <div class="margintop15"> <video width="100%" height="auto" controls class=""><source src="Files/gallery_video/<? echo $gallery[gallery_video]; ?>" type="video/mp4"> </video> </div> <? } ?> <? if (isset($gallery[gallery_youtube])&&trim($gallery[gallery_youtube])!='') { ?> <div class="margintop15"> <div class="embed-responsive embed-responsive-16by9"> <iframe class="" src="<?php echo $gallery['gallery_youtube']; ?>?rel=0&controls=0&showinfo=0" frameborder="0" allow="autoplay; encrypted-media" allowfullscreen></iframe> </div> </div> <? } ?> <? if (isset($gallery[gallery_facebook])&&trim($gallery[gallery_facebook])!='') { ?> <div class="margintop15"> <div class="embed-responsive embed-responsive-16by9"> <iframe class="" src="https://www.facebook.com/plugins/video.php?href=<?php echo $gallery['gallery_facebook']; ?>&show_text=0&width=269" style="border:none;overflow:hidden" scrolling="no" frameborder="0" allowTransparency="true" allowFullScreen="true"></iframe> </div> </div> <? } ?> <? if (isset($gallery[gallery_review])&&trim($gallery[gallery_review])!='') { ?> <div class="margintop15"> <?php echo $gallery[gallery_review]; ?> </div> <? } ?> <? if (isset($gallery[gallery_link])&&trim($gallery[gallery_link])!='') { ?> <div class="margintop15"> <a target="_blank" class="btn btn-default" href="http://<?php echo $gallery[gallery_link]; ?>"> <span class="glyphicon glyphicon-link"></span> <?php echo $gallery[gallery_link]; ?> </a> </div> <? } ?> <? if (isset($gallery[gallery_download])&&trim($gallery[gallery_download])!='') { ?> <div class="margintop15"> <a target="_blank" class="btn btn-default" href="Files/gallery_download/<?php echo $gallery[gallery_download]; ?>"> <span class="glyphicon glyphicon-download"></span> <?php echo $gallery[gallery_download]; ?> </a> </div> <? } ?> <? } ?> </div> </div> </div> </div> <? } ?>
<? if (isset($product[product_googlemaps])&&trim($product[product_googlemaps])!='') { ?> <div class="row"> <div class="col-md-12"> <div class="panel panel-default boxsha2 no-border margintop15 " > <div class="panel-body">
<? if (isset($_SESSION['member_online_id']) && trim($_SESSION['member_online_id'])!="") { ?> <div class="embed-responsive embed-responsive-16by9"> <? echo $product[product_googlemaps]; ?> </div> <? } else{ ?> <p> สำหรับสมาชิกเท่านั้น จะเห็นตำแหน่งแผนที่ </p> <div class="embed-responsive embed-responsive-16by9"> <iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d7960340.516073458!2d98.87346097425129!3d13.05369311955807!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x304d8df747424db1%3A0x9ed72c880757e802!2z4Lib4Lij4Liw4LmA4LiX4Lio4LmE4LiX4Lii!5e0!3m2!1sth!2sth!4v1665933785059!5m2!1sth!2sth" width="600" height="450" style="border:0;" allowfullscreen="" loading="lazy" referrerpolicy="no-referrer-when-downgrade"></iframe> </div> <? } ?>
</div> </div> </div> </div> <? } ?>
</div> <!-- 8 --> <div class="col-md-4"> <div class="row "> <div class="col-md-12">
<div class="panel panel-default boxsha2 no-border " > <div class="panel-body"> <p class="font1 size20 margintop15"> สนใจสอบถามรายละเอียด </p> <? $social_SL = " SELECT * FROM social ORDER BY social_sort ASC "; $social_QR = mysqli_query($con,$social_SL); while ($social = mysqli_fetch_array($social_QR)) { ?> <p class="hide1" title="<?php echo $social[social_name]; ?>"> <? if (isset($social[social_link])&&$social[social_link]!='') {
if ($social[social_type]=='Tel') { ?> <a style="text-align: left;" class="padding5 size17 text-black" href="tel:<?php echo $social[social_link]; ?>" target="_blank"> <? if (isset($social[social_photo])&&$social[social_photo]!='') { ?> <img style="max-height:28px;" src="Files/social_photo/<?php echo $social[social_photo]; ?>" /> <? } else{ echo $social[social_type]." : "; } ?> <?php echo $social[social_name]; ?> </a> <? } else{ ?> <a style="text-align: left;" class="padding5 size17 text-black" href="http://<?php echo $social[social_link]; ?>" target="_blank"> <? if (isset($social[social_photo])&&$social[social_photo]!='') { ?> <img style="max-height:28px;" src="Files/social_photo/<?php echo $social[social_photo]; ?>" /> <? } else{ echo $social[social_type]." : "; } ?> <?php echo $social[social_name]; ?> </a> <? } } else{ ?> <a style="text-align: left;" class="padding5 size17 text-black"> <? if (isset($social[social_photo])&&$social[social_photo]!='') { ?> <img style="max-height:28px;" src="Files/social_photo/<?php echo $social[social_photo]; ?>" /> <? } else{ echo $social[social_type]." : "; } ?> <?php echo $social[social_name]; ?> </a> <? } ?> </p> <? } ?>
</div> </div>
</div> </div> </div> <!-- 4 --> </div> <!-- row --> <div class="margintop50"> <div class="row"> <div class="col-md-12"> <p class="page-topic"> อสังหาริมทรัพย์อื่นๆ </p> </div> </div> <? $product_SL = " SELECT * FROM product WHERE product_id != '$product_id' AND ".$product_web_sql." ORDER BY RAND() LIMIT 4"; $product_QR = mysqli_query($con,$product_SL); $Ac_i=1; while ($product = mysqli_fetch_array($product_QR)) { if ($Ac_i==1) { ?> <div class="row"> <? } ?> <div class="col-md-3 col-xs-6"> <? include 'index_panel_product.php'; ?> </div> <? if ($Ac_i==4) { $Ac_i=0; ?> </div> <? } $Ac_i++; } if ($Ac_i!=1) { echo "</div>"; } ?> </div> <div class="row hidden-sm hidden-xs margintop30" > <div class="col-md-4"> <ul class="breadcrumb no-radius" style="margin-bottom: 0px;"> <li> <a onclick="goBack();" href="#"> กลับ </a> </li> <li><a href="index.php">หน้าแรก</a></li> <li><a href="product.php"> อสังหาริมทรัพย์ </a></li> </ul> </div> </div> </div> <? include 'index_footer.php'; ?> </body> </html>
|