<?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'];
    $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'";
    $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'";
    $runcontact = mysqli_query($db,$sqlcontact) or die("Query Not run");
    $datacontact = mysqli_fetch_assoc($runcontact);
    
    // return page 
    $sqlreturn = "SELECT * FROM `tbl_site_pages` WHERE site_pages_link='return-policy'";
    $runreturn = mysqli_query($db,$sqlreturn) or die("Query Not run");
    $datareturn = mysqli_fetch_assoc($runreturn);
    
    // 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 
    $sqlblog = "SELECT * FROM `tbl_site_pages` WHERE site_pages_link='blog'";
    $runblog = mysqli_query($db,$sqlblog) or die("Query Not run");
    $datablog = mysqli_fetch_assoc($runblog);
    
    // enroll page 
    $sqlenquiry = "SELECT * FROM `tbl_site_pages` WHERE site_pages_link='enquiry'";
    $runenquiry = mysqli_query($db,$sqlenquiry) or die("Query Not run");
    $dataenquiry = mysqli_fetch_assoc($runenquiry);
    
    // 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);
    
    // faqs page 
    $sqlfaqs = "SELECT * FROM `tbl_site_pages` WHERE site_pages_link='faqs'";
    $runfaqs = mysqli_query($db,$sqlfaqs) or die("Query Not run");
    $datafaqs = mysqli_fetch_assoc($runfaqs);
    
    // sitemap page 
    $sqlsitemap = "SELECT * FROM `tbl_site_pages` WHERE site_pages_link='sitemap'";
    $runsitemap = mysqli_query($db,$sqlsitemap) or die("Query Not run");
    $datasitemap = mysqli_fetch_assoc($runsitemap);
    
    // result page 
    $sqltestimonial = "SELECT * FROM `tbl_site_pages` WHERE site_pages_link='testimonial'";
    $runtestimonial = mysqli_query($db,$sqltestimonial) or die("Query Not run");
    $datatestimonial = mysqli_fetch_assoc($runtestimonial);
    
    // canonical 
    $protocol = isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on' ? 'https://' : 'http://';
    $canonical = $protocol . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'];
?>