Attendance System by Sending RFID Data to MySQL Server Using Python With Arduino
ฝัง
- เผยแพร่เมื่อ 13 ก.ค. 2019
- Here in this project we are sending RFID data to MySQL server using python and Arduino
You can buy tools from amazon, below are the links:
Arduino Uno link in amazon: amzn.to/2yYpcyT
RFID RC522 link in amazon: amzn.to/2Zd3LJj
You can get the source code from this link:
github.com/Embedotronics/Send...
FB: / embedotronics - วิทยาศาสตร์และเทคโนโลยี
Hello! Nice video but I'm running into some trouble. I'm getting an error message regarding the following command "Sending_To_db();", the error states 'Sending_To_db' was not declared in this scope
". What might be the problem?
Hi i have question. How is it the output of this project to be appear on own website?
I want to send data from virtual terminal as RFID reader (because I didn't get RFID module library for protues) to My SQL database in Xampp using java in simulation. I didn't practically implement it but I want them interact each other to see the simulation. what can i do? sir please tell me........or can't we send data unless external device is connected? please tell me
Hi, I am working same project, but i have one question that i want to store both IN and out time in the database (like Tag scan first time store IN data and same Tag scan second time then store Out data).
Can you give me any information how can i do it? . Thanks so much in advance.
Hi thank you for the tutorial, but is it possible to fetch data from the mysql database without using any ethernet shield/esp8266 (just using arduino and python)?
Like if allowed_members = 1, servo motor will open or LED will turn on, but if allowed_members = 0, servo motor will not open and LED will not turn on.
Hoping you reply to this question and hopefully you make a tutorial on it. Thank you
Hi, The video makes the database I can't find. May I ask for a video link?
Hi i am getting an error while running the python code. MySQLdb._exceptions.OperationalError: (1049, "Unknown database 's102878018_db'") tho i have installed all the sql libraries and also connection is done.. can u please help me to fix this at urgnt basis
My Port is /dev/ttyACM. I'd changed it instead of COM 6, but program was still not run
what app you use in coding python
Hi i need to learn Phython as well as Arduino. Please let me know if providing trainings class too .Thanks
Hi, I'm having troubles inserting data into Database. I can see the RFID card's number but nothing gets inserted into database. Also in python i get line like "b'416415141 1 Card detected:
'" how do I remove those "
" writings
Hi @kur_karolis , i got the same problem.
Do you find the solutions?
If got, please let me know.
Thanks!
Hi @kur_karolis, i just solve the problem.
My solutions is using Pyhton2.7 instead Python3.7
@@jlo7951 hello dear can you please suggest me I'm also having and error its showing that unable to connect com3 and failed and its going under processing
@@jlo7951 did using python 2.7 really work?
I tried to do as said in this video but I am unable to connect to "PORT" even my port name is right. I always receive message "failed to connect COM4" and then infinite loop of processing starts
I have the same problem but in my case it is port COM6
Embedotronics technologies I have the same problem I always receive message "failed to connect COM6" and infinite loop of processing starts
hi, I have a question, what if the server is not local. it's a webserver site.
how to send the data?
@@kyozho3912 you can make IP publicly accessible using port forwarding and if you want to run your server temporarily then you can run ngrok software for that 👍
why is nothing happening in my phpmyadmin? there's no error in python code and ide code
Yes same thing nothing is happening to database not getting updated
Can you please tell how do i set up the database first?
Please watch our 2nd video of Arduino playlist in our channel to know about that 👍
The code shows no error , but data base doesn't change . can you help me please ?
Check your Python code may be from there it is having some issues 👍
Can you please give the php code ? It's not there on the github link
In this we are not using php code, here we are using python code to send data serially to MySQL server 👍
@@embedotronics so there's no php file that I have to place inside the " htdocs " folder ?
@@ateebhussain8468 Yes in this project there is no php file, as here you can see we are not using any Ethernet shield, here we are using python script . We are using php file in another video, you can check it in our Arduino playlist there we are using php script and we are saving in "htdocs"
@@embedotronics Thanks for the guidance. It went great 👍
@@ateebhussain8468 thanks 👌
Can you please share the code and circuit diagram.
Allow us some time will share the code and circuit soon....
please visit this link for more details about the project
www.hackster.io/embedotronics-technologies/attendance-system-using-arduino-and-rfid-with-python-3b69c8
can you please share the code?
You can get the source code from the video description 👍
is it applicable for raspberry pi?
You can connect Arduino to raspberry pi and can send data serially to phpmyadmin by installing the LAMP server in Raspberry pi
y
where this file ?
import serial
import MySQLdb
import time
you have to install these libraries, steps are there in my previous video of the same playlist Arduino
hi share your connection ,diagram thanks
please visit this link for more details about the project
www.hackster.io/embedotronics-technologies/attendance-system-using-arduino-and-rfid-with-python-3b69c8