![arduino to mysql database server from scratch arduino to mysql database server from scratch](http://giselda.altervista.org/image/pdf/rete2/Diapositiva02.jpg)
- ARDUINO TO MYSQL DATABASE SERVER FROM SCRATCH SERIAL
- ARDUINO TO MYSQL DATABASE SERVER FROM SCRATCH MANUAL
If they are, it'll take their temperature and output their temperature on the LCD screen. A distance sensor will then sense if a user is ready to take their temperature. Next, the Arduino will prompt the user to take their temperature. Let's say, now, we have a valid user that just tapped. If it's not a valid user, it'd just say "Error! Invalid User!". Afterwards, RaspberryPi confirms with the database that said card is a valid user, and if it is, it sends to the Arduino confirming it and the Arduino outputs "Welcome, name" on the LCD screen.
![arduino to mysql database server from scratch arduino to mysql database server from scratch](https://i.pinimg.com/236x/0d/42/3a/0d423a83201b3d01b01fd3bd25329a56.jpg)
ARDUINO TO MYSQL DATABASE SERVER FROM SCRATCH SERIAL
Upon having an RFID card tap on the Arduino, the card information is stored in the Arduino, sent to the RaspberryPi via Serial Communication.
![arduino to mysql database server from scratch arduino to mysql database server from scratch](https://giselda.altervista.org/image/pdf/sql/sql_09.jpeg)
Then, it establishes a query connection to check the database and awaits for the Arduino to send relevant information through the Serial Communication port.
ARDUINO TO MYSQL DATABASE SERVER FROM SCRATCH MANUAL
This reduces the manual labor work of teachers/administrative staffs in the school. The tables inside will also be checked & created automatically if needed. Upon launching the Python Program, it automatically checks for if the database if already created, if not, it'll be created automatically. The RaspberryPi holds a Python Program & the MySQL database. The reason for it is because our system is able to deploy to automatically measure the temperature of valid users so that their temperature can be monitored and an alert will be sent whenever it exceeds a certain threshold level. The Theme for our project is Social Impact by SqwidNet, and in the area of Good health and well-being in the Sustainable Development Goal (SDG). The task is very tedious and time consuming as each form teacher will need to perform entries for about 40 students. After the temperature measurement exercise, staff will have to manually key all the students temperature data and students particular to database. Hence, it affects the success rate of the temperature taking exercise. Due to personal hygiene, students are not allow to share their thermometers and they might not have sufficient money to buy a new piece. However, some students might not be able to participate during the exercise due to the reasons like misplaced or damaged thermometer and forget to bring the device. Whenever there is a temperature taking exercise scheduled by the school, students are required to bring their own digital thermometer for this exercise. In Asia, due to hot weather and the outbreak of severe acute respiratory syndrome (SARS) in 2003, the primary and secondary school students need to perform temperature measurement during every quarter to ensure the well being of the students.