Jifunze kutengeneza blog system ya kisasa kwa kutumia PHP, MySQL, PDO na Bootstrap 5. Mfumo huu una admin dashboard, kuongeza posts, ku-edit posts, kufuta posts, kuonyesha posts kwa visitors, SEO title, description, images, na link ya https://faulink.com
.

Utangulizi

Blog ni moja ya njia bora za kushare maarifa, kutangaza biashara, kufundisha watu, na kupata kipato kupitia internet. Kama una website yako, unaweza kuandika makala kuhusu elimu, teknolojia, biashara, afya, michezo, tutorials au habari mbalimbali.

Katika makala hii tutajifunza kutengeneza Professional Blog System kwa kutumia PHP, MySQL, PDO na Bootstrap 5. Mfumo huu utakuwa na sehemu ya admin ya kuongeza blog posts na sehemu ya visitors ya kusoma posts.

Pia tutaweka link ya https://faulink.com
kama button nzuri, lakini itaendelea kuonekana kama link halisi.

Features za Mfumo

Mfumo huu utakuwa na:

Admin kuongeza blog post
Admin ku-edit blog post
Admin kufuta blog post
Visitors kuona posts zote
Visitors kusoma post moja
SEO title na meta description
Featured image
Bootstrap design
PDO prepared statements
Search posts
Responsive layout
Link ya https://faulink.com
kama button
Step 1: Tengeneza Database
CREATE DATABASE blog_system;
USE blog_system;

CREATE TABLE blog_posts (
id INT AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(255) NOT NULL,
slug VARCHAR(255) NOT NULL UNIQUE,
description TEXT NOT NULL,
content LONGTEXT NOT NULL,
image VARCHAR(255) DEFAULT NULL,
author VARCHAR(100) DEFAULT 'Admin',
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
Step 2: Tengeneza Connection File

Tengeneza file:

config.php

setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

} catch (PDOException $e) {
die("Database connection failed: " . $e->getMessage());
}
?>
Step 3: Tengeneza Admin Page

Tengeneza file:

admin_posts.php

prepare("
INSERT INTO blog_posts(title, slug, description, content, image, author)
VALUES(?, ?, ?, ?, ?, ?)
");

$stmt->execute([
$title,
$slug . "-" . time(),
$description,
$content,
$image,
$author
]);

$message = "Blog post imeongezwa kikamilifu.";
}

if ($action === "edit") {
$slug = makeSlug($title);

$stmt = $pdo->prepare("
UPDATE blog_posts
SET title=?, slug=?, description=?, content=?, image=?, author=?
WHERE id=?
");

$stmt->execute([
$title,
$slug . "-" . $id,
$description,
$content,
$image,
$author,
$id
]);

$message = "Blog post imebadilishwa kikamilifu.";
}

if ($action === "delete") {
$stmt = $pdo->prepare("DELETE FROM blog_posts WHERE id=?");
$stmt->execute([$id]);

$message = "Blog post imefutwa kikamilifu.";
}

} catch (Throwable $e) {
$error = $e->getMessage();
}
}

$posts = $pdo->query("SELECT * FROM blog_posts ORDER BY id DESC")->fetchAll(PDO::FETCH_ASSOC);
?>

Step 4: Tengeneza Page ya Visitors

Tengeneza file:

index.php

prepare("
SELECT * FROM blog_posts
WHERE title LIKE ? OR description LIKE ? OR content LIKE ?
ORDER BY id DESC
");
$stmt->execute(["%$q%", "%$q%", "%$q%"]);
} else {
$stmt = $pdo->query("SELECT * FROM blog_posts ORDER BY id DESC");
}

$posts = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>

Search

" class="card-img-top blog-img">

= e($post["title"]) ?>

By = e($post["author"]) ?> | = e($post["created_at"]) ?>

= e(substr($post["description"], 0, 150)) ?>...

" class="btn btn-primary btn-rounded"> Read More

No blog posts found.

Step 5: Tengeneza Single Post Page

Tengeneza file:

post.php

prepare("SELECT * FROM blog_posts WHERE slug=? LIMIT 1");
$stmt->execute([$slug]);
$post = $stmt->fetch(PDO::FETCH_ASSOC);

if (!$post) {
die("Post not found.");
}
?>

">

Back to Blog

= e($post["title"]) ?>

By = e($post["author"]) ?> | = e($post["created_at"]) ?>

" class="post-img">

= e($post["description"]) ?>

---

= nl2br(e($post["content"])) ?>

---

https://faulink.com

Step 6: Jinsi ya Kutumia Mfumo

Baada ya kuweka files zote:

config.php
admin_posts.php
index.php
post.php

Fungua:

http://localhost/blog_system/admin_posts.php

Ongeza blog post mpya.

Kisha fungua:

http://localhost/blog_system/index.php

Utaona posts zako kwenye website ya visitors.

Conclusion

Huu ni mfumo tofauti kabisa na locations. Ni Professional Blog System kamili kwa PHP, MySQL na Bootstrap 5. Una admin dashboard, post creation, post editing, post deleting, search, single post page, SEO meta description, responsive design na link ya https://faulink.com
ikiwa kama button nzuri lakini imebaki kuonekana kama link halisi.