48 lines
1.1 KiB
PHP
48 lines
1.1 KiB
PHP
<?php
|
|
// config/database.php
|
|
|
|
$serverName = '192.168.20.20';
|
|
$connectionOptions = [
|
|
'Database' => 'Gastro',
|
|
'Uid' => 'sa',
|
|
'PWD' => 'karczma!@#26',
|
|
'CharacterSet' => 'UTF-8',
|
|
];
|
|
|
|
$conn = sqlsrv_connect($serverName, $connectionOptions);
|
|
|
|
if (!$conn) {
|
|
die(json_encode([
|
|
'status' => 'error',
|
|
'message' => 'Błąd połączenia z bazą danych.',
|
|
'errors' => sqlsrv_errors()
|
|
], JSON_UNESCAPED_UNICODE));
|
|
}
|
|
|
|
// Analytics MySQL (event tracking)
|
|
$DB_HOST = '192.168.20.24';
|
|
$DB_NAME = 'karczma_stoliki';
|
|
$DB_USER = 'karczma_stoliki';
|
|
$DB_PASS = 'Reuse-Splicing-Backfire-Bouncing-Operable4';
|
|
$DB_CHARSET = 'utf8mb4';
|
|
|
|
function getAnalyticsPdo()
|
|
{
|
|
global $DB_HOST, $DB_NAME, $DB_USER, $DB_PASS, $DB_CHARSET;
|
|
static $pdo = null;
|
|
|
|
if ($pdo instanceof PDO) {
|
|
return $pdo;
|
|
}
|
|
|
|
$dsn = "mysql:host={$DB_HOST};dbname={$DB_NAME};charset={$DB_CHARSET}";
|
|
$options = [
|
|
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
|
|
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
|
|
PDO::ATTR_EMULATE_PREPARES => false,
|
|
];
|
|
|
|
$pdo = new PDO($dsn, $DB_USER, $DB_PASS, $options);
|
|
return $pdo;
|
|
}
|