<?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);
    
    // canonical 
    $protocol = isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on' ? 'https://' : 'http://';
    $canonical = $protocol . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'];
?>