R E D

NAME	SIZE	PERMISSION	ACTION
connect.php	2.13 KB	-rwxr-xr-x
index.php	129 B	-rwxr-xr-x

Code Editor : connect.php

<?php
	error_reporting (E_ALL ^ E_NOTICE);
	error_reporting(0);
	error_reporting(E_ERROR | E_PARSE);
$servername = "localhost";
	$username = "lifelonglearn";
	$password = "2n1J3q2s";
	$dbname = "lifelonglearn";
	
	try 
	{
		$conn = new PDO("mysql:host=$servername;dbname=$dbname;charset=utf8", $username, $password);
		$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	} 
	catch(PDOException $e) 
	{
		echo "Connection Failed: " . $e->getMessage();
	}
	
	date_default_timezone_set("Asia/Bangkok");
	
	$company_id = "1";
	$stmt_company = $conn->prepare("SELECT * FROM company WHERE company_id=:company_id");
	$stmt_company->bindParam(':company_id', $company_id , PDO::PARAM_STR);
	$stmt_company->execute();
	$row_company = $stmt_company->fetch(PDO::FETCH_ASSOC);

$company_brand = $row_company['company_brand'];
        $company_brand_en = $row_company['company_brand_en'];
	$company_name = $row_company['company_name'];
        $company_name_en = $row_company['company_name_en'];
	$company_address = $row_company['company_address'];
	$company_tel = $row_company['company_tel'];
	$company_logo = $row_company['company_logo'];
	$company_email = $row_company['company_email'];
	$company_header = $row_company['company_header'];
	$company_header_sm = $row_company['company_header_sm'];
	$company_url = $row_company['company_url'];
	$company_facebook = $row_company['company_facebook'];
	$company_line = $row_company['company_line'];
	$company_open = $row_company['company_open'];
	$company_welcome = $row_company['company_welcome'];
	$company_welcome_sm = $row_company['company_welcome_sm'];
	$txt_header_md = $row_company['txt_header_md'];
	$txt_header_sm = $row_company['txt_header_sm'];
	$txt_box1 = $row_company['txt_box1'];
	$txt_box2 = $row_company['txt_box2'];
	$company_maps = $row_company['company_maps'];
	$title = $company_name;
        $company_service = $row_company['company_service'];
        $company_service_en = $row_company['company_service_en'];

$strLang = $_GET["lang"];
$strPage = $_GET["page"];

$lang = "";

if($strLang == "th")
{
	$lang = "navbar.php";
}
else if($strLang == "en")
{
	$lang = "navbar_en.php";
}
else
{
	$lang = "navbar.php";
}
?>

${this.title}

Code Editor : connect.php