Jinsi ya Kuunganisha Database kwa PDO kutumia PHP – Mwongozo Rahisi na Salama
Jifunze jinsi ya kufanya database connection kwa kutumia PDO katika PHP kwa njia salama, rahisi na professional. Mwongozo huu unafaa kwa beginners na developers wanaotengeneza website za kisasa.
MySQL Database
CREATE DATABASE pdo_blog;
USE pdo_blog;
CREATE TABLE posts (
id INT AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(255) NOT NULL,
description TEXT NOT NULL,
content LONGTEXT NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
File: config.php
setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
echo "Database connected successfully";
} catch (PDOException $e) {
die("Connection failed: " . $e->getMessage());
}
?>
File: index.php
prepare($sql);
$stmt->execute([
':title' => $title,
':description' => $description,
':content' => $content
]);
header("Location: index.php");
exit();
}
$posts = $pdo->query("SELECT * FROM posts ORDER BY id DESC");
?>
Add Blog Post
All Blog Posts
= htmlspecialchars($post['title']) ?>
= date('d M Y', strtotime($post['created_at'])) ?>
= htmlspecialchars($post['description']) ?>
Features za Code
PDO Secure Database Connection
Prepared Statements
SQL Injection Protection
Bootstrap Design
Add Unlimited Blog Posts
Responsive Design
Professional Layout
Simple CRUD Foundation
Website Link Example
🚀 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.