<?php
include("./Admin/Includes/db.php");
extract($_POST);



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

}

elseif (!empty($_POST["place"])) {
    $query = "select * from tbl_admin where id='$place'";
    $res = mysqli_query($con, $query) or die(mysqli_error($con));
    if (mysqli_num_rows($res) > 0) {
        echo '<option value="">Select avaliblity</option>';
        $rows = mysqli_fetch_assoc($res);
        $avaliblity = $rows['avaliblity'];
        $r = explode(',', $avaliblity);
        foreach ($r as  $value) {

             $querys = "select * from tbl_week where id='$value'";
             $ress = mysqli_query($con, $querys) or die(mysqli_error($con));

             $sql_rows = mysqli_fetch_assoc($ress);

            echo '<option value="' . $sql_rows['id'] . '">' . $sql_rows['week_name'] . '</option>';
            # code...
        }
        // while ($row = mysqli_fetch_assoc($res)) {
            
        // }
    } else {
        echo '<option value="">Doctor not available</option>';
    }

}

?>