PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
PDO::ATTR_EMULATE_PREPARES => false
]
);
return $pdo;
} catch (PDOException $e) {
die("Connection failed: " . $e->getMessage());
}
}
function generateSlug($title) {
$slug = strtolower(trim($title));
$slug = preg_replace('/[^a-z0-9-]/', '-', $slug);
$slug = preg_replace('/-+/', '-', $slug);
$slug = trim($slug, '-');
return $slug;
}
function noteUrl($id, $title = '') {
$slug = $title ? '/' . generateSlug($title) : '';
return BASE_URL . 'note/' . $id . $slug;
}
function diaryUrl($id, $title = '') {
$slug = $title ? '/' . generateSlug($title) : '';
return BASE_URL . 'diary/' . $id . $slug;
}
function pageUrl($slug) {
return BASE_URL . $slug;
}
function notesUrl($page = 1) {
if ($page <= 1) {
return BASE_URL . 'notes';
}
return BASE_URL . 'notes/page/' . $page;
}
function url($path) {
$seoUrls = [
'index.php' => '',
'login.php' => 'login',
'register.php' => 'register',
'logout.php' => 'logout',
'dashboard.php' => 'dashboard',
'create-note.php' => 'create',
'public-notes.php' => 'notes',
];
if (isset($seoUrls[$path])) {
return BASE_URL . $seoUrls[$path];
}
return BASE_URL . $path;
}
// Get site settings
function getSiteSettings() {
$pdo = getDB();
$stmt = $pdo->query("SELECT setting_key, setting_value FROM site_settings");
$settings = [];
while ($row = $stmt->fetch()) {
$settings[$row['setting_key']] = $row['setting_value'];
}
return $settings;
}
// Get menu items
function getMenuItems($type) {
$pdo = getDB();
$stmt = $pdo->prepare("SELECT * FROM menu_items WHERE menu_type = ? AND is_active = 1 ORDER BY sort_order");
$stmt->execute([$type]);
return $stmt->fetchAll();
}
// Get ad by position
function getAd($position) {
$pdo = getDB();
$stmt = $pdo->prepare("SELECT * FROM ads WHERE ad_position = ? AND is_active = 1");
$stmt->execute([$position]);
return $stmt->fetch();
}
function getPages($location = 'header') {
$pdo = getDB();
$column = ($location === 'header') ? 'show_in_header' : 'show_in_footer';
$stmt = $pdo->prepare("SELECT title, slug FROM pages WHERE {$column} = 1 AND is_active = 1 ORDER BY sort_order ASC");
$stmt->execute();
return $stmt->fetchAll();
}
// Start session if not started
if (session_status() === PHP_SESSION_NONE) {
session_start();
}
?>