<footer class="footer-wrapper footer-layout3" data-bg-src="assets/img/bg/footer_bg_3.png">
    <div class="widget-area">
        <div class="container">
            <div class="row justify-content-between">
                <div class="col-md-6 col-xl-auto">
                    <div class="widget footer-widget">
                        <div class="th-widget-about">
                            <div class="about-logo">
                                <a href="index.php"><img src="<?php echo $lightLogo; ?>" alt="Ostad Group" style="max-width:180px;"></a>
                            </div>
                            <?php
                            $footerAbout = $connect -> prepare("select * from `tbl_about`");
                            $footerAbout -> execute();
                            $footerAboutRow = $footerAbout -> fetch(PDO::FETCH_ASSOC);
                            ?>
                            <p class="about-text"><?php echo $footerAboutRow['short_desc']; ?></p>
                            <div class="th-social">
                                <?php
                                $footerSocial = $connect -> prepare("select * from `tbl_social` where `delete_flag` = 0 order by `id` desc");
                                $footerSocial -> execute();
                                if($footerSocial -> rowCount() > 0){
                                    while ($footerSocialRows = $footerSocial -> fetch(PDO::FETCH_ASSOC)){
                                        echo '<a href="'.$footerSocialRows['link'].'" target="_blank" title="'.$footerSocialRows['title'].'"><i class="fab '.$footerSocialRows['icon'].'"></i></a>';
                                    }
                                }
                                ?>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-md-6 col-xl-auto">
                    <div class="widget widget_nav_menu footer-widget">
                        <h3 class="widget_title">Useful Links</h3>
                        <div class="menu-all-pages-container">
                            <ul class="menu">
                                <li><a href="index.php">Home</a></li>
                                <li><a href="services.php">Services</a></li>
                                <li><a href="blog.php">Blog</a></li>
                                <li><a href="contact.php">Contact Us</a></li>
                                <li><a href="about.php">About Us</a></li>
                            </ul>
                        </div>
                    </div>
                </div>
                <div class="col-md-6 col-xl-auto">
                    <div class="widget widget_nav_menu footer-widget">
                        <h3 class="widget_title">Our Services</h3>
                        <div class="menu-all-pages-container">
                            <ul class="menu">
                                <?php
                                $footerService = $connect -> prepare("select * from `tbl_service` where `delete_flag` = 0 order by `id` desc");
                                $footerService -> execute();
                                if($footerService -> rowCount() > 0){
                                    while ($footerServiceRows = $footerService -> fetch(PDO::FETCH_ASSOC)){
                                        echo '<li><a href="service-details.php?id='.$footerServiceRows['id'].'">'.$footerServiceRows['title'].'</a></li>';
                                    }
                                }
                                ?>
                            </ul>
                        </div>
                    </div>
                </div>
                <div class="col-md-6 col-xl-auto">
                    <div class="widget widget_nav_menu footer-widget">
                        <h3 class="widget_title">Our Blog</h3>
                        <div class="menu-all-pages-container">
                            <ul class="menu">
                                <?php
                                $footerBlog = $connect -> prepare("select * from `tbl_service` where `delete_flag` = 0 order by `id` desc limit 5");
                                $footerBlog -> execute();
                                if($footerBlog -> rowCount() > 0){
                                    while ($footerBlogRows = $footerBlog -> fetch(PDO::FETCH_ASSOC)){
                                        echo '<li><a href="blog-details.php?id='.$footerBlogRows['id'].'">'.$footerBlogRows['title'].'</a></li>';
                                    }
                                }
                                ?>
                            </ul>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="copyright-wrap">
        <div class="container">
            <div class="row gy-2 align-items-center">
                <div class="col-md-12 text-center">
                    <p class="copyright-text">Copyright <i class="fal fa-copyright"></i> 2024 <a href="index.php">OstadGroup</a>. All Rights Reserved</p>
                </div>
            </div>
        </div>
    </div>
</footer>