--
CREATE DATABASE hanave_library;
CREATE TABLE students (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
email VARCHAR(100) NOT NULL UNIQUE,
password_hash VARCHAR(255) NOT NULL,
course VARCHAR(100)
);
CREATE TABLE staff (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
email VARCHAR(100) NOT NULL UNIQUE,
password_hash VARCHAR(255) NOT NULL,
role ENUM('admin','staff') NOT NULL
);
CREATE TABLE uploads (
id INT AUTO_INCREMENT PRIMARY KEY,
file_name VARCHAR(255) NOT NULL,
uploaded_by INT NOT NULL,
upload_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
--
setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
die("Database connection failed: " . $e->getMessage());
}
?>
prepare("SELECT * FROM staff WHERE email = ?");
$stmt->execute([$email]);
$staff = $stmt->fetch(PDO::FETCH_ASSOC);
if($staff && password_verify($password, $staff['password_hash'])){
$_SESSION['user_id'] = $staff['id'];
$_SESSION['role'] = $staff['role'];
header('Location: admin_dashboard.php');
exit();
}
// Check students
$stmt = $pdo->prepare("SELECT * FROM students WHERE email = ?");
$stmt->execute([$email]);
$student = $stmt->fetch(PDO::FETCH_ASSOC);
if($student && password_verify($password, $student['password_hash'])){
$_SESSION['user_id'] = $student['id'];
$_SESSION['role'] = 'student';
header('Location: student_dashboard.php');
exit();
}
$error = 'Invalid email or password';
}
?>
Login | HANAVE Online Library
HANAVE University Online Library Login
'.$error.''; ?>
prepare("INSERT INTO uploads (file_name, uploaded_by) VALUES (?, ?)");
$stmt->execute([basename($_FILES["pdf"]["name"]), $_SESSION['user_id']]);
$msg = "PDF uploaded successfully.";
} else {
$msg = "Error uploading file.";
}
}
}
?>
Admin Dashboard | HANAVE Online Library
Admin / Staff Dashboard
'.$msg.''; ?>
Uploaded PDFs
query("SELECT * FROM uploads ORDER BY upload_date DESC");
while($row = $stmt->fetch(PDO::FETCH_ASSOC)){
echo '- '.$row['file_name'].'
';
}
?>
Logout