QuizIt is a flashcard application project developed by Kenny Zhang for the class CS 4750: Database Systems at the University of Virginia. For this project, the database is hosted locally in phpMyAdmin using XAMPP. Thus, the application is also hosted locally within the XAMPP PHP environment. All of the project files are to be placed within the XAMPP environment (XAMPP/htdocs). To set up, deploy, and run the project:
- Download and set up the XAMPP environment (https://www.apachefriends.org/docs/)
- Clone the git repo into XAMPP/htdocs
- Go to the local phpMyAdmin dashboard (http://localhost)
- Set up the database by running the SQL code contained within the backend/flashcard_app.sql file
- In phpMyAdmin, create a user account called “app” with a “localhost” host name and take note of the password. Do not give it global privileges.
- Copy the password into the backend/connect-db.php file
- Set up the proper application permissions to the database by running the SQL code contained within backend/access-control.sql file
- Start the app by navigating to (http://localhost/flashcard-app/index.html)