Viewing file:  appoinment.php (10.56 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
error_reporting(0);
include "admin/conn.php";
// site fetch settings
$settings = mysqli_query($con, "SELECT * FROM settings");
$setting = mysqli_fetch_array($settings);
// fetch department settings
$depart = mysqli_query($con, "SELECT * FROM department");
$depa = mysqli_fetch_array($depart);
$query = "SELECT * FROM department";
$result = mysqli_query($con, $query);
$departments = array();
if ($result) {
while ($row = mysqli_fetch_assoc($result)) {
$department = array(
'id' => $row['id'],
'd_name' => $row['d_name']
);
$departments[] = $department;
}
mysqli_free_result($result);
}
$query1 = "SELECT * FROM schedule";
$result1 = mysqli_query($con, $query1);
$doctor1 = array();
if ($result1) {
while ($row1 = mysqli_fetch_assoc($result1)) {
$doctor = array(
'id' => $row1['id'],
'd_name' => $row1['d_name'],
'date_start' => $row1['date_start'],
'date_end' => $row1['date_end'],
'status' => $row1['status'] // Add the 'status' field
);
$doctor1[] = $doctor;
}
mysqli_free_result($result1);
}
mysqli_close($con);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="keywords" content="Site keywords here">
<meta name="description" content="#">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<title><?php echo $setting['site_name']; ?></title>
<link rel="icon" href="assets/img/favicon.png">
<link href="https://fonts.googleapis.com/css2?family=Barlow:ital,wght@0,400;0,500;0,600;0,700;0,900;1,500;1,700&display=swap" rel="stylesheet">
<link rel="stylesheet" href="assets/css/bootstrap.min.css">
<link rel="stylesheet" href="assets/css/cube-portfolio.min.css">
<link rel="stylesheet" href="assets/css/owl.carousel.min.css">
<link rel="stylesheet" href="assets/css/slicknav.min.css">
<link rel="stylesheet" href="assets/css/maginific-popup.min.css">
<link rel="stylesheet" href="assets/css/animate.min.css">
<link rel="stylesheet" href="assets/css/nice-select.css">
<link rel="stylesheet" href="assets/css/datepicker.css">
<link rel="stylesheet" href="assets/css/fontawesome.min.css">
<link rel="stylesheet" href="assets/css/icofont.css">
<link rel="stylesheet" href="assets/css/default.css">
<link rel="stylesheet" href="assets/css/style.css">
<link rel="stylesheet" href="assets/css/responsive.css">
<link rel="stylesheet" href="assets/css/custom-css.css">
<link href="assets/Content/bootstrap.min.css" rel="stylesheet" />
<link rel="stylesheet" href="assets/Content/bootstrap-theme.min.css" />
<link rel="stylesheet" href="assets/Content/MdBootstrapPersianDateTimePicker/jquery.Bootstrap-PersianDateTimePicker.css" />
<script src="assets/Scripts/jquery-2.1.4.js" type="text/javascript"></script>
<script src="assets/Scripts/bootstrap.min.js" type="text/javascript"></script>
<style type="text/css">
body, table {
font-family: 'Segoe UI', Tahoma;
font-size: 14px;
}
</style>
</head>
<body>
<?php include('header.php')?>
<section class="breadcrumbs" style="background-image:url(assets/img/breadcrumb-bg.jpg)">
<div class="container">
<div class="row">
<div class="col-lg-6 offset-lg-3 col-12">
<div class="breadcrumb-content">
<h4>appoinment</h4>
<ul class="breadcrumb-menu">
<li><a href="index.php">Home</a><i class="far fa-angle-double-right"></i></li>
<li><a href="#">Appointment</a></li>
</ul>
</div>
</div>
</div>
</div>
</section>
</section>
<!-- Appointment Section -->
<section class="appoinment-area" style="background-image:url('assets/img/appo.jpg')">
<div class="container">
<div class="row">
<div class="col-lg-8 offset-lg-2 col-md-10 offset-md-1 col-12 wow fadeInUp" data-wow-delay="0.2s">
<form action="appo.php" method="POST">
<div class="appoinment-inner">
<div class="appoinment-title">
<h3>Make An Appointment</h3>
<p>Schedule your appointment easily with our convenient book-in service</p>
</div>
<div class="row">
<div class="col-lg-6 col-12">
<div class="form-group">
<input type="text" id="name" name="name" placeholder="Name" required="required">
</div>
</div>
<div class="col-lg-6 col-12">
<div class="form-group">
<input type="email" id="email" name="email" placeholder="Email" required="required">
</div>
</div>
<div class="col-lg-6 col-12">
<div class="form-group">
<input type="text" id="phone" name="phone" placeholder="Phone" required="required">
</div>
</div>
<div class="col-lg-6 col-12">
<div class="form-group">
<select name="department">
<option value="" selected disabled>Choose Department</option>
<?php
foreach ($departments as $department) {
$departmentId = $department['id'];
$departmentName = $department['d_name'];
echo '<option value="' . $departmentName . '">' . $departmentName . '</option>';
}
?>
</select>
</div>
</div>
<div class="col-lg-6 col-12">
<div class="form-group">
<select name="doctor_name" id="doctor_name">
<option value="" selected disabled>Doctor</option>
<?php
foreach ($doctor1 as $doctor) {
if ($doctor['status'] !== 'not-available') {
echo '<option value="' . $doctor['d_name'] . '">' . $doctor['d_name'] . '</option>';
}
}
?>
</select>
</div>
</div>
<div class="col-lg-6 col-12">
<div class="form-group">
<input type="time" id="time" name="time" placeholder="Preferred Time" id="datepicker">
</div>
</div>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script>
$(document).ready(function() {
$('#doctor_name').on('change', function() {
var doctorName = $(this).val();
var from_date = '';
var to_date = '';
<?php foreach ($doctor1 as $doctor) { ?>
if ('<?php echo $doctor['d_name']; ?>' === doctorName) {
from_date = '<?php echo $doctor['date_start']; ?>';
to_date = '<?php echo $doctor['date_end']; ?>';
}
<?php } ?>
var current_date = new Date(from_date);
var end_date = new Date(to_date);
var dropdownHtml = '<select name="date">';
while (current_date <= end_date) {
var formatted_date = current_date.toLocaleDateString('en-GB', { day: 'numeric', month: 'numeric', year: 'numeric' });
dropdownHtml += '<option value="' + formatted_date + '">' + formatted_date + '</option>';
current_date.setDate(current_date.getDate() + 1);
}
dropdownHtml += '</select>';
$('#availableDates').html(dropdownHtml);
});
});
</script>
<div class="col-lg-6 col-12">
<div class="form-group">
<label for="date">Choose Date</label>
<div id="availableDates">
</div>
</div>
</div>
</div>
<div class="col-12">
<div class="form-group">
<textarea name="appo_message" id="appo_message" placeholder="Write Your Message Here..."></textarea>
</div>
</div>
<div class="col-12">
<div class="contact-btn">
<input type="submit" name="submit" value="Submit">
</div>
</div>
</div>
</form>
</div>
</div>
</div>
</section>
</body>
</html>
|