FM / public

/home/u775757334/domains/civicwelllife.com/public_html/

/home/u775757334/domains/civicwelllife.com/public_html

Name	Size	Mode	Actions
admin/	-	0755	rm
civiclife/	-	0755	rm
css/	-	0755	rm
fonts/	-	0755	rm
function/	-	0755	rm
images/	-	0755	rm
include/	-	0755	rm
js/	-	0755	rm
management/	-	0755	rm
media/	-	0755	rm
razorpay/	-	0755	rm
seller/	-	0755	rm
vendor/	-	0755	rm
09.php	142	0644	edit dl rm
about-us.php	3025	0644	edit dl rm
account.php	7408	0644	edit dl rm
add-shipping.php	6073	0644	edit dl rm
affiliate-registration.php	4543	0644	edit dl rm
arrow.jpg	1546	0644	edit dl rm
blog-details.php	10838	0644	edit dl rm
blog-list.php	9268	0644	edit dl rm
blog.php	10062	0644	edit dl rm
booking-process.php	2149	0644	edit dl rm
booking-success.php	5541	0644	edit dl rm
category-details.php	7903	0644	edit dl rm
checkout.php	15505	0644	edit dl rm
civiclife (2).zip	151986360	0644	edit dl rm
config.php	9419	0644	edit dl rm
consultation-payment.php	12113	0644	edit dl rm
consultation.php	17921	0644	edit dl rm
contact-us.php	9742	0644	edit dl rm
cpage.css	14115	0644	edit dl rm
create-order.php	443	0644	edit dl rm
create_zoom_link.php	2832	0644	edit dl rm
default.php	16369	0644	edit dl rm
delivery-return.php	2923	0644	edit dl rm
dlogout.php	125	0644	edit dl rm
doctor-account.php	36857	0644	edit dl rm
doctor-appointments.php	10379	0644	edit dl rm
doctor-blog.php	8588	0644	edit dl rm
doctor-consultation.php	5467	0644	edit dl rm
doctor-profile.php	32002	0644	edit dl rm
doctor-registration.php	13189	0644	edit dl rm
doctors.php	10383	0644	edit dl rm
end_meeting.php	230	0644	edit dl rm
faq-list.php	7900	0644	edit dl rm
faq.php	6367	0644	edit dl rm
get_subcategory.php	437	0644	edit dl rm
health-test.php	31910	0644	edit dl rm
index.html	4133	0644	edit dl rm
index.php	3656	0644	edit dl rm
login.php	3842	0644	edit dl rm
media.zip	37481598	0644	edit dl rm
my-account.php	7397	0644	edit dl rm
order-details.php	6172	0644	edit dl rm
patient-login.php	7935	0644	edit dl rm
privacy-policy.php	2430	0644	edit dl rm
product-detail.php	32756	0644	edit dl rm
product-list.php	10761	0644	edit dl rm
return-and-refund.php	2398	0644	edit dl rm
review.php	12362	0644	edit dl rm
seller-registration.php	11374	0644	edit dl rm
send_review.php	765	0644	edit dl rm
start_meeting.php	194	0644	edit dl rm
sub-category.php	7839	0644	edit dl rm
terms-and-conditions.php	2681	0644	edit dl rm
testimonial-list.php	8787	0644	edit dl rm
testimonial.php	8060	0644	edit dl rm
timing-list.php	6068	0644	edit dl rm
timming.php	7571	0644	edit dl rm
vedio-list.php	7877	0644	edit dl rm
vedio.php	8579	0644	edit dl rm
vedios.php	8787	0644	edit dl rm

Edit: /home/u775757334/domains/civicwelllife.com/public_html/doctor-profile.php (32002B)

<?php
include "config.php";

/* -----------------------------
   1) doctor id lo
------------------------------ */
$doctor_id = isset($_GET['doctor_id']) ? (int)$_GET['doctor_id'] : 0;

if ($doctor_id <= 0) {
    die("Invalid doctor id");
}

