<?php
   
  include("Includes/db.php");
  

   extract($_POST);
     if (!empty($_POST["state"])) {
    $query = "select * from states where country_id ='$state'";
    $res = mysqli_query($con, $query) or die(mysqli_error($con));
    if (mysqli_num_rows($res) > 0) {
        echo '<option value="">Select State</option>';
        while ($row = mysqli_fetch_assoc($res)) {
            echo '<option value="' . $row['id'] . '">' . $row['name'] . '</option>';
        }
    } else {
        echo '<option value="">State not available</option>';
    }

}


 if (!empty($_POST["city"])) {
    $query = "select * from districts where state_id  ='$city'";
    $res = mysqli_query($con, $query) or die(mysqli_error($con));
    if (mysqli_num_rows($res) > 0) {
        echo '<option value="">Select city</option>';
        while ($row = mysqli_fetch_assoc($res)) {
            echo '<option value="' . $row['id'] . '">' . $row['name'] . '</option>';
        }
    } else {
        echo '<option value="">city not available</option>';
    }

}
   ?>