|
Server IP : 162.214.80.37 / Your IP : 216.73.216.83 Web Server : Apache System : Linux sh013.webhostingservices.com 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64 User : imyrqtmy ( 2189) PHP Version : 8.2.18 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home2/imyrqtmy/public_html/vssvclinic/Ajax/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include("../Admin/Includes/db.php");
extract($_POST);
if (!empty($_POST["city"])) {
$query = "SELECT DISTINCT(day) FROM `tbl_slot` where location='$city'";
$res = mysqli_query($con, $query) or die(mysqli_error($con));
if (mysqli_num_rows($res) > 0) {
echo '<option value="">Select Day</option>';
while ($row = mysqli_fetch_assoc($res)) {
echo '<option value="' . $row['day'] . '">' . $row['day'] . '</option>';
}
} else {
echo '<option value="">Day not available</option>';
}
}
if (!empty($_POST["day"])) {
$query = "SELECT * FROM `tbl_slot` where day='$day' and location='$place' and seen_flag='0'";
$res = mysqli_query($con, $query) or die(mysqli_error($con));
if (mysqli_num_rows($res) > 0) {
echo '<option value="">Select Slot</option>';
while ($row = mysqli_fetch_assoc($res)) {
echo '<option value="' . $row['id'] . '">' . $row['s_from'] . ' - ' . $row['s_to'] . '</option>';
}
} else {
echo '<option value="">Slot not available</option>';
}
}
?>