/* -----------------------------
   2) doctor detail fetch karo
------------------------------ */
$sqlDoctor = mysqli_query($conn, "SELECT * FROM tbl_doctor_registration WHERE id = '$doctor_id'");
if (!$sqlDoctor || mysqli_num_rows($sqlDoctor) == 0) {
    die("Doctor not found");
}
$doctorRow = mysqli_fetch_assoc($sqlDoctor);

/* -----------------------------
   3) helper function
   comma separated ids se names lane ke liye
------------------------------ */
function getNamesFromIds($conn, $table, $idField, $nameField, $idString)
{
    $names = [];

if (empty($idString)) {
        return $names;
    }

$ids = array_filter(array_map('intval', explode(',', $idString)));

if (empty($ids)) {
        return $names;
    }

$idList = implode(',', $ids);

$sql = mysqli_query($conn, "SELECT $nameField FROM $table WHERE $idField IN ($idList)");
    if ($sql) {
        while ($row = mysqli_fetch_assoc($sql)) {
            $names[] = $row[$nameField];
        }
    }

return $names;
}

/* -----------------------------
   4) specialization fetch karo
   category_id => tbl_doctor_sp
------------------------------ */
$speciality_list = getNamesFromIds(
    $conn,
    "tbl_doctor_sp",
    "id",
    "name",
    $doctorRow['category_id']
);

/* -----------------------------
   5) disease/problem fetch karo
   problem_id => tbl_disease_category
------------------------------ */
$problem_list = getNamesFromIds(
    $conn,
    "tbl_disease_category",
    "id",
    "name",
    $doctorRow['problem_id']
);

/* -----------------------------
   6) doctor main array banao
   same keys rakho jo tum html me use kar rahe ho
------------------------------ */
$doctor = [
    "id" => $doctorRow['id'],
    "name" => $doctorRow['name'],
    "status" => !empty($doctorRow['status']) ? $doctorRow['status'] : "Available",
    "speciality" => !empty($speciality_list) ? implode(', ', $speciality_list) : "General Consultation",
    "degree" => !empty($doctorRow['eduaction']) ? $doctorRow['eduaction'] : "Qualification Not Added",
    "experience_years" => !empty($doctorRow['experience']) ? $doctorRow['experience'] . " Years of Experience" : "Experience Not Added",
    "about" => !empty($doctorRow['about']) ? $doctorRow['about'] : "Doctor information will be updated soon.",
    "clinic_name" => !empty($doctorRow['hospital_name']) ? $doctorRow['hospital_name'] : "Clinic Not Added",
    "consultation_fee" => !empty($doctorRow['consultation_fee']) ? "₹" . $doctorRow['consultation_fee'] : "N/A",

/* ye abhi static rakh diye */
    "member_fee" => "₹150",
    "member_old_fee" => !empty($doctorRow['consultation_fee']) ? "₹" . $doctorRow['consultation_fee'] : "₹200",
    "member_discount" => "25% off",

"image" => !empty($doctorRow['image1']) ? "media/image/" . $doctorRow['image1'] : "images/doctor-placeholder.jpg"
];

/* -----------------------------
   7) timings fetch karo
   tbl_timming se
------------------------------ */
$timings = [];

$sqlTiming = mysqli_query($conn, "SELECT * FROM tbl_timmng WHERE doctor_id = '$doctor_id' ORDER BY id ASC");

if ($sqlTiming && mysqli_num_rows($sqlTiming) > 0) {
    while ($timeRow = mysqli_fetch_assoc($sqlTiming)) {

$timeParts = [];

// Morning
        if (!empty($timeRow['start_timming'])) {
            $timeParts[] = $timeRow['start_timming'];
        }

// Evening
        if (!empty($timeRow['evening_time'])) {
            $timeParts[] = $timeRow['evening_time'];
        }

// Combine
        $timeText = !empty($timeParts) ? implode(" & ", $timeParts) : "Closed";

$timings[] = [
            "day" => $timeRow['day'],
            "time" => $timeText
        ];
    }
} else {
    $timings[] = [
        "day" => "Monday - Sunday",
        "time" => !empty($doctorRow['timimg']) ? $doctorRow['timimg'] : "Time not available"
    ];
}

