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(); } ?>