PHP : Looping through database rows.

 

 

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>";

    }
}