Simple-Library-Management-System/index.php at main · Dev-MoiMoi/Simple-Library-Management-System · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
<?php
session_start();
include "db.php";

// Fetch all users-
$users = [];
$result = $conn->query("SELECT id, name, role FROM users ORDER BY role, name");
while ($row = $result->fetch_assoc()) {
    $users[] = $row;
}

// Handle login
if ($_SERVER["REQUEST_METHOD"] === "POST") {
    $user_id = (int) $_POST['user_id'];

    // Get user info
    $stmt = $conn->prepare("SELECT name, role FROM users WHERE id=?");
    $stmt->bind_param("i", $user_id);
    $stmt->execute();
    $stmt->bind_result($name, $role);
    $stmt->fetch();
    $stmt->close();

    $_SESSION['user_id'] = $user_id;
    $_SESSION['user_name'] = $name;
    $_SESSION['role'] = $role;

    if ($role === "user")
        header("Location: user.php");
    else
        header("Location: librarian.php");
    exit();
}

$conn->close();
?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <title>iGit</title>
    <link rel="stylesheet" href="style.css">
    <link rel="icon" type="image/png" href="igit.png">
</head>

<body>
    <div class="login-container">
        <div class="login-header">
            <img src="igit.png" alt="Library Logo" class="login-logo">
            <h1>Welcome to iGit Library</h1>
        </div>

        <form method="POST">
            <label for="user_id">A Simple Library Management System</label>
            <select name="user_id" id="user_id" required>
                <option value="">Choose User</option>
                <?php foreach ($users as $u): ?>
                    <option value="<?= $u['id'] ?>">
                        <?= htmlspecialchars($u['name']) ?> (<?= $u['role'] ?>)
                    </option>
                <?php endforeach; ?>
            </select>
            <button type="submit">Enter</button>
        </form>
    </div>
</body>

</html>