Connect RFID to PHP and MySQL Database with NodeMCU ESP8266

แชร์
ฝัง
  • เผยแพร่เมื่อ 9 ก.ย. 2022
  • This tutorial will teach how to Connect RFID to PHP & MySQL Database with NodeMCU ESP8266. Here I have interfaced the RFID-RC522 Module with NodeMcu ESP8266 and then I'm sending data of RFID to MySQL Database. We are just reading the serial data coming from NodeMCU ESP8266 and then publishing that to MySQL Database through python code. Unlike others, This project is Protable because we can access data from any device connected to the Internet. Basically, this project can store the Credentials of Students or employees.
    ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
    Connect RFID to PHP and MySQL Database with NodeMCU ESP8266
    Requirements:
    Hardware Components Required
    ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
    NodeMcu ESP8266: amzn.to/3mTuL95
    RFID-RC522 Module: amzn.to/3pOPpb4
    Jumper Wires: amzn.to/2JWSR44
    Mini Breadboard (optional): amzn.to/3n33uRT
    Software Required
    ▬▬▬▬▬▬▬▬
    Arduino IDE
    XAMPP server
    PHP Source Code
    RFID-RC522 Library
    NodeMcu ESP8266 Library and Board Manager
    ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
    Written Tutorial Link: iotprojectsideas.com/connect-...
    ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
    ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
    Special Thanks to
    Original Creator of this project: • Arduino IDE + NodeMCU ...
    ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
    ESP8266 Tutorial: Connect RFID to PHP and MySQL Database with NodeMCU ESP8266
    I hope you enjoyed this tutorial. I'll see you in the next one.
    Thanks for watching it.
    ~-~~-~~~-~~-~
    Please watch: "Relay Control with Arduino & DWIN HMI Display"
    • Relay Control with Ard...
    ~-~~-~~~-~~-~
  • วิทยาศาสตร์และเทคโนโลยี

ความคิดเห็น • 40

  • @MiqbalMaulana-nr1ox
    @MiqbalMaulana-nr1ox 10 หลายเดือนก่อน +5

    Rfid cards and rfid tags cannot be read on the website, bro, but the serial monitor appears, what's the solution? 🙏

  • @markshandonalviar5145
    @markshandonalviar5145 ปีที่แล้ว

    D2 was not declared in this scope what should i do ? im new in arduino ide

  • @turinayoevode888
    @turinayoevode888 9 หลายเดือนก่อน

    thanks you! but can you show as how to get data and display it on lcd
    like i want to scan tag if it is in database then it data will display on lcd

  • @kusumamada7633
    @kusumamada7633 8 หลายเดือนก่อน +1

    terimakasih boloo sangat membantu

  • @febripray
    @febripray ปีที่แล้ว +2

    Error code when write D2 and D1, can help to solved it?

  • @user-rk5bq9bx5i
    @user-rk5bq9bx5i 8 หลายเดือนก่อน +1

    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

  • @Madalina-DumitrinaGordei
    @Madalina-DumitrinaGordei ปีที่แล้ว +1

    The RFID doesn't read the data on my card. what to do?
    I changed the RFID and it still doesn't work

  • @BoxappsEnginfx8935
    @BoxappsEnginfx8935 ปีที่แล้ว

    hi i have a system and will like to add this devices so that attendance can me marked from this devices.

  • @gloriasowanou8835
    @gloriasowanou8835 ปีที่แล้ว

    Thank you for the video I was able to redo it without worries, thank you again.
    My concern is the image "home ok ok png" how did you get it? Please answer me, I have to make a project on this before the end of the month

  • @faysaltaysir7503
    @faysaltaysir7503 ปีที่แล้ว

    you told about the URL
    but what is the URL?
    I am not finding

  • @dharshanvisu7686
    @dharshanvisu7686 7 หลายเดือนก่อน +1

    Http client begin declared with attribute error obsolute api use begin ( wifi client , url)

  • @siddarth9281
    @siddarth9281 ปีที่แล้ว

    how to access the url created?

  • @hannibal012
    @hannibal012 ปีที่แล้ว +1

    Thanks maaan ❤❤
    You saved my project

    • @hiteshmulwani701
      @hiteshmulwani701 3 หลายเดือนก่อน

      hey did you make this project , did it work properly ? if yes then can you tell me from where did you order the components from?

    • @lovelycuteshorts2944
      @lovelycuteshorts2944 2 หลายเดือนก่อน

      ​@@hiteshmulwani701I need your help bro please

    • @bhuvanv1658
      @bhuvanv1658 2 หลายเดือนก่อน

      @@hiteshmulwani701 hey same question here if you sucessfully completed the prject could you please help on how to read rfid on website

    • @hiteshmulwani701
      @hiteshmulwani701 2 หลายเดือนก่อน +1

      @@bhuvanv1658 yes I made the project, and it's working perfectly, we even hosted the website..., but there alot of mistakes in source code, so now I have all the new and working code. If you want it tell me, I will share

    • @bhuvanv1658
      @bhuvanv1658 2 หลายเดือนก่อน

      @@hiteshmulwani701 yes would be really great if youcould share it

  • @legitme5241
    @legitme5241 7 หลายเดือนก่อน +1

    Where can i find the source code

  • @justineferanil6887
    @justineferanil6887 ปีที่แล้ว

    Can i see the code on php ?

  • @tejaskadam31
    @tejaskadam31 2 หลายเดือนก่อน +1

    plzzz give us all code that u are use in this project arduino code php code ........!!!!

  • @somashekar5192
    @somashekar5192 9 หลายเดือนก่อน

    Sir is it possible to code the same project with the help of esp 32 module .Can anyone tell

  • @user-ih7zh7di3i
    @user-ih7zh7di3i 9 หลายเดือนก่อน

    Please am getting this error statement when i compiled. call to 'HTTPClient::begin' declared with attribute error:obsolete API, use ::begin (WiFiClient, url), please help me out.

  • @alvenjanolino9464
    @alvenjanolino9464 ปีที่แล้ว

    can you add a button to generate an excel file on the read tag id area ? below the output ? for the users log? please

  • @electronicmechanic2662
    @electronicmechanic2662 9 หลายเดือนก่อน

    where is attendance data ???????????????????????

  • @markprodz8786
    @markprodz8786 ปีที่แล้ว +2

    Arduino: 1.8.20 Hourly Build 2022/04/25 09:33 (Windows 10), Board: "NodeMCU 1.0 (ESP-12E Module), 80 MHz, Flash, Disabled (new aborts on oom), Disabled, All SSL ciphers (most compatible), 32KB cache + 32KB IRAM (balanced), Use pgm_read macros for IRAM/PROGMEM, 4MB (FS:2MB OTA:~1019KB), 2, v2 Lower Memory, Disabled, None, Only Sketch, 115200"
    C:\Users\ADMIN\Documents\Arduino\NodeMCU-and-RFID-RC522-IoT-Projects\NodeMCU-and-RFID-RC522-IoT-Projects.ino: In function 'void loop()':
    NodeMCU-and-RFID-RC522-IoT-Projects:103:15: error: call to 'HTTPClient::begin' declared with attribute error: obsolete API, use ::begin(WiFiClient, url)
    103 | http.begin("192.168.1.7/NodeMCU-and-RFID-RC522-IoT-Projects/getUID.php"); //Specify request destination
    | ~~~~~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    exit status 1
    call to 'HTTPClient::begin' declared with attribute error: obsolete API, use ::begin(WiFiClient, url)
    C:\Users\ADMIN\Documents\Arduino\NodeMCU-and-RFID-RC522-IoT-Projects\NodeMCU-and-RFID-RC522-IoT-Projects.ino: In function 'void loop()':
    NodeMCU-and-RFID-RC522-IoT-Projects:91:17: error: 'getid' was not declared in this scope
    91 | readsuccess = getid();
    | ^~~~~
    C:\Users\ADMIN\Documents\Arduino\NodeMCU-and-RFID-RC522-IoT-Projects\NodeMCU-and-RFID-RC522-IoT-Projects.ino: In function 'int getid()':
    NodeMCU-and-RFID-RC522-IoT-Projects:134:5: error: 'array_to_string' was not declared in this scope
    134 | array_to_string(readcard, 4, str);
    | ^~~~~~~~~~~~~~~
    exit status 1
    'getid' was not declared in this scope
    This report would have more information with
    "Show verbose output during compilation"
    option enabled in File -> Preferences.

  • @BoxappsEnginfx8935
    @BoxappsEnginfx8935 ปีที่แล้ว

    can you contact me so that we can look at it how we can archieve this

  • @user-rk5bq9bx5i
    @user-rk5bq9bx5i 8 หลายเดือนก่อน

    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