Arduino IDE + NodeMCU V3 + MySQL + PHP | NodeMCU V3 with RFID RC522 uses MySQL Database and PHP
Vložit
- čas přidán 5. 09. 2024
- Arduino IDE + NodeMCU V3 + MySQL + PHP | NodeMCU V3 ESP8266 / ESP12E with RFID RC522 uses MySQL Database and PHP | CRUD. In this project video I use Arduino IDE 1.8.9 , Notepad++ V7.7.1 , XAMPP V3.2.2 , RFID RC522 and LoLin NodeMCU V3 ESP8266/ESP12E.
To add the Library and NodeMCU ESP8266 Board see here : • Arduino | LoLin NodeMC...
For how to install XAMPP Server see here : • How to Install XAMPP S...
For how to install the MFRC522 / RC522 RFID Library see here: • Arduino | How to use A...
Download source code here : drive.google.c...
The code file is saved in the .rar file format. I created a .rar file using Winrar V5.50, so to extract it, make sure you use the same version of Winrar that I use or the latest version or use the winrar extractor online.
***********************************************
Thanks for watching & don't forget to like, comment and Subscribe...
***********************************************
For other video tutorials on this channel, please see this playlist:
- Basic4Android (B4A) Tutorials : • Basic4Android (B4A) | ...
- Electronics Tutorials : • 3 LED Flip Flop
- Arduino Tutorials : • Arduino | Scrolling Te...
- Great Cow Basic Tutorials : • Great Cow BASIC with A...
- Bascom Avr Tutorials : • Bascom Avr | How to Se...
- VB .NET Tutorials : • Visual Basic .NET | ...
- LoLin NodeMCU V3 ESP8266 Tutorials : • Arduino | LoLin NodeMC...
***********************************************
Download Arduino IDE : www.arduino.cc...
Download Fritzing : fritzing.org/do...
Download Notepad++ : notepad-plus-p...
Download Bootstrap : getbootstrap.c...
Download jquery : jquery.com/dow...
***********************************************
Download RFID MFRC522 / RC522 Library : github.com/mig...
***********************************************
Images and Icons Sources in this video:
NodeMCU V3 ESP8266 : github.com/pra...
Laptop/PC : www.iconfinder...
WiFi : www.iconfinder...
WiFi Router : www.iconfinder...
***********************************************
Reference :
HTML Blink Tag (w3docs.com) : www.w3docs.com...
PHP CRUD Tutorial (www.startutorial.com) :
- www.startutori...
- www.startutori...
- www.startutori...
PHP - AJAX and MySQL (www.w3schools.com) : www.w3schools....
AJAX Database Example (www.w3schools.com) : www.w3schools....
Forms (getbootstrap.com) : getbootstrap.c...
And from several other references.
***********************************************
Music Background:
Chill Guitar / Flamingo by jlsmrl / jlsmrl
Creative Commons - Attribution 3.0 Unported - CC BY 3.0
Free Download / Stream: bit.ly/chill-g...
Music promoted by Audio Library • Chill Guitar / Flaming...
Feel Good by MusicbyAden / musicbyaden
Creative Commons - Attribution-ShareAlike 3.0 Unported - CC BY-SA 3.0
Free Download / Stream: bit.ly/_feel-good
Music promoted by Audio Library • Feel Good - MusicbyAde...
Morning Routine - Ghostrifter Official / ghostrifter-of. .
Creative Commons - Attribution 3.0 Unported - CC BY 3.0
Free Download / Stream: bit.ly/_mornin...
Music promoted by Audio Library • Morning Routine - Ghos...
Lights by Sappheiros / sappheirosmusic
Creative Commons - Attribution 3.0 Unported - CC BY 3.0
Free Download / Stream: bit.ly/LightsS...
Music promoted by Audio Library • Lights - Sappheiros (N...
Skydive by Loxbeats / loxbeats
Creative Commons - Attribution 3.0 Unported - CC BY 3.0
Free Download / Stream: bit.ly/2uUKEmd
Music promoted by Audio Library • Skydive - Loxbeats (No...
***********************************************
finally i fix the error -1. just turn off your firewall maam/sir it will perfectly work
Good work 👍
hello. can you provide the solution for the error -1? I am getting the same error and I cannot find the solution to this. Any help would be appreciated. Thank you!
i still can't fix sir can you help me?
Thank you! It worked 😅
But may I know Sir what do the -1 and 200 indicate? I don't have a good background in coding yet 😅
Opa boa tarde, sou brasileiro e o fato de não precisar e áudio me ajudou, e sério você me salvou eu tinha um projeto para apresentar a qual usava o ESP e o RFID, e eu não sabia como fazer direito, seu vídeo foi maravilhoso, parabéns
Ringrazio voi è stato duro il lavoro ci sono riuscito e vi faccio un complimento meraviglioso il software che avete creato mi ha soddisfatto tantissimo complimenti per la ralizzazione bellissimo. Un abbraccio immenso.
Ho tradotto la tua lingua con Google Translate e penso che sia un complimento. Grazie :-)
Kalo ada manual book nya lebih lebih lebih mantap bro, tapi video juga mantap bro, ini yg saya cari cari bro, terima kasih sudah buat video nya.
Blm sempat buat manual booknya bro.
Sama-sama brooo 🙂
uh something is depricated an error occurred:
'bool HTTPClient::begin(String)' is deprecated
Terimakasih tutorialnya, membantu banget buat mahasiswa yang baru belajar iot. sekali lagi terimakasih
Sama-sama :-)
Thanks sir your videos are amazing
Now I am working on graduation project .
We uesd arduino and RFID and esp8266 with Google sheets and connect it with website (student based attendance system)
Can you please make video about it.
Thank you.
At the moment I haven't had the chance to make it. But there are some videos that discuss that, maybe it can be a reference for you. Look here :
czcams.com/video/hJhnAZ-oDN0/video.html
czcams.com/video/4e9hE34RMZM/video.html
Hi, the UIDContainer exercise does work but when creating the registration page the tag id does not appear, I don't know what the error is due to. can you help me?
@Uteh Str you did awesome work, I kept trying for 3 days, one simple error makes me dig all the codes and causes shit apparently found the error, Thank you so much, mate.
Hi, if i want to make a servo motor rotate when i'm in the read tag (and is registed), how can i do that?
For anyone who encounters problems.
Warning: Undefined array key "UIDresult" in C:\xampp\htdocs\project\getUID.php on line 4.
Try changing script to
function fetchRFID() {
fetch('UIDContainer.php')
.then(response => response.text())
.then(data => {
document.getElementById('rfidDisplay').innerText = data;
})
.catch(error => console.error('Error fetching RFID:', error));
}
setInterval(fetchRFID, 2000);
Supper tutorial 😊💗 but i need extra funtion. 👇
How to gain the Check report to a new table while checking the registered rfid at the time of displaying ?
If that checked Id had in our database at that time how to save a report in a new table with the checked time ?
I have a problem, UID of the RFID card is not displayed at Registration level, But UID is displayed at monitor serial level. what is the problem please
Hello there
nice project well explained to everyone.....
but i have one question......
what is the practical use of this project?????
it would be nicer to have also a confirmation to the esp that the card is valid ......
and enable an output for a door.......
and another option to write in the database the timestamp everytime reading the valid tag on different table....
thanks in advanced
Niko
attendance , asset management
hello. why am i getting this error sir?
Notice: Undefined index: UIDresult in C:\Users\admin\Documents\xampp\htdocs
fid-reader\getUID.php on line 3
When did the error message appear ?
@@utehstr i got same error after scanning rfid and checking for update in browser (UIDcontainer.php)
@@VINDROIDGAMING Did you get solution for this?
did you solved?
@@poojahgurumurthy7476 did you solved?
Worked when first try..but when i tried again on next week, it showed Undefined array key "UIDresult" in C:\xampp\htdocs
fidattendace\getUID.php on line 2. Can i know what's the problem sir ? minta bantu bang.
Sudah ketemu belum solusinya bang
Great!!! einfach und ohne worte hat ganz klar alles erklärt, genial. Muchas gracias por compartir...va mi like ;) Grüßen aus München!
Vielen Dank :-)
Ich übersetze Ihre Sprache mit Google Translate.
Es ist mir noch nicht möglich, meine Stimme in das Video einzutragen.
Grüße aus Nord-Sumatra, Indonesien.
Thanks for the videos. Very informative and step by step shown. Can you help to understand how to published in web? And how to ensure the databased only can be access by admin and the user..
You're welcome :-)
I am interested in your comments on the section "And how to ensure the database only can be access by admin and the user". About that I am still studying it. Honestly, my knowledge about php and databases is still very limited, I will still study it. I will make the video later if my knowledge of it is sufficient.
Sorry if my English is confusing, I am using an online translator.
Rfid card sama rfid tags nya tidak terbaca di website nya bang, tetapi di serial monitor muncul, gimana yah solusinya? 🙏
This is excellent work, it's working perfectly fine. How about if I want to put the details show the registered card into another database as well and the time they were scanned. Please help
great project !, I wish to add a contactless temperature sensor (MLX90614) on this project so the user can additional measure his/her temperature and save the values to the server also display them on a website. Please Help
I have question. I already achieve a 200 http status code but when I try another rfid card it shows -1 again and when I tap again the card that shows status 200, it will come back again to -1. Any idea what causes that? thank you
The 1st time I attempt to follow this tutorial, I was able to make it working.Then I put the hardware, nodemcu and rfid in a bag and tested it again for the 2nd time. It is no longer working. Is it possible that the rfid is damage.. I was able to upload the code to my nodeMCU. it' sjust that it cannot read the card.
Hi Uteh!
First of all I have to thank you show us such a complete and clear tutorial.
However ,I had a problem :I only have Arduino UNO except NodeMCU. Is there a possible way to POST ID tag data via serial port ?
Thank you for helping me!
Hello! Very good job! Thank you! Sorry, but I have a question.
We read ID and show only present ID on page "read tag ID". But how can we show ALL read tag on page "read tag ID"? Without updating?
I have a problem where in "UIDContainer.php" the card ID able to displayed. But in "read tag.php" the form unable to display the user information. Same goes as the ID in registration form. Please help me to solve this problem :(
Thank you Uteh!! Good job!
You're welcome :-)
Im trying this for weeks for a project that im doing and the UID container doesnt show the id, i don't know what else to do, please help me 😥 life or death situation...
Im working with vscode, the id just show up in the serial monitor and that's it. Is a project for university... thanks
how can i connect with door lock to this system? plz help me
Great video. Such a good help. Do you have more tutorials for this especially connecting with led lights and buzzer with source code? KUDOS!
Thank you :-)
Look here :
czcams.com/video/fQ6HyvQ7IUU/video.html
or see this playlist :
czcams.com/video/8jMr94B8iN0/video.html
Thanks a lot for sharing this great project for us. just need little guidance if information on tag is matching with data base then how can i grant access to that user for example at security check point i installed this system some is coming and scan his card after matching his information how can i operate the security gate for him? please give me solution for that please
Works great on Xampp and Wampp but I couldn't find any clue why it is not working with Apache installed on Windows or Linux instead of installing Xampp or Wampp. Anyone?
Instead of NodeMCU V3 can i use an arduino uno and if yes is there something i should change?
Bang.. knapa pas di form registration ID gak muncul, cuma di serial monitor doang yg muncul?
UIDContainer.php ny juga udh muncul ID ny di browser. Tapi knapa pas di menu registration kok gak muncul ya?
@@ashabimaulana541 Seperti kamu lihat pada video semua bekerja dengan baik. coba kamu lihat lagi videonya dan periksa kode kamu , mungkin kamu melewatkan sesuatu.
hi, thankyou for this helpful tutorial by the way,
I have a question I have rfid can i also put an mlx90614 temperature module in nodemcu ? i want to add it if is possible ?
Thankyou
I have some of question .. for our thesis I hope you can help us ... Because our thesis is about locker security system using RFID . .
Will it work with the locker security system because I need this kind of system admin to control the locker
Buenos dias,me aparece un error en user data.php : Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\NodeMCU_RC522_Mysql\user data.php on line 95
Thank you much. very nice videoo... Keep it up
Everything went well which there's no error encounter, however in the read tag page.. It doesnt show the scan rfid card. i hopen someone can guide me. thanks in advance'
great job i like your project
Thank you :-)
I can't find the 'home ok ok' jpg. Can you help?
I did not share the image file. You can replace it with another image file.
thank you. the update is not working for me. (user edit page) when I validate with the submit button (after 23 minutes of the video)
Ótimo projeto! Parabéns.
O que mudar para usar o esp32 ? Obrigado.
Sou de Barueri, São Paulo, Brasil.
After registration the values of gender and email are showing boolean values. I didn't get the actual data which I give before..
So help me to rectify this error
hi, I already exactly do the same like this video and it went well. Can you help me what if I want to put currenttime. when they scan the time alse come out.please help me
First of all Thank you for such great tutorail!!
Everything is working perfectly except that 200, I'm constantly getting -1
What can I do to change it as because of that the UID number is not printed on the website..
Please help
Can u fix this problem? I get same problem like u :(
hello sir, can u help me .....when I upload program into nodemcu then my rfid red light is not blinking please help me......
How can 1 sent Parents Notification With SMS Notifications With This Program For Student ARRIVAL AND departure
👍 super .Thanks 😍
You're welcome :-)
interesting project. Can you help me on this, please. As in your project once scan the rfid tag if successful i need to open boom gate (having 230v power) via a relay connected to arduino board for seconds and close atomatically. I need arduino code for this. thank you
i got an error like
'HTTPClient::begin' declared with attribute error: obsolete API, use ::begin(WiFiClient, url)
how can i fix this?
Take a look in the "Read Me.txt" file in the code file I shared.
Help me please!! :'(
I have a problem, when I lopload the code on Arduino, in the serial port mencioned "connecting" but the problem is that doesn't connect nothing :(
I have one hour with the message "connecting"🥺😥😔
Make sure you have written the correct SSID and Password in the Arduino code.
if the 3.3v in rfid is connected to 3v in NodeMCU can it or no? The problem at NodeMCU is that there isn't 3.3v
3v on nodemcu is 3v3 (3.3v)
Hello! When I scan the card then ambiguous string shows on serial monitor of Arduino IDE. What is this error please guide me.?
What do you mean by ambiguous string?
Excelente, Cambia mucho para el modulo Esp32? Gracias
Hello, need a help from you what if I want to record the log in database every time a card is scanned. Can you help me with this? Thanks in advance.
I would like to intercept UIDContainer.php value, to use on other server pages, before sending it to the database,
Can you help me please?
Thanks.
Hello friend, I used bootstrap 5, and there was no apparent problem, or is there any reason why you used version 2.3.2, will it cause any problems? Greetings.
For anyone getting the following error "call to 'HTTPClient::begin' declared with attribute error: obsolete API, use ::begin(WiFiClient, url)
Just check the B folder in the uploaded code, it contains the updated arduino code.
thankyou
bonjour monsieur moi je possède une carte ESP32 je veux faire votre projet mais je sais pas comment connecter pour que ça puisse s'adapter avec votre programme merci beaucoup !!! j'attend impatiemment votre réponse.
Sir after compelling code with out error in serial monitor
i didn't get like connect and tag is not reading and not getting tag id
Please tell me what is the problem
Sir Uteh, When I upload the code into nodeMCU, I always got this message "Leaving.. Hard reseting via RTS pin"
The code uploads successfully, I can see the status connecting in serial monitor but the reader cannot read rfid card. Please help
Make sure that the installation between the rfid module and nodemcu is correct.
@@utehstr Sir, do you have facebook. How do I connect to you. Can I have your email address Sir.
@@ryanbarrera2595 Look in the "About" tab of this channel, you can contact me from email and Instagram.
Hi Sir, i have a problem in the moment than i want to make a Registration and read the tag.
The RFID send the ID to the UIDcontainer but when i want to show the ID to make a registration the information of the tag dosn´t show in the field of ID, the same thing happend when i wanto to read the ID to show the information, nothing appers.
I follow all the steps from the video. Hope you can help me, Thanks you
i have the same problems do you find the issues of this?
Thank you, this video is amazing. Now, I'm understand
You are welcome :-)
@@utehstr Mantap bg teh
@@sahrialardians Makasi deq :-)
@@utehstr NodeMCU itu kek rasberrypie ya bg ?
@@sahrialardians Beda deq :-)
Nodemcu ini kayak arduino board juga, cm dia udah dilengkapi modul wifi esp8266.
I had a problem when I try to get the uid it doesn't work it on the first thing when I put the code on the arduino
What do you mean it didn't work ? what appears in the arduino IDE serial terminal ?
hello Uteh Str, I have an error Notice: Trying to access array offset on value of type bool in C:\xampp\htdocs\NodeMCU_RC522_Mysql\baca data pengguna.php on line 17. Can you help me?
did you manage find the solution? I'm also currently facing the same error
I get
SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES), and what's the problem?
how to calculate the array_to_string, it always return to -1 in my serial monitor
me too
@Uteh Str I just want to ask if you can do a video tutorial regarding a project which uses Arduino IDE + ESP8266 + MySQL + PHP + RFID RC522+ (4x4) Keypad, wherein the database will not just only accept reading from the RFID Reader but also accept input (number/amount) coming from a 4x4 keypad ( keypad is connected to arduino). Hoping for a response from you sir! Thanks :)
Hello, I have implemented the code in localhost but now I want to upload my PHP and mysql into cloud hosting server. So my question is what changes I have to do in order to work correctly and data will be sent to my server instead of localhost?
I have never tried this project using a cloud hosting server, so I only answer your questions technically. So if my answer doesn't work please ask this question in the Arduino forum or in the PHP forum.
In the arduino code, change the localhost IP to Public IP from the cloud hosting server. Next create a data base (adjusting the database that you created on localhost so you don't need to make many changes to the php code) and upload all php files from this project to your cloud hosting server.
@@utehstr Thanks for your reply. I have replaced the localhost IP with my domain name as well as IP address of the hosting server but it is not working. Means data is not successfully send to my hosting server mysql database. Anyway I am checking the other source if get any answer.
Hello sir I need help. This code is usefull for nfc reader? I have nfc device and I make same system like your demo.. but I can't find any solution. Please help. My nfc device is (acs acr1255).
😁Im Succes, Thanks My Friend
Good work 👍.
You're welcome 🙂.
Thanks a lot 🙏🏻
You're welcome :-)
hello sir , where you keep nodemcu....on which base....??
wich is folder can i use for placement for arduino file htdocs or other place
Warning: Undefined array key "UIDresult" in C:\xampp\htdocs\NodeMCU_RC522_Mysql\getUID.php on line 2
Kindly help me.....? whats this issue.?? why this is not matching??????
where you able to find the solution of this problem?
Mantab
Di tunggu tutorial emoney
Terimakasih videonya sangat membantu
Sama-sama :-)
Aviso a la fecha 30/06/2021 no funciona correctamente debido a este error: call to 'HTTPClient::begin' declared with attribute error: obsolete API, use ::begin(WiFiClient, url)
Make sure that you are using ESP8266 version 2.7.4 on the Arduino IDE.
SIR I HAVE TO SUBMIT PROJECT IN 2 DAYS PLEASE HELP ME ALL CONNECTION AND CODE IS RIGHT THE CODE IS UPLOADED SUCCESSFUL BUT IN SERIAL PLOTER ITS SHOWING LIKE THIS: Connecting...................................................................... BUT ITS NOT I HAVE ALSO CONNECTED TO SAME NETWORK PLEASE HELP ME SIR...
How to store finger print using finger print module of arduino
hi sir. Does this work on NodeMCU lua CP2102, too?
Could you please (explain or) add the comand to arduino to activate "the lock of the door" if this RFID is registered in database, please. Also would be greate to add for example temp sensor value on the web page and database. So you super video will contain everything to start with and I would personally would be happy to donate for that..)
If you want to discuss a special project like that, contact me via email.
Hi sir,my RFID reader cannot detect the rfid card and rfid tag.Do you know what is the problem?
broken rfid card, i change mine
Hello sir, I don't know why when I valid the card it doesn't appear in page read tags
Hello
Watch the video again, maybe you missed something.
can you add and excel on the read tag id area ? belos the output ?
downloadable excel file for the printable data
hello sir, how to do wire connection between nodemcu and rfid , do u have any circuit digram...
Hello
Look at 00:24
Mantep banget sumpah,thanks
Sama-sama :-)
Hello, I have solved the display issue in serial monitor. It is showing that successfully connected to WiFi and asked to tag the card but when I am touching the RFID tag then nothing happen. Can you please tell me what can be the issue. I am using different internet connection into my computer and WiFi from other source. That can be the issue?
Hello...
Make sure NodeMCU and Server Computer are on the same network.
@@utehstr Hello, yes NodeMCU and server computer are in same network. I have got the error "WARNING: Communication failure, is the MFRC522 properly connected?" This is the error I am getting in serial monitor despite that I have made the connection exactly told in your video. Please tell me what to do.
@@sadhanace Recheck the cable that connects NodeMCU with MRC522. Make sure you have installed it according to what is in the video.
Hello Uteh Str, I have a problem about error get the response payload (-1) . How can I fix? Thanks
Make sure you have used the correct IP address in the arduino code and make sure the nodemcu and server computer are on one network.
wow, amazing..
Thank you :-)
bang, misalkan saya buat kategori tambahan yaitu SALDO, dan saya pengen ketika setiap scan rfid, maka saldo nya berkurang gimana caranya bang?
Thanks video good
Sama-sama :-)
Saya sudah lihat channel kamu, konten-konten kamu bagus sekali.
@@utehstr makasih pak.
@@Junaproject01 Sip 👍🙂
When I Upload The Code The Serial Monitor It Shows That It Is Connected But When I Scan My Card It Does Not Show The Card Plz Help
Make sure that the server computer and nodemcu v3 are connected to the same network.
Hello, how do we make the system mark attendance?
Hello Uteh Str,
I am following the instruction step by step, but when i try to load home page i got this error: Parse error: syntax error, unexpected '" . "' (T_CONSTANT_ENCAPSED_STRING), expecting variable (T_VARIABLE) or '$' in C:\xampp\htdocs\NodeMCU_RC522_Mysql\home.php on line 2.
Can you help me to solve this problem?
The code is exactly like yours. I made copy of yours.
Thanks in advance.
Hello Uteh Str,
I fixed the problem. Sorry if i waste your time.
Have a nice day.
Good work :-)
hello, how are you, I'm failing to read user data from the database, if I scan it's not displaying user data in the database, only displaying the tag UID and say tag not registered when it is registered, help please i copied code as is and have cross-checked, its still not retrievind data from database
In this project I made it sequentially, so try watching the video again and follow the instructions in sequence according to the video, maybe you missed something.
@@utehstr it's now working thank you
@ Uteh Str, Hello hope you are well, I'm using wifi from school which requires some login details, so instead i have connected the machine which is also the server to the wifi and switched on hotspot to supply a connection for the NodeMcu but still, it does not work, the server computer is working as the router to the nodemcu. Could this be the issue?
Hello...
What do you mean by "login details" ?
@@utehstr its an open network so you connect and it redirects you to a login page
@@bekithembankomo3665 I have never connected NodeMCU with wifi that has a login page, maybe you can ask this in the arduino forum.
hello sir when I upload this arduino code, I get the error, this is: "Compilation error for NodeMCU 1.0 board (ESP-12E Module)."
Look here: forum.arduino.cc/index.php?topic=596688.0
brilliant!!!!
Thank you 🙂