Blog details sayfamvar ve tüm bilgileri çekiyor ancak title ve
description kısımına gelince işler biraz karıştı blog-details.php?id=17 bu şekilde id ile çekiyor anca title ve description bir türlü çektiremedim yardım edecek birisi varmıdır kodu paylaşıyorum.
<?php
include 'header.php';
if (isset($_GET['id'])) {
$id = intval($_GET['id']);
$stmt = $pdo->prepare("SELECT * FROM bloglar WHERE id = ?");
$stmt->execute([$id]);
$blog = $stmt->fetch(PDO::FETCH_ASSOC);
if ($blog) {
$sayfa_baslik = !empty($blog['baslik']) ? $blog['baslik'] : "Blog";
$sayfa_aciklama = !empty($blog['aciklama']) ? strip_tags($blog['aciklama']) : "hakkında en güncel blog yazıları burada.";
$sayfa_resim = !empty($blog['resim_yolu']) ? './admin/' . $blog['resim_yolu'] : "./admin/default-image.jpg";
$sayfa_anahtarkelime = !empty($blog['etiket']) ? $blog['etiket'] : ", blog, konaklama";
$tarih = !empty($blog['tarih']) ? $blog['tarih'] : date("Y-m-d");
} else {
header("Location: blog.php");
exit;
}
} else {
header("Location: blog.php");
exit;
}
?>
<!DOCTYPE html>
<html lang="tr">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title><?php echo htmlspecialchars($sayfa_baslik); ?></title>
<meta name="description" content="<?php echo htmlspecialchars(mb_substr($sayfa_aciklama, 0, 160, 'UTF-8')); ?>">
<meta name="keywords" content="<?php echo htmlspecialchars($sayfa_anahtarkelime); ?>">
<meta property="og:title" content="<?php echo htmlspecialchars($sayfa_baslik); ?>">
<meta property="og:description" content="<?php echo htmlspecialchars(mb_substr($sayfa_aciklama, 0, 160, 'UTF-8')); ?>">
<meta property="og:image" content="<?php echo htmlspecialchars($sayfa_resim); ?>">
<meta property="og:type" content="article">
<meta property="og:url" content="..r/blog-details.php?id=<?php echo $id; ?>">
<meta name="twitter:card" content="summary_large_image">
<meta name="twitter:title" content="<?php echo htmlspecialchars($sayfa_baslik); ?>">
<meta name="twitter:description" content="<?php echo htmlspecialchars(mb_substr($sayfa_aciklama, 0, 160, 'UTF-8')); ?>">
<meta name="twitter:image" content="<?php echo htmlspecialchars($sayfa_resim); ?>">
<style>
.single-media .media-photo {
width: 100%;
height: 400px;
display: flex;
align-items: center;
justify-content: center;
overflow: hidden;
}
.single-media .media-photo img {
width: 100%;
height: 100%;
object-fit: cover;
}
.widget-blog-single .single-detail {
margin-top: 20px;
line-height: 1.6;
}
.widget-blog-single .single-detail h2 {
font-size: 2.5rem;
font-weight: bold;
margin-bottom: 20px;
}
.widget-blog-single .single-detail p {
font-size: 1.1rem;
color: #444;
}
.blog-tags {
margin-top: 20px;
}
.blog-tags .etiket {
display: inline-block;
background: #f1f1f1;
color: #333;
padding: 6px 15px;
margin-right: 10px;
margin-top: 10px;
border-radius: 30px;
font-size: 14px;
text-transform: capitalize;
transition: background 0.3s ease;
}
.blog-tags .etiket:hover {
background: #007BFF;
color: white;
}
.widget-breadcrumb {
margin-top: 20px;
}
.widget-breadcrumb ul {
list-style-type: none;
padding: 0;
}
.widget-breadcrumb ul li {
display: inline;
margin-right: 10px;
}
.widget-breadcrumb ul li a {
color: #007BFF;
text-decoration: none;
}
.widget-breadcrumb ul li::after {
content: " /";
margin-left: 10px;
}
.widget-breadcrumb ul li:last-child::after {
content: "";
}
@media (max-width: 768px) {
.single-media .media-photo {
height: 300px;
}
.widget-blog-single .single-detail h2 {
font-size: 2rem;
}
.widget-blog-single .single-detail p {
font-size: 1rem;
}
}
</style>
</head>
<body>
<div class="site-main">
<div class="section">
<div class="widget-page-title">
<div class="widget-background" data-background="<?php echo htmlspecialchars($sayfa_resim); ?>"></div>
<div class="wrapper-inner">
<h5></h5>
<h1><?php echo htmlspecialchars($sayfa_baslik); ?></h1>
<div class="widget-breadcrumb">
<ul>
<li><a href="../index.php">Anasayfa</a></li>
<li><?php echo htmlspecialchars($sayfa_baslik); ?></li>
</ul>
</div>
</div>
</div>
<div class="wrapper-inner">
<div class="widget-blog-single">
<div class="single-media">
<div class="media-photo">
<a href="<?php echo htmlspecialchars($sayfa_resim); ?>" title="<?php echo htmlspecialchars($sayfa_baslik); ?>" class="popup-photo">
<img src="<?php echo htmlspecialchars($sayfa_resim); ?>" alt="<?php echo htmlspecialchars($sayfa_baslik); ?>">
</a>
</div>
</div>
<div class="single-detail">
<div class="detail-head">
<a href="#"></a> <i class="fa fa-clock-o"></i> <?php echo htmlspecialchars($tarih); ?>
</div>
<div class="detail-content">
<h2><?php echo htmlspecialchars($sayfa_baslik); ?></h2>
<p><?php echo nl2br(htmlspecialchars($sayfa_aciklama)); ?></p>
<div class="blog-tags">
<?php
$etiketler = explode(',', $sayfa_anahtarkelime);
foreach ($etiketler as $etiket) {
echo '<span class="etiket">' . htmlspecialchars(trim($etiket)) . '</span> ';
}
?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php include 'footer.php'; ?>
</body>
</html>