prepare("SELECT * FROM mubashier_listings WHERE id = :id LIMIT 1"); $seo_stmt->execute([':id' => $actual_id]); $seo_data = $seo_stmt->fetch(PDO::FETCH_ASSOC); $final_title = (!empty($seo_data['title'])) ? $seo_data['title'] : ((!empty($seo_data['subject'])) ? $seo_data['subject'] : 'بالبلدي - آخر الأخبار'); $final_content = (!empty($seo_data['description'])) ? $seo_data['description'] : ((!empty($seo_data['content'])) ? $seo_data['content'] : $seo_data['body']); $final_desc = mb_substr(strip_tags($final_content), 0, 160); $final_image = (!empty($seo_data['image'])) ? $seo_data['image'] : 'https://belbalady.net'; $final_date = isset($seo_data['created_at']) ? date('c', strtotime($seo_data['created_at'])) : date('c'); $clean_title_html = htmlspecialchars($final_title, ENT_QUOTES, 'UTF-8'); $clean_desc_html = htmlspecialchars($final_desc, ENT_QUOTES, 'UTF-8'); $clean_url_html = "https://belbalady.net" . $actual_id; ?>