<?php   
    include_once "admin/config.php";
    // general 
    $sql1 = "SELECT * FROM `tbl_general`";
    $run1 = mysqli_query($db,$sql1) or die("Query Not run");
    $data1 = mysqli_fetch_assoc($run1);
    // seo 
    $sqll = "SELECT * FROM `tbl_seo` WHERE se_id=1";
    $runl = mysqli_query($db,$sqll) or die("Query Not run");
    $datal = mysqli_fetch_assoc($runl);
    $wspath=$datal['site_path'];
    
    // home page 
    $sqlhome = "SELECT * FROM `tbl_site_pages` WHERE site_pages_link='index'";
    $runhome = mysqli_query($db,$sqlhome) or die("Query Not run");
    $datahome = mysqli_fetch_assoc($runhome);
    
    // about page 
    $sqlabout = "SELECT * FROM `tbl_site_pages` WHERE site_pages_link='about-us'";
    $runabout = mysqli_query($db,$sqlabout) or die("Query Not run");
    $dataabout = mysqli_fetch_assoc($runabout);
    
    // contact page 
    $sqlcontact = "SELECT * FROM `tbl_site_pages` WHERE site_pages_link='contact-us'";
    $runcontact = mysqli_query($db,$sqlcontact) or die("Query Not run");
    $datacontact = mysqli_fetch_assoc($runcontact);
    
// enroll page 
    $sqlenroll = "SELECT * FROM `tbl_site_pages` WHERE site_pages_link='enroll-now'";
    $runenroll = mysqli_query($db,$sqlenroll) or die("Query Not run");
    $dataenroll = mysqli_fetch_assoc($runenroll);
    // privacy page 
    $sqlprivacy = "SELECT * FROM `tbl_site_pages` WHERE site_pages_link='privacy-policy'";
    $runprivacy = mysqli_query($db,$sqlprivacy) or die("Query Not run");
    $dataprivacy = mysqli_fetch_assoc($runprivacy);
    
    // course page 
    $sqlcourse = "SELECT * FROM `tbl_site_pages` WHERE site_pages_link='courses'";
    $runcourse = mysqli_query($db,$sqlcourse) or die("Query Not run");
    $datacourse = mysqli_fetch_assoc($runcourse);
    
    // Job page 
    $sqljob = "SELECT * FROM `tbl_site_pages` WHERE site_pages_link='job-opportunities'";
    $runjob = mysqli_query($db,$sqljob) or die("Query Not run");
    $datajob = mysqli_fetch_assoc($runjob);
    
    // enroll page 
    $sqlenroll = "SELECT * FROM `tbl_site_pages` WHERE site_pages_link='enroll-now'";
    $runenroll = mysqli_query($db,$sqlenroll) or die("Query Not run");
    $dataenroll = mysqli_fetch_assoc($runenroll);
    
    // gallery page 
    $sqlgallery = "SELECT * FROM `tbl_site_pages` WHERE site_pages_link='gallery'";
    $rungallery = mysqli_query($db,$sqlgallery) or die("Query Not run");
    $datagallery = mysqli_fetch_assoc($rungallery);
    
    // video gallery page 
    $sqlvideo = "SELECT * FROM `tbl_site_pages` WHERE site_pages_link='video-gallery'";
    $runvideo = mysqli_query($db,$sqlvideo) or die("Query Not run");
    $datavideo = mysqli_fetch_assoc($runvideo);
    
    // sitemap page 
    $sqlsitemap = "SELECT * FROM `tbl_site_pages` WHERE site_pages_link='site-map'";
    $runsitemap = mysqli_query($db,$sqlsitemap) or die("Query Not run");
    $datasitemap = mysqli_fetch_assoc($runsitemap);
    
    // result page 
    $sqlresult = "SELECT * FROM `tbl_site_pages` WHERE site_pages_link='result'";
    $runresult = mysqli_query($db,$sqlresult) or die("Query Not run");
    $dataresult = mysqli_fetch_assoc($runresult);
    
    // result page 
    $sqlguide = "SELECT * FROM `tbl_site_pages` WHERE site_pages_link='leet-guide'";
    $runguide = mysqli_query($db,$sqlguide) or die("Query Not run");
    $dataguide = mysqli_fetch_assoc($runguide);
    
    // canonical 
    $protocol = isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on' ? 'https://' : 'http://';
    $canonical = $protocol . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'];
?>
<?php
    $loc_slug = $_REQUEST['loc_slug'] ?? null;

    if ($loc_slug !== null) {
        $loc = "SELECT * FROM `tbl_location` WHERE loc_slug='$loc_slug'";
        $runloc = mysqli_query($db, $loc) or die("Query Not run");
        $dataloc = mysqli_fetch_assoc($runloc);
        $location = $dataloc["loc_name"];
    } else {
        $sqldef = "SELECT * FROM `login_tbl` WHERE id=1";
        $rundef = mysqli_query($db, $sqldef) or die("Query Not run");
        $datadef = mysqli_fetch_assoc($rundef);
        $location = $datadef['default_location'];
    }
?>