shojiyao12/up_third-year_courses-database

This is a simple web-application simulator, where third-year college students can freely enroll themselves into university. (The school in the simulator will be the University of the Philippines.) Front-End: HTML/CSS, Back-End: PHP & Javascript, Database: MySQL

Quickstart Guide

1. Copy all the contents from this repository.
2. Copy all files and directories to the htdocs directory inside xampp (for example: C:\xampp\htdocs\CMSC127-MP1-Yao_SJ), where "CMSC127-MP1-Yao_SJ" will contain all of the files.
3. Import the database [thirdyear_courses.sql] in phpmyadmin or directly embed it into your MySQL database through the command prompt (refer to this link on how - https://www.warp.dev/terminus/mysql-import-sql-file).
4. Open your XAMPP Panel and make sure to start your APACHE and MySQL 'Modules' under 'Actions' (refer to this link, if you do not have XAMPP, yet - https://www.apachefriends.org/download.html)
5. Open any browser, enter localhost, and browse the file location on the search bar. (i.e. localhost/CMSC127-MP1-Yao_SJ)

Target User/s

• ADMIN
• Teacher
• Student (Year III - UP)

Technology Stack

• Front-End
  • HTML/CSS
• Back-End
  • PHP, JavaScript
• Database
  • MySQL

Core Concept

• File Processing and Database Systems
• Web Development

Note:

• The sample login credentials for the ADMINs and Teachers can be found in the technical documentation below.
• Being that this is a simulator only, the purpose of the actual software is just for user experience and testing, and in no way will the content of this simulator reflect directly into the actual enrollment process of UP.

URL

• Link to Technical Documentation: https://drive.google.com/file/d/1UmMTqGqG0SKCEU7dPCbixWoitZH9PSFK/view?usp=drive_link
• Link to Database Schema: https://drive.google.com/file/d/1zrJf48_vlxLAnxr5P-0UKBz2czxcGwyx/view?usp=drive_link

Preview of Web Application