Educational Resource Management System

index.php Educational Resource Management System

Welcome, !

You are logged in as a

Dashboard Overview

Total Resources

query($resource_count_query); $resource_count = $resource_count_result->fetch_assoc()['count']; echo "

$resource_count

"; ?>

User Type

Last Login

login.php query($sql); if ($result->num_rows > 0) { $row = $result->fetch_assoc(); if (password_verify($password, $row['password'])) { $_SESSION['username'] = $row['username']; $_SESSION['user_type'] = $row['user_type']; header('Location: index.php'); exit(); } else { $error = "Invalid username or password."; } } else { $error = "Invalid username, password, or user type."; } } ?> Login

Login Form

$error

"; ?>

logout.php signup.php alert('Passwords do not match!'); window.history.back();"; exit; } $hashed_password = password_hash($password, PASSWORD_BCRYPT); $sql = "INSERT INTO users (username, password, user_type) VALUES ('$username', '$hashed_password', '$user_type')"; if ($conn->query($sql) === TRUE) { header('Location: login.php'); } else { echo "Error: " . $conn->error; } } ?> Signup

Signup Form

view_resources.php prepare($delete_sql); $stmt->bind_param('i', $resource_id); if ($stmt->execute()) { $success_message = "Resource deleted successfully."; } else { $error_message = "Error deleting resource: " . $conn->error; } } // Fetch institutions, departments, and resource types for dropdown filters $institutions = $conn->query("SELECT DISTINCT institution FROM resources"); $departments = isset($_POST['institution']) ? $conn->query("SELECT DISTINCT department FROM resources WHERE institution = '" . $conn->real_escape_string($_POST['institution']) . "'") : null; $resource_types = $conn->query("SELECT DISTINCT type FROM resources"); // Fetch resources based on filters $filters = []; $sql = "SELECT * FROM resources WHERE 1=1"; if (isset($_POST['institution']) && $_POST['institution'] !== '') { $filters['institution'] = $_POST['institution']; $sql .= " AND institution = ?"; } if (isset($_POST['department']) && $_POST['department'] !== '') { $filters['department'] = $_POST['department']; $sql .= " AND department = ?"; } if (isset($_POST['resource_type']) && $_POST['resource_type'] !== '') { $filters['resource_type'] = $_POST['resource_type']; $sql .= " AND type = ?"; } $stmt = $conn->prepare($sql); if ($filters) { $stmt->bind_param(str_repeat('s', count($filters)), ...array_values($filters)); } $stmt->execute(); $result = $stmt->get_result(); ?> View Resources - Educational Resource Management System

Welcome, !

You are logged in as a

View Resources

$success_message

"; } if (isset($error_message)) { echo "

$error_message

"; } ?> num_rows > 0): ?> fetch_assoc()): ?>

Resource Name	Resource Type	Institution	Department	Download	Delete	Download
				Download

No resources available.

add_resources.php Add Resource - Educational Resource Management System

Welcome, !

You are logged in as a

Add New Resource

query($sql) === TRUE) { echo "

Resource added successfully!

"; } else { echo "

Error: " . $conn->error . "

"; } } else { echo "

Sorry, there was an error uploading your file.

"; } } ?>

Resource Name:

Resource Type:

Institution:

Department:

Upload Resource (PDF/Video):

db.php connect_error) { die("Connection failed: " . $conn->connect_error); } ?>