Environment === "Production") ? "localhost" : "192.168.1.190";
$database = (string) $applicationSettings->DatabaseName;
$user = (string) $applicationSettings->DatabaseUser;
$password = (string) $applicationSettings->DatabasePassword;
try {
$connection = new PDO(
"mysql:host={$host};dbname={$database};charset=utf8mb4",
$user,
$password,
[
PDO::ATTR_EMULATE_PREPARES => false,
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
]
);
} catch (PDOException | Exception $e) {
echo "Unable to connect to the database.";
exit();
}
// Drop and recreate table.
try {
$connection->exec("SET FOREIGN_KEY_CHECKS = 0");
$connection->exec("DROP TABLE IF EXISTS `{$table}`");
$connection->exec($SQL);
$connection->exec("SET FOREIGN_KEY_CHECKS = 1");
echo htmlspecialchars("Table {$table} was created.", ENT_QUOTES, "UTF-8");
} catch (PDOException | Exception $e) {
try {
$connection->exec("SET FOREIGN_KEY_CHECKS = 1");
} catch (Exception $ignored) {
}
echo "Error creating table.";
exit();
}
?>