76 lines
2.5 KiB
PHP
76 lines
2.5 KiB
PHP
<?php
|
|
// includes/db.php
|
|
$host = 'localhost';
|
|
$db = 'line_staff';
|
|
$user = 'root'; // Change as needed
|
|
$pass = '@Samui@1074200'; // Change as needed
|
|
$charset = 'utf8mb4';
|
|
|
|
$dsn = "mysql:host=$host;dbname=$db;charset=$charset";
|
|
$bot_db = 'line_bot';
|
|
$dsn_bot = "mysql:host=$host;dbname=$bot_db;charset=$charset";
|
|
|
|
$options = [
|
|
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
|
|
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
|
|
PDO::ATTR_EMULATE_PREPARES => false,
|
|
];
|
|
|
|
try {
|
|
// 1. Connection for local Line OA Database (line_staff) -> Settings & Admin
|
|
$pdo = new PDO($dsn, $user, $pass, $options);
|
|
|
|
// 2. Connection for Line Bot Database (line_bot) -> Staff Register
|
|
$pdo_bot = new PDO($dsn_bot, $user, $pass, $options);
|
|
} catch (\PDOException $e) {
|
|
die("Database connection failed. Please configure includes/db.php.");
|
|
}
|
|
|
|
// 2. Connection for HIS Database (hosxp)
|
|
$his_host = '10.0.250.250';
|
|
$his_db = 'hos';
|
|
$his_user = 'dmstele'; // Change as needed
|
|
$his_pass = 'dmstele10742'; // Change as needed
|
|
|
|
$conn_hosxp = mysqli_connect($his_host, $his_user, $his_pass, $his_db);
|
|
if (!$conn_hosxp) {
|
|
// die("HIS Database connection failed: " . mysqli_connect_error());
|
|
} else {
|
|
mysqli_set_charset($conn_hosxp, "utf8");
|
|
}
|
|
|
|
// 3. Connection for HR Database (hosoffice)
|
|
$hr_host = '10.0.250.115'; // *** อย่าลืมแก้ 10.0.x.x เป็น IP จริงของ HR นะครับ ***
|
|
$hr_db = 'hosoffice_2566';
|
|
$hr_user = 'hosoffice';
|
|
$hr_pass = 'hosoffice10742';
|
|
|
|
$conn_hosoffice = mysqli_connect($hr_host, $hr_user, $hr_pass, $hr_db);
|
|
if (!$conn_hosoffice) {
|
|
// die("HR Database connection failed: " . mysqli_connect_error());
|
|
} else {
|
|
mysqli_set_charset($conn_hosoffice, "utf8");
|
|
}
|
|
|
|
// 4. Connection for IT Assessment Database
|
|
$assess_host = '10.0.250.112'; // *** แก้เป็น IP ของ Host ประเมิน ***
|
|
$assess_db = 'it_assessment';
|
|
$assess_user = 'root'; // *** แก้ Username ***
|
|
$assess_pass = '@Samui@10742'; // *** แก้ Password ***
|
|
$dsn_assess = "mysql:host=$assess_host;dbname=$assess_db;charset=$charset";
|
|
|
|
try {
|
|
$pdo_assess = new PDO($dsn_assess, $assess_user, $assess_pass, $options);
|
|
} catch (\PDOException $e) {
|
|
$pdo_assess = null;
|
|
}
|
|
|
|
// Helper function to get settings
|
|
function getSetting($pdo, $key)
|
|
{
|
|
$stmt = $pdo->prepare("SELECT setting_value FROM settings WHERE setting_key = ?");
|
|
$stmt->execute([$key]);
|
|
$result = $stmt->fetch();
|
|
return $result ? $result['setting_value'] : null;
|
|
}
|