1#@!#!123s

��JFIF�� 1#@!#!123s
: / home4 / mcspunei / www / shubhamangal.co.in / includes /
Filename : refine_search.php
back
<script>
function age(val){
	//alert(val);
	 $.ajax({url: "age_ajax.php?val="+val, success: function(result){
        $("#toage").html(result);
    }});
}
</script>  
          
<?php
$heightFrm = isSet($_REQUEST['heightfrom']) ? $_REQUEST['heightfrom'] : '' ;
$heightTo = isSet($_REQUEST['heightto']) ? $_REQUEST['heightto'] : '' ;
$_REQUEST['age_from'] = isSet($_REQUEST['age_from']) ? $_REQUEST['age_from'] : '' ;
$_REQUEST['age_to'] = isSet($_REQUEST['age_to']) ? $_REQUEST['age_to'] : '' ;
?>



<aside>
  
		 <div class="search-sidebar">
		 <h4 class="sidebar-heading">Refine Search</h4>
         <form name="refine" id="refine" method="get">
<div class="panel-group" id="refineSearch" role="tablist" aria-multiselectable="true">
  <div class="panel panel-default">
    <div class="panel-heading" role="tab" id="headingOne">
      <h4 class="panel-title"> 
      <a  class="accordion-toggle " data-toggle="collapse" data-parent="#refineSearch" href="#refineOne" aria-expanded="true" aria-controls="refineOne">Age Range </a> </h4>
    </div>
    <div id="refineOne"  class="panel-collapse collapse in" role="tabpanel" aria-labelledby="headingOne">
      <div class="panel-body">
        <div class="list-group">
			<div class="form-group">
			  <label>From</label>
			  <div >
			  <input type="hidden" name="gender" value="<?=isSet($_REQUEST['gender']) ? $_REQUEST['gender'] : '' ;?>" />
			  <input type="hidden" name="mothertongue" value="<?=isSet($_REQUEST['mothertongue']) ? $_REQUEST['mothertongue'] : '' ;?>" />
			  <input type="hidden" name="education" value="<?=isSet($_REQUEST['education']) ? $_REQUEST['education'] : '' ;?>" />
			  
				<select  class="form-control" name="age_from" onchange="return age(val);">
					<option <?php if($_REQUEST['age_from']=='') echo "selected";?> value="18">--From--</option>
					<?php for($i=18; $i<=71; $i++) {  ?>
					<option <?php if($_REQUEST['age_from']==$i) echo "selected";?> value="<?php echo $i; ?>"><?php echo $i; ?></option>
					<?php } ?>	
				</select>
			  </div>
			  </div>
			
			  <div class="form-group">
			  <label>To</label>
			  <div  id="toage" >
				<select  class="list-group-item" name="age_to">
					<option <?php if($_REQUEST['age_to']=='') echo "selected";?> value="70">--To--</option>
					<?php for($j=18; $j<=71; $j++) {  ?>
					<option <?php if($_REQUEST['age_to']==$j) echo "selected";?> value="<?php echo $j; ?>"><?php echo $j; ?></option>
					<?php } ?>	
				</select>
			  </div>
			  </div>
        </div>
      </div>
    </div>
  </div>
  <div class="panel panel-default">
    <div class="panel-heading" role="tab" id="headingTwo" >
      <h4 class="panel-title"> 
      <a  class="accordion-toggle  collapsed" data-toggle="collapse" data-parent="#refineSearch" href="#refineTwo" aria-expanded="false" aria-controls="refineTwo"> Height</a> </h4>
    </div>
    <div id="refineTwo"  class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingTwo">
      <div class="panel-body">
	  <div class="list-group">
	   <div class="form-group">
	     <label>From</label>
          <select  name="heightfrom" class="form-control">
                 <option <?php if($heightFrm=="") echo "selected";?> value="4ft 2in - 127cm">From</option>
					<OPTION <?php if($heightFrm=="4ft 2in - 127cm") echo "selected";?> value="4ft 2in - 127cm">4ft 2in - 127cm</OPTION> 
					<OPTION <?php if($heightFrm=="4ft 3in - 130cm") echo "selected";?> value="4ft 3in - 130cm">4ft 3in - 130cm</OPTION> 
					<OPTION <?php if($heightFrm=="4ft 4in - 132cm") echo "selected";?> value="4ft 4in - 132cm">4ft 4in - 132cm</OPTION> 
					<OPTION <?php if($heightFrm=="4ft 4in - 132cm") echo "selected";?> value="4ft 5in - 134cm">4ft 5in - 134cm</OPTION> 
					<OPTION <?php if($heightFrm=="4ft 6in - 137cm") echo "selected";?> value="4ft 6in - 137cm">4ft 6in - 137cm</OPTION> 
					<OPTION <?php if($heightFrm=="4ft 7in - 139cm") echo "selected";?> value="4ft 7in - 139cm">4ft 7in - 139cm</OPTION> 
					<OPTION <?php if($heightFrm=="4ft 8in - 142cm") echo "selected";?> value="4ft 8in - 142cm">4ft 8in - 142cm</OPTION> 
					<OPTION <?php if($heightFrm=="4ft 9in - 144cm") echo "selected";?> value="4ft 9in - 144cm">4ft 9in - 144cm</OPTION> 
					<OPTION <?php if($heightFrm=="4ft 10in - 147cm") echo "selected";?> value="4ft 10in - 147cm">4ft 10in - 147cm</OPTION> 
					<OPTION <?php if($heightFrm=="4ft 11in - 149cm") echo "selected";?> value="4ft 11in - 149cm">4ft 11in - 149cm</OPTION> 
					<OPTION <?php if($heightFrm=="5ft - 152cm") echo "selected";?> value="5ft - 152cm">5ft - 152cm</OPTION> 
					<OPTION <?php if($heightFrm=="5ft 1in - 154cm") echo "selected";?> value="5ft 1in - 154cm">5ft 1in - 154cm</OPTION> 
					<OPTION <?php if($heightFrm=="5ft 2in - 157cm") echo "selected";?> value="5ft 2in - 157cm">5ft 2in - 157cm</OPTION> 
					<OPTION <?php if($heightFrm=="5ft 3in - 160cm") echo "selected";?> value="5ft 3in - 160cm">5ft 3in - 160cm</OPTION> 
					<OPTION <?php if($heightFrm=="5ft 4in - 162cm") echo "selected";?> value="5ft 4in - 162cm">5ft 4in - 162cm</OPTION> 
					<OPTION <?php if($heightFrm=="5ft 5in - 165cm") echo "selected";?> value="5ft 5in - 165cm">5ft 5in - 165cm</OPTION> 
					<OPTION <?php if($heightFrm=="5ft 6in - 167cm") echo "selected";?> value="5ft 6in - 167cm">5ft 6in - 167cm</OPTION> 
					<OPTION <?php if($heightFrm=="5ft 7in - 170cm") echo "selected";?> value="5ft 7in - 170cm">5ft 7in - 170cm</OPTION> 
					<OPTION <?php if($heightFrm=="5ft 8in - 172cm") echo "selected";?> value="5ft 8in - 172cm">5ft 8in - 172cm</OPTION> 
					<OPTION <?php if($heightFrm=="5ft 9in - 175cm") echo "selected";?> value="5ft 9in - 175cm">5ft 9in - 175cm</OPTION> 
					<OPTION <?php if($heightFrm=="5ft 10in - 177cm") echo "selected";?> value="5ft 10in - 177cm">5ft 10in - 177cm</OPTION> 
					<OPTION <?php if($heightFrm=="5ft 11in - 180cm") echo "selected";?> value="5ft 11in - 180cm">5ft 11in - 180cm</OPTION> 
					<OPTION <?php if($heightFrm=="6ft - 182cm") echo "selected";?> value="6ft - 182cm">6ft - 182cm</OPTION> 
					<OPTION <?php if($heightFrm=="6ft 1in - 185cm") echo "selected";?> value="6ft 1in - 185cm">6ft 1in - 185cm</OPTION> 
					<OPTION <?php if($heightFrm=="6ft 2in - 187cm") echo "selected";?> value="6ft 2in - 187cm">6ft 2in - 187cm</OPTION> 
					<OPTION <?php if($heightFrm=="6ft 3in - 190cm") echo "selected";?> value="6ft 3in - 190cm">6ft 3in - 190cm</OPTION> 
					<OPTION <?php if($heightFrm=="6ft 4in - 193cm") echo "selected";?> value="6ft 4in - 193cm">6ft 4in - 193cm</OPTION> 
					<OPTION <?php if($heightFrm=="6ft 5in - 195cm") echo "selected";?> value="6ft 5in - 195cm">6ft 5in - 195cm</OPTION> 
					<OPTION <?php if($heightFrm=="6ft 6in - 198cm") echo "selected";?> value="6ft 6in - 198cm">6ft 6in - 198cm</OPTION> 
					<OPTION <?php if($heightFrm=="6ft 7in - 200cm") echo "selected";?> value="6ft 7in - 200cm">6ft 7in - 200cm</OPTION> 
					<OPTION <?php if($heightFrm=="6ft 8in - 203cm") echo "selected";?> value="6ft 8in - 203cm">6ft 8in - 203cm</OPTION> 
					<OPTION <?php if($heightFrm=="6ft 9in - 205cm") echo "selected";?> value="6ft 9in - 205cm">6ft 9in - 205cm</OPTION> 
					<OPTION <?php if($heightFrm=="6ft 10in - 208cm") echo "selected";?> value="6ft 10in - 208cm">6ft 10in - 208cm</OPTION> 
					<OPTION <?php if($heightFrm=="6ft 11in - 210cm") echo "selected";?> value="6ft 11in - 210cm">6ft 11in - 210cm</OPTION> 
					<OPTION <?php if($heightFrm=="7ft - 213cm") echo "selected";?> value="7ft - 213cm">7ft - 213cm</OPTION> 
					<OPTION <?php if($heightFrm=="7ft 1in - 216cm") echo "selected";?> value="7ft 1in - 216cm">7ft 1in - 216cm</OPTION> 
					<OPTION <?php if($heightFrm=="7ft 2in - 218cm") echo "selected";?> value="7ft 2in - 218cm">7ft 2in - 218cm</OPTION>
                </select>
			</div>
			<div class="form-group">
			  <label>To</label>
			  <div class="accordion-toggle">
				<select  name="heightto" class="form-control">
					<option <?php if($heightTo=="") echo "selected";?> value="7ft 2in - 218cm">To</option>
					<OPTION <?php if($heightTo=="4ft 2in - 127cm") echo "selected";?> value="4ft 2in - 127cm">4ft 2in - 127cm</OPTION> 
					<OPTION <?php if($heightTo=="4ft 3in - 130cm") echo "selected";?> value="4ft 3in - 130cm">4ft 3in - 130cm</OPTION> 
					<OPTION <?php if($heightTo=="4ft 4in - 132cm") echo "selected";?> value="4ft 4in - 132cm">4ft 4in - 132cm</OPTION> 
					<OPTION <?php if($heightTo=="4ft 4in - 132cm") echo "selected";?> value="4ft 5in - 134cm">4ft 5in - 134cm</OPTION> 
					<OPTION <?php if($heightTo=="4ft 6in - 137cm") echo "selected";?> value="4ft 6in - 137cm">4ft 6in - 137cm</OPTION> 
					<OPTION <?php if($heightTo=="4ft 7in - 139cm") echo "selected";?> value="4ft 7in - 139cm">4ft 7in - 139cm</OPTION> 
					<OPTION <?php if($heightTo=="4ft 8in - 142cm") echo "selected";?> value="4ft 8in - 142cm">4ft 8in - 142cm</OPTION> 
					<OPTION <?php if($heightTo=="4ft 9in - 144cm") echo "selected";?> value="4ft 9in - 144cm">4ft 9in - 144cm</OPTION> 
					<OPTION <?php if($heightTo=="4ft 10in - 147cm") echo "selected";?> value="4ft 10in - 147cm">4ft 10in - 147cm</OPTION> 
					<OPTION <?php if($heightTo=="4ft 11in - 149cm") echo "selected";?> value="4ft 11in - 149cm">4ft 11in - 149cm</OPTION> 
					<OPTION <?php if($heightTo=="5ft - 152cm") echo "selected";?> value="5ft - 152cm">5ft - 152cm</OPTION> 
					<OPTION <?php if($heightTo=="5ft 1in - 154cm") echo "selected";?> value="5ft 1in - 154cm">5ft 1in - 154cm</OPTION> 
					<OPTION <?php if($heightTo=="5ft 2in - 157cm") echo "selected";?> value="5ft 2in - 157cm">5ft 2in - 157cm</OPTION> 
					<OPTION <?php if($heightTo=="5ft 3in - 160cm") echo "selected";?> value="5ft 3in - 160cm">5ft 3in - 160cm</OPTION> 
					<OPTION <?php if($heightTo=="5ft 4in - 162cm") echo "selected";?> value="5ft 4in - 162cm">5ft 4in - 162cm</OPTION> 
					<OPTION <?php if($heightTo=="5ft 5in - 165cm") echo "selected";?> value="5ft 5in - 165cm">5ft 5in - 165cm</OPTION> 
					<OPTION <?php if($heightTo=="5ft 6in - 167cm") echo "selected";?> value="5ft 6in - 167cm">5ft 6in - 167cm</OPTION> 
					<OPTION <?php if($heightTo=="5ft 7in - 170cm") echo "selected";?> value="5ft 7in - 170cm">5ft 7in - 170cm</OPTION> 
					<OPTION <?php if($heightTo=="5ft 8in - 172cm") echo "selected";?> value="5ft 8in - 172cm">5ft 8in - 172cm</OPTION> 
					<OPTION <?php if($heightTo=="5ft 9in - 175cm") echo "selected";?> value="5ft 9in - 175cm">5ft 9in - 175cm</OPTION> 
					<OPTION <?php if($heightTo=="5ft 10in - 177cm") echo "selected";?> value="5ft 10in - 177cm">5ft 10in - 177cm</OPTION> 
					<OPTION <?php if($heightTo=="5ft 11in - 180cm") echo "selected";?> value="5ft 11in - 180cm">5ft 11in - 180cm</OPTION> 
					<OPTION <?php if($heightTo=="6ft - 182cm") echo "selected";?> value="6ft - 182cm">6ft - 182cm</OPTION> 
					<OPTION <?php if($heightTo=="6ft 1in - 185cm") echo "selected";?> value="6ft 1in - 185cm">6ft 1in - 185cm</OPTION> 
					<OPTION <?php if($heightTo=="6ft 2in - 187cm") echo "selected";?> value="6ft 2in - 187cm">6ft 2in - 187cm</OPTION> 
					<OPTION <?php if($heightTo=="6ft 3in - 190cm") echo "selected";?> value="6ft 3in - 190cm">6ft 3in - 190cm</OPTION> 
					<OPTION <?php if($heightTo=="6ft 4in - 193cm") echo "selected";?> value="6ft 4in - 193cm">6ft 4in - 193cm</OPTION> 
					<OPTION <?php if($heightTo=="6ft 5in - 195cm") echo "selected";?> value="6ft 5in - 195cm">6ft 5in - 195cm</OPTION> 
					<OPTION <?php if($heightTo=="6ft 6in - 198cm") echo "selected";?> value="6ft 6in - 198cm">6ft 6in - 198cm</OPTION> 
					<OPTION <?php if($heightTo=="6ft 7in - 200cm") echo "selected";?> value="6ft 7in - 200cm">6ft 7in - 200cm</OPTION> 
					<OPTION <?php if($heightTo=="6ft 8in - 203cm") echo "selected";?> value="6ft 8in - 203cm">6ft 8in - 203cm</OPTION> 
					<OPTION <?php if($heightTo=="6ft 9in - 205cm") echo "selected";?> value="6ft 9in - 205cm">6ft 9in - 205cm</OPTION> 
					<OPTION <?php if($heightTo=="6ft 10in - 208cm") echo "selected";?> value="6ft 10in - 208cm">6ft 10in - 208cm</OPTION> 
					<OPTION <?php if($heightTo=="6ft 11in - 210cm") echo "selected";?> value="6ft 11in - 210cm">6ft 11in - 210cm</OPTION> 
					<OPTION <?php if($heightTo=="7ft - 213cm") echo "selected";?> value="7ft - 213cm">7ft - 213cm</OPTION> 
					<OPTION <?php if($heightTo=="7ft 1in - 216cm") echo "selected";?> value="7ft 1in - 216cm">7ft 1in - 216cm</OPTION> 
					<OPTION <?php if($heightTo=="7ft 2in - 218cm") echo "selected";?> value="7ft 2in - 218cm">7ft 2in - 218cm</OPTION>
                </select>
			  </div>
			  </div>
        </div>
	  </div>
    </div>
  </div>
   <div class="panel panel-default">
  <div class="panel-heading" role="tab" id="headingThree">
                                                    <h4 class="panel-title"> <a class="accordion-toggle collapsed" data-toggle="collapse" data-parent="#refineSearch" href="#refineThree" aria-expanded="false" aria-controls="refineThree"> Country</a> </h4>
                                                </div>
                                                <div id="refineThree" class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingThree">
                                                    <div class="panel-body">
                                                        <div class="list-group">
                                                            <select onchange="categorylist(this.value);" name="country" id="country" class="form-control">
                                                                <option value="">Select Country</option>
                                                                <?php
			$countries = isset($_REQUEST['country'])?$_REQUEST['country']:array('none');
			$sel_cou = $db->get_all("select * from skadate_location_country order by Country_str_name asc");
			foreach($sel_cou as $i=>$sel_country)
			{
			?>
			<option <?php if($_REQUEST['country']==$sel_country['Country_str_code']) echo "selected";?> style="width:150px;" value="<?php echo $sel_country['Country_str_code']; ?>" ><?php echo $sel_country['Country_str_name']; ?></option>
			<?php } ?>
                                                            </select>
                                                        </div>
                                                    </div>
                                                </div>
  
</div>
  
  <div class="panel panel-default">

                                                <div class="panel-heading" role="tab" id="headingFour">
                                                    <h4 class="panel-title"> <a class="accordion-toggle collapsed" data-toggle="collapse" data-parent="#refineSearch" href="#refineFour" aria-expanded="false" aria-controls="refineFour"> State</a> </h4>
                                                </div>
                                                <div id="refineFour" class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingFour">
                                                    <div class="panel-body">
                                                        <div class="list-group">
                                                            <div id="statenew">
                                                                <select name="state" class="form-control" onchange="Javascript:citylist(this.value);">
                                                                    <option value="">Select State</option>
                                                                   <?php
		if(!empty ($_REQUEST['country'][0])){
			$countries = implode(',',$_REQUEST['country']);
				if($countries[strlen($country)-1]==','){
					$countries = substr($country,0,strlen($country)-1);
				}	
				$con = "where FIND_IN_SET(Country_str_code,'$country')";
			}else{
				$con = "";
			}
			$states = isset($_REQUEST['state'])?$_REQUEST['state']:array('none');;
		$queryy="select * from skadate_location_state where Country_str_code='$country'";
		$sqll=$db->get_all($queryy);
		foreach($sqll as $i=>$roww)
		{
		 ?>
		 <option <?php if($roww['Admin1_str_code']==$_REQUEST['state']) echo "selected"; ?> value="<?php echo $roww['Admin1_str_code'];?>"><?php echo $roww['Admin1_str_name'];?></option>
		 <?php } ?>
                                                                </select>
                                                            </div>
                                                        </div>
                                                    </div>
                                                </div>
  </div>
  <div class="panel panel-default">

                                                <div class="panel-heading" role="tab" id="headingFive">
                                                    <h4 class="panel-title"> <a class="accordion-toggle collapsed" data-toggle="collapse" data-parent="#refineSearch" href="#refineFive" aria-expanded="false" aria-controls="refineFive"> City</a> </h4>
                                                </div>

                                                <div id="refineFive" class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingFive">
                                                    <div class="panel-body">
                                                        <div class="list-group">
                                                            <div id="citynew">
                                                                <select name="city" class="form-control">
                                                                    <option value="">Select City</option>
                                                                    <?php
		if(!empty($_REQUEST['state'][0])){
				$countries = implode(',',$_REQUEST['state']);
				if($countries[strlen($countries_live)-1]==','){
					$countries= substr($countries_live,0,strlen($countries_live)-1);
				}	
				$con = "where FIND_IN_SET(Admin1_str_code,'$countries')";
			}else{
				$con = "where Country_str_code='IN'";
			}

		$cites = isset($_REQUEST['city'])?$_REQUEST['city']:array('none');
		
		$query="select * from skadate_location_city where Admin1_str_code='$state'";
		$res=$db->get_all($query);
		foreach($res as $i=>$row)
		{
		 ?>
		 <option value="<?php echo $row['Feature_str_name'];?>"><?php echo $row['Feature_str_name'];?></option>
		 <?php } ?>
                                                                </select>
                                                            </div>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
	
  <div class="panel panel-default">
    <div class="panel-heading" role="tab" id="headingSix">
      <h4 class="panel-title"> <a class="accordion-toggle collapsed" data-toggle="collapse" data-parent="#refineSearch" href="#refineSix" aria-expanded="false" aria-controls="refineSix"> Marital Status</a> </h4>
    </div>
    <div id="refineSix" class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingSix">
      <div class="panel-body">
	  <div class="list-group">
	    <select  name="marital" class="form-control">
		  <option value="">Select</option>
		  <option <?php if($_REQUEST['marital'] =="UnMarried") { echo "selected"; } ?> value="UnMarried">UnMarried</option>
		  <option <?php if($_REQUEST['marital'] =="Divorced") { echo "selected"; } ?> value="Divorced">Divorced</option>
		  <option <?php if($_REQUEST['marital'] =="Widowed") { echo "selected"; } ?> value="Widowed">Widowed</option>
		  <option <?php if($_REQUEST['marital'] =="Awaiting Divorce") { echo "selected"; } ?> value="Awaiting Divorce">Awaiting Divorce</option>
		</select>
        </div>
	 </div>
    </div>
	
  </div>
  
   <div class="panel panel-default">
  
 
    <div class="panel-heading" role="tab" id="headingSix">
      <h4 class="panel-title"> <a class="accordion-toggle collapsed" data-toggle="collapse" data-parent="#refineSearch" href="#refineSeven" aria-expanded="false" aria-controls="refineSeven"> Caste</a> </h4>
    </div>
    <div id="refineSeven" class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingSeven">
      <div class="panel-body">
	  <div class="list-group">
	     <?php 
		$sel_caste = $db->get_all("SELECT * FROM caste order by caste asc");
		?>
		<select name="caste" class="form-control"> 
		 <option value="">Select Caste</option>
		 <?php

		 
		 if($_REQUEST['caste']=="Other") {
		 ?>
		 <option value="Other" selected="selected">Other</option>
		 <?php }
		else if($_REQUEST['caste']=="Don't Know"){ ?> 
		 <option value="Other" selected="selected">Don't Know</option>					
		<?php
		}
		foreach($sel_caste as $i=>$subcst)
		{
			
		?>
		 <option value="<?php echo $subcst['id'];?>" <?php if($_REQUEST['caste']==$subcst['id']) { ?> selected="selected" <?php } ?>><?php echo $subcst['caste']; ?></option>
		 
		<?php

		}
		?>
		</select>
        </div>
	 </div>
    </div>
	 
  </div>
  
</div>
		<input type="submit" value="FILTER" class="button radius" style="background:#FBA043; margin:5px; border:none;" name="refinesearch">
		<!--<input type="hidden" name="refinesearch" />-->
		<input type="hidden" name="strget" value="<?php echo $strget;?>" />
	</form>

	</div>
		  
</aside>