if (isset($_GET['getState'])) {
$sql = "SELECT id,state_name FROM loc_state WHERE inactive='0' AND country_id ='".$_GET['getState']."';";
$stateDdList = $conn->query($sql);
if ($stateDdList->num_rows > 0) {
echo "<select name='state' onChange='getDistrict(this.value)' required='' class='form-control custom-select' >";
echo "<option value=''>Choose state</option>";
while($state=$stateDdList->fetch_assoc()) {
echo "<option value='".$state['id']."'>".$state['state_name']."</option>";
}
echo "</select>";
} else {
echo "<select name='state' required='' class='form-control custom-select' >";
echo "<option value=''>No State found</option>";
echo "</select>";
}
}
Comments
Post a Comment