Introduction: IOT Project: QuizPi
A quiz made with Flask and Python, connected to a Raspberry Pi and a MySql database. The concept of the product is that you can play a quiz of 15 questions long, when you are done with the quiz you see your score. You can also handle your leds of your buttons with the webpage. There is also a score page where you can see the scores.
Step 1: Step 1: Parts
You need the following parts:
- Massive Arcade Button with LED - 100mm Red -> $ 12,95
- Buzzer 5V - Breadboard friendly -> $ 3,95
- Vilros Raspberry Pi 3 Ultimate Starter Kit -> $ 79,99
Step 2: Step 2: Schematic - Wiring the Raspberry Pi
This is the schematic i used. There are no resistors in my schematic because the are built-in the massive arcade buttons.
Step 3: Step 3: Normalised Database Structure
First of all you'll need to create a new database on your Raspberry Pi as shown on the picture.
Step 4: Step 4: Make the Quizquestions
Here is the file with the data for the database. Import this data into your MySql database.
Step 5: Step 5: Make Your Flask App
When you imported all the data to your database you should upload it to your Raspberry Pi.
Then download all the folders from github, then upload all the folders to your Raspberry Pi.
Github link: https://github.com/lennert03/website
Then run the website.py file and surf to your Raspberry's Pi IP address followed by :8080 If everything went ok you should see the home page of the QuizPi.
Step 6: Step 6: Make the Housing
The dimension of my housing is 24 x 78 x 19, but you can choose the dimension that you want of course.
So first I made the four plates and then I drilled 2 holes in it for the buttons. And i glued them to stick to the plate.