🎓 University Alumni Management System - AlumSphere

A web-based alumni management platform designed for universities and academic institutions to manage alumni data and organize events. The system includes both an admin panel and user interface with CSV data handling and event participation tracking.

---

🚀 Features

🔐 Admin End

• View all uploaded alumni
• Add and manage university events
• Track alumni event responses

👤 User End

• Log in to the system
• Upload alumni details via CSV file
• View upcoming events
• Confirm participation in events

---

---

🛠️ Tech Stack

• Frontend: HTML, CSS (Vanilla)
• Backend: PHP
• Database: MySQL (via XAMPP)
• Tool: phpMyAdmin for DB management

---

📦 Database Tables

This project uses the following MySQL tables:

• admin – admin login credentials
• users – user/alumni login details
• alumni – uploaded alumni data
• events – event titles, dates, descriptions
• event_responses – stores alumni participation

You can find the table structure in:
📁 sql/database_schema

---

📌 How to Set Up (Localhost)

1. Clone the repository or download the ZIP
2. Place the folder in htdocs/ (XAMPP)
3. Start Apache & MySQL via XAMPP Control Panel
4. Import the SQL file from /sql/database_schema using phpMyAdmin
5. Update /dtaabase/db_connect.php with your MySQL credentials
6. Open http://localhost/alumni-management-system/index.php

**important: for the ease i have uploaded the files as folders ,to run the exact code you must copy only the files and paste them in htdocs | or else please update the code with file locations before execution example: Old:

include 'db_connect.php';

New:

include '../db/db_connect.php';

---

🧾 CSV Upload Format

When uploading alumni data via CSV, make sure your file includes these fields in order:

Sample file available at:
📄 sample_Data.csv

---

📷 Screenshots

• Home



• Upload csv



• Manage Events



• My Details_User end



• Event _User end

🤝 Contributions

This is a university project. Contributions, suggestions, or improvements are welcome via pull requests or issues.

---

📃 License

MIT License – You are free to use, modify, and distribute this project.

---

🙋‍♀️ Author

Shalini Wanasinghe
University of Vavuniya – Faculty of Applied Sciences
🗓️ Year: 2025
📧 Feel free to reach out

---

PHP, MySQL, Alumni Management System, University Project, Web Application, CSV Upload, Event Management, Admin Dashboard, Open Source, Student Project, University System, Academic Portal, XAMPP, phpMyAdmin, Database Project, User Authentication, Alumni Portal, Backend Development, MIT License