JINSI YA KUTENGENEZA SECURE MULTI-USER SYSTEM KWA PHP NA MYSQL

Multi-user system inahitaji:

User registration & login

Password hashing & verification

Role-based access control (RBAC)

Session management

Input validation & security

Goal: Ensure each user can only access data and functionalities they are authorized to.

⚙️ 2. Database Structure
CREATE DATABASE multi_user_system;
USE multi_user_system;

CREATE TABLE roles (
id INT AUTO_INCREMENT PRIMARY KEY,
role_name VARCHAR(50) NOT NULL UNIQUE
);

CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(50) NOT NULL UNIQUE,
email VARCHAR(100) NOT NULL UNIQUE,
password VARCHAR(255) NOT NULL,
role_id INT NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (role_id) REFERENCES roles(id)
);

-- Insert basic roles
INSERT INTO roles (role_name) VALUES ('Admin'), ('User');

🧩 3. User Registration (register.php)

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

if(isset($_POST['register'])){
$username = htmlspecialchars(trim($_POST['username']));
$email = filter_var($_POST['email'], FILTER_SANITIZE_EMAIL);
$password = $_POST['password'];
$role_id = intval($_POST['role_id']);

$hashed_password = password_hash($password, PASSWORD_DEFAULT);

$stmt = $pdo->prepare("INSERT INTO users (username, email, password, role_id) VALUES (:username, :email, :password, :role_id)");
$stmt->execute([
'username' => $username,
'email' => $email,
'password' => $hashed_password,
'role_id' => $role_id
]);

echo "✅ Registration successful!";
}
?>

🧩 4. User Login (login.php)

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

if(isset($_POST['login'])){
$username = htmlspecialchars(trim($_POST['username']));
$password = $_POST['password'];

$stmt = $pdo->prepare("SELECT u.*, r.role_name FROM users u JOIN roles r ON u.role_id = r.id WHERE username = :username");
$stmt->execute(['username' => $username]);
$user = $stmt->fetch();

if($user && password_verify($password, $user['password'])){
// Secure session setup
session_regenerate_id(true);
$_SESSION['user_id'] = $user['id'];
$_SESSION['username'] = $user['username'];
$_SESSION['role'] = $user['role_name'];
echo "✅ Login successful! Welcome, ".$_SESSION['username'];
} else {
echo "❌ Invalid credentials!";
}
}
?>

⚙️ 5. Role-Based Access Control Example

🔑 6. Security Enhancements

Password hashing – use password_hash() and password_verify().

Session management – regenerate IDs, secure cookies.

Input validation & sanitization – prevent XSS/SQLi.

Role-based access control – restrict sensitive pages.

HTTPS enforcement – encrypt session cookies.

Optional: CSRF tokens for forms, login attempt limiter.

✅ 7. Hitimisho

Multi-user system requires authentication + authorization mechanisms.

Combine secure passwords, sessions, RBAC, input sanitization kwa full security.

Can be extended to activity logging, multi-level roles, na secure file access.

🔗 Tembelea:

👉 https://www.faulink.com/

Kwa mafunzo zaidi ya PHP, multi-user systems, na web application security.