Last year I wrote this for databases class. It’s a system designed to work on all future FRC games that have 3 teams in an alliance vs. 3 other teams in another alliance. It has been sitting on my server collecting dust for a year and though I may as well share it since I’m no longer on a team. Sorry the code is an absolute mess with comments everywhere.
You will need a working MySQL server and and Apache web server with PHP. If you do not, I recommend installing XAMPP.
The repository has an image of how the database should be structured.
If anyone needs help setting up the server or database, I’ll try my best to respond helpfully in the comments below.
Git Repository
I rigged up a live demo. (read only)