noooviiieee
23 lines
820 B
PHP
23 lines
820 B
PHP
<?php
|
|
// Baca environment variable dari Coolify, fallback ke localhost untuk development
|
|
$host = getenv('DB_HOST') ?: 'localhost';
|
|
$user = getenv('DB_USER') ?: 'root';
|
|
$pass = getenv('DB_PASSWORD') ?: '';
|
|
$db = getenv('DB_NAME') ?: 'peta_spbu';
|
|
$port = getenv('DB_PORT') ?: 3306;
|
|
|
|
// Sediakan PDO
|
|
try {
|
|
$pdo = new PDO("mysql:host=$host;port=$port;dbname=$db;charset=utf8mb4", $user, $pass);
|
|
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
|
|
} catch (PDOException $e) {
|
|
die("Koneksi PDO gagal: " . $e->getMessage());
|
|
}
|
|
|
|
// Kembalikan $conn sebagai MySQLi karena banyak script lama bergantung pada mysqli
|
|
$conn = new mysqli($host, $user, $pass, $db, $port);
|
|
if ($conn->connect_error) {
|
|
die("Koneksi MySQLi gagal: " . $conn->connect_error);
|
|
}
|
|
$conn->set_charset('utf8mb4');
|
|
?>
|