article

Sunday, June 3, 2018

Dynamic Loading of ComboBox using jQuery and Ajax in PHP

Dynamic Loading of ComboBox using jQuery and Ajax in PHP

Download

 
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Dynamic Loading of ComboBox using jQuery and Ajax PHP and Mysqli</title>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.0/jquery.min.js"></script>

<script type="text/javascript">
$(document).ready(function() {
 $('#loader').hide();
 $('#show_heading').hide();
 $('#search_category_id').change(function(){
    $('#show_sub_categories').fadeOut();
    $('#loader').show();
    $.post("get_child_categories.php", {
     parent_id: $('#search_category_id').val(),
    }, function(response){ 
     setTimeout("finishAjax('show_sub_categories', '"+escape(response)+"')", 400);
    });
    return false;
  });
}); 
function finishAjax(id, response){ 
  $('#loader').hide();
  $('#show_heading').show();
  $('#'+id).html(unescape(response));
  $('#'+id).fadeIn();
}
</script>
 
<style>
.both h4{ font-family:Arial, Helvetica, sans-serif; margin:0px; font-size:14px;}
#search_category_id{ padding:3px; width:200px;}
#sub_category_id{ padding:3px; width:200px;}
.both{ float:left; margin:0 15px 0 0; padding:0px;}
</style>
</head>
<body>
<?php include('dbcon.php');?>
<div style="padding-left:30px;">
<form action="#" name="form" id="form" method="post" onsubmit="return alert_id();" enctype="multipart/form-data">
 <div class="both">
  <h4>Select Category</h4>
  <select name="search_category"  id="search_category_id">
  <option value="" selected="selected"></option>
  <?php
  $sql="SELECT * from ajax_category";
  if ($result=mysqli_query($conn,$sql))
  {
   while ($row=mysqli_fetch_row($result)) {
  $id =  $row[0];
  $category =  $row[2];
  echo "<option value='$id'>$category</option>";
   }
   mysqli_free_result($result);
  }
  mysqli_close($conn);
  ?>
  </select>  
 </div>
  <div class="both">
  <h4 id="show_heading">Select Sub Category</h4>
  <div id="show_sub_categories" align="center">
   <img src="img/loader.gif" style="margin-top:8px; float:left" id="loader" alt="" />
  </div>
  </div>
</form>
</div>
</body>
</html>
//get_child_categories.php
<?php
include('dbcon.php');
if($_REQUEST)
{
 $id  = $_REQUEST['parent_id'];
 $query="SELECT * from ajax_categories2 where pid = ".$id;
 if ($result=mysqli_query($conn,$query)){
?>
 <select name="sub_category"  id="sub_category_id">
 <option value="" selected="selected"></option>
 <?php
 while ($row=mysqli_fetch_row($result)) { ?>
  <option value="<?php echo $row[2];?>  ID=<?php echo $row[0];?>"><?php echo $row[2];?></option>
 <?php } ?>
 </select> 
 <?php }
}
?>
//dbcon.php
<?php
$conn = new mysqli('localhost','root','','testingdb');
if ($conn->connect_error) {
    die('Error : ('. $conn->connect_errno .') '. $conn->connect_error);
}
?>

Related Post