Viewing file:  index.php (28.12 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include "admin/conn.php";
// site fetch settings
$settings = mysqli_query($con,"SELECT * FROM settings");
$setting = mysqli_fetch_array($settings);
//fetch testimonial setting
$testi = mysqli_query($con,"SELECT * FROM testimonials");
// aboutus fetch settings
$resultt = mysqli_query($con,"SELECT * FROM about");
$roww = mysqli_fetch_array($resultt);
// Blog fetch settings
$blog = mysqli_query($con,"SELECT * FROM blog");
$blogg = mysqli_fetch_array($blog);
// service fetch settings
$services_result = mysqli_query($con, "SELECT * FROM service");
// Department fetch settings
$depart = mysqli_query($con,"SELECT * FROM department");
$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);
}
// fetch settings
$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="Kateb Curative Hospital, medical center, healthcare, expert doctors, medical services, patient care, appointments, emergency care, specialist treatments, healthcare expertise">
<meta name="description" content="Welcome to Kateb Curative Hospital, where we provide expert medical care and treatment. Schedule an appointment with our experienced doctors today.">
<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">
<style>
.single-slider {
background-size: cover;
background-repeat: no-repeat;
background-position: center;
}
.hero-title {
font-size: 24px;
}
.hero-heading {
font-size: 36px;
}
/* Media query for mobile screens */
@media (max-width: 768px) {
.single-slider {
background-size: contain;
}
.hero-area {
width: 100%;
height: 300px;
}
.single-slider{
width: 100%;
height: 300px;
}
.hero-title {
font-size: 14px;
}
.hero-heading {
font-size: 18px;
}
}
</style>
</head>
<body>
<?php include('header.php') ?>
<section class="hero-area mt-0">
<div class="hero-slider owl-carousel owl-theme">
<div class="single-slider" style="background-image:url('admin/images/slider/<?php echo $setting['s1']; ?>')">
<div class="container">
<div class="row">
<div class="col-lg-8 col-md-8 col-12">
<div class="hero-content">
<span class="hero-title">Kateb Curative Hospital</span>
<h1 class="hero-heading">Kateb; house of speciality and treatment</h1>
<div class="hero-button">
<a href="appoinment" class="theme-btn">Appointment</a>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="single-slider" style="background-image:url('admin/images/slider/<?php echo $setting['s2']; ?>')">
<div class="container">
<div class="row">
<div class="col-lg-8 col-md-8 col-12">
<div class="hero-content">
<span class="hero-title">Kateb Curative Hospital</span>
<h1 class="hero-heading">Kateb; house of speciality and treatment</h1>
<div class="hero-button">
<a href="appoinment.html" class="theme-btn">Appointment</a>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</section>
<section class="features-area">
<div class="container">
<div class="row">
<div class="col-12 wow zoomIn" data-wow-delay="0.1s">
<div class="feature-s-title">
<h3>Why Kateb Curative Hospital is the Best!</h3>
</div>
</div>
</div>
<div class="row">
<div class="col-lg-3 col-md-6 col-12 wow fadeInLeft" data-wow-delay="0.3s">
<div class="single-features" style="width: 100%; height:90%;">
<div class="feature-icon">
<i class="far fa-user-headset"></i>
</div>
<div class="feature-content">
<h5>24/4 Support</h5>
<p>Kateb Curative Hospital is always open for supporting Patients.</p>
</div>
</div>
</div>
<div class="col-lg-3 col-md-6 col-12 wow fadeInUp" data-wow-delay="0.5s">
<div class="single-features" style="width: 100%; height:90%;">
<div class="feature-icon">
<i class="far fa-user-md"></i>
</div>
<div class="feature-content">
<h5>Expert and Experienced Doctors</h5>
<p>Expert and experienced doctors provide top-notch healthcare.</p>
</div>
</div>
</div>
<div class="col-lg-3 col-md-6 col-12 wow fadeInUp" data-wow-delay="0.5s">
<div class="single-features" style="width: 100%; height:90%;">
<div class="feature-icon">
<i class="far fa-stethoscope"></i>
</div>
<div class="feature-content">
<h5>Appointment</h5>
<p>Schedule your appointment easily with our convenient book-in service.</p>
</div>
</div>
</div>
<div class="col-lg-3 col-md-6 col-12 wow fadeInRight" data-wow-delay="0.3s">
<div class="single-features" style="width: 100%; height:90%;">
<div class="feature-icon">
<i class="far fa-ambulance"></i>
</div>
<div class="feature-content">
<h5>Emergency Help</h5>
<p>Urgent aid: Call for help now! <br/> .</p>
</div>
</div>
</div>
</div>
</div>
</section>
<!-- About Us sectios -->
<section class="about-area">
<div class="container">
<div class="row">
<div class="col-lg-6 col-12 wow fadeInLeft" data-wow-delay="0.1s">
<div class="about-image-content">
<div class="about-img">
<img src="admin/images/about/<?php echo $roww['img']; ?>" alt="about image">
</div>
</div>
</div>
<div class="col-lg-6 col-12 wow fadeInRight" data-wow-delay="0.2s">
<div class="about-content">
<div class="about-c-title">
<span>About Us</span>
<h3><?php echo $roww["title"]; ?></h3>
</div>
<p>
<?php echo $roww["descrip"]; ?>
</p>
<div class="about-content-list">
<div class="row">
<div class="col-lg-9 col-md-9 col-12">
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</section>
<!-- Service Area -->
<section class="service-area">
<div class="container">
<div class="row">
<div class="col-lg-8 offset-lg-2 col-12">
<div class="section-title">
<span>Our Services</span>
<h3>What We Provide</h3>
<p>Comprehensive medical care for all.</p>
</div>
</div>
</div>
<?php
$count = 0;
while($service_row=mysqli_fetch_array($services_result)){
if ($count % 4 == 0) {
echo '<div class="row">';
}
?>
<div class="col-3">
<a href="service-details?id=<?php echo $service_row['id']; ?>">
<div class="department-single">
<img style="width: 40%; border-radius: 40%;" src="admin/images/service/<?php echo $service_row["ser_icon"]; ?>" alt="">
<h6><?php echo $service_row["ser_title"]; ?></h6>
</div>
</a>
</div>
<?php
if ($count % 4 == 3) {
echo '</div>';
}
$count++;
}
if ($count % 4 != 0) {
echo '</div>';
}
?>
</div>
</div>
</div>
</div>
</section>
<!-- Department Section-->
<section class="department-area">
<div class="container">
<div class="row">
<div class="col-lg-8 offset-lg-2 col-12">
<div class="section-title">
<span>Department</span>
<h3>Our Departments</h3>
<p>Kateb,Center of expertise and treatment.</p>
</div>
</div>
</div>
<div class="department-details-main">
<?php
$count = 0;
while($depa=mysqli_fetch_array($depart)){
if ($count % 4 == 0) {
echo '<div class="row">';
}
?>
<div class="col-3">
<a href="department-single?id=<?php echo $depa['id']; ?>">
<div class="department-single">
<img style="width: 40%; border-radius: 40%;" src="admin/images/department/<?php echo $depa["img"]; ?>" alt="">
<h6><?php echo $depa['d_name'] ?></h6>
</div>
</a>
</div>
<?php
if ($count % 4 == 3) {
echo '</div>'; // Close the row after every 4 departments
}
$count++;
}
// If the number of departments is not a multiple of 4, close the last row
if ($count % 4 != 0) {
echo '</div>';
}
?>
</div>
</section>
<!-- Blog section -->
<?php
include('admin/conn.php');
$blogsPerPage = 3;
if (isset($_GET['page'])) {
$currentPage = $_GET['page'];
} else {
$currentPage = 1;
}
$offset = ($currentPage - 1) * $blogsPerPage;
$blogQuery = "SELECT * FROM blog ORDER BY id DESC LIMIT $blogsPerPage OFFSET $offset";
$blogResult = mysqli_query($con, $blogQuery);
?>
<section class="blog-area blog-archive-area">
<div class="container">
<div class="row">
<div class="col-lg-8 offset-lg-2 col-12">
<div class="section-title">
<span>Trainings</span>
<h3>Trainings</h3>
<p>Improve Your Skills</p>
</div>
</div>
<?php while ($roww = mysqli_fetch_array($blogResult)) { ?>
<div class="col-lg-4 col-md-6 col-12 wow fadeInLeft" data-wow-delay="0.2s">
<div class="single-blog">
<div class="s-blog-head">
<div class="blog-image">
<img class="blog-image" src="admin/images/blog/<?php echo $roww['img']; ?>" alt="">
<style>
.blog-image img {
width: 500px;
height: 550px;
object-fit: cover;
border-radius: 15px;
}
</style>
</div>
<div class="top-meta">
<span><?php echo $roww['date']; ?></span>
</div>
</div>
<div class="single-blog-content">
<div class="single-blog-title">
<h3><a href="training-details?id=<?php echo $roww['id']; ?>"><?php echo $roww['title']; ?> </a></h3>
<p>
<?php
$ddesc = $roww['descrip'];
echo $dec = substr($ddesc, 0, 35);
?>
</p>
</div>
<div class="blog-author">
<div class="b-author-left"></div>
<div class="b-author-content"></div>
</div>
</div>
</div>
</div>
<?php } ?>
</div>
<?php
$totalBlogsQuery = "SELECT COUNT(*) AS total FROM blog";
$totalBlogsResult = mysqli_query($con, $totalBlogsQuery);
$totalBlogs = mysqli_fetch_assoc($totalBlogsResult)['total'];
$totalPages = ceil($totalBlogs / $blogsPerPage);
?>
<div class="row">
<div class="col-12">
<div class="pagination-main">
<ul class="pagination">
<?php if ($currentPage > 1) { ?>
<li class="prev"><a href="index?page=<?php echo ($currentPage - 1); ?>"><i class="far fa-long-arrow-left"></i></a></li>
<?php } ?>
<?php for ($i = 1; $i <= $totalPages; $i++) { ?>
<li <?php if ($currentPage == $i) echo 'class="active"'; ?>><a href="index?page=<?php echo $i; ?>"><?php echo $i; ?></a></li>
<?php } ?>
<?php if ($currentPage < $totalPages) { ?>
<li class="next"><a href="index?page=<?php echo ($currentPage + 1); ?>"><i class="far fa-long-arrow-right"></i></a></li>
<?php } ?>
</ul>
</div>
</div>
</div>
</div>
</section>
<!-- Achievement area -->
<section class="funfact-area" style="background-image: url('assets/img/achiv.jpg')">
<div class="container">
<div class="row">
<div class="col-lg-8 offset-lg-2 col-12">
<div class="section-title funfact-s-title">
<span>Acheivement</span>
<h3>Our Acheivement</h3>
<p></p>
</div>
</div>
</div>
<div class="row">
<div class="row row-cols-1 row-cols-md-4 g-4 m-2" style="padding-bottom: 20px;">
<?php
include('admin/conn.php');
$result = mysqli_query($con,"SELECT * FROM acheivement_details ORDER BY ach_id DESC LIMIT 4");
while( $row = mysqli_fetch_array($result)){
?>
<div class="col">
<div class="card">
<img src="admin/images/acheivement/<?php echo $row['achi_img']; ?>" class="card-img-top" alt="...">
<div class="card-body" style="height: 400px;">
<h5 class="card-title"><?php echo $row['achi_title'] ?></h5>
<p class="card-text"><?php echo $row['achi_des'] ?></p>
</div>
</div>
</div>
<?php } ?>
</div>
</div>
</div>
</section>
<!-- Testimonials section -->
<section class="testimonial-area" style="background-image: url('assets/img/2.png');">
<div class="container">
<div class="row">
<div class="col-lg-8 offset-lg-2 col-12">
<div class="section-title testimonial-s-title">
<span>Testimonials</span>
<h3>What People Say?</h3>
<p>It is a long established fact that a reader will be distracted.</p>
</div>
</div>
</div>
<div class="row">
<div class="col-12 wow fadeInUp" data-wow-delay="0.2s">
<div class="testimonial-slider owl-carousel owl-theme">
<?php
while($testii=mysqli_fetch_array($testi)){
?>
<div class="single-testimonial">
<div class="testimonial-content">
<div class="testimonial-t-content">
<ul class="t-ratting">
<li><i class="fas fa-star"></i></li>
<li><i class="fas fa-star"></i></li>
<li><i class="fas fa-star"></i></li>
<li><i class="fas fa-star"></i></li>
<li><i class="fas fa-star"></i></li>
</ul>
<div class="t-right-icon">
<i class="far fa-quote-right"></i>
</div>
</div>
<p><?php echo $testii['descrip'] ?></p>
<div class="testimonial-b-content">
<div class="client-image">
<img src="admin/images/testimonial/<?php echo $testii['img']; ?>" alt="">
</div>
<div class="client-title">
<h5><?php echo $testii["title"]; ?></h5>
<span><?php echo $testii['designation']; ?></span>
</div>
</div>
</div>
</div>
<?php } ?>
</div>
</div>
</div>
</div>
</div>
</section>
<!-- Appointment Section -->
<section class="appoinment-area" style="background-image:url('assets/img/4.png')">
<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" 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>
<!-- Partner Section -->
<div class="partner-area">
<div class="container">
<div class="row">
<div class="section-title">
<span>Partners</span>
<h3>Our partners</h3>
</div>
<div class="col-12">
<div class="partner-slider owl-carousel owl-theme">
<div class="single-partner">
<a href="#"><img style="height: 100px;" src="assets/img/partner/2.jpg" alt="#"></a>
</div>
<div class="single-partner">
<a href="#"><img style="height: 100px;" src="assets/img/partner/3.jpg" alt="#"></a>
</div>
<div class="single-partner">
<a href="#"><img style="height: 100px;" src="assets/img/partner/4.jpg" alt="#"></a>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- Footer Section -->
<?php include("footer.php") ?>
<script data-cfasync="false" src="../cdn-cgi/scripts/5c5dd728/cloudflare-static/email-decode.min.js"></script>
<script src="assets/js/jquery-3.6.0.min.js"></script>
<script src="assets/js/bootstrap.bundle.min.js"></script>
<script src="assets/js/bootstrap-datepicker.js"></script>
<script src="assets/js/modernizer.min.js"></script>
<script src="assets/js/magnific-popup.min.js"></script>
<script src="assets/js/waypoints.min.js"></script>
<script src="assets/js/jquery.counterup.min.js"></script>
<script src="assets/js/owl.carousel.min.js"></script>
<script src="assets/js/cube-portfolio.min.js"></script>
<script src="assets/js/nice-select.min.js"></script>
<script src="assets/js/wow.min.js"></script>
<script src="assets/js/jquery.slicknav.min.js"></script>
<script src="assets/js/steller.min.js"></script>
<script src="assets/js/easing.min.js"></script>
<script src="assets/js/jquery.scrollUp.min.js"></script>
<script src="assets/js/main.js"></script>
</body>
</html>
|