<?php
include '../include/config.php'; 
   extract($_POST);
     if (!empty($_POST["city"])) {
     
    ?>
    
   
                                                <div>
                                                    <div class="mb-3">
                                                        <label for="example-text-input" class="form-label">City</label>
                                                        <select class="form-select" name="city" id="city">
                                                         <option value="">Select city</option>
                                                            
                                                            <?php
                                                               
                                                                $result = mysqli_query($con,"select * from districts where state_id  ='$city'");
                                                                while($row = mysqli_fetch_array($result)) {
                                                                   
                                                                ?>
                                                                   <option value="<?php echo $row['id'];?>"><?php echo $row['name'] ;?></option>
                                                                <?php
                                                                
                                                                
                                                                }
                                                                ?>
                                                                
                                                        </select>
                                                    </div>
                                                    
                                                </div>
                                            

<?php }  ?>