Faulink.com – Jukwaa Bora la Kupata Makala, Habari na Maarifa Mtandaoni
Faulink.com ni tovuti inayokuletea makala bora, habari, elimu, teknolojia, biashara na maarifa mbalimbali kwa lugha rahisi na yenye mvuto kwa wasomaji.
1. Database MySQL
CREATE DATABASE faulink_blog;
USE faulink_blog;
CREATE TABLE posts (
id INT AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(255) NOT NULL,
description TEXT NOT NULL,
content LONGTEXT NOT NULL,
post_link VARCHAR(255),
image VARCHAR(255),
author VARCHAR(100) DEFAULT 'Admin',
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
2. Full Code: index.php
<?php
$conn = mysqli_connect("localhost", "root", "", "faulink_blog");
if (!$conn) {
die("Database connection failed: " . mysqli_connect_error());
}
if (isset($_POST['save'])) {
$title = mysqli_real_escape_string($conn, $_POST['title']);
$description = mysqli_real_escape_string($conn, $_POST['description']);
$content = mysqli_real_escape_string($conn, $_POST['content']);
$post_link = mysqli_real_escape_string($conn, $_POST['post_link']);
$author = mysqli_real_escape_string($conn, $_POST['author']);
$image_name = "";
if (!empty($_FILES['image']['name'])) {
if (!is_dir("uploads")) {
mkdir("uploads");
}
$image_name = time() . "_" . basename($_FILES['image']['name']);
$target = "uploads/" . $image_name;
move_uploaded_file($_FILES['image']['tmp_name'], $target);
}
$sql = "INSERT INTO posts(title, description, content, post_link, image, author)
VALUES('$title', '$description', '$content', '$post_link', '$image_name', '$author')";
mysqli_query($conn, $sql);
header("Location: index.php");
exit();
}
if (isset($_GET['delete'])) {
$id = intval($_GET['delete']);
mysqli_query($conn, "DELETE FROM posts WHERE id=$id");
header("Location: index.php");
exit();
}
$posts = mysqli_query($conn, "SELECT * FROM posts ORDER BY id DESC");
?>
<!DOCTYPE html>
<html lang="sw">
<head>
<meta charset="UTF-8">
<title>Faulink Blog</title>
<meta name="description" content="Faulink.com ni tovuti bora ya makala, habari, elimu, teknolojia na maarifa mtandaoni.">
<meta name="keywords" content="Faulink, faulink.com, blog, elimu, teknolojia, habari, makala, Tanzania">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/css/bootstrap.min.css" rel="stylesheet">
</head>
<body class="bg-light">
<nav class="navbar navbar-expand-lg navbar-dark bg-primary sticky-top">
<div class="container">
<a class="navbar-brand fw-bold" href="https://faulink.com">Faulink.com</a>
</div>
</nav>
<div class="container my-4">
<div class="card shadow mb-4">
<div class="card-header bg-primary text-white">
<h4>Ongeza Blog Post</h4>
</div>
<div class="card-body">
<form method="POST" enctype="multipart/form-data">
<div class="mb-3">
<label class="form-label">Title</label>
<input type="text" name="title" class="form-control" required
value="Faulink.com – Jukwaa Bora la Kupata Makala, Habari na Maarifa Mtandaoni">
</div>
<div class="mb-3">
<label class="form-label">Description</label>
<textarea name="description" class="form-control" rows="3" required>Faulink.com ni tovuti inayokuletea makala bora, habari, elimu, teknolojia, biashara na maarifa mbalimbali kwa lugha rahisi na yenye mvuto kwa wasomaji.</textarea>
</div>
<div class="mb-3">
<label class="form-label">Content / Maudhui</label>
<textarea name="content" class="form-control" rows="8" required>Karibu Faulink.com, sehemu bora ya kupata makala zenye elimu, habari, teknolojia, biashara, fursa na maarifa muhimu kwa maisha ya kila siku.
Kupitia Faulink.com, wasomaji wanaweza kujifunza mambo mapya, kupata taarifa muhimu, kusoma makala za kuvutia na kufuatilia maudhui yanayosaidia kuongeza uelewa.
Faulink.com inalenga kuwa daraja la maarifa kwa wanafunzi, walimu, wafanyabiashara, vijana na jamii kwa ujumla.</textarea>
</div>
<div class="mb-3">
<label class="form-label">Link</label>
<input type="url" name="post_link" class="form-control" value="https://faulink.com">
</div>
<div class="mb-3">
<label class="form-label">Author</label>
<input type="text" name="author" class="form-control" value="Faulink Admin">
</div>
<div class="mb-3">
<label class="form-label">Image</label>
<input type="file" name="image" class="form-control">
</div>
<button type="submit" name="save" class="btn btn-success">Save Post</button>
</form>
</div>
</div>
<h3 class="mb-3">Blog Posts</h3>
<div class="row">
<?php while ($row = mysqli_fetch_assoc($posts)) { ?>
<div class="col-md-6 mb-4">
<div class="card shadow h-100">
<?php if (!empty($row['image'])) { ?>
<img src="uploads/<?php echo $row['image']; ?>" class="card-img-top" style="height:250px; object-fit:cover;">
<?php } ?>
<div class="card-body">
<h4 class="card-title text-primary">
<?php echo htmlspecialchars($row['title']); ?>
</h4>
<p class="text-muted">
By <?php echo htmlspecialchars($row['author']); ?> |
<?php echo date("d M Y", strtotime($row['created_at'])); ?>
</p>
<p>
<?php echo htmlspecialchars($row['description']); ?>
</p>
<p style="text-align: justify;">
<?php echo nl2br(htmlspecialchars($row['content'])); ?>
</p>
<?php if (!empty($row['post_link'])) { ?>
<a href="<?php echo htmlspecialchars($row['post_link']); ?>" target="_blank" class="btn btn-primary">
Tembelea Faulink.com
</a>
<?php } ?>
<a href="index.php?delete=<?php echo $row['id']; ?>"
onclick="return confirm('Una uhakika unataka kufuta post hii?')"
class="btn btn-danger">
Delete
</a>
</div>
</div>
</div>
<?php } ?>
</div>
</div>
<footer class="bg-primary text-white text-center p-3 mt-5">
<p class="mb-0">© <?php echo date("Y"); ?> Faulink.com - All Rights Reserved</p>
</footer>
</body>
</html>
Weka file hii kama index.php, tengeneza database, kisha fungua kwenye browser.
🚀 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.