<?php 
include("connection.php");
include('include/header.php');
$service_slug =
mysqli_real_escape_string(
    $con,
    $_GET['service']
);

$location_slug =
mysqli_real_escape_string(
    $con,
    $_GET['location']
);

/* Service */

$serviceQuery =
mysqli_query(
    $con,
    "SELECT *
     FROM tbl_top_category
     WHERE slug='$service_slug'"
);

$service =
mysqli_fetch_assoc($serviceQuery);

if(!$service)
{
    include("404.php");
    exit;
}

/* Location */

$locationQuery =
mysqli_query(
    $con,
    "SELECT *
     FROM tbl_location_pages
     WHERE category_id='{$service['t_id']}'
     AND slug='$location_slug'
     AND status='1'"
);

$location =
mysqli_fetch_assoc($locationQuery);

if(!$location)
{
    include("404.php");
    exit;
}
?>

<style>
    .blog-details__img img {
        aspect-ratio: 3 / 2;
    }

    img.floating {
        animation-name: floating;
        animation-duration: 2s;
        animation-iteration-count: infinite;
        animation-timing-function: ease-in-out;
        margin-left: 0px;
        margin-top: 0px;
    }

    @keyframes floating {
        0% {
            transform: translate(0, 0px);
        }

        50% {
            transform: translate(0, 15px);
        }

        100% {
            transform: translate(0, -0px);
        }
    }

    p {
        text-align: justify;
    }
</style>
<!--Page Header Start-->
<section class="page-header">
    <div class="page-header__bg" style="background-image: url(<?php path() ?>assets/images/backgrounds/page-header-bg.jpg);">
    </div>
    <div class="page-header__shape-1">
        <img src="<?php path() ?>assets/images/shapes/page-header-shape-1.png" alt="">
    </div>
    <div class="container">
        <div class="page-header__inner">
            <h3><?php echo $service['cat_name'] . ' Services in ' . $location['slug']; ; ?></h3>
            <div class="thm-breadcrumb__inner">
                <ul class="thm-breadcrumb list-unstyled">
                    <li><a href="<?php path() ?>index.php">Home</a></li>
                    <li><span class="fas fa-angle-right"></span></li>
                    <li><a href="<?php echo path() . 'services/' . $service['slug'] ?>"><?php echo $service['cat_name']?></a></li>
                </ul>
            </div>
        </div>
    </div>
</section>
<!--Page Header End-->

<!--Blog Details Start -->
<section class="blog-details">
    <div class="container">
        <div class="row">
            <div class="col-xl-6 col-lg-6">
                <div class="blog-details__left">
                    <div class="blog-details__img-box-1">
                        <div class="blog-details__img">
                            <img class="floating" src="<?php path(); ?>/admin/assets/images/service/<?php echo htmlspecialchars($Image); ?>" alt="">
                        </div>

                    </div>

                </div>
            </div>

            <!--Start Sidebar-->
            <div class="col-xl-6 col-lg-6">
                <div class="blog-details__content">
                    <?php echo $location['description']; ?> 
                </div>
            </div>
            <!--End Sidebar-->
        </div>
    </div>
</section>


<?php
include("include/footer.php");
?>