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/blog-details.php (10838B)

<?php
include 'config.php';
$meta_title = "Doctor Blog Details";
$meta_keyword = "doctor blog details, ayurveda article, health blog";
$meta_description =
    "Doctor blog detail page with related blogs and related products.";

$blog_id = isset($_GET['blog_id']) ? (int)$_GET['blog_id'] : 0;

if ($blog_id == 0) {
    die("Invalid Blog ID");
}

// ✅ MAIN BLOG + DOCTOR JOIN
$sql = mysqli_query($conn, "
    SELECT 
        b.id,
        b.heading,
        b.short_description,
        b.description,
        b.image1,
        b.`date`, b.category_id,

d.name AS doctor_name,
        d.image1 AS doctor_image,
        d.experience,
        d.eduaction,tbl_category.name AS category_name

FROM tbl_blog b
    LEFT JOIN tbl_doctor_registration d 
        ON b.doctor_id = d.id

LEFT JOIN tbl_category 
        ON b.category_id = tbl_category.id

WHERE b.id = $blog_id
") or die(mysqli_error($conn));

$blog = mysqli_fetch_assoc($sql);
$category_id = $blog['category_id'];
// ✅ Doctor Image Fix
$doctor_img = !empty($blog['doctor_image'])
    ? "media/image/" . $blog['doctor_image']
    : "assets/images/default-doctor.png";

// ✅ RELATED BLOGS
$related_sql = mysqli_query($conn, "
    SELECT id, heading, image1 
    FROM tbl_blog 
    WHERE id != $blog_id 
    ORDER BY id DESC 
    LIMIT 3
");

$related_blogs = [];

while ($row = mysqli_fetch_assoc($related_sql)) {
    $row['link'] = "blog-details.php?blog_id=" . $row['id'];
    $related_blogs[] = $row;
}

$product_sql = mysqli_query($conn, "
    SELECT id, name, image1, sale_price,url
    FROM tbl_product
    WHERE category_id = '$category_id'
    ORDER BY id DESC
    LIMIT 4
");

$related_products = [];

while ($row = mysqli_fetch_assoc($product_sql)) {
    $row['link'] = "product-detail.php?&url=" . $row['url'] . "-" . $row['id'] . "";
    $row['image'] = "media/image/" . $row['image1'];
    $related_products[] = $row;
}

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

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

<div class="blog-detail-image-wrap">
                                <img src="media/image/<?= $blog['image1']; ?>"
                                    alt="<?= $blog['heading']; ?>"
                                    class="blog-detail-main-image">
                            </div>

<div class="blog-author-mini-box">
                                <img src="media/image/<?= $blog['doctor_image']; ?>"
                                    alt="<?= $blog['doctor_name']; ?>"
                                    class="blog-author-mini-img">
                                <div class="blog-author-mini-info">
                                    <h6 class="mb-1"><?=
                                                        $blog['doctor_name']; ?></h6>
                                    <p class="mb-0"><?= $blog['eduaction']; ?>
                                        • <?= $blog['experience']; ?>+ Years Experiences</p>
                                </div>
                            </div>

<div class="blog-detail-content">
                                <h3>Introduction</h3>
                                <?= $blog['description']; ?>
                            </div>
                        </div>
                    </div>

<div class="col-lg-4">
                        <div class="blog-sidebar-card sticky-top">
                            <div class="sidebar-doctor-card">
                                <h4 class="sidebar-card-title">Doctor
                                    Info</h4>
                                <div class="sidebar-doctor-inner">
                                    <img src="media/image/<?= $blog['doctor_image']; ?>"
                                        alt="<?= $blog['doctor_name']; ?>"
                                        class="sidebar-doctor-img">
                                    <div>
                                        <h5 class="mb-1"><?=
                                                            $blog['doctor_name']; ?></h5>
                                        <p class="mb-1"><?= $blog['eduaction'];
                                                        ?></p>
                                        <span class="sidebar-exp-badge"><?=
                                                                        $blog['experience']; ?></span>
                                    </div>
                                </div>
                            </div>

<div class="related-blogs-box mt-4">
                                <h4 class="sidebar-card-title">Related
                                    Blogs</h4>

<?php foreach ($related_blogs as $item): ?>
                                    <a href="<?= $item['link']; ?>"
                                        class="related-blog-item">
                                        <img src="media/image/<?= $item['image1']; ?>"
                                            alt="<?= $item['heading']; ?>"
                                            class="related-blog-img">
                                        <div class="related-blog-text">
                                            <h6><?= $item['heading']; ?></h6>
                                            <span>Read Article</span>
                                        </div>
                                    </a>
                                <?php endforeach; ?>
                            </div>
                        </div>
                    </div>
                </div>

<div class="related-products-wrap mt-5">
                    <div class="section-title-wrap mb-4">
                        <h3><i class="bi bi-bag-heart me-2"></i>Related
                            Products</h3>
                    </div>

<div class="row g-4">
                        <?php foreach ($related_products as $product): ?>
                            <div class="col-6 col-md-4 col-lg-3">
                                <div class="related-product-card h-100">
                                    <a href="<?= $product['link']; ?>"
                                        class="related-product-img-wrap">
                                        <img src="<?= $product['image']; ?>"
                                            alt="<?= $product['name']; ?>"
                                            class="related-product-img">
                                    </a>

<div class="related-product-content">
                                        <h5><?= $product['name']; ?></h5>
                                        <div class="related-product-price"><?=
                                                                            $product['sale_price']; ?></div>
                                        <a href="<?= $product['link']; ?>"
                                            class="related-product-btn">View
                                            Product</a>
                                    </div>
                                </div>
                            </div>
                        <?php endforeach; ?>
                    </div>
                </div>

</div>
        </main>

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

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

</html>

<?= $meta_title ?>

• + Years Experiences

Introduction

Doctor Info

Related Blogs

Related Products