$value) { if (is_string($value)) { $siteConfig[$key] = htmlspecialchars_decode($value, ENT_QUOTES); } } } catch (PDOException $e) { $error = "Database error: " . htmlspecialchars($e->getMessage()); logError($error); } // Handle form submission if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'update') { if (!verifyCSRF($_POST['csrf_token'])) { $error = "Invalid CSRF token."; logError($error); } else { $site_title = sanitizeInput($_POST['site_title'], false); $site_subtitle = sanitizeInput($_POST['site_subtitle'], false); $meta_title = sanitizeInput($_POST['meta_title'], false); $meta_description = sanitizeInput($_POST['meta_description'], false); $meta_keywords = sanitizeInput($_POST['meta_keywords'], false); $meta_author = sanitizeInput($_POST['meta_author'], false); $address = sanitizeInput($_POST['address'], false); $phone1 = sanitizeInput($_POST['phone1'], false); $phone2 = !empty($_POST['phone2']) ? sanitizeInput($_POST['phone2'], false) : null; $email = sanitizeInput($_POST['email'], false); $working_hours = sanitizeInput($_POST['working_hours'], false); $facebook_url = !empty($_POST['facebook_url']) ? sanitizeInput($_POST['facebook_url'], false) : '#'; $twitter_url = !empty($_POST['twitter_url']) ? sanitizeInput($_POST['twitter_url'], false) : '#'; $instagram_url = !empty($_POST['instagram_url']) ? sanitizeInput($_POST['instagram_url'], false) : '#'; $youtube_url = !empty($_POST['youtube_url']) ? sanitizeInput($_POST['youtube_url'], false) : '#'; $website_url = !empty($_POST['website_url']) ? sanitizeInput($_POST['website_url'], false) : '#'; $map_embed_url = !empty($_POST['map_embed_url']) ? trim($_POST['map_embed_url']) : null; $footer_logo = $siteConfig['footer_logo'] ?? null; $header_logo = $siteConfig['header_logo'] ?? null; $site_icon = $siteConfig['site_icon'] ?? null; if ($map_embed_url) { logError('Raw map_embed_url input: ' . $map_embed_url); if (preg_match('/]+src=["\'](.*?)["\']/i', $map_embed_url, $matches)) { $map_embed_url = $matches[1]; } $map_embed_url = filter_var($map_embed_url, FILTER_SANITIZE_URL); logError('Processed map_embed_url: ' . $map_embed_url); if ($map_embed_url && !preg_match('/^https:\/\/www\.google\.com\/maps\/embed\?/', $map_embed_url)) { $error = "Google Maps Embed URL must start with 'https://www.google.com/maps/embed?'."; logError($error); } } if (empty($site_title) || empty($site_subtitle) || empty($meta_title) || empty($meta_description) || empty($meta_keywords) || empty($meta_author) || empty($address) || empty($phone1) || empty($email) || empty($working_hours)) { $error = "Please fill in all required fields."; logError($error); } elseif (!filter_var($email, FILTER_VALIDATE_EMAIL)) { $error = "Invalid email address."; logError($error); } else { // Handle file uploads using config.php's uploadFile function if (!empty($_FILES['footer_logo']['name'])) { $uploadResult = uploadFile($_FILES['footer_logo'], 'img/site_config'); if ($uploadResult['success']) { if (!empty($siteConfig['footer_logo'])) { $oldFilePath = __DIR__ . '/../img/site_config/' . $siteConfig['footer_logo']; if (file_exists($oldFilePath)) { unlink($oldFilePath); logError("Old footer logo deleted: " . $siteConfig['footer_logo']); } } $footer_logo = $uploadResult['filename']; } else { $error = $uploadResult['message']; logError($error); } } if (!empty($_FILES['header_logo']['name'])) { $uploadResult = uploadFile($_FILES['header_logo'], 'img/site_config'); if ($uploadResult['success']) { if (!empty($siteConfig['header_logo'])) { $oldFilePath = __DIR__ . '/../img/site_config/' . $siteConfig['header_logo']; if (file_exists($oldFilePath)) { unlink($oldFilePath); logError("Old header logo deleted: " . $siteConfig['header_logo']); } } $header_logo = $uploadResult['filename']; } else { $error = $uploadResult['message']; logError($error); } } if (!empty($_FILES['site_icon']['name'])) { $uploadResult = uploadFile($_FILES['site_icon'], 'img/site_config'); if ($uploadResult['success']) { if (!empty($siteConfig['site_icon'])) { $oldFilePath = __DIR__ . '/../img/site_config/' . $siteConfig['site_icon']; if (file_exists($oldFilePath)) { unlink($oldFilePath); logError("Old site icon deleted: " . $siteConfig['site_icon']); } } $site_icon = $uploadResult['filename']; } else { $error = $uploadResult['message']; logError($error); } } if (empty($error)) { try { $stmt = $db->prepare(" UPDATE site_config SET site_title = ?, site_subtitle = ?, meta_title = ?, meta_description = ?, meta_keywords = ?, meta_author = ?, address = ?, phone1 = ?, phone2 = ?, email = ?, working_hours = ?, facebook_url = ?, twitter_url = ?, instagram_url = ?, youtube_url = ?, footer_logo = ?, header_logo = ?, site_icon = ?, website_url = ?, map_embed_url = ?, updated_at = NOW() WHERE id = ? "); $stmt->execute([ $site_title, $site_subtitle, $meta_title, $meta_description, $meta_keywords, $meta_author, $address, $phone1, $phone2, $email, $working_hours, $facebook_url, $twitter_url, $instagram_url, $youtube_url, $footer_logo, $header_logo, $site_icon, $website_url, $map_embed_url, $siteConfig['id'] ]); $success = "Site configuration updated successfully."; clearSiteConfigCache(); header("Location: site_config.php?success=" . urlencode($success)); exit; } catch (PDOException $e) { $error = "Database error: " . htmlspecialchars($e->getMessage()); logError($error); } } } } } $pageTitle = "Site Configuration Management"; include 'includes/header.php'; ?>

Update Site Configuration

Site Title *

Site Subtitle *

Meta Title *

Meta Description *

Meta Keywords * (Comma separated)

Meta Author *

Address *

Email *

Phone Number 1 *

Phone Number 2 (Optional)

Working Hours *

Website URL *

Header Logo

Current Header Logo

Footer Logo

Current Footer Logo

Site Icon (Favicon)

Current Site Icon

Facebook URL (Optional)

Twitter URL (Optional)

Instagram URL (Optional)

YouTube URL (Optional)

Google Maps Embed URL (Optional) Paste the full <iframe> code or just the URL starting with 'https://www.google.com/maps/embed?'

Cancel