File: /home/southcentraltrains.co.uk/public_html/wp-content/uk/index.php
<?php
$folder_location='uk';
$page_extension='.php';
class DB_Conf { //database setup for the whole script
public static $DB_Config = array(
'DbConfig' => array(
'Hostname' => 'localhost', //database ip
'Username' => 'rubbish_clear', //database user name
'Password' => 'Follypress2', //database password
'Database' => 'rubbish_clear', //database name
)
);
}
class DB_connect{
public static function connect_db(){
$cont = mysqli_init();
mysqli_options($cont,MYSQLI_OPT_CONNECT_TIMEOUT, 30);
mysqli_real_connect($cont,DB_Conf::$DB_Config['DbConfig']['Hostname'], DB_Conf::$DB_Config['DbConfig']['Username'], DB_Conf::$DB_Config['DbConfig']['Password'], DB_Conf::$DB_Config['DbConfig']['Database']);
// echo @mysqli_ping($cont) ? 'true' : 'false';
return $cont;
}
public static function disconnect_db($cont){
mysqli_close($cont);
}
}
$domain= preg_replace('/^www./','',$_SERVER['HTTP_HOST']);
$path = $_SERVER['REQUEST_URI'];
$path = strtok($path, '?');
$path = str_replace('%20',' ',$path);
$path = str_replace('%09',' ',$path);
$path = str_replace('/'.$folder_location,'',$path);
$path = str_replace($page_extension,'',$path);
$base_url='../';
$cont=DB_connect::connect_db();
$query = mysqli_query($cont, "SELECT * FROM `data` WHERE `url`='$path';");
$page_data=mysqli_fetch_assoc($query);
$type_of_page=$page_data['page_type'];
$page_id=$page_data['id'];
$location_links='';
$keyword_link='';
if( $type_of_page==0){
$location_links='';
$keyword_link='';
}
if( $type_of_page==1){
$query = mysqli_query($cont, "SELECT `linked_to` FROM `index` WHERE `page_id`='$page_id' AND `linked_to_type`='2';");
$index_select=array();
while($row=mysqli_fetch_assoc($query)){
$index_select[]=$row;
};
foreach($index_select as $ind){
$this_id=$ind['linked_to'];
$query = mysqli_query($cont, "SELECT `url`,`Heading` FROM `data` WHERE `id`='$this_id';");
$link=mysqli_fetch_assoc($query);
$location_links.='<li><a href="/'.$folder_location.$link['url'].'">'.$link['Heading'].'</a></li>'.PHP_EOL;
}
}
if( $type_of_page==2){
$query = mysqli_query($cont, "SELECT `linked_to` FROM `index` WHERE `page_id`='$page_id' AND `linked_to_type`='1';");
$index_select=array();
while($row=mysqli_fetch_assoc($query)){
$index_select[]=$row;
};
foreach($index_select as $ind){
$this_id=$ind['linked_to'];
$query = mysqli_query($cont, "SELECT `url`,`Heading` FROM `data` WHERE `id`='$this_id';");
$link=mysqli_fetch_assoc($query);
$keyword_link.='<li><a href="/'.$folder_location.$link['url'].$page_extension.'">'.$link['Heading'].'</a></li>'.PHP_EOL;
}
}
if( $type_of_page==3){
$query = mysqli_query($cont, "SELECT `linked_to` FROM `index` WHERE `page_id`='$page_id' AND `linked_to_type`='1';");
$index_select=array();
while($row=mysqli_fetch_assoc($query)){
$index_select[]=$row;
};
foreach($index_select as $ind){
$this_id=$ind['linked_to'];
$query = mysqli_query($cont, "SELECT `url`,`Heading` FROM `data` WHERE `id`='$this_id';");
$link=mysqli_fetch_assoc($query);
$keyword_link.='<li><a href="/'.$folder_location.$link['url'].$page_extension.'">'.$link['Heading'].'</a></li>'.PHP_EOL;
}
$query = mysqli_query($cont, "SELECT `linked_to` FROM `index` WHERE `page_id`='$page_id' AND `linked_to_type`='2';");
$index_select=array();
while($row=mysqli_fetch_assoc($query)){
$index_select[]=$row;
};
foreach($index_select as $ind){
$this_id=$ind['linked_to'];
$query = mysqli_query($cont, "SELECT `url`,`Heading` FROM `data` WHERE `id`='$this_id';");
$link=mysqli_fetch_assoc($query);
$location_links.='<li><a href="/'.$folder_location.$link['url'].'">'.$link['Heading'].'</a></li>'.PHP_EOL;
}
}
if( $type_of_page==4){
$base_page_id=$page_data['base_page'];
$query = mysqli_query($cont, "SELECT `page_type`, `url` FROM `data` WHERE `id`='$base_page_id';");
$base_page=mysqli_fetch_assoc($query);
$base_url='/'.$folder_location.$base_page['url'];
$base_type=$base_page['page_type'];
##query the top level page
##get the type of page and the id from it
##get the data from the index
if( $base_type==1){
$query = mysqli_query($cont, "SELECT `linked_to` FROM `index` WHERE `page_id`='$base_page_id' AND `linked_to_type`='2';");
$index_select=array();
while($row=mysqli_fetch_assoc($query)){
$index_select[]=$row;
};
foreach($index_select as $ind){
$this_id=$ind['linked_to'];
$query = mysqli_query($cont, "SELECT `url`,`Heading` FROM `data` WHERE `id`='$this_id';");
$link=mysqli_fetch_assoc($query);
$location_links.='<li><a href="/'.$folder_location.$link['url'].'">'.$link['Heading'].'</a></li>'.PHP_EOL;
}
}
if( $base_type==2){
$query = mysqli_query($cont, "SELECT `linked_to` FROM `index` WHERE `page_id`='$base_page_id' AND `linked_to_type`='1';");
$index_select=array();
while($row=mysqli_fetch_assoc($query)){
$index_select[]=$row;
};
foreach($index_select as $ind){
$this_id=$ind['linked_to'];
$query = mysqli_query($cont, "SELECT `url`,`Heading` FROM `data` WHERE `id`='$this_id';");
$link=mysqli_fetch_assoc($query);
$keyword_link.='<li><a href="/'.$folder_location.$link['url'].$page_extension.'">'.$link['Heading'].'</a></li>'.PHP_EOL;
}
}
if( $base_type==3){
$query = mysqli_query($cont, "SELECT `linked_to` FROM `index` WHERE `page_id`='$base_page_id' AND `linked_to_type`='1';");
$index_select=array();
while($row=mysqli_fetch_assoc($query)){
$index_select[]=$row;
};
foreach($index_select as $ind){
$this_id=$ind['linked_to'];
$query = mysqli_query($cont, "SELECT `url`,`Heading` FROM `data` WHERE `id`='$this_id';");
$link=mysqli_fetch_assoc($query);
$keyword_link.='<li><a href="/'.$folder_location.$link['url'].$page_extension.'">'.$link['Heading'].'</a></li>'.PHP_EOL;
}
$query = mysqli_query($cont, "SELECT `linked_to` FROM `index` WHERE `page_id`='$base_page_id' AND `linked_to_type`='2';");
$index_select=array();
while($row=mysqli_fetch_assoc($query)){
$index_select[]=$row;
};
foreach($index_select as $ind){
$this_id=$ind['linked_to'];
$query = mysqli_query($cont, "SELECT `url`,`Heading` FROM `data` WHERE `id`='$this_id';");
$link=mysqli_fetch_assoc($query);
$location_links.='<li><a href="/'.$folder_location.$link['url'].'">'.$link['Heading'].'</a></li>'.PHP_EOL;
}
}
}
if($page_data['lat']==0){
$page_data['lat']='0';
$page_data['long']=52;
}
#take the page
#find in the pages
#look at the link structure and get the required links
#read the has reviews in order to search for reviews for the pages that are created
#if its not there create some sort of a 404 page that will try to direct you to the correct place.
DB_connect::disconnect_db($cont);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en-gb">
<head>
<title><?php echo $page_data['meta_title']; ?></title>
<meta name="description" content="<?php echo $page_data['meta_descriptions']; ?>" />
<meta name="keywords" content="<?php echo $page_data['meta_keywords']; ?>" />
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<script src="js/ie-emulation-modes-warning.js"></script>
<link rel="apple-touch-icon" href="/apple-touch-icon.png">
<link rel="icon" href="/favicon.ico">
<link href="css/bootstrap.min.css" rel="stylesheet" type="text/css">
<link href="css/docs.min.css" rel="stylesheet" type="text/css">
<link href="/uk/css/bootstrap.min.css" rel="stylesheet" type="text/css">
<link href="/uk/css/docs.min.css" rel="stylesheet" type="text/css">
</head>
<body class="bs-docs-home">
<a id="skippy" class="sr-only sr-only-focusable" href="/healthandsafety.php#content"><div class="container"><span class="skiplink-text">Skip to main content</span></div></a>
<!-- Docs master nav -->
<header class="navbar navbar-static-top bs-docs-nav" id="top" role="banner">
<div class="container">
<div class="navbar-header">
<button class="navbar-toggle collapsed" type="button" data-toggle="collapse" data-target=".bs-navbar-collapse">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a href="/healthandsafety.php" class="navbar-brand">Any Waste</a>
</div>
<nav class="collapse navbar-collapse bs-navbar-collapse">
<?php include ($_SERVER["DOCUMENT_ROOT"] . '/includes/menu.php'); ?>
</nav>
</div>
<!-- Start of LiveChat (www.livechatinc.com) code -->
<script>
window.__lc = window.__lc || {};
window.__lc.license = 12765381;
;(function(n,t,c){function i(n){return e._h?e._h.apply(null,n):e._q.push(n)}var e={_q:[],_h:null,_v:"2.0",on:function(){i(["on",c.call(arguments)])},once:function(){i(["once",c.call(arguments)])},off:function(){i(["off",c.call(arguments)])},get:function(){if(!e._h)throw new Error("[LiveChatWidget] You can't use getters before load.");return i(["get",c.call(arguments)])},call:function(){i(["call",c.call(arguments)])},init:function(){var n=t.createElement("script");n.async=!0,n.type="text/javascript",n.src="https://cdn.livechatinc.com/tracking.js",t.head.appendChild(n)}};!n.__lc.asyncInit&&e.init(),n.LiveChatWidget=n.LiveChatWidget||e}(window,document,[].slice))
</script>
<noscript><a href="https://www.livechatinc.com/chat-with/12765381/" rel="nofollow">Chat with us</a>, powered by <a href="https://www.livechatinc.com/?welcome" rel="noopener nofollow" target="_blank">LiveChat</a></noscript>
<!-- End of LiveChat code -->
</header>
<!-- Page content of course! -->
<main class="bs-docs-masthead" id="content" role="main" tabindex="-1">
<div class="container">
<div class="row">
<div class="col-sm-6">
<?php echo $page_data['box1']; ?>
<p><b><?php echo $page_data['box3']; ?></b></p>
</div>
<div class="col-sm-6">
<p> </p>
<p> </p>
<p><img src="/uk/images/rubbish-logo.png" /></p>
</div>
</div>
</div>
</main>
<div class="bs-docs-featurette">
<div class="container">
<?php echo $page_data['box2']; ?>
<div class="row">
<div class="col-sm-9"><h2><a href="<?php echo $base_url; ?>"><?php echo $page_data['Heading']; ?></a></h2><?php echo $page_data['content']; ?></div>
<div class="col-sm-3">
<br><div id="map">
<div id="map-canvas"></div></div>
<img src="/uk/images/enviroment.png"/>
<div id="facebook">
<!-- +1 -->
<div class="plusone">
<!-- Place this tag where you want the +1 button to render -->
<g:plusone size="medium" annotation="none"></g:plusone>
<!-- Place this render call where appropriate -->
<script type="text/javascript">
(function() {
var po = document.createElement('script'); po.type = 'text/javascript'; po.async = true;
po.src = 'https://apis.google.com/js/plusone.js';
var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(po, s);
})();
</script>
</div>
<!-- end +1 -->
<!-- twitter -->
<div class="twitter">
<a href="https://twitter.com/share" class="twitter-share-button" data-count="none" data-via="dominoc">Tweet</a><script type="text/javascript" src="//platform.twitter.com/widgets.js"></script>
</div>
<!-- end twitter -->
<!-- like -->
<div class="fb-like" data-send="false" data-layout="button_count" data-width="90" data-show-faces="false"></div>
<!-- end like -->
</div>
<img src="/uk/images/logo2.png" />
<h2>____________________</h2>
<h2>Call now on Manchester 07437 617 021</h2>
<h2><img src="/uk/images/stars-reviews.gif" /></h2>
<h2><br/>
<img src="/uk/images/recycle.png" width="200" height="150" /><br />
</h2>
<div id="links"> <h4>Local Manchester areas</h4>
<?php echo $location_links; ?></div><br /><br />
<div id="links"><h4>Services</h4>
<?php echo $keyword_link; ?></div></div>
</div>
</div>
</div>
<div class="bs-docs-featurette">
<div class="container">
<h2 class="bs-docs-featurette-title">Latest reviews from happy <span data-hveid="50"><em>Mancunian</em></span>s</h2>
<p class="lead">Please feel free to read our latest reviews from customers in London, Essex & Berkshire. <a href="/healthandsafety.php#">More testimonials</a></p>
<p class="lead"><em><?php echo $page_data['box4']; ?></em></p>
<hr class="half-rule">
<div class="row bs-docs-featured-sites">
<div class="col-xs-6 col-sm-3">
<p>"RC Ltd did exactly what they said and removed all of garden rubbish and took away the fridge too. Good company..."</p>
<p>Mrs Brown -<strong>Manchester</strong></p>
<p><img src="/uk/images/stars-reviews.gif"/></p>
</div>
<div class="col-xs-6 col-sm-3">
<p>"Always prompt & courteous - very quick & no hassles. We've used them for home and for a big workplace clear out. Very efficient." Mr & Mrs Hall <strong>Manchester</strong></p>
<p><img src="/uk/images/stars-reviews.gif" alt=""/></p>
</div>
<div class="col-xs-6 col-sm-3">
<p>"They sent two blokes with a lorry and took away all the rubbish for less that we had been quoted elsewhere. Enough said.</p>
<p>Chris - Altrincham</p>
<p><img src="/uk/images/stars-reviews.gif" alt=""/></p>
</div>
<div class="col-xs-6 col-sm-3">
<p>"Thanks, clean service, thanks for taking the fridge and sweeping up Callum and Alan were a delight! :)</p>
<p>Peter - <strong>Prestwich</strong></p>
<p><img src="/uk/images/stars-reviews.gif" alt=""/></p>
</div>
</div>
<p class="lead"> </p>
</div>
</div>
<!-- Footer
================================================== -->
<footer class="bs-docs-footer" role="contentinfo">
<div class="container">
<div class="bs-docs-social"> </div>
<?php include ($_SERVER["DOCUMENT_ROOT"] . '/includes/footer.php'); ?><div style="hidden"><?php echo $page_data['rich_snippets_location']; ?> <?php echo $page_data['rich_snippets_product']; ?> </ul></div>
</div>
</footer>
<!-- Bootstrap core JavaScript
================================================== -->
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-61446304-1', 'auto');
ga('send', 'pageview');
</script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/docs.min.js"></script>
<!-- IE10 viewport hack for Surface/desktop Windows 8 bug -->
<script src="js/ie10-viewport-bug-workaround.js"></script>
<script src="/uk/js/bootstrap.min.js"></script>
<script src="/uk/js/docs.min.js"></script>
<script>
window.twttr = (function (d,s,id) {
var t, js, fjs = d.getElementsByTagName(s)[0];
if (d.getElementById(id)) return; js=d.createElement(s); js.id=id; js.async=1;
js.src="https://platform.twitter.com/widgets.js"; fjs.parentNode.insertBefore(js, fjs);
return window.twttr || (t = { _e: [], ready: function(f){ t._e.push(f) } });
}(document, "script", "twitter-wjs"));
</script>
<script>
function initialize() {
var myLatlng = new google.maps.LatLng(<?php echo $page_data['long']; ?>, <?php echo $page_data['lat']; ?>);
var mapOptions = {
zoom: 10,
center: myLatlng,
mapTypeId: google.maps.MapTypeId.ROADMAP
};
var map = new google.maps.Map(document.getElementById('map-canvas'),
mapOptions);
var contentString = '';
var marker = new google.maps.Marker({
position: myLatlng,
map: map,
title: 'Rubbish Clearance'
});
infowindow.open(map,marker);
}
function loadScript() {
var script = document.createElement('script');
script.type = 'text/javascript';
script.src = 'https://maps.googleapis.com/maps/api/js?v=3.exp&sensor=false&' +
'callback=initialize';
document.body.appendChild(script);
}
window.onload = loadScript;
</script>
<div id="fb-root"></div>
<script>(function(d, s, id) {
var js, fjs = d.getElementsByTagName(s)[0];
if (d.getElementById(id)) return;
js = d.createElement(s); js.id = id;
js.src = "//connect.facebook.net/en_GB/all.js#xfbml=1";
fjs.parentNode.insertBefore(js, fjs);
}(document, 'script', 'facebook-jssdk'));</script>
</body>
</html>