Jinsi ya Kutengeneza Students Management System

Students Management System (SMS) ni mfumo unaowawezesha walimu/administrators:

Kuongeza, kuhariri, na kufuta wanafunzi (CRUD).

Kuangalia orodha ya wanafunzi kwa darasa, jinsia, au score.

Kuonyesha statistics za shule.

Mfumo huu utakuwa secure kwa kutumia PDO, na utumie prepared statements kuzuia SQL Injection.

⚙️ 2. Muundo wa Project

Tengeneza folder la project, mfano: students_management/

students_management/
├── config.php
├── index.php ← View students
├── add_student.php ← Add student
├── edit_student.php ← Edit student
├── delete_student.php ← Delete student
└── logout.php

🧩 3. Database Setup
CREATE DATABASE school_db;

USE school_db;

CREATE TABLE students (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
class VARCHAR(50) NOT NULL,
gender ENUM('Male','Female') NOT NULL,
age INT NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

💡 Maelezo:

ENUM inasaidia kuweka jinsia.

created_at inarekodi wakati mwanafunzi aliongezwa.

⚙️ 4. Database Connection (config.php)

setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
die("❌ Connection failed: " . $e->getMessage());
}
?>

âž• 5. Add Student (add_student.php)

prepare("INSERT INTO students (name, class, gender, age) VALUES (:name, :class, :gender, :age)");
$stmt->execute([
'name'=>$name,
'class'=>$class,
'gender'=>$gender,
'age'=>$age
]);

echo "

✅ Student added successfully!

";
}
?>

âž• Add Student

📄 6. View Students (index.php)

query("SELECT * FROM students ORDER BY id DESC");
?>

📋 Students List

✏️ 7. Edit Student (edit_student.php)

prepare("SELECT * FROM students WHERE id = :id");
$stmt->execute(['id'=>$id]);
$student = $stmt->fetch(PDO::FETCH_ASSOC);

if(!$student){
die("❌ Student not found!");
}

if($_SERVER['REQUEST_METHOD'] === 'POST'){
$stmt = $pdo->prepare("UPDATE students SET name=:name, class=:class, gender=:gender, age=:age WHERE id=:id");
$stmt->execute([
'name'=>$_POST['name'],
'class'=>$_POST['class'],
'gender'=>$_POST['gender'],
'age'=>$_POST['age'],
'id'=>$id
]);
echo "

✅ Student updated successfully!

";
}
?>

✏️ Edit Student

❌ 8. Delete Student (delete_student.php)

prepare("DELETE FROM students WHERE id=:id");
$stmt->execute(['id'=>$id]);

header("Location: index.php");
exit;
?>

🧠 9. Vidokezo vya Security na Maboresho

PDO + Prepared Statements – Salama dhidi ya SQL Injection.

Input Validation – Hakikisha data sahihi inapoingizwa.

Pagination & Search – Kwa data nyingi, ongeza pagination na search box.

Session & Authentication – Zuia user asiye admin kuingia system.

Frontend Design – Tumia Bootstrap au TailwindCSS kuboresha UI.

✅ 10. Hitimisho

Mfumo huu ni msingi wa Students Management System.

Unaweza kuongeza modules za grades, attendance, reports kwa urahisi.

PDO + prepared statements inaboresha security na kudhibiti data salama.

🔗 Tembelea:

👉 https://www.faulink.com/

Kwa mafunzo zaidi ya PHP, PDO, MySQL, na web systems development.