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
if (!empty($page_meta_image)) {
$og_image = (strpos($page_meta_image, 'http') === 0) ? $page_meta_image : SITE_URL . '/' . ltrim($page_meta_image, '/');
} elseif (!empty($site_header_logo)) {
$og_image = SITE_URL . '/' . ltrim($site_header_logo, '/');
} elseif (!empty($site_footer_logo)) {
$og_image = SITE_URL . '/' . ltrim($site_footer_logo, '/');
} else {
$og_image = '';
}
} else {
$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());
$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 : '';
}
/* ===== Phone formatting without country code ===== */
$display_phone = '';
$wa_phone = '';
if (!empty($site_phone1)) {
$digits = preg_replace('/\D+/', '', $site_phone1);
// Extract just the local number (last 10 digits) and format it
$local10 = substr($digits, -10);
if ($local10) {
// Format as: XXXXX-XXXXX or as per your preference
$formatted_local = substr($local10, 0, 5) . '-' . substr($local10, 5);
$display_phone = $formatted_local; // e.g., 78805-88713 (without +91)
$wa_phone = $local10; // Store just the 10-digit number for WhatsApp
}
}
?>
<?php echo htmlspecialchars($meta_title); ?>