prepare("SELECT * FROM site_config WHERE id = 1"); $stmt->execute(); $siteConfig = $stmt->fetch(PDO::FETCH_ASSOC); if ($siteConfig) { $site_title = $siteConfig['site_title']; $site_subtitle = $siteConfig['site_subtitle']; $meta_title = !empty($page_meta_title) ? $page_meta_title : $siteConfig['meta_title']; $meta_description = !empty($page_meta_description) ? $page_meta_description : $siteConfig['meta_description']; $meta_keywords = $siteConfig['meta_keywords']; $meta_author = $siteConfig['meta_author']; $site_address = $siteConfig['address']; $site_phone1 = $siteConfig['phone1']; $site_phone2 = $siteConfig['phone2']; $site_email = $siteConfig['email']; $site_working_hours = $siteConfig['working_hours']; $site_facebook_url = $siteConfig['facebook_url']; $site_twitter_url = $siteConfig['twitter_url']; $site_instagram_url = $siteConfig['instagram_url']; $site_youtube_url = $siteConfig['youtube_url']; $site_header_logo = isset($siteConfig['header_logo']) && !empty($siteConfig['header_logo']) ? 'img/site_config/' . $siteConfig['header_logo'] : ''; $site_footer_logo = 'img/site_config/' . $siteConfig['footer_logo']; $site_icon = 'img/site_config/' . $siteConfig['site_icon']; $active_style = $siteConfig['active_style'] ?? 'style.css'; $website_url = !empty($page_url) ? $page_url : SITE_URL; $og_image = !empty($page_meta_image) ? $page_meta_image : $site_footer_logo; } else { // If no config found, set empty values $site_title = ''; $site_subtitle = ''; $meta_title = !empty($page_meta_title) ? $page_meta_title : ''; $meta_description = !empty($page_meta_description) ? $page_meta_description : ''; $meta_keywords = ''; $meta_author = ''; $site_address = ''; $site_phone1 = ''; $site_phone2 = ''; $site_email = ''; $site_working_hours = ''; $site_facebook_url = ''; $site_twitter_url = ''; $site_instagram_url = ''; $site_youtube_url = ''; $site_header_logo = ''; $site_footer_logo = ''; $site_icon = ''; $active_style = 'style.css'; $website_url = !empty($page_url) ? $page_url : ''; $og_image = !empty($page_meta_image) ? $page_meta_image : ''; } } catch (PDOException $e) { error_log("Error fetching site config: " . $e->getMessage()); // Set empty values on database error $site_title = ''; $site_subtitle = ''; $meta_title = !empty($page_meta_title) ? $page_meta_title : ''; $meta_description = !empty($page_meta_description) ? $page_meta_description : ''; $meta_keywords = ''; $meta_author = ''; $site_address = ''; $site_phone1 = ''; $site_phone2 = ''; $site_email = ''; $site_working_hours = ''; $site_facebook_url = ''; $site_twitter_url = ''; $site_instagram_url = ''; $site_youtube_url = ''; $site_header_logo = ''; $site_footer_logo = ''; $site_icon = ''; $active_style = 'style.css'; $website_url = !empty($page_url) ? $page_url : SITE_URL; $og_image = !empty($page_meta_image) ? $page_meta_image : ''; } ?> <?php echo htmlspecialchars($meta_title); ?>
Get Support
Donate