57 lines
1.5 KiB
PHP
57 lines
1.5 KiB
PHP
<?php
|
|
$host = 'webgis-db'; // Matches the service name in docker-compose
|
|
$db = getenv('POSTGRES_DB');
|
|
$user = getenv('POSTGRES_USER');
|
|
$pass = getenv('POSTGRES_PASSWORD');
|
|
|
|
try {
|
|
$dsn = "pgsql:host=$host;port=5432;dbname=$db;";
|
|
$pdo = new PDO($dsn, $user, $pass, [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);
|
|
|
|
if ($pdo) {
|
|
echo "<h1>✅ Connected to PostGIS!</h1>";
|
|
|
|
// Check PostGIS version
|
|
$query = $pdo->query("SELECT PostGIS_full_version();");
|
|
$version = $query->fetch();
|
|
echo "<p><strong>PostGIS Version:</strong> " . $version[0] . "</p>";
|
|
}
|
|
} catch (PDOException $e) {
|
|
echo "<h1>❌ Connection Failed</h1>";
|
|
echo "<p>" . $e->getMessage() . "</p>";
|
|
}
|
|
?>
|
|
|
|
|
|
|
|
|
|
|
|
<?php
|
|
|
|
// ========================================================================================
|
|
// INIT.PHP — Datenbankverbindung und Session-Initialisierung
|
|
// ========================================================================================
|
|
//
|
|
// ob_start();
|
|
|
|
// session_start();
|
|
|
|
// try {
|
|
|
|
// $opt = [
|
|
// PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
|
|
// PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
|
|
// PDO::ATTR_EMULATE_PREPARES => false
|
|
// ];
|
|
|
|
|
|
// $dsn = "pgsql:host=localhost;dbname=getenv('POSTGRES_DB');port=5432";
|
|
// $pdo = new PDO($dsn, getenv('POSTGRES_USER'), 'getenv('POSTGRES_PASSWORD'), $opt);
|
|
|
|
|
|
// } catch(PDOException $e) {
|
|
// echo "Error: ".$e->getMessage();
|
|
// }
|
|
?>
|
|
|