<?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);
    
    $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'];
    }
    
    // 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'];
    $site_name=$datal['site_name'];
    
    // 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);
    
    // 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);
    
    // terms page 
    $sqlterms = "SELECT * FROM `tbl_site_pages` WHERE site_pages_link='term-and-conditions'";
    $runterms = mysqli_query($db,$sqlterms) or die("Query Not run");
    $dataterms = mysqli_fetch_assoc($runterms);
    
    // privacy page 
    $sqlprivecy = "SELECT * FROM `tbl_site_pages` WHERE site_pages_link='privacy-policy'";
    $runprivecy = mysqli_query($db,$sqlprivecy) or die("Query Not run");
    $dataprivecy = mysqli_fetch_assoc($runprivecy);
    
    // privacy page 
    $sqlrefund = "SELECT * FROM `tbl_site_pages` WHERE site_pages_link='refund-policy'";
    $runrefund = mysqli_query($db,$sqlrefund) or die("Query Not run");
    $datarefund = mysqli_fetch_assoc($runrefund);
    
    // canonical 
    $protocol = isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on' ? 'https://' : 'http://';
    $canonical = $protocol . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'];
?>