> My html code in a php file
<td align="left">
Assignment
</td>
<td>
<div class="">
<div class="form-group">
<select class="form-control" id="distplace1" name="distplace1" onchange="gettaluka(this.value);" required="">
<option value="0">
Select Assignment
</option>
<option value="1">
Cost Name
</option>
<option value="2">
Project Name
</option>
<option value="3">
Other Recovery
</option>
</select>
</div>
</div>
</td>
<td>
<div class="">
<div class="form-group">
<select class="form-control" id="talukaplace" maxlength="10" name="talukaplace" required="">
<option maxlength="10" value="0">
Select Values
</option>
</select>
</div>
</div>
</td>
My ajax function
function gettaluka(id)
{
if(id){
$.ajax({
type:‘POST’,
url:‘ajaxData.php’,
data:{‘id’:id},
success:function(data){ //console.log(html); return;
$(’#talukaplace’).html(data);
storetaluka();
}
});
}else{
$(’#talukaplace’).html(‘Select Taluka’);
}
}
The file where ajax function is called. i.e., ajaxData.php
$dist_id = $_POST["id"];
if ($dist_id == '1') {
?>
<html>
<?php
$query = "select cost_name from cost_centers";
$results = mysqli_query($conn, $query);
if (mysqli_num_rows($results) > 0) {
echo '<option value="" maxlength="100">Select Taluka</option>';
while ($row = mysqli_fetch_assoc($results)) {
echo '<option value="' . $row['cost_name'] . '">' . $row['cost_name'] . '</option>';
}
} else {
echo '<option value="">Select Values</option>';
}
}
;
elseif ($dist_id == '2') {
$query = "select proj_name from project";
$results = mysqli_query($conn, $query);
if (mysqli_num_rows($results) > 0) {
echo '<option value="">Select Project</option>';
while ($row = mysqli_fetch_assoc($results)) {
echo '<option value="' . $row['proj_name'] . '">' . $row['proj_name'] . '</option>';
}
} else {
}
}