array(
'Hostname' => 'localhost', //database ip
'Username' => 'hurlinghamcliniccouk', //database user name
'Password' => 'j5lA6mAhGIyrgzCd', //database password
'Database' => 'hurlinghamcliniccouk', //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.=''.$link['Heading'].' '.$link['Heading'].' '.$link['Heading'].' '.$link['Heading'].' '.$link['Heading'].' '.$link['Heading'].' '.$link['Heading'].' '.$link['Heading'].'
<? echo $page_data['meta_title']; ?>
