Professional attendance system using NodeMCU with a website and a Database.
Вставка
- Опубліковано 10 вер 2024
- Hi, everyone.
Months ago, I made an Attendance system using Arduino UNO and RFID cards by saving the information about cards in Excel file
So in this video, I'm going to show you how to interfacing RFID-RC522 with NodeMCU and send the data to a web page and saving them onto a database.
you can use it to ensure all employees in a company or students had come in time every day and save their logs with their situations.
This the instruction that you need:
Notice:
In order to make the project working, the WiFi network should be a router network, not a Mobile hotspot.
In case you want to use the xampp server instead of WampServer you don't need to modify any config file, just copy the website files into the xampp/htdocs folder then continue the remaining steps.
Step 1:
1_ Add the ESP boards to the Arduino IDE.
2_Add the RFID library from Sketch--Include Library--Manages Libraries--search for (RFID)--then Install it.
3_After having the RFID-module wired to the nodeMCU like this:
SDA --- D8
SCK --- D5
MOSI --- D7
MISO --- D6
IRQ --- Not connected
GND --- GND
RST --- D3
3.3V --- 3.3V
connect it to the computer using a Micro USB.
4_Open the RFID_NodeMCU code and enter your WiFi setting(Name, Password) and your computer IP(you can know it from the command line by typing "ipconfig" then check ipv4), after that select the nodeMCU board from Tools--boards with the correct Port COM, and then upload it.
5_Open the serial monitor and set the baud rate to 115200 to check the connection status and the nodeMCU IP, save the IP(to put it in the server file "httpd.conf").
step 2:
1_Download the WampServer or xampp and install it.
2_Run it.
3_If you're using WAMPServer 2.1:
Click on wamp icon: Apache--httpd.conf--Add the nodeMCU IP to the permit list ( Allow from "nodeMCU IP")or try(Allow from all) next to this line: Allow from 127.0.0.1, then save it.
while If you're using WAMPServer 3.0.6:
Click on wamp icon: Apache--httpd-vhosts.conf--simply replace “Require local” with “Require all granted“ or "Require ip 192.168.xx.xx"(nodeMCU IP), then save it.
4_Click on wamp icon: Restart all services.
5_Click on wamp icon: www directory, then copy the website folder(login system folder) into it.
6_Click on wamp icon: localhost--login system--install.php(It should give you a success message, if not check the PHPMyAdmin password and username from (C:\wamp\apps\phpmyadmin3.3.9\config.inc.php) then put the password in (connectDB.php and install.php) pages.
7_Go to localhost/loginsystem/AddCard.php to add the users.
8_Then localhost/loginsystem/view.php to check the log.
It should appear on the serial monitor these messages:
for a new card or an available card:
200
successful
"the cardID"
and should the two LEDs blink
for a login:
200
login
"the cardID"
and should the red LED turn on
for a logout:
200
logout
"the cardID"
and should the blue LED turn on
**************************************
If you have any problems while using WAMPServer (like you get a "-1" or "-2" on the Serial monitor) please consider checking these steps:
1_The most important thing is the correct IP in the nodeMCU code(server IP) and in the permit list of the server apache config file (httpd.conf)or(httpd-vhosts.conf).
2_Make sure you restart all services (restart the server).
3_Check if your server has a password or not.
4_if you're receiving a message on the serial monitor that says "you don't have permissions to access this server" that means you must check the (httpd.conf)or(httpd-vhosts.conf) file because the nodeMCU IP is incorrect.
Or "404 Not Found The requested URL /loginsystem/postdemo.php was not found on this server" that means the website file doesn't exist into the www folder.
5_OR you're receiving just "-1" with the card ID that means there's no replying from the server, so check the server IP and enter it in the code.
**************************************
Download The diagram, the NodeMCU code and The website files from here:
github.com/Inf...
In case you want to use Arduino with SIM800L instead of NodeMCU then use this code:
github.com/Inf...
Please, Let me know if there any issues with the code.
To add the ESP boards to Arduino IDE here the custom URL:
arduino.esp8266...
you can download the wampServer from this link:
www.wampserver....
Or xampp server:
www.apachefrie...
**************************************
If you want to buy the components:
NodeMCU: www.gearbest.c...
RFID-RC522: www.gearbest.c...
**************************************
Music: Chaël - Sparks (Vlog No Copyright Music)
If you like this video don't forget to Like and Share.
Don't be a stranger, hit the Subscribe button, It will be awesome having you here.
Comment if you have any questions.
Thanks for watching.
Hi everyone.
Recently, some guys have done the project and it has worked perfectly with a bit difficult and it still works very good for me on my Raspberry PI Cluster web server, but in another hand, some guys told me the project didn't work completely like logout doesn't work every time or they have a problem while sending the data to the server and didn't get the correct response from the server.
Therefore I've fixed all these problems in the new version and you can download it from here:
github.com/InfinityWorldHI/NodeMCU
In this version, the Card ID will appear on the Users Log page automatically each time you scan a card and you don't need to refresh the page any more.
On the AddCard page also you don't have to reload the page to add the new user just scan the card then the ID will be selected with a check green sign.
You can send your problem to my email("electbusinees@gmail.com")
or to my facebook page: facebook.com/ElectronicsTechHaIs/ if want that
or leave a comment and I will try to help you.
You're welcome.
Cheers...
Hey there mate! Any news yet? Thanks
Every update will be available after the new year.
@@ElectronicsTechHaIs
Hello, thanks a lot for your effort, I appreciate it,
the new update is more stable than the old,
Please if don't mind making another tutorial about RFID with Arduino(SD Card, RTC, Excel).
Thanks in advance.
can you send cicruit diagram?
@@muharifandi550
The diagram is included with the code:
bit.ly/RFIDnodeMCUv2code
We Respect and Love you don't stop helping peoples
hi sir. I am using Arduino Uno with ESP8266 that connects to WiFi. I don't have nodeMCU, so can I use ESP8266 instead of nodeMCU. I need Arduino Uno to communicate with my ESP8266 , that means code is uploaded to Arduino to control ESP8266. Thank you
Hi, yes you can, but first, you need to modify the code to make it work with Arduino UNO and ESP8266, each one needs a different coding. The RFID module will be connected to Arduino then the ESP8266 will send the data to the website. Arduino and the ESP will be interfaced by Serial in order to communicate.
Thank you for publishing this wonderful project. This is really a nice project for a newbie like me to learn new technologies. I request you to continue your service to this fascinating field. Please try to add MQTT server option too so that manipulating RFID data will be much more easier with GUI. Wish You all the Best.
I'm glad you liked it.
Good suggestion, thanks.
For me I prefer working with http requests and design my own IOT platform so there will be much things to handle with many problems to fix and that will make the learning process more interesting.
I'm working on many projects with MQTT and I like it as well.
Thank you for your time and support.............
It's fully working now
You're welcome any time.
thanks for your feedback, I appreciate that.
bro can you help me...The card id(before name) is not showing when addcard.php is accessed
This is a good start to program a electrical car charging wallbox to avoid unauthorized use. Only add a relay module and little program changes
hello good morning, sorry for the inconvenience. In the web server project with rfid I have a problem when installing on localhost. gets error while creating database: can't create database 'nodemculog', but it creates the log normally. Do you have any idea what it might be?
Then create the database manually and import the tables manually "nodemculog.sql":
download the nodemculog.sql database from this link
github.com/InfinityWorldHI/NodeMCU/tree/master/loginsystem
Bro thanks a lot for this video. I took the contents of the code , modified it for our standards and obtained a research paper out of it.
You're welcome, thanks for telling me that.
I would like to read the research paper if you don't mind.
Could you send it to me, please?
Hi, i just do it all correct, i have checked the ips but i still having the -1 on my serial monitor, what can i do? thanks
Hi,
Have you followed my instructions in the video description?
I have learnt so much from you thank you and keep up the good work
Glad you like it and you find it useful.
Thanks so much for the amazing project, although it takes time to make it working. But any way everything now works perfectly.
Thank you sir.
You're welcome.
I'm glad it was useful.
how did you make it work?
@@kishorerabha8920
I just followed his steps that he mentioned in the video description and everything went well as it should.
This project helped me a lot in my final year.
So you can make it works because the code is good not a bad one.
Thx works pretty well
You're welcome.
in my project
it shows up when I install: Error creating database: Can't create database 'nodemculog'; database exists
Table logs created successfullyTable users created successfully
you're good, that's correct.
@@ElectronicsTechHaIs what should I do?
Continue the steps as in the video.
@@ElectronicsTechHaIs but from the error to install the database, just create the log
Sir this is awsome project i loved it this is really awsome 😃
You're Welcome.
I'm glad it was helpful.
Hello. Would I be able to use my active standalone reader that has been bought not constructed by me like the RC522, antenna and also the key cards with this system?
Hi sir, I want to do this project on Linux operating system with postgresql instead of MySQL. So can u tell me what changes i have to do in this code. And also u tell me why we use Wi-Fi in this project.
Sir, How too unblock the incoming data from other devices? Because i am not able to add card from the AddCard.php page.
Thank you :)
sorry I read a few comments below. but I can't understand how to deal with it
You need to make many changes on your PC, So Google it, but before that try xampp, you don't need to modify the config file.
@@ElectronicsTechHaIs sorry, I already used wamp and xampp but when I turned on the firewall the ID card was read on the serial monitor but on top there was still -1.
and if I turn off the firewall will appear
404
Not Found
Not Found
HTTP Error 404. The requested resource is not found.
on the serial monitor
What should I do? thank you
The localhost loginsystem page doesn't have a CardID field. Scan the card and it doesn't show up. Please help me.Thanks
Make sure that you're able to access the website from your mobile browser by typing the computer IP address
@@ElectronicsTechHaIs Thank you.
@@itsiam3839 Hey Siam, I am facing the same problem, can you tell me how you overcome it. Please
i scan the card but it don't appear the ID, help me!
Make sure your computer is accessible from other devices on the same network.
I will try this project. This is a very good one.
hello , sorry for the inconvenience. In the web server project with rfid I have a problem when installing on localhost. gets error while creating database: can't create database 'nodemculog', but it creates the log normally. Do you have any idea what it might be? pleaseeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Create the database manually and import the tables manually "nodemculog.sql":
download the nodemculog.sql database from this link
github.com/InfinityWorldHI/NodeMCU/tree/master/loginsystem
@@ElectronicsTechHaIs how and where to create and import manually
@@ElectronicsTechHaIs what to do after importing?
Continue the steps after install.php step.
timed out for packet error it says in arduino
Check the local server and the computer IP.
Can you added the dashboard on the website without change anything, I mean the dashboard the tab 1. name is schedule, schedule for college it's for information to student, and tab 2 that's attendance system like on your video, same function for information to student
Send more information about it on my Email.
@@ElectronicsTechHaIs I've been heard wampserver can't be accessed with online not like xampp, could you make tutorial attendance with xampp same project with this video.. Ive project in the college, "system information attendance with IoT"
yes xampp is a bit easier to use but I recommend using a raspberry pi as a web server using Nginx, not your computer
then use xampp instead of wampserver.
Hello sir, thank for your support but, I have some questions, how can I add department in login system so that students can be found in separate department instead of being printed together. If you have a code ,you can help me. Thanks
Hello Sir, All is working perfect , but every morning my system is not working i need to restart the server ( my laptop ), any suggestion. why server stop in night or some time after 1 to 2 hrs .
Please help
My leds aren't glowing while doing entry log what should i do??
I've fixed that, Check the my GitHub link for the new update, thanks.
Hello. Would you mind adding the pin names on your diagram for the rc522? There are some card readers with different pin settings and it's hard to know which pin setting is in your setup.
of course, here's how to connect the reader to the NodeMCU:
SDA --- D8 (or any pin you want)
SCK --- D5
MOSI --- D7
MISO --- D6
IRQ --- Not connected
GND --- GND
RST --- D3 (or any pin you want)3.3V --- 3.3V
How many users can be registered on the website? And what if the administrator wants to use it when using a WiFi network with a different internet provider, how to deal with it how?
Please answer my question :)
As much as you want,
Then you need to host the website on a host service like 000webhost.
then how to clear the user history log? and how to make the lamp work according to the previously uploaded command? because that's the problem I faced in making this project
Go to phpmyadmin and delete the log.
Hi sir I'm new learner and I've done everything as you did but still shows me the massage error can't create database for Nodemculog
Send a screenshot to my email.
I have implemented all things as per the video but i am not able to add card from the AddCard.php page. It doesn't show the card id on webpage.
Have you followed my instructions in the video description?
@@ElectronicsTechHaIs yeah
@@ElectronicsTechHaIs can you tell me what must be the problem?
Your local server and its port.
the WiFi network.
The omputer IP in the nodeMCU code.
@@ElectronicsTechHaIs I have configured everything as per the video description
Hello. I saw that you added time in and time out but i dont know which program for arduino is right. Or its new?
why does the program and the web not work? when I paste the rfid id card does not appear on the web? please help me
Hey! Everything went well but the reader isn't recognizing the card on serial monitor and not even on the webpage.
What can I do please help!!
you mean the card ID doesn't appear on the serial monitor at all.
set the baud rate to 115200, and please follow the steps that I wrote them in the video description.
I hope that helps you in some way.
Yes sir now the card ID is appearing on serial monitor but it is appearing with '-1' . I tried all the possible ways you told but it is not working. Please help ASAP.
I've updated the video description for a bit more and I hope that helps you to make it work just be patient and give it another try.
Why the RFID is not displayed on serial monitor of arduino ide?
And I am having problem with phpmyadmin login
Is it possible to make this with Arduino UNO and send the data through a GSM SIM800L module??
sir in your code its "post data" and in the code provided its get data will this make a change in the overall running?
Another question is, what if the sever is turned off while the system is on?? Can you please share us a code that can store those data while sever is off and send them after the sever is turned on?? Thanks
How to validate if the card that is reading the RFID is registered in database?
You can find that on the serial monitor.
so if you use does it work if you use your pc hotspot to connect to the NodeMCU?
isit possoble to connect just the arduino with xampp without nodemcu or ethernet shield , since im gonna connect the arduino to my laptop which runs xampp locally???
yes, you can.
There's a tool which provides communication between the Arduino and Local server via USB called "MySQLio".
You can check it out from this link: github.com/akay25/mysqlIO
Hii plz help me with the below question i have made the whole project but only able to scan a card once in a day what changes should i do in code so that it can store multiple arrival and leaving timings of students plz help..
Hi, leave your email to send you the modified file.
@@ElectronicsTechHaIs Can you please send me the file? Thanks.
notice me sir, the serial monitor read my rfid card and below it it have -1, and the problem is in the add.php it doesn't have any output, help me sir
That means there's no response from the website, therefore, check if your computer allows the incoming requests to access the local server, Are you able to access the website from your mobile browser by searching for the computer IP?
@@ElectronicsTechHaIs no sir i can't access beacuase im using localhost, i already disable tha firewall but it has the same output, what should i do?
did you find solution to this
@@ElectronicsTechHaIs sir please solution to this problem iamalso facing same issue
Had the same problem, but could find solution by doing the steps in this link-->blog.pcrisk.com/windows/12803-err-connection-timed-out just try it, good luck
Hello
excellent approach regarding the usage of the system.
I've made and an portable lcd with wemos so i can visualize any card or keyfob among all.
There must be something at the addcard php function which is not prossesing data the right way.
Lets say i have programmed 10 cards only by inserting them without username .
after i copy paste a card number and press select it shows up to the left.
Then i fill up user serial and gender and i press add.
Message appears that it was succesful But the user data went to another empty card number.
Please advice.
thanks in advance
Kostas
thanks for your notice, I will upgrade the website and it will be available next Sunday.
I'm going to fix these bugs.
Can u tell me how can I use our university I'd cards for scanning instead of RFID cards??
hello sir i wanted to know if it posible to make this project with an ethernet shield also
What the code should I have to typing.. I want to add one column for 'schedule' on side right after the Table 'name' column... Thank you
you should add a column into user and logs tables, also you need to add that column in view.php page and AddCard.php as well.
how can i change the look of the server? like the background img i tried to replace it but it dosnt change
You should change it here: background-image:url("image/2.jpg");
I have a problem. There " hard bersetting via rts pin" . Can you help me about this problem?
Try to press the flash button on the board when you see "connecting....."
What to do if we want to demonstrate it using mobile hotspot
if i want to put a buzzer on board and Beep. when RFID tag touch to RFID reader. How to do this
You just need to put the buzzer after "
for (byte i = 0; i < mfrc522.uid.size; i++) {
CardID += mfrc522.uid.uidByte[i];
} "
i have one question, how many rfid cards/tags can this handle?.
because i want to make it as a school attendance system with around 200 students
As many cards you want because everything will be stored in a database, not on the nodeMCU.
Hi how do you do this with a ethernet shield i do not have a esp8266
can you please help me what is the type of " date , time in , time out " in the database?
Date is date type, time in and time out is time type.
SALAMAT PO NG MARAMI!!!!!!
I am facing a problem, data is not entering to user log, could you please give me a solution ? It's urgent for me
i have made a website to register the attendance of students but i have problem with how i can make the website receive card number from the rfid and esp and i think the problem is in the php code please if you read this answer me
I see, Could you send me more information on how you done it? or Have you used my code?
How do I change the website Title to 'XYZ University Attendance portal' instead of 'RFID auto recorder' ?
Open the header.php file and modified as you want.
Hi i'm using lamp on ubuntu. How do i configure httpd.conf? Pleas help asap
whenever i will try to upload nodemcu code in board at that time i receive this error 'SPI' was not declared in this scope
Check if the SPI library is already exist or not.
Hello, how do we add multiple arrival time and leave time.
Can you do it? Multiple arrival and departure times
Hi,
Can 2X16 LCD IC2 be connected to your project?
can you help with this.
Hi, Yes you can.
connect the I2C LCD pins instead of the LEDs pins.
I did the same thing as you and it still does not work...at the serial port they receive -1 error, even after I did what you said in the description
Excuse me for the delayed reply.
There's a trick to find where the problem is.
So in your browser go to: ( localhost/loginsystem/postdemo.php?CardID=15353114161)
must appear a "successful" message.
then go to AddCard page it should the CardID"15353114161" appear, If so then your database and website work just fine.
After that go to your server file where you put the nodeMCU IP and enter your mobile IP, then open the mobile browser to ( "Your computer IP"/loginsystem/postdemo.php?CardID=25468971354)
it should appear a "successful" message, If not then your computer is blocking all incoming data.
Let me know.
may i know how do you enter the coding at first because i cannot do that
Hey! Just allow the port 80 in the inbound section of firewall into your computer. Watch this tutorial:
ua-cam.com/video/Jq-Y-mQEgYk/v-deo.html
Thank me later :D
@@ElectronicsTechHaIs but after following all of your steps, the CardID doesn't appear on AddCard.php page! PLease let me know :))
@@syedmuhammadumer4693 thanks bro❤️ it works
can i do it with the webpage without the nodemcu ? just using the arduino uno and rfid
Then you need a USB connection and a tool called MySQLIO
or you can connect a WiFi module called the ESP8266 V1 with the Arduino by connecting RFID to the Arduino then the ESP8266 will send the data to the website from the Arduino via Rx/Tx.
I will take about it in the next video.
Hi. This project is very good but I'm having a problem with exporting the file to excel. It doesn't do anything when i press the export to excel button. Please help me.
Hi, Because the day of the log is empty and it must be users into the log also you can select the date log in order to export it to Excel.
My wifi cannot connect to the server ,,,what is the problem
It shows for example abcd is connecting ......................
......
Hello, have you tried doing RFID with Wifi Shield Cytron? Do you have any idea on how to combine both source code?
Sorry I haven't.
because of the nodeMCU a bit more easy to use. But you can give a try to make it by understanding how Wifi Shield Cytron works, Then modify the source code to make it suitable for Cytron Shield.
I have an plan to host this in an cloud server but how to do that and deal with Ip address n stuff??
Just put the domain name of your website instead of the IP.
How to change the real time because the date is correct on my web page... is there any specific coding or just to change it on sublime text ?
What time do you mean?
Change timezone in the php file
hello sir,can i ask why my rfid card didnt functioning??when i swipe the to the rc522,the led does not turn on and the id card did not display..please help me sir.
Hi.
you should check if your computer allows the outcoming data
from your mobile go to: yourcomputerIP/loginsystem/postdemo.php?CardID=15353114161
try xampp if you're confused about that.
so in this case is it possible because i dont have xampp??
Yes it's possible, however, xampp is a bit easier
thank you sir.btw i have one question,i meantime,my connection with the xampp is succesful,but when inswipe the rfid card,the data cannot enter the phpmyadmin,why is it happen??i hope u can answer my question as soon as possible.Thanks!
send some screenshots to my facebook page or my email.
Sir I am using mobile hotspot for project and I have given proper access to the node but it shows "you don't have permission to enter this file " so is it because of the wifi or does it have any other issue
Try to turn off the firewall and later try another WiFi network.
can i know where to upload the uid number in the excel login code
and it it not showing me the uid no in the serial port.can u please help me.
What do you mean by that?
Hi..
sir in add a new user php file it not showing card id...
and in com4 it showing -1,-1,
i use xammp as a server...
Hi, First check if your computer allows the outcoming data to access your server. From your mobile browser go to your computer IP/loginsystem/postdemo.php?CardID=15353114161 It should appear a successful message, If not then your computer is blocking the outcoming data.
How can I set up multiple log in and log out for a single id
Hello sir. Will it work if I change the rfid reader library to rdm6300 instead of rc522? because im using rdm6300 rfid reader for my project. your response is highly appreciated
Hi, It should work, if you made the right modification on the code.
Hi, do you know how to write a code that can show the location of RFID reader? For example, if I scan the card on RFID reader in Malaysia, it will show "Location : Malaysia", if it in Indonesia, then it will show "Location : Indonesia". I want it to show the premise location where it was scanned in the database
Yes, you just need to give the device(reader) permission to access location and it will work
cant find the changes you made in wamp server please help meeout regarding this
Where exactly?
This is awesome. Could it be possible I could follow this guide for our project? And by the way, can I ask why can I not use a mobile hotspot just only from router? thank you ☺☺
hai may i know why i cannt connect to wamp server ? last time i can connect but thus times it shows that this site cant be reached
Hi, You can use xampp server is a bit stable than wampserver. check the link if it's correct: localhost/loginsystem/AddCard.php and if the website files actually exist in www folder.
Can you please share me your httpd.config file i tried every thing it shows only -1 and error 403 forbidden .Need help!
I've sent all that you need to your email, check it.
I have issue of
It shows after uploading
Leaving
Hard restting via RTS pin....
Plz help uh
Email me with your problem and a screenshot.
can I know what kind of type NodeMCU that you use?? Is that NodeMCU V2 or NodeMCU V3??
Any version will work,
Master, how can add second shift time in same data base ?
Hello @Electronics Tech can u just tell me how to proceed this with xampp server as I'm using Linux n I don't have option to use wamp!!
Hi, you just need to copy the website files into xampp/htdocs folder without editing any file.
Sir we switch off at daily night after worktime so, it will save last recording or not?
yes, it will.
However, when you start before midnight and finish after midnight then it will save both of the entries as a separated entries.
Sir I want to apply machine learning on the obtained exel file can you suggest me the algorithm I could use .
If you want it on the website side then you can use either MobileNets or using python.
oh great teacher there is no problem if I do it with the module
esp32 ?
Thanks,
Yes, you can use ESP32, but the diagram is a bit different.
Hello, theres a few questions i would like to ask:
1. Do i need to set the day manually everyday or will it update on its own?
2. How can i access this database via WAN network (instead of this LAN)
3. I did actually change the image file (which was labeled as '2'). But it didnt update the site's background image. Is it possible? cause i need to change it to my school's image thingy.
Thanks in advance
Hi, 1_ No, you don't. it will update the day automatically.
2_ You need to host the website on a hosting service like 000webhost then put your website domain instead of your computer IP in the NodeMCU code.
3_ Check your image extension it should be ".jpg"
@@ElectronicsTechHaIs wow thanks haha
can i use firebase as my server? or is it exclusively xampp and wampserver?
You can use any public server.
Hello , when I copied the login system and open the website.I don't have the card Id on the upper part of the website. Is the website code missing or what's the problem?
Hi, Everything was tested and work as it should. Use xampp instead of using wampserver and copy the website files into xampp/hstdocs folder then go to localhost/loginsystem and continue the steps as in the video. Also, you don't need to reload the page any more it will reload the data automatically.
Yeah the card id doesn't show up on webpage nor on the serial monitor
Hello, i use xampp and i wanna know where should i put the IP in httpd.conf ?. Thank you
Hi, you don't need to modify that file while using xampp.
@@ElectronicsTechHaIs ohhh okay. Thanks for responding my comment. Have a nice day!
hi sir,
To add the ESP boards to Arduino IDE here the custom URL:
How can i get the link , i'm sorry i can't understand ?
Hi, open your Arduino IDE then from file go to preferences then insert the ESP link into the custom link box.
Thanks bro it worked for me
I'm glad it was helpful. You're welcome
Greetings, has anyone managed to get the new version (rfidattendance) to work beyond the password prompt? The error message I get is "There a database error!! ". I have verified that the database and tables are present. Also, I have perused the Mysql forums, but they are bereft of ideas. Regards.
Hello,
Make sure that the connectDB page has the right phpmyadmin credentials.
@@ElectronicsTechHaIs Thanks for the reply.I forgot to mention that I am using OSX/XAMPP. I resolved the issue by using the IP address of the MYSQL server rather than "localhost". However, when I switch the device mode to "Attendance", nothing appears in the Table `users_logs`. I have cross tested by using the same Sketch and database on Windows 10 also with XAMPP and everthing works as expected. I will resume troubleshooting next week and provide feedback as it might help other OSX users. On a different note, I would like to add a 16x2 LCD display to provide visual feedback such as Access Granted or Access Denied and attendee's name at login -out. I would like to know if it is OK to make changes to the your source code?
Hi sir..I am having some problem in reading the rfid card.. Can you help me sir?
What happened?
Hi , Thank a lot ... This is work very fine.
Hi, Good to hear that, My pleasure.
Thank you again and if possible I have a question
,too. In this project, when the card is first used it is recorded as an entry .The second time is recorded as the exit hour. In the following If the card is used for the third time, the exit time will change.
That is correct But if I want to be recorded this time as another entry,What should i do ? Thank you very much...
Oh, I see, yes you can make that. Leave your email and I will send you the modified page.
@@ElectronicsTechHaIs yasehbahari@gmail.com ,, thank you.
Hi sir! the CardID above the name was disappear. can u please help me to resolve this. been resolving this for a week. thank you
The card ID must appear inside the table not above the name because I updated the website months ago and I mentioned that in the video description.
Sir, add user procedure is working correctly. But attendance system is not working. please help me to solve this
What is the problem?
I want to use this with UNO and NANO boards, how do I go about it?
You need either a WiFi shield or an ESP board
hello good afternoon, I would like to talk about the project. almost everything worked so far, I passed the data, the program and the web server. But when I enter the web server and put my id card, nothing happens, the code is not passed to the program, I missed something or can fix? another detail is that does not appear on top of add name the option CardId. thanks in advance for the program.
Good afternoon,
That's good so far. Which local server you're using? Have you checked whether your computer allow other devices to access it?
@@ElectronicsTechHaIs I'm using wamp. I think my computer supports it, but if it doesn't accept what should I do?
Try xampp server.
and test if you can access the website via the PC IP from your mobile browser.
Hi! Using this, How can I achieve multiple log in and log out of the same card within the same day? Can you help me thank you great work sir thank you😊