1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / nc6d095 / suceafricana.com / view /
Filename : region.php
back
<?php
include("../admin/inc/config.php");

if(!isset($_GET['a'])){}
else{
$a = slugToStr($_GET['a']);
if(!is_string($a)){
}
else{
    $q = dbSelect('kn_states',"*","LCASE(name)='$a'");
    while($cData=mysqli_fetch_assoc($q)){
        $cId = $cData['id'];
        $name = $cData['name'];
        $capital = $cData['capital'];
        $zone = $cData['zone'];
        $country = getDBVal('kn_zones',$zone,'country');
        $slogan = $cData['slogan'];
        $overview = $cData['overview'];
        $details = $cData['details'];
        $government = $cData['government'];
        $business = $cData['business'];
        $economy = $cData['economy'];
        $entertainment = $cData['entertainment'];
        $travel = $cData['travel'];
        $population = $cData['population'];
        $landArea = $cData['landArea'];
        $postalCode = $cData['postalCode'];
        $linguas = $cData['linguas'];
        $ethnicGroups = $cData['ethnicGroups'];
        $mapImg = $cData['mapImg'];
        $coverImg = $cData['coverImg'];
        $created = $cData['created'];
        $dc = $cData['dc'];
        $header = $name;
        $sloganTxt = !empty($slogan) ?? ": $slogan";
    }
    define("TITLE", "$name");
    define("HEADER", "$header $sloganTxt");
    define("OVERVIEW", "$overview");
    define("BREADCRUMB", "region");
    $pgView = true;


    include("../inc/head.php");
?>

<body>
    <div class="content-wrapper">
        <?php include("../inc/header.php"); ?>
        <!-- /header -->

        <?php include("../inc/page-header.php"); ?>
        <!-- /page-header -->

        <section class="wrapper bg-light">
            <div class="container py-14 py-md-16">
                <div class="row gy-3 pt-3">
                    <div class="col-md-7">
                        <div class="card card-border-top border-primary">
                            <div class="card-body">
                                <figure class="overlay overlay-1 hover-scale rounded mb-5"><img src="<?= $uploadsRoot; ?>images/kn-states/cover/<?= $coverImg; ?>" alt="" /></figure>

                                <div class="text-justify">
                                    <?= $details ?>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-5">
                        <div class="card card-border-start border-primary">
                            <div class="card-body">
                                <figure class="overlay overlay-1 hover-scale rounded mb-5"><img src="<?= $uploadsRoot; ?>images/kn-states/maps/<?= $mapImg; ?>" alt="" /></figure>
                                <ul class="list-group list-group-flush">
                                    <li class="list-group-item d-flex justify-content-between align-items-center">
                                        <span class="badge bg-primary rounded-pill me-3">Capital</span>
                                        <?= $capital ?>
                                    </li>
                                    <li class="list-group-item d-flex justify-content-between align-items-center">
                                        <span class="badge bg-primary rounded-pill me-3">Country</span>
                                        <?= $country > 0 ? getDBVal('kn_countries',$country) : '' ?>
                                    </li>
                                    <li class="list-group-item d-flex justify-content-between align-items-center">
                                        <span class="badge bg-primary rounded-pill me-3">Created</span>
                                        <?= !empty($created) ? formatDate($created, "F jS Y") : '' ?>
                                    </li>
                                    <li class="list-group-item d-flex justify-content-between align-items-center">
                                        <span class="badge bg-primary rounded-pill me-3">Population</span>
                                        <?= $population ?>
                                    </li>
                                    <li class="list-group-item d-flex justify-content-between align-items-center">
                                        <span class="badge bg-primary rounded-pill me-3">Official Languages</span>
                                        <?= $linguas ?>
                                    </li>
                                    <li class="list-group-item d-flex justify-content-between align-items-center">
                                        <span class="badge bg-primary rounded-pill me-3">Ethnic Groups</span>
                                        <?= $ethnicGroups ?>
                                    </li>
                                    <li class="list-group-item d-flex justify-content-between align-items-center">
                                        <span class="badge bg-primary rounded-pill me-3">Land Area</span>
                                        <?= $landArea ?>
                                    </li>
                                    <li class="list-group-item d-flex justify-content-between align-items-center">
                                        <span class="badge bg-primary rounded-pill me-3">Postal Code</span>
                                        <?= $postalCode ?>
                                    </li>
                                </ul>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <!-- /.container -->
        </section>
        <!-- /section -->

        <?php if(!empty($government) || !empty($business) || !empty($economy) || !empty($entertainment) || !empty($travel)): ?>
        <section class="wrapper bg-soft-ash">
            <div class="container py-15 py-md-17">
                <div class="row text-center">
                    <div class="col-lg-10 col-xl-9 col-xxl-8 mx-auto position-relative">
                        <img src="<?= $mainRoot ?>assets/img/svg/doodle3.svg" class="h-11 position-absolute d-none d-lg-block" style="top: -45%; left: 23%" alt="">
                        <img src="<?= $mainRoot ?>assets/img/svg/doodle4.svg" class="h-8 position-absolute d-none d-lg-block" style="top: 6%; right: 2%" alt="">
                        <h2 class="fs-16 text-uppercase text-muted mb-3">Sectors</h2>
                        <h3 class="display-3 mb-11 px-lg-5 px-xl-0 px-xxl-3">Check out the sectors in <span class="text-gradient gradient-7"><?= $name ?></span> state.</h3>
                    </div>
                    <!-- /column -->
                </div>
                <!-- /.row -->
                <div class="row gx-lg-0 gy-10 align-items-center jus">
                    <div class="col-lg-12">
                        <div class="row g-6 text-center justify-content-center">
                            <?php if(!empty($government)): ?>
                            <div class="col-md-4">
                                <div class="card shadow-lg mb-6 border-bottom border-primary border-5">
                                    <figure class="card-img-top overlay overlay-1">
                                        <a href="#"><img class="img-fluid" src="./assets/img/photos/fs4.jpg" alt="" /></a>
                                        <figcaption>
                                            <h5 class="from-top mb-0">Read More</h5>
                                        </figcaption>
                                    </figure>
                                    <div class="card-body p-4">
                                        <h3 class="h4 mb-0">Government</h3>
                                    </div>
                                    <!--/.card-body -->
                                </div>
                                <!-- /.card -->
                            </div>
                            <?php endif ?>
                            <!-- /column -->
                            <?php if(!empty($business)): ?>
                            <div class="col-md-4">
                                <div class="card shadow-lg mb-6 border-bottom border-primary border-5">
                                    <figure class="card-img-top overlay overlay-1">
                                        <a href="#"><img class="img-fluid" src="./assets/img/photos/fs4.jpg" alt="" /></a>
                                        <figcaption>
                                            <h5 class="from-top mb-0">Read More</h5>
                                        </figcaption>
                                    </figure>
                                    <div class="card-body p-4">
                                        <h3 class="h4 mb-0">Business</h3>
                                    </div>
                                    <!--/.card-body -->
                                </div>
                                <!-- /.card -->
                            </div>
                            <?php endif ?>
                            <!-- /column -->
                            <?php if(!empty($economy)): ?>
                            <div class="col-md-4">
                                <div class="card shadow-lg mb-6 border-bottom border-primary border-5">
                                    <figure class="card-img-top overlay overlay-1">
                                        <a href="#"><img class="img-fluid" src="./assets/img/photos/fs4.jpg" alt="" /></a>
                                        <figcaption>
                                            <h5 class="from-top mb-0">Read More</h5>
                                        </figcaption>
                                    </figure>
                                    <div class="card-body p-4">
                                        <h3 class="h4 mb-0">Economy</h3>
                                    </div>
                                    <!--/.card-body -->
                                </div>
                                <!-- /.card -->
                            </div>
                            <?php endif ?>
                            <!-- /column -->
                            <?php if(!empty($entertainment)): ?>
                            <div class="col-md-4">
                                <div class="card shadow-lg mb-6 border-bottom border-primary border-5">
                                    <figure class="card-img-top overlay overlay-1">
                                        <a href="#"><img class="img-fluid" src="./assets/img/photos/fs4.jpg" alt="" /></a>
                                        <figcaption>
                                            <h5 class="from-top mb-0">Read More</h5>
                                        </figcaption>
                                    </figure>
                                    <div class="card-body p-4">
                                        <h3 class="h4 mb-0">Entertainment</h3>
                                    </div>
                                    <!--/.card-body -->
                                </div>
                                <!-- /.card -->
                            </div>
                            <?php endif ?>
                            <!-- /column -->
                            <?php if(!empty($travel)): ?>
                            <div class="col-md-4">
                                <div class="card shadow-lg mb-6 border-bottom border-primary border-5">
                                    <figure class="card-img-top overlay overlay-1">
                                        <a href="#"><img class="img-fluid" src="./assets/img/photos/fs4.jpg" alt="" /></a>
                                        <figcaption>
                                            <h5 class="from-top mb-0">Read More</h5>
                                        </figcaption>
                                    </figure>
                                    <div class="card-body p-4">
                                        <h3 class="h4 mb-0">Travel</h3>
                                    </div>
                                    <!--/.card-body -->
                                </div>
                                <!-- /.card -->
                            </div>
                            <?php endif ?>
                            <!-- /column -->
                        </div>
                        <!-- /.row -->
                    </div>
                    <!-- /column -->
                </div>
                <!-- /.row -->
            </div>
            <!-- /.container -->
        </section>
        <!-- /section -->
        <?php endif ?>

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

        <?php }} include("../inc/foot.php"); ?>