prepare($query);
$countryData->bind_param('s',$country_id);
$countryData->execute();
$result=$query->get_result();
if($result->num_rows>0)
{
echo "";
while($arr= $result->fetch_assoc())
{
echo "
";
}
}
}
// Fetching city data
$state_id=!empty($_POST['state_id'])?$_POST['state_id']:'';
if(!empty($state_id))
{
$query="SELECT id, name from cities WHERE state_id=?";
$countryData = $conn->prepare($query);
$countryData->bind_param('i',$state_id);
$countryData->execute();
$result=$query->get_result();
if($result->num_rows>0)
{
echo "";
while($arr= $result->fetch_assoc())
{
echo "
";
}
}
}
?>