Jifunze jinsi ya kuongeza Data selection kwenye website yako yenye title na description. SEO-friendly blog post example
Source code
<?php
session_start();
// Check if user is logged in
$user_id = $_SESSION['user_id'] ?? null;
if (!$user_id) {
die("Unauthorized access. Please log in.");
}
// Database connection
$servername = "localhost";
$username = "faulink";
$password = "faulink";
$dbname = "faustine";
try {
$pdo = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
die("Connection failed: " . $e->getMessage());
}
// Enable error display
error_reporting(E_ALL);
ini_set('display_errors', 1);
// Handle blog post addition
$message = "";
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['add_post'])) {
$title = $_POST['title'];
$content = $_POST['content'];
$post_date = $_POST['post_date'] ?? date('Y-m-d');
$stmt = $pdo->prepare("INSERT INTO blog_posts (title, content, post_date, user_id) VALUES (?, ?, ?, ?)");
if ($stmt->execute([$title, $content, $post_date, $user_id])) {
$message = "<div class='alert alert-success'>Blog post added successfully!</div>";
} else {
$message = "<div class='alert alert-danger'>Failed to add blog post.</div>";
}
}
// Fetch all posts for this user
$stmt = $pdo->prepare("SELECT * FROM blog_posts WHERE user_id = ? ORDER BY post_date DESC");
$stmt->execute([$user_id]);
$posts = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Jinsi ya Kuongeza Blog Post na Date Selection | Faulink</title>
<meta name="description" content="Jifunze jinsi ya kuongeza blog post kwenye website yako na date selection option. SEO friendly blog post example.">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
<nav class="navbar navbar-expand-lg navbar-dark bg-dark">
<div class="container-fluid">
<a class="navbar-brand" href="#">Faulink Blog</a>
<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarNav">
<ul class="navbar-nav ms-auto">
<li class="nav-item"><a class="nav-link" href="index.php">Home</a></li>
<li class="nav-item"><a class="nav-link text-warning" href="logout.php">Logout</a></li>
</ul>
</div>
</div>
</nav>
<div class="container mt-5">
<h2 class="mb-4">Ongeza Blog Post Mpya</h2>
<?= $message; ?>
<form method="POST" class="row g-3">
<div class="col-md-6">
<label class="form-label">Title ya Blog Post</label>
<input type="text" name="title" class="form-control" required>
</div>
<div class="col-md-6">
<label class="form-label">Tarehe ya Post</label>
<input type="date" name="post_date" class="form-control" value="<?= date('Y-m-d') ?>" required>
</div>
<div class="col-12">
<label class="form-label">Maudhui ya Post</label>
<textarea name="content" class="form-control" rows="5" required></textarea>
</div>
<div class="col-12">
<button type="submit" name="add_post" class="btn btn-primary w-100">Ongeza Blog Post</button>
</div>
</form>
<hr class="my-4">
<h3>Blog Posts Zilizopo</h3>
<div class="list-group">
<?php if ($posts): ?>
<?php foreach ($posts as $post): ?>
<div class="list-group-item mb-2">
<h5><?= htmlspecialchars($post['title']) ?></h5>
<small class="text-muted">Posted on: <?= $post['post_date'] ?></small>
<p><?= nl2br(htmlspecialchars($post['content'])) ?></p>
</div>
<?php endforeach; ?>
<?php else: ?>
<p>Hakuna blog posts zilizopo.</p>
<?php endif; ?>
</div>
<hr class="my-4">
<h5>Links Za Kujifunza Zaidi</h5>
<ul>
<li>🌠Faulink Official Website: <a href="https://www.faulink.com/" target="_blank">https://www.faulink.com/</a></li>
<li>📘 Jifunze Web Design & Programming: <a href="https://www.faulink.com/excel_mifumo.php" target="_blank">https://www.faulink.com/excel_mifumo.php</a></li>
<li>📲 Piga / WhatsApp kwa msaada wa haraka: <a href="https://wa.me/255693118509" target="_blank">https://wa.me/255693118509</a></li>
</ul>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>🚀 Unahitaji mfumo au website ya biashara?
Chagua huduma hapa chini kisha mteja bofya moja kwa moja kwenda kwenye ukurasa wa huduma au kuwasiliana nasi kwa WhatsApp.