hjkhhrterwefdgdfgdfgdfgdgdfgdfgdsvstertrt
bnmbertsdfsdfgdfgdfgfffdgdfgdfgrtdfg
/
home
/
u652258970
/
domains
/
drgreal.in
/
public_html
/
Upload FileeE
HOME
<?php require_once("money_format_class.php"); $pagename="search"; ?> <?php ob_start(); require"config.php"; //require_once("CSSPagination.class.php"); require_once("my_pagina_class.php"); function no_to_words($no) { $words = array('0'=> '' ,'1'=> 'One' ,'2'=> 'Two' ,'3' => 'Three','4' => 'Four','5' => 'Five','6' => 'Six','7' => 'Seven','8' => 'Eight','9' => 'Nine','10' => 'Ten','11' => 'Eleven','12' => 'Twelve','13' => 'Thirteen','14' => 'Fouteen','15' => 'Fifteen','16' => 'Sixteen','17' => 'Seventeen','18' => 'Eighteen','19' => 'Nineteen','20' => 'Twenty','30' => 'Thirty','40' => 'Fourty','50' => 'Fifty','60' => 'Sixty','70' => 'Seventy','80' => 'Eighty','90' => 'Ninty','100' => 'Hundred ','1000' => 'Thousand','100000' => 'Lakh','10000000' => 'Crore'); if($no == 0) return ' '; else { $novalue=''; $highno=$no; $remainno=0; $value=100; $value1=1000; while($no>=100) { if(($value <= $no) &&($no < $value1)) { $novalue=$words["$value"]; $highno = (int)($no/$value); $remainno = $no % $value; break; } $value= $value1; $value1 = $value * 100; } if(array_key_exists("$highno",$words)) return $words["$highno"]." ".$novalue." ".no_to_words($remainno); else { $unit=$highno%10; $ten =(int)($highno/10)*10; return $words["$ten"]." ".$words["$unit"]." ".$novalue." ".no_to_words($remainno); } } } ?> <!DOCTYPE HTML> <!--[if IE 7 ]><html class="ie ie7" lang="en"> <![endif]--> <!--[if IE 8 ]><html class="ie ie8" lang="en"> <![endif]--> <!--[if (gte IE 9)|!(IE)]><!--> <html lang="en"> <!--<![endif]--> <head> <!-- Basic Page Needs --> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>Dr G RealEstates</title> <meta name="description" content=""> <meta name="keywords" content=""> <meta name="author" content=""> <!-- Favicon --> <link rel="shortcut icon" href="images/favicon.png"> <!-- Mobile Specific Metas --> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <!-- CSS --> <link rel="stylesheet" href="css/bootstrap.css"> <link rel="stylesheet" href="css/style.css" type="text/css"> <link rel="stylesheet" href="css/styles.css"> <link type="text/css" rel="stylesheet" href="css/flexslider.css" id='flexslider-css-css' media="all"> <link href='https://fonts.googleapis.com/css?family=Open+Sans:400,300,600,700' rel='stylesheet' type='text/css'> <link href='https://fonts.googleapis.com/css?family=Merriweather:300' rel='stylesheet' type='text/css'> <!---End--> <link href="css/jquery.bxslider.css" rel="stylesheet" /> <link type="text/css" rel="stylesheet" href="css/responsive-tabs.css" /> <script src="js/custom.js" type="text/javascript"></script> <script language="javascript" type="text/javascript"> function valida() { var count=document.forma.acount.value; var radio_choice = false; for (counter = 1; counter <= count; counter++) { if (document.forma.elements['selecta'+counter].checked) radio_choice = true; } if (!radio_choice) { alert("Please select atleast one checkbox.") return false; } } function validu() { var icount=document.formu.icount.value; var radio_choice = false; for (counter = 1; counter <= icount; counter++) { if (document.formu.elements['selectu'+counter].checked) radio_choice = true; } if (!radio_choice) { alert("Please select atleast one checkbox.") return false; } } </script> <script language="javascript"> var xmlHttp2 function ajax_slink6(str) { xmlHttp2=GetXmlHttpObject() if (xmlHttp2==null) { alert ("Browser does not support HTTP request") return } var url="ajax_distic_ser.php" url=url+"?q="+str xmlHttp2.onreadystatechange=stateChanged2 xmlHttp2.open("GET",url,true) xmlHttp2.send(null) } function stateChanged2() { if (xmlHttp2.readyState==4 || xmlHttp2.readyState=="complete") { document.getElementById('div_slink2').style.display="block"; document.getElementById('div_slink2').innerHTML=xmlHttp2.responseText } } function GetXmlHttpObject() { var xmlHttp2=null; try { // Firefox, Opera 8.0+, Safari xmlHttp2=new XMLHttpRequest(); } catch (e) { //Internet Explorer try { xmlHttp2=new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { xmlHttp2=new ActiveXObject("Microsoft.XMLHTTP"); } } return xmlHttp2; } </script> <script language="javascript"> var xmlHttp10 function ajax_slink(str) { xmlHttp10=GetXmlHttpObject() if (xmlHttp10==null) { alert ("Browser does not support HTTP request") return } var url="ajax_city_ser.php" url=url+"?q="+str xmlHttp10.onreadystatechange=stateChanged10 xmlHttp10.open("GET",url,true) xmlHttp10.send(null) } function stateChanged10() { if (xmlHttp10.readyState==4 || xmlHttp10.readyState=="complete") { document.getElementById('div_slink').style.display="block"; document.getElementById('div_slink').innerHTML=xmlHttp10.responseText } } function GetXmlHttpObject() { var xmlHttp10=null; try { // Firefox, Opera 8.0+, Safari xmlHttp10=new XMLHttpRequest(); } catch (e) { //Internet Explorer try { xmlHttp10=new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { xmlHttp10=new ActiveXObject("Microsoft.XMLHTTP"); } } return xmlHttp10; } </script> <script language="javascript"> var xmlHttp20 function ajax_slink1(str) { xmlHttp20=GetXmlHttpObject() if (xmlHttp20==null) { alert ("Browser does not support HTTP request") return } var url="ajax_area_ser.php" url=url+"?q="+str xmlHttp20.onreadystatechange=stateChanged20 xmlHttp20.open("GET",url,true) xmlHttp20.send(null) } function stateChanged20() { if (xmlHttp20.readyState==4 || xmlHttp20.readyState=="complete") { document.getElementById('div_slink1').style.display="block"; document.getElementById('div_slink1').innerHTML=xmlHttp20.responseText } } function GetXmlHttpObject() { var xmlHttp20=null; try { // Firefox, Opera 8.0+, Safari xmlHttp20=new XMLHttpRequest(); } catch (e) { //Internet Explorer try { xmlHttp20=new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { xmlHttp20=new ActiveXObject("Microsoft.XMLHTTP"); } } return xmlHttp20; } </script> </head> <body> <?php include "header.php"; ?> <div class="banner about"> <div class="container"> <div class="col-md-6"> <h3>Property Services</h3> </div> <div class="col-md-6 col-sm-6"> <p><a href="index.php">Home</a> / Property Services</p> </div> </div> </div> <div class="producs about_bg"> <div class="container"> <div class="col-md-3 col-sm-3"> <div class="property_search"> <h3>Property Search</h3> <form action="view_search.php" method="get" name="frm_sear_user" id="frm_sear_user"> <?php $sid= $_GET['state_id']; if(!empty($sid)) { $statequery ="select * from tbl_state where stat_id='".$sid."'"; $statres = mysql_query( $statequery) or die("Didn't select data.."); $fetchstate = mysql_fetch_array($statres); ?> <select class="list-box" name="state_id" onchange="ajax_slink6(this.value);"> <option value="<?php echo $sid; ?>"><?php echo $fetchstate['stat_name']; ?></option> <option value="">--Select State--</option> <?php $sql_state=mysql_query("select * from tbl_state where stat_status='Y' order by stat_name asc"); while($res_state=mysql_fetch_array($sql_state)) { ?> <option value="<?php echo $res_state['stat_id'];?>" ><?php echo $res_state['stat_name'];?></option> <?php }?> </select> <?php }else { ?> <select class="list-box" name="state_id" onchange="ajax_slink6(this.value);"> <option value="" selected="selected">--Select State--</option> <?php $sql_state=mysql_query("select * from tbl_state where stat_status='Y' order by stat_name asc"); while($res_state=mysql_fetch_array($sql_state)) { ?> <option value="<?php echo $res_state['stat_id'];?>" ><?php echo $res_state['stat_name'];?></option> <?php } }?> </select> <?php $did= $_GET['dis_id']; $satid= $_GET['state_id']; if(!empty($did)) { $distquery ="select * from tbl_distic where dis_id='".$did."'"; $distres = mysql_query( $distquery) or die("Didn't select data.."); $fetchdist = mysql_fetch_array($distres); $satquery ="select * from tbl_distic where stat_id='".$satid."' order by dis_name asc"; $satres = mysql_query($satquery) or die("Didn't select data.."); ?> <div id="div_slink2" style="display:block"> <select class="list-box" name="dis_id" onchange="ajax_slink(this.value);"> <option value="<?php echo $did; ?>"><?php echo $fetchdist['dis_name']; ?></option> <option value="">--Select District--</option> <?php while($fetchsat = mysql_fetch_array($satres)){?> <option value="<?php echo $fetchsat['dis_id']; ?>"><?php echo $fetchsat['dis_name']; ?></option><?php }?> </select></div><?php } else {?> <div id="div_slink2" style="display:block"> <select class="list-box" name="dis_id"> <option value="">--Select District--</option> </select></div> <?php } $cid= $_GET['city_id']; $disid= $_GET['dis_id']; if($cid!=NULL) { $cityquery ="select * from tbl_city where cit_id='".$cid."'"; $cityres = mysql_query( $cityquery) or die("Didn't select data.."); $fetchcity = mysql_fetch_array($cityres); $disquery ="select * from tbl_city where dis_id='".$disid."' order by cit_name asc"; $disres = mysql_query( $disquery) or die("Didn't select data..");?> <div id="div_slink" style="display:block"> <select class="list-box" name="city_id" onchange="ajax_slink1(this.value);"> <option value="<?php echo $cid;?>"><?php echo $fetchcity['cit_name']; ?></option> <option value="">--Select City--</option> <?php while($fetchdis = mysql_fetch_array($disres)){?> <option value="<?php echo $fetchdis['cit_id'];?>"><?php echo $fetchdis['cit_name'];?></option><?php }?> </select></div><?php } else {?> <div id="div_slink" style="display:block"> <select class="list-box" name="city_id"> <option value="">--Select City--</option> </select></div><?php }?></td><td width="13%"> <?php $aid= $_GET['area_id']; $ccid= $_GET['city_id']; if($aid!=NULL) { $areaquery ="select * from tbl_area where area_id='".$aid."'"; $areares = mysql_query( $areaquery) or die("Didn't select data.."); $fetcharea = mysql_fetch_array($areares); $citquery ="select * from tbl_area where cit_id='".$ccid."' order by area_name asc"; $citres = mysql_query( $citquery) or die("Didn't select data..");?> <div id="div_slink1" style="display:block"> <select name="area_id"> <option value="<?php echo $aid;?>"><?php echo $fetcharea['area_name']; ?></option> <option value="">--Select Area--</option> <?php while($fetchcit = mysql_fetch_array($citres)){?> <option value="<?php echo $fetchcit['area_id'];?>"><?php echo $fetchcit['area_name']; ?></option> <?php }?> </select></div><?php } else {?> <div id="div_slink1" style="display:block"> <select class="list-box" name="area_id"> <option value="">--Select Area--</option> </select></div> <?php } ?> <?php $propertype = $_REQUEST['pro_type']; if(!empty( $propertype)){ ?> <select name="pro_type" id="pro_type"> <!--<option selected="selected" value="<?php echo $propertype; ?>"><?php echo $propertype; ?></option>--> <option value="">--Select Type--</option> <option <?php if($propertype=="Buy") echo "selected"; else echo ""; ?> value="Buy">Buy</option> <option <?php if($propertype=="Rent") echo "selected"; else echo ""; ?> value="Rent">Rent</option> <option <?php if($propertype=="Lease") echo "selected"; else echo ""; ?> value="Lease">Lease</option> </select><?php } else {?> <select class="list-box" name="pro_type" id="pro_type"> <option value="">--Select Type--</option> <option value="Buy">Buy</option> <option value="Rent">Rent</option> <option value="Lease">Lease</option> <!-- <option value="sell">Sell</option> --> </select> <?php } ?> <?php $dshow = "display: none;"; //echo $properid;die(); if($_GET['pro_type'] =='Buy') { $dshow = "display: block;"; } ?> <div id="pro_hide1" style="<?php echo $dshow; ?>"> <select class="list-box" id="pro_property_type" name="pro_property_type"> <option value="">--SelectPropertyType--</option> <optgroup label="------ALL RESIDENTIAL------"> <option <?php if($_GET['pro_property_type'] == 'Residential Plot/Land') echo "selected";else echo ""; ?> value="Residential Plot/Land">Residential Plot/Land</option> <option <?php if($_GET['pro_property_type'] == 'Independent House/Villa new') echo "selected";else echo ""; ?> value="Independent House/Villa new">Independent House/Villa new</option> <option <?php if($_GET['pro_property_type'] == 'Independent House/Villa resale') echo "selected";else echo ""; ?> value="Independent House/Villa resale">Independent House/Villa resale</option> <option <?php if($_GET['pro_property_type'] == 'Multistorey Apartment resale') echo "selected";else echo ""; ?> value="Multistorey Apartment resale">Multistorey Apartment/ resale</option> <option <?php if($_GET['pro_property_type'] == 'Multistorey Apartment new') echo "selected";else echo ""; ?> value="Multistorey Apartment new">Multistorey Apartment/ new</option> <option <?php if($_GET['pro_property_type'] == 'Agricultural Land') echo "selected";else echo ""; ?> value="Agricultural Land">Agricultural Land</option> <option <?php if($_GET['pro_property_type'] == 'Farm House Approved Plot') echo "selected";else echo ""; ?> value="Farm House Approved Plot">Farm House</option> <option <?php if($_GET['pro_property_type'] == 'Hotel') echo "selected";else echo ""; ?> value="Hotel">Hotel</option> <option <?php if($_GET['pro_property_type'] == 'Joint Venture') echo "selected";else echo ""; ?> value="Joint Venture">Joint Venture</option> <option <?php if($_GET['pro_property_type'] == 'Paying Guest') echo "selected";else echo ""; ?> value="Paying Guest">Guest House</option> <option <?php if($_GET['pro_property_type'] == 'Room Mates') echo "selected";else echo ""; ?> value="Room Mates">PG</option> <option <?php if($_GET['pro_property_type'] == 'Furnished Sharing accommodation') echo "selected";else echo ""; ?> value="Furnished Sharing accommodation">Furnished Sharing accommodation</option> </optgroup> <optgroup label="------ALL COMMERCIAL------"> <option <?php if($_GET['pro_property_type'] == 'Commercial Land') echo "selected";else echo ""; ?> value="Commercial Land">Commercial Land</option> <option <?php if($_GET['pro_property_type'] == 'Commercial Office Space') echo "selected";else echo ""; ?> value="Commercial Office Space">Commercial Office Space</option> <option <?php if($_GET['pro_property_type'] == 'Commercial Shop') echo "selected";else echo ""; ?> value="Commercial Shop">Commercial Shop</option> <option <?php if($_GET['pro_property_type'] == 'Commercial Showroom') echo "selected";else echo ""; ?> value="Commercial Showroom">Commercial Showroom</option> <option <?php if($_GET['pro_property_type'] == 'Industrial Land') echo "selected";else echo ""; ?> value="Industrial Land">Industrial Land</option> <option <?php if($_GET['pro_property_type'] == 'Industrial Shed') echo "selected";else echo ""; ?> value="Industrial Shed">Industrial Shed</option> <option <?php if($_GET['pro_property_type'] == 'Industrial Building') echo "selected";else echo ""; ?> value="Industrial Building">Industrial Building</option> <option <?php if($_GET['pro_property_type'] == 'Warehouse/Godown') echo "selected";else echo ""; ?> value="Warehouse/Godown">Warehouse/ Godown</option> <option <?php if($_GET['pro_property_type'] == 'Business Centre') echo "selected";else echo ""; ?> value="Business Centre">Business Centre</option> </optgroup> <!-- <optgroup label="------OTHERS------"> <option value="Agricultural Land">Agricultural Land</option> <option value="Hotel">Hotel</option> <option value="Joint Venture">Joint Venture</option> <option value="Paying Guest">Paying Guest</option> <option value="Room Mates">Room Mates</option> <option value="Furnished Sharing accommodation">Furnished Sharing accommodation</option> </optgroup> --> </select> </div> <?php // else{ $show = "display: none;"; if($_GET['pro_type']=='Rent') { $show="display:block;"; } ?> <div id="pro_hide" style="<?php echo $show; ?>"> <select class="list-box" id="pro_property_type1" name="pro_property_rent"> <option value="" selected="selected">--SelectPropertyType--</option> <optgroup label="------ALL RESIDENTIAL------"> <option <?php if($_GET['pro_property_rent'] == 'Independent House/Villa rent') echo "selected";else echo ""; ?> value="Independent House/Villa rent">Independent House/Villa rent</option> <option <?php if($_GET['pro_property_rent'] == 'Multistorey Apartment Rent') echo "selected";else echo ""; ?> value="Multistorey Apartment Rent">Multistorey Apartment Rent</option> <option <?php if($_GET['pro_property_rent'] == 'Paying Guest') echo "selected";else echo ""; ?> value="Paying Guest">Guest House</option> <option <?php if($_GET['pro_property_rent'] == 'Room Mates') echo "selected";else echo ""; ?> value="Room Mates">PG</option> </optgroup> <optgroup label="------ALL COMMERCIAL------"> <option <?php if($_GET['pro_property_rent'] == 'Commercial Office Space Rent') echo "selected";else echo ""; ?> value="Commercial Office Space Rent">Commercial Office Space Rent</option> <option <?php if($_GET['pro_property_rent'] == 'Commercial Shop Rent') echo "selected";else echo ""; ?> value="Commercial Shop Rent">Commercial Shop Rent</option> <option <?php if($_GET['pro_property_rent'] == 'Commercial Showroom') echo "selected";else echo ""; ?> value="Commercial Showroom">Commercial Showroom</option> <option <?php if($_GET['pro_property_rent'] == 'Industrial Shed Rent') echo "selected";else echo ""; ?> value="Industrial Shed Rent">Industrial Shed Rent</option> <option <?php if($_GET['pro_property_rent'] == 'Industrial Building Rent') echo "selected";else echo ""; ?> value="Industrial Building Rent">Industrial Building Rent</option> </optgroup> </select> </div> <?php // else{ $show = "display: none;"; if($_GET['pro_type']=='Lease') { $show="display:block;"; } ?> <div id="pro_lease" style="<?php echo $show; ?>"> <select class="list-box" id="pro_property_type2" name="pro_property_lease"> <option value="" selected="selected">--SelectPropertyType--</option> <option <?php if($_GET['pro_property_lease'] == 'Independent House Lease') echo "selected";else echo ""; ?> value="Independent House Lease">Independent House Lease</option> <option <?php if($_GET['pro_property_lease'] == 'Apartment Lease') echo "selected";else echo ""; ?> value="Apartment Lease">Apartment Lease</option> <option <?php if($_GET['pro_property_lease'] == 'Land Lease') echo "selected";else echo ""; ?> value="Land Lease"> Land Lease</option> </select> </div> <input class="btn btn-sm yellow filter-submit margin-bottom " name="search" type="submit" class="view_button" id="search" value="Search" ></input> </form> </div> </div> <div class="col-md-9 col-sm-9"> <div class="contact_form"> <?php //$room_arr = ['Independent House/Villa','Multistorey Apartment/Flat','Commercial Office Space','Farm House Approved Plot','Commercial Shop','Commercial Showroom','Industrial Shed','Industrial Building','Warehouse/ Godown','Business Centre','Hotel','Joint Venture','Paying Guest','Room Mates','Furnished Sharing accommodation']; //$land_arr = ['Commercial Land','Agricultural Land','Industrial Land','Residential Plot/Land']; //echo '<pre>'; //print_r($room_arr);die; //http://localhost/jaimaa/view_search.php?state_id=1&dis_id=1&city_id=1&area_id=7&pro_property_type=Independent+House%2FVilla+new&pro_property_type=&pro_type=Buy&search=Search if(isset($_REQUEST['search']) || $_REQUEST['front']=="front" ) { // print_r($_REQUEST); exit; ?> <?php $cond = 1; if(!empty($_REQUEST['state_id'])) { $cond .= ' AND stat_id='.$_REQUEST['state_id']; } if(!empty($_REQUEST['dis_id'])) { $cond .= ' AND dis_id='.$_REQUEST['dis_id']; } if(!empty($_REQUEST['city_id'])) { $cond .= ' AND cit_id='.$_REQUEST['city_id']; } if(!empty($_REQUEST['area_id'])) { $cond .= ' AND area_id='.$_REQUEST['area_id']; } if(!empty($_REQUEST['pro_property_type'])) { $cond .= " AND pro_property_type='".$_REQUEST['pro_property_type']."'"; } if(!empty($_REQUEST['pro_property_rent'])) { $cond .= " AND pro_property_type='".$_REQUEST["pro_property_rent"]."'"; } if(!empty($_REQUEST['pro_property_lease'])) { $cond .= " AND pro_property_type='".$_REQUEST["pro_property_lease"]."'"; } if(!empty($_REQUEST['pro_type'])) { $cond .= " AND pro_type ='".$_REQUEST['pro_type']."'"; } $protype2 = $_REQUEST['pro_type']; $front = $_REQUEST['front']; if($front) { $query = "select * from tbl_property where pro_type='".$protype2."' AND pro_status='Y' AND isdelete=0"; } else { $query = "select * from tbl_property where ".$cond." AND pro_status='Y' AND isdelete=0"; } //echo $query;die(); //$res = mysql_query($query)or die('Mysql Error'); //$count=mysql_num_rows($res); //$rowsperpage = 5; $website = $_SERVER['PHP_SELF']."?state_id=".$_REQUEST['state_id']."&dis_id=".$_REQUEST['dis_id']."&city_id=".$_REQUEST['city_id']."&area_id=".$_REQUEST['area_id']."&pro_property_type=".$_REQUEST['pro_property_type']."&pro_type=".$_REQUEST['pro_type']."&skey=".$_REQUEST['skey']; //echo "link :: ".urlencode($website); //$website = urlencode($website); /*$pagination = new CSSPagination($query, $rowsperpage, $website); $pagination->setPage($_GET[page]); $qsql1 = @mysql_query($query, $connection) or die("failed"); $sno=$pagination->getLimit() + 1; $sql2 = $query." limit " . $pagination->getLimit() . ", ". $rowsperpage; $res2 = @mysql_query($sql2, $connection) or die("failed"); */ $test = new MyPagina(); $test->number_links = 10; $test->sql = $query; // the (basic) sql statement (use the SQL whatever you like) $result1 = $test->get_page_result(); // result set //echo "<pre>"; //print_r($result1);die(); $num_rows = $test->get_page_num_rows(); // number of records in result set $nav_info = $test->page_info("Result: %d - %d of %d records"); // information about the number of records on page (example: "Result: 10 - 20 of 100 records") $nav_links = $test->navigation(" | ", "currentStyle", false, false, false, true); // the navigation links (define a CSS class selector for the current link) $numbers_only = $test->navigation("", "current", true); // navigation links using number only $simple_nav_links = $test->back_forward_link(true); // the navigation with only the back and forward links, use true to use images $test->forw = "►"; $test->back = "◄"; $simple_nav_txt_links = $test->back_forward_link(); $total_recs = $test->get_total_rows(); // the total number of records (not used with this example) ?> <p><strong><?php echo $total_recs." "; ?>Record(s) found</strong></p> <?php if(!empty($result1)&& $result1!="Resource id #18") { if($num_rows>0) { //while($res_propertu = mysql_fetch_array($res2)) for ($i = 0; $i < $num_rows; $i++) { $dist_id = mysql_result($result1, $i, "dis_id"); $state_id = mysql_result($result1, $i, "stat_id"); $cit_id = mysql_result($result1, $i, "cit_id"); $area_id = mysql_result($result1, $i, "area_id"); $proimage = mysql_result($result1, $i, "pro_image"); $properttype = mysql_result($result1, $i, "pro_property_type"); $landarea = mysql_result($result1, $i, "lan_coveredarea"); $landareasize = mysql_result($result1, $i, "lan_coveredarea_size"); $bulidupareapro = mysql_result($result1, $i, "pro_coveredarea"); $bulidupareasize = mysql_result($result1, $i, "pro_coveredarea_size"); $pro_other = mysql_result($result1, $i, "pro_other"); $pro_no_of_bedrooms = mysql_result($result1, $i, "pro_no_of_bedrooms"); $pro_no_of_bathrooms = mysql_result($result1, $i, "pro_no_of_bathrooms"); $pro_budget = mysql_result($result1, $i, "pro_budget"); $proper_id = mysql_result($result1, $i, "pro_id"); $title = mysql_result($result1, $i, "pro_seo_title"); $completion_date = mysql_result($result1, $i, "completion_date"); $age_of_building = mysql_result($result1, $i, "age_of_building"); $sql_state=mysql_query("select * from tbl_state where stat_id='".$state_id."'")or die(mysql_error()); $res_state=mysql_fetch_array($sql_state); $sql_city=mysql_query("select * from tbl_city where cit_id='".$cit_id."'") or die(mysql_error()); $res_city=mysql_fetch_array($sql_city); $sql_area=mysql_query("select * from tbl_area where area_id='".$area_id."'")or die(mysql_error()); $res_area=mysql_fetch_array($sql_area);?> <div class="property_section"> <div class="property_list"> <?php if($proimage!=''){?> <img src="property/<?php echo $proimage;?>" /> <?php } else {?> <img src="images/property1.jpg" /> <?php } ?> </div> <div class="dis"> <p><strong><?php echo ucfirst($title);?></strong></p> <p><strong><?php echo $properttype;?></strong></p> <ul> <li><strong>State :</strong> <?php echo $res_state['stat_name'];?></li> <?php $sql_distic=mysql_query("select * from tbl_distic where dis_id='$dist_id'"); $res_distic=mysql_fetch_array($sql_distic); ?> <li><strong>District :</strong> <?php echo $res_distic['dis_name'];?></li> <li><strong>City :</strong> <?php echo $res_city['cit_name'];?></li> <li><strong>Area : </strong> <?php echo $res_area['area_name'];?></li> <?php if(in_array($properttype,$room_arr)){ echo " ";}else{?> <li><strong>Land Area : </strong> <?php if($landarea>0) {echo $landarea;}else {echo 'Nill';}?><?php echo " ".$landareasize;}?></li> <?php if(in_array($properttype,$land_arr)){ echo " ";}else{?> <li><strong>Built-up Area :</strong> <?php if($bulidupareapro>0) { echo $bulidupareapro;}else {echo 'Nill';}?><?php echo " ".$bulidupareasize;?></li> <li><strong>Bedrooms :</strong> <?php echo $pro_no_of_bedrooms;?></li><li><strong>Bathrooms :</strong> <?php echo $pro_no_of_bathrooms;?></li> <?php if($pro_other!='') { ?> <li><strong>Others : </strong> <?php echo $pro_other;?></li><?php }} ?> <li><strong>Price : </strong> <?php echo formatInIndianStyle($pro_budget); ?>/- </li> <li><strong>Price In Words :</strong> <?php echo no_to_words($pro_budget); ?> </li> <?php if(in_array($properttype, $new_arr)){?> <li><strong>Completion Date :</strong> <?php echo $completion_date; ?> </li> <?php }?> <?php if(in_array($properttype, $resale_arr)){?> <li><strong>Age of Building :</strong> <?php echo $age_of_building; ?> </li> <?php }?> </ul> </div> <a href="property-details.php?id=<?php echo base64_encode($proper_id);?>">Read More</a> </div> <?php $sno++; }?> <div width="70%" class="pagena" align="left"><?php echo "<p>".$nav_links."</p>\n"; //echo $pagination->showPage(); ?></div> <?php } } else {?> <div class="no-record"> <p>No Record Found!</p> </div> <?php } } else {?> <div class="no-record"> <h2><strong>Please Select Location on left side bar!</strong></h2> </div> <?php } ?> </div> </div> </div> </div> <?php include "footer.php"; ?> <!-- END FOOTER --> <!-- BEGIN JAVASCRIPTS(Load javascripts at bottom, this will reduce page load time) --> <!-- BEGIN CORE PLUGINS --> <!--[if lt IE 9]> <script src="<?php echo SITE_URL ?>/assets/global/plugins/respond.min.js"></script> <script src="<?php echo SITE_URL ?>/assets/global/plugins/excanvas.min.js"></script> <![endif]--> <script src="<?php echo SITE_URL ?>/assets/global/plugins/jquery.min.js" type="text/javascript"></script> <script src="<?php echo SITE_URL ?>/assets/global/plugins/jquery-migrate.min.js" type="text/javascript"></script> <!-- IMPORTANT! Load jquery-ui.min.js before bootstrap.min.js to fix bootstrap tooltip conflict with jquery ui tooltip --> <script src="<?php echo SITE_URL ?>/assets/global/plugins/jquery-ui/jquery-ui.min.js" type="text/javascript"></script> <script src="<?php echo SITE_URL ?>/assets/global/plugins/bootstrap/js/bootstrap.min.js" type="text/javascript"></script> <script src="<?php echo SITE_URL ?>/assets/global/plugins/bootstrap-hover-dropdown/bootstrap-hover-dropdown.min.js" type="text/javascript"></script> <script src="<?php echo SITE_URL ?>/assets/global/plugins/jquery-slimscroll/jquery.slimscroll.min.js" type="text/javascript"></script> <script src="<?php echo SITE_URL ?>/assets/global/plugins/jquery.blockui.min.js" type="text/javascript"></script> <script src="<?php echo SITE_URL ?>/assets/global/plugins/jquery.cokie.min.js" type="text/javascript"></script> <script src="<?php echo SITE_URL ?>/assets/global/plugins/uniform/jquery.uniform.min.js" type="text/javascript"></script> <script src="<?php echo SITE_URL ?>/assets/global/plugins/bootstrap-switch/js/bootstrap-switch.min.js" type="text/javascript"></script> <!-- END CORE PLUGINS --> <!-- BEGIN PAGE LEVEL PLUGINS --> <script type="text/javascript" src="<?php echo SITE_URL ?>/assets/global/plugins/select2/select2.min.js"></script> <script type="text/javascript" src="<?php echo SITE_URL ?>/assets/global/plugins/datatables/media/js/jquery.dataTables.min.js"></script> <script type="text/javascript" src="<?php echo SITE_URL ?>/assets/global/plugins/datatables/plugins/bootstrap/dataTables.bootstrap.js"></script> <script type="text/javascript" src="<?php echo SITE_URL ?>/assets/global/plugins/bootstrap-datepicker/js/bootstrap-datepicker.min.js"></script> <!-- END PAGE LEVEL PLUGINS --> <!-- BEGIN PAGE LEVEL SCRIPTS --> <script src="<?php echo SITE_URL ?>/assets/global/scripts/metronic.js" type="text/javascript"></script> <script src="<?php echo SITE_URL ?>/assets/admin/layout/scripts/layout.js" type="text/javascript"></script> <script src="<?php echo SITE_URL ?>/assets/admin/layout/scripts/quick-sidebar.js" type="text/javascript"></script> <script src="<?php echo SITE_URL ?>/assets/admin/layout/scripts/demo.js" type="text/javascript"></script> <script src="<?php echo SITE_URL ?>/assets/global/scripts/datatable.js"></script> <script src="<?php echo SITE_URL ?>/assets/admin/pages/scripts/ecommerce-products.js"></script> <script> jQuery(document).ready(function() { Metronic.init(); // init metronic core components Layout.init(); // init current layout QuickSidebar.init(); // init quick sidebar Demo.init(); // init demo features EcommerceProducts.init(); }); </script> <script type="text/javascript"> $(document).ready(function(){ $('#pro_type').change(function(){ //alert('zsczscfz'); if($('#pro_type').val()=="Buy" ) { $('#pro_hide').hide(); $('#rent_select').val(''); $('#pro_lease').hide(); $('#pro_property_type1').val(''); $('#pro_property_type2').val(''); //alert('asfafas'); $('#pro_hide1').show(); }else if($('#pro_type').val()=="Lease"){ $('#pro_hide').hide(); $('#pro_hide1').hide(); $('#pro_lease').show(); $('#pro_property_type').val(''); $('#pro_property_type1').val(''); } else { $('#pro_hide').show(); $('#pro_hide1').hide(); $('#pro_lease').hide(); $('#buy_select').val(''); $('#pro_property_type').val(''); $('#pro_property_type2').val(''); } }); }); </script> </body> </html>