/* -----------------------------
   8) education array
   abhi simple rakha hai
------------------------------ */
$education = [
    [
        "course" => !empty($doctorRow['eduaction']) ? $doctorRow['eduaction'] : "Qualification Not Added",
        "institute" => "Institute details will be updated soon",
        "year" => ""
    ]
];

/* -----------------------------
   9) experience array
   abhi simple rakha hai
------------------------------ */
$experience = [
    [
        "designation" => "Doctor",
        "hospital" => !empty($doctorRow['hospital_name']) ? $doctorRow['hospital_name'] : "Hospital Not Added",
        "duration" => !empty($doctorRow['experience']) ? $doctorRow['experience'] . " Years" : "N/A"
    ]
];

/* -----------------------------
   10) faq fetch karo
------------------------------ */
$faqs = [];

$sqlFaq = mysqli_query($conn, "SELECT * FROM tbl_faq WHERE doctor_id = '$doctor_id' ORDER BY id DESC");
if ($sqlFaq && mysqli_num_rows($sqlFaq) > 0) {
    while ($faqRow = mysqli_fetch_assoc($sqlFaq)) {
        $faqs[] = [
            "question" => $faqRow['question'],
            "answer" => $faqRow['answer']
        ];
    }
} else {
    /* fallback static faq */
    $faqs[] = [
        "question" => "How can I book an appointment?",
        "answer" => "You can click on the Book Appointment button to continue."
    ];
}

/* -----------------------------
   11) meta tags dynamic
------------------------------ */
$blogs = [];

$sqlBlog = mysqli_query($conn, "SELECT * FROM tbl_blog WHERE doctor_id = '$doctor_id' ORDER BY id DESC");

if ($sqlBlog && mysqli_num_rows($sqlBlog) > 0) {
    while ($blogRow = mysqli_fetch_assoc($sqlBlog)) {
        $blogs[] = [
            "id" => $blogRow['id'],
            "image" => $blogRow['image1'],
            "heading" => $blogRow['heading'],
            "description" => substr(strip_tags($blogRow['short_description']), 0, 150) . "..."
        ];
    }
} else {
    /* fallback */
    $blogs[] = [
        "id" => "1",
        "image" => "default.jpg",
        "heading" => "Health Tips for Better Living",
        "description" => "Simple lifestyle changes can improve your health and prevent diseases. Regular exercise, balanced diet, and stress management are key."
    ];
}

$testimonials = [];

$sqlTestimonial = mysqli_query($conn, "SELECT * FROM tbl_testimonial WHERE doctor_id = '$doctor_id' ORDER BY id DESC");

if ($sqlTestimonial && mysqli_num_rows($sqlTestimonial) > 0) {
    while ($row = mysqli_fetch_assoc($sqlTestimonial)) {
        $testimonials[] = [
            "name" => $row['name'],
            "description" => $row['description']
        ];
    }
} else {
    /* fallback */
    $testimonials[] = [
        "name" => "Rahul Sharma",
        "description" => "Very good doctor, highly recommended. Treatment was effective and consultation was smooth."
    ];
}
$meta_title = $doctor['name'] . " - Doctor Profile";
$meta_keyword = $doctor['name'] . ", " . $doctor['speciality'] . ", " . $doctor['degree'] . ", Doctor Profile";
$meta_description = "Consult " . $doctor['name'] . ", specialist in " . $doctor['speciality'] . " with " . $doctor['experience_years'] . ".";
?>

<!DOCTYPE html>
<html xml:lang="en-US" lang="en-US">

.blog-card:hover {
            transform: translateY(-5px);
        }

.blog-card img {
            height: 180px;
            object-fit: cover;
        }

.blog-card .card-title {
            font-size: 16px;
            font-weight: 600;
        }

.blog-card .card-text {
            font-size: 14px;
            color: #666;
        }

.testimonial-card {
            background: #f8f9fa;
            border-radius: 12px;
            transition: 0.3s;
        }

.testimonial-card:hover {
            transform: translateY(-5px);
        }

.testimonial-text {
            font-size: 14px;
            color: #555;
        }

.testimonial-name {
            font-weight: 600;
            color: #000;
        }
    </style>
</head>

<div class="doctor-breadcrumb mb-3">
                    <a href="index.php">Home</a>
                    <span>/</span>
                    <a href="#">Doctors</a>
                    <span>/</span>
                    <span><?= $doctor['name']; ?></span>
                </div>

<div class="doctor-hero-card">
                            <div class="row g-4 align-items-center">
                                <div class="col-md-4">
                                    <div class="doctor-image-box text-center">
                                        <img src="<?= $doctor['image']; ?>" alt="<?= $doctor['name']; ?>" class="img-fluid doctor-profile-img">
                                    </div>
                                </div>

<div class="col-md-8">
                                    <div class="doctor-info-content">
                                        <div class="doctor-top-badge-wrap">
                                            <span class="doctor-status-badge">
                                                <i class="bi bi-patch-check-fill me-1"></i><?= $doctor['status']; ?>
                                            </span>
                                            <span class="doctor-like-badge">
                                                <i class="bi bi-heart-pulse-fill me-1"></i>Trusted Specialist
                                            </span>
                                        </div>

<p class="doctor-short-about mb-4">
                                            Expert in <strong><?= !empty($problem_list) ? htmlspecialchars($problem_list[0]) : 'patient care'; ?></strong>
                                            and <?= htmlspecialchars($doctor['speciality']); ?> consultation
                                            with over <?= htmlspecialchars($doctorRow['experience']); ?> years of clinical experience.
                                        </p>

<div class="doctor-highlights">
                                            <div class="highlight-item">
                                                <i class="bi bi-clock-history"></i>
                                                <span>Available 7 Days</span>
                                            </div>
                                            <div class="highlight-item">
                                                <i class="bi bi-cash-coin"></i>
                                                <span>Fee <?= $doctor['consultation_fee']; ?></span>
                                            </div>
                                            <div class="highlight-item">
                                                <i class="bi bi-geo-alt"></i>
                                                <span><?= $doctor['clinic_name']; ?></span>
                                            </div>
                                        </div>

<div class="doctor-action-btns mt-4">
                                            <a href="consultation-payment.php?doctor_id=<?= $doctor['id']; ?>" class="btn doctor-btn-primary">
                                                <i class="bi bi-calendar2-check me-2"></i>Book Appointment
                                            </a>
                                            <a href="https://wa.me/" target="_blank" class="btn doctor-btn-outline">
                                                <i class="bi bi-whatsapp me-2"></i>Share on WhatsApp
                                            </a>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>

<div class="doctor-nav-card mt-4">
                            <ul class="doctor-section-nav">
                                <li><a href="#about">About</a></li>
                                <li><a href="#clinic">Clinic</a></li>
                                <li><a href="#speciality">Speciality</a></li>
                                <li><a href="#education">Education</a></li>
                                <li><a href="#experience">Experience</a></li>
                                <li><a href="#faq">FAQs</a></li>
                                <li><a href="#blog">Blogs</a></li>
                                <li><a href="#testimonial">Testimonial</a></li>
                            </ul>
                        </div>

<section id="about" class="doctor-content-card mt-4">
                            <div class="section-title-wrap">
                                <h3><i class="bi bi-person-vcard me-2"></i>About Dr. Jyoti Gangwar</h3>
                            </div>
                            <p><?= $doctor['about']; ?></p>
                        </section>

<section id="clinic" class="doctor-content-card mt-4">
                            <div class="section-title-wrap">
                                <h3><i class="bi bi-hospital me-2"></i><?= $doctor['clinic_name']; ?> Clinic(s)</h3>
                            </div>

<div class="clinic-box">
                                <div class="clinic-name-row">
                                    <div>
                                        <h5 class="mb-1"><?= $doctor['clinic_name']; ?></h5>
                                        <p class="clinic-sub-text mb-0">Consultation available every day</p>
                                    </div>
                                    <span class="clinic-tag">Available All Days</span>
                                </div>

<div class="table-responsive mt-3">
                                    <table class="table doctor-timing-table align-middle mb-0">
                                        <thead>
                                            <tr>
                                                <th>Day</th>
                                                <th>Timing</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php foreach ($timings as $item): ?>
                                                <tr>
                                                    <td>
                                                        <span class="day-badge"><?= $item['day']; ?></span>
                                                    </td>
                                                    <td><?= $item['time']; ?></td>
                                                </tr>
                                            <?php endforeach; ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </section>

<section id="speciality" class="doctor-content-card mt-4">
                            <div class="section-title-wrap">
                                <h3><i class="bi bi-stars me-2"></i>Speciality</h3>
                            </div>

<div class="doctor-tag-list">
                                <?php if (!empty($speciality_list)) { ?>
                                    <?php foreach ($speciality_list as $sp) { ?>
                                        <span class="doctor-tag"><?= htmlspecialchars($sp); ?></span>
                                    <?php } ?>
                                <?php } else { ?>
                                    <span class="doctor-tag">General Consultation</span>
                                <?php } ?>

<?php if (!empty($problem_list)) { ?>
                                    <?php foreach ($problem_list as $problem) { ?>
                                        <span class="doctor-tag"><?= htmlspecialchars($problem); ?></span>
                                    <?php } ?>
                                <?php } ?>
                            </div>
                        </section>

<section id="education" class="doctor-content-card mt-4">
                            <div class="section-title-wrap">
                                <h3><i class="bi bi-mortarboard me-2"></i>Education</h3>
                            </div>

<?php foreach ($education as $edu): ?>
                                <div class="doctor-list-item">
                                    <div class="doctor-list-left">
                                        <div class="list-icon"><i class="bi bi-book"></i></div>
                                        <div>
                                            <h5 class="mb-1"><?= $edu['course']; ?></h5>
                                            <p class="mb-0"><?= $edu['institute']; ?></p>
                                        </div>
                                    </div>
                                    <span class="doctor-year"><?= $edu['year']; ?></span>
                                </div>
                            <?php endforeach; ?>
                        </section>

<section id="experience" class="doctor-content-card mt-4">
                            <div class="section-title-wrap">
                                <h3><i class="bi bi-briefcase me-2"></i>Experience</h3>
                            </div>

<?php foreach ($experience as $exp): ?>
                                <div class="doctor-list-item">
                                    <div class="doctor-list-left">
                                        <div class="list-icon"><i class="bi bi-person-workspace"></i></div>
                                        <div>
                                            <h5 class="mb-1"><?= $exp['designation']; ?></h5>
                                            <p class="mb-0"><?= $exp['hospital']; ?></p>
                                        </div>
                                    </div>
                                    <span class="doctor-year"><?= $exp['duration']; ?></span>
                                </div>
                            <?php endforeach; ?>
                        </section>

<section id="faq" class="doctor-content-card mt-4">
                            <div class="section-title-wrap">
                                <h3><i class="bi bi-chat-square-text me-2"></i>Common Questions & Answers</h3>
                            </div>

<div class="accordion doctor-faq-accordion" id="doctorFaqAccordion">
                                <?php foreach ($faqs as $index => $faq): ?>
                                    <div class="accordion-item">
                                        <h2 class="accordion-header" id="faqHeading<?= $index; ?>">
                                            <button class="accordion-button <?= $index != 0 ? 'collapsed' : ''; ?>" type="button"
                                                data-bs-toggle="collapse"
                                                data-bs-target="#faqCollapse<?= $index; ?>"
                                                aria-expanded="<?= $index == 0 ? 'true' : 'false'; ?>"
                                                aria-controls="faqCollapse<?= $index; ?>">
                                                <?= $faq['question']; ?>
                                            </button>
                                        </h2>
                                        <div id="faqCollapse<?= $index; ?>"
                                            class="accordion-collapse collapse <?= $index == 0 ? 'show' : ''; ?>"
                                            aria-labelledby="faqHeading<?= $index; ?>"
                                            data-bs-parent="#doctorFaqAccordion">
                                            <div class="accordion-body">
                                                <?= $faq['answer']; ?>
                                            </div>
                                        </div>
                                    </div>
                                <?php endforeach; ?>
                            </div>
                        </section>
                        
                        <section id="blog" class="doctor-content-card mt-4">
                            <div class="section-title-wrap">
                                <h3><i class="bi bi-journal-text me-2"></i>Health Blogs</h3>
                            </div>

<div class="row">
                                <?php foreach ($blogs as $blog): ?>
                                    <div class="col-md-4 mb-3">
                                        <a href="blog-details.php?blog_id=<?= $blog['id']; ?>" style="text-decoration:none; color:inherit;">

<img src="media/image/<?= $blog['image']; ?>" class="card-img-top" alt="blog">

<div class="card-body">
                                                    <h5 class="card-title"><?= $blog['heading']; ?></h5>
                                                    <p class="card-text"><?= $blog['description']; ?></p>
                                                </div>

</div>

</a>
                                    </div>
                                <?php endforeach; ?>
                            </div>
                        </section>
                        
                        <section id="testimonial" class="doctor-content-card mt-4">
                            <div class="section-title-wrap">
                                <h3><i class="bi bi-chat-quote me-2"></i>Patient Testimonials</h3>
                            </div>

</div>
                                    </div>
                                <?php endforeach; ?>
                            </div>
                        </section>
                    </div>

<div class="col-lg-4">
                        <div class="doctor-sidebar-card sticky-top">
                            <div class="sidebar-top-box">
                                <h4 class="sidebar-title mb-3">Consultation Fees</h4>

<div class="fee-box">
                                    <div class="fee-row">
                                        <span>Consultation Fee</span>
                                        <strong><?= $doctor['consultation_fee']; ?></strong>
                                    </div>
                                </div>

</div>

<div class="doctor-sidebar-info mt-4">
                                <div class="sidebar-info-item">
                                    <span>Doctor</span>
                                    <strong><?= $doctor['name']; ?></strong>
                                </div>
                                <div class="sidebar-info-item">
                                    <span>Speciality</span>
                                    <strong><?= $doctor['speciality']; ?></strong>
                                </div>
                                <div class="sidebar-info-item">
                                    <span>Qualification</span>
                                    <strong><?= $doctor['degree']; ?></strong>
                                </div>
                                <div class="sidebar-info-item">
                                    <span>Experience</span>
                                    <strong><?= $doctor['experience_years']; ?></strong>
                                </div>
                                <div class="sidebar-info-item">
                                    <span>Timing</span>
                                    <strong>
                                        <?= !empty($timings[0]['time']) ? htmlspecialchars($timings[0]['time']) : 'Time not available'; ?>
                                    </strong>
                                </div>
                            </div>

<a href="consultation-payment.php?doctor_id=<?= $doctor['id']; ?>" class="btn doctor-btn-primary w-100 mt-4">
                                <i class="bi bi-calendar-check me-2"></i>Book Appointment
                            </a>
                        </div>
                    </div>
                </div>
            </div>
        </main>

<?php include 'include/footer.php'; ?>
    </div>

<?php include 'include/footer-tab.php'; ?>
    <?php include 'include/model.php'; ?>

$(document).on("click", ".sidebar-overlay", function() {
            $("#sidebarMenu").removeClass("active");
            $(this).remove();
        });
    </script>

$("#testimonialForm").submit(function(e) {
            e.preventDefault();

let formData = new FormData(this);
            formData.append("action", "saveTest");

$("#submitBtn").text("Saving...").prop("disabled", true);

$.ajax({
                url: "function/ajax_function.php",
                type: "POST",
                data: formData,
                contentType: false,
                processData: false,

success: function(res) {
                    let r = JSON.parse(res);

if (r.status == 1) {
                        alert(r.msg);
                        window.location.href = "testimonial-list.php";
                    } else {
                        alert(r.msg);
                    }

$("#submitBtn").text("Save").prop("disabled", false);
                }
            });
        });
    </script>
</body>

</html>

cmd: