Arduino IDE + NodeMCU V3 + MySQL + PHP | NodeMCU V3 with RFID RC522 uses MySQL Database and PHP
HTML-код
- Опубликовано: 8 дек 2019
- 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.com/file/d/1FA_1...
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/en/Main/Software
Download Fritzing : fritzing.org/download/
Download Notepad++ : notepad-plus-plus.org/downloads/
Download Bootstrap : getbootstrap.com/2.3.2/
Download jquery : jquery.com/download/
***********************************************
Download RFID MFRC522 / RC522 Library : github.com/miguelbalboa/rfid
***********************************************
Images and Icons Sources in this video:
NodeMCU V3 ESP8266 : github.com/prasertsakd/esp826...
Laptop/PC : www.iconfinder.com/icons/4417...
WiFi : www.iconfinder.com/icons/9258...
WiFi Router : www.iconfinder.com/icons/4736...
***********************************************
Reference :
HTML Blink Tag (w3docs.com) : www.w3docs.com/learn-html/htm...
PHP CRUD Tutorial (www.startutorial.com) :
- www.startutorial.com/articles...
- www.startutorial.com/articles...
- www.startutorial.com/articles...
PHP - AJAX and MySQL (www.w3schools.com) : www.w3schools.com/php/php_aja...
AJAX Database Example (www.w3schools.com) : www.w3schools.com/xml/ajax_da...
Forms (getbootstrap.com) : getbootstrap.com/docs/4.3/com...
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-guitar-flamingo
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/_morning-routine
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/LightsSappheiros
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 :-)
@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, 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?
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!
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?
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 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.
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.
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
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
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
Terimakasih tutorialnya, membantu banget buat mahasiswa yang baru belajar iot. sekali lagi terimakasih
Sama-sama :-)
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
Thank you Uteh!! Good job!
You're welcome :-)
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
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 :(
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
uh something is depricated an error occurred:
'bool HTTPClient::begin(String)' is deprecated
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
Instead of NodeMCU V3 can i use an arduino uno and if yes is there something i should change?
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'
Ótimo projeto! Parabéns.
O que mudar para usar o esp32 ? Obrigado.
Sou de Barueri, São Paulo, Brasil.
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?
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.
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 ?
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)
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
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.
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 🙂
hello sir, can u help me .....when I upload program into nodemcu then my rfid red light is not blinking please help me......
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
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.
Excelente, Cambia mucho para el modulo Esp32? Gracias
How can 1 sent Parents Notification With SMS Notifications With This Program For Student ARRIVAL AND departure
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
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
Rfid card sama rfid tags nya tidak terbaca di website nya bang, tetapi di serial monitor muncul, gimana yah solusinya? 🙏
Thank you much. very nice videoo... Keep it up
wich is folder can i use for placement for arduino file htdocs or other place
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 :
ruclips.net/video/fQ6HyvQ7IUU/видео.html
or see this playlist :
ruclips.net/video/8jMr94B8iN0/видео.html
@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 :)
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.
hello sir , where you keep nodemcu....on which base....??
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).
how can i connect with door lock to this system? plz help me
hi sir. Does this work on NodeMCU lua CP2102, too?
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.
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
apa ada tutorial penggunaan rfid untuk pembayaran maupun top up deposit yang terhubung ke database?
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
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?
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?
great job i like your project
Thank you :-)
Hello, how do we make the system mark attendance?
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
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.
Kernn broo lanjutkan
Makasi bro 🙂
Mantab
Di tunggu tutorial emoney
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 :
ruclips.net/video/hJhnAZ-oDN0/видео.html
ruclips.net/video/4e9hE34RMZM/видео.html
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.
👍 super .Thanks 😍
You're welcome :-)
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)
bang, misalkan saya buat kategori tambahan yaitu SALDO, dan saya pengen ketika setiap scan rfid, maka saldo nya berkurang gimana caranya bang?
I get
SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES), and what's the problem?
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.
How to store finger print using finger print module of arduino
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.
Mantep banget sumpah,thanks
Sama-sama :-)
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 :(
bang mintak ajarkan gimana mahu buat selepas scan data akan masuk dalam data table berdasarkan data dari data table awal
Bom dia!
Tutorial: poderia criar sistema usando display lcd touch arduino com winforms crud mysql?
"Usar o meu winforms do pc e emular no arduino com display lcd touch".
Buen video, Como puedo leer datos desde MySQL con ESP8266 y esto controlar desde una pagina web que está en la nube?
hello sir, how to do wire connection between nodemcu and rfid , do u have any circuit digram...
Hello
Look at 00:24
I make everithing you say and its works great !! thanks a lot for your tutorial ! thumbs Up and Suscribe for you.
Good job 👍
You're welcome 🙂
Thank you for subscribing.
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.
how to calculate the array_to_string, it always return to -1 in my serial monitor
me too
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 ?
can you add and excel on the read tag id area ? belos the output ?
downloadable excel file for the printable data
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.
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.
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
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.
@ 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.
😁Im Succes, Thanks My Friend
Good work 👍.
You're welcome 🙂.
Hello Uteh Str,
The same problem here. When i download the code there is an error: damaged or unknown format...
Can you send me the code?
Thanks in advance.
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.
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.
brilliant!!!!
Thank you 🙂
Mas,klo untuk mendeteksi arus dengan pzem004Tv3 dan nodemcuesp8266 serta localhost gmn cara nya bang ,jadi nilai sensor nya dikirim ke web dan dinrecord ke database bang,mohon pencerahannya bang, terimakasih
Maaf, saya belum pernah pake modul itu.
Its that have for esp32???
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
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, 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 sir why we need to change the array UID into a string?
In my opinion to make it easier to display and send UID data. Is that a problem?
how to add scanned attendance to record
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
How to put a activity log