{
"@context": "https://schema.org",
"@type": "Article",
"headline": "' . htmlspecialchars($post['title']) . '",
"image": "' . $seo_image . '",
"datePublished": "' . date('c', strtotime($post['published_at'] ?? $post['created_at'])) . '",
"dateModified": "' . date('c', strtotime($post['updated_at'] ?? $post['created_at'])) . '",
"author": {
"@type": "Person",
"name": "' . $seo_author . '"
},
"publisher": {
"@type": "Organization",
"name": "' . htmlspecialchars(SITE_TITLE) . '",
"logo": {
"@type": "ImageObject",
"url": "' . BASE_URL . 'assets/images/logo.webp"
}
},
"description": "' . htmlspecialchars(substr(strip_tags($post['excerpt'] ?? $post['content']), 0, 200)) . '"
}
';
// Update view count
$update_query = "UPDATE posts SET views = views + 1 WHERE id = ?";
$update_stmt = mysqli_prepare($conn, $update_query);
mysqli_stmt_bind_param($update_stmt, "i", $post['id']);
mysqli_stmt_execute($update_stmt);
// Fetch related posts
$related_query = "SELECT * FROM posts
WHERE post_type = 'blog'
AND status = 'published'
AND id != ?
AND (category_id = ? OR category_id IS NULL)
ORDER BY published_at DESC
LIMIT 3";
$related_stmt = mysqli_prepare($conn, $related_query);
mysqli_stmt_bind_param($related_stmt, "ii", $post['id'], $post['category_id']);
mysqli_stmt_execute($related_stmt);
$related_result = mysqli_stmt_get_result($related_stmt);
$related_posts = [];
while ($related = mysqli_fetch_assoc($related_result)) {
$related_posts[] = $related;
}
// Fetch recent posts for sidebar
$recent_query = "SELECT * FROM posts WHERE post_type = 'blog' AND status = 'published' ORDER BY published_at DESC LIMIT 5";
$recent_result = mysqli_query($conn, $recent_query);
$recent_posts = [];
if ($recent_result) {
while ($recent = mysqli_fetch_assoc($recent_result)) {
$recent_posts[] = $recent;
}
}
$page_title = htmlspecialchars($post['title']);
// SEO Meta Tags
$seo_title = htmlspecialchars($post['title']);
$seo_description = !empty($post['excerpt']) ? htmlspecialchars(substr($post['excerpt'], 0, 160)) : htmlspecialchars(substr(strip_tags($post['content']), 0, 160));
$seo_keywords = 'OHPAG, oral health Ghana, dental news Ghana, ' . (!empty($post['category_name']) ? htmlspecialchars($post['category_name']) . ', ' : '') . htmlspecialchars($post['title']);
$seo_image = !empty($post['featured_image']) ? BASE_URL . htmlspecialchars($post['featured_image']) : BASE_URL . 'assets/images/logo.webp';
$seo_type = 'article';
$canonical_url = BASE_URL . 'post/' . htmlspecialchars($post['slug']);
$seo_author = 'OHPAG';
// Structured Data for Blog Post
$post_date = !empty($post['published_at']) ? $post['published_at'] : $post['created_at'];
$structured_data = '
' . (!empty($post['category_name']) ? '' : '') . '
';
require_once 'includes/header.php';
?>