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.

КОМЕНТАРІ • 1 тис.

  • @ElectronicsTechHaIs
    @ElectronicsTechHaIs  5 років тому +21

    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...

    • @TjSPB11
      @TjSPB11 5 років тому

      Hey there mate! Any news yet? Thanks

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      Every update will be available after the new year.

    • @pcibra5401
      @pcibra5401 5 років тому +1

      @@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.

    • @muharifandi550
      @muharifandi550 5 років тому

      can you send cicruit diagram?

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      @@muharifandi550
      The diagram is included with the code:
      bit.ly/RFIDnodeMCUv2code

  • @diygenix3192
    @diygenix3192 3 роки тому +1

    We Respect and Love you don't stop helping peoples

  • @yh1811
    @yh1811 5 років тому +3

    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

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому +1

      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.

  • @rarenu
    @rarenu 4 роки тому +2

    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.

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 роки тому

      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.

  • @muhammadtalha5885
    @muhammadtalha5885 5 років тому +1

    Thank you for your time and support.............
    It's fully working now

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      You're welcome any time.
      thanks for your feedback, I appreciate that.

    • @imranraza1957
      @imranraza1957 5 років тому

      bro can you help me...The card id(before name) is not showing when addcard.php is accessed

  • @tesla-martin
    @tesla-martin 5 років тому

    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

  • @vitorchicano3953
    @vitorchicano3953 4 роки тому +2

    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?

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 роки тому

      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

  • @shivasagarram7564
    @shivasagarram7564 4 роки тому

    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.

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 роки тому

      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?

  • @freddylopez2839
    @freddylopez2839 4 роки тому +2

    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

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 роки тому

      Hi,
      Have you followed my instructions in the video description?

  • @sheravsingh9421
    @sheravsingh9421 5 років тому

    I have learnt so much from you thank you and keep up the good work

  • @rhbsanj5alb464
    @rhbsanj5alb464 5 років тому +2

    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.

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому +2

      You're welcome.
      I'm glad it was useful.

    • @kishorerabha8920
      @kishorerabha8920 5 років тому +1

      how did you make it work?

    • @rhbsanj5alb464
      @rhbsanj5alb464 5 років тому +1

      @@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.

  • @gurmithsingh5402
    @gurmithsingh5402 4 роки тому +2

    Thx works pretty well

  • @douglasvitordejesus1567
    @douglasvitordejesus1567 4 роки тому +2

    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

  • @DjLight.
    @DjLight. 5 років тому +1

    Sir this is awsome project i loved it this is really awsome 😃

  • @chimpei3965
    @chimpei3965 2 роки тому

    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?

  • @pradnyaparhar5643
    @pradnyaparhar5643 5 років тому +2

    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.

  • @wicaksono2865
    @wicaksono2865 4 роки тому +2

    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 :)

    • @wicaksono2865
      @wicaksono2865 4 роки тому

      sorry I read a few comments below. but I can't understand how to deal with it

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 роки тому

      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.

    • @wicaksono2865
      @wicaksono2865 4 роки тому

      @@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

  • @itsiam3839
    @itsiam3839 2 роки тому +2

    The localhost loginsystem page doesn't have a CardID field. Scan the card and it doesn't show up. Please help me.Thanks

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  2 роки тому

      Make sure that you're able to access the website from your mobile browser by typing the computer IP address

    • @itsiam3839
      @itsiam3839 2 роки тому

      @@ElectronicsTechHaIs Thank you.

    • @ranahussnain8376
      @ranahussnain8376 2 роки тому

      @@itsiam3839 Hey Siam, I am facing the same problem, can you tell me how you overcome it. Please

  • @tuyenvothibich9796
    @tuyenvothibich9796 3 роки тому +2

    i scan the card but it don't appear the ID, help me!

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  3 роки тому

      Make sure your computer is accessible from other devices on the same network.

  • @robloxianfilipinocsgcars
    @robloxianfilipinocsgcars 2 роки тому

    I will try this project. This is a very good one.

  • @filipirodrigues2421
    @filipirodrigues2421 4 роки тому +1

    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!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 роки тому +1

      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

    • @sudheer7312
      @sudheer7312 4 роки тому

      @@ElectronicsTechHaIs how and where to create and import manually

    • @sudheer7312
      @sudheer7312 4 роки тому

      @@ElectronicsTechHaIs what to do after importing?

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 роки тому

      Continue the steps after install.php step.

  • @shivasagarram7564
    @shivasagarram7564 4 роки тому +2

    timed out for packet error it says in arduino

  • @AswinYanuarPTMASWINDOBUMIMAS
    @AswinYanuarPTMASWINDOBUMIMAS 5 років тому

    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

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      Send more information about it on my Email.

    • @AswinYanuarPTMASWINDOBUMIMAS
      @AswinYanuarPTMASWINDOBUMIMAS 5 років тому

      @@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"

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      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.

  • @Digitallife-tv
    @Digitallife-tv Рік тому +1

    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

  • @Know-Tree
    @Know-Tree 3 роки тому +1

    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

  • @therisingedge755
    @therisingedge755 5 років тому +1

    My leds aren't glowing while doing entry log what should i do??

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      I've fixed that, Check the my GitHub link for the new update, thanks.

  • @dertester1
    @dertester1 5 років тому +1

    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.

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      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

  • @ariarahmadfadillah6846
    @ariarahmadfadillah6846 4 роки тому +2

    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 :)

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 роки тому +1

      As much as you want,
      Then you need to host the website on a host service like 000webhost.

    • @ariarahmadfadillah6846
      @ariarahmadfadillah6846 4 роки тому

      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

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 роки тому +1

      Go to phpmyadmin and delete the log.

  • @yasser518ksa
    @yasser518ksa 4 роки тому +1

    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

  • @MoreGanesh
    @MoreGanesh 4 роки тому +2

    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.

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 роки тому +1

      Have you followed my instructions in the video description?

    • @MoreGanesh
      @MoreGanesh 4 роки тому

      @@ElectronicsTechHaIs yeah

    • @MoreGanesh
      @MoreGanesh 4 роки тому

      @@ElectronicsTechHaIs can you tell me what must be the problem?

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 роки тому +1

      Your local server and its port.
      the WiFi network.
      The omputer IP in the nodeMCU code.

    • @MoreGanesh
      @MoreGanesh 4 роки тому

      @@ElectronicsTechHaIs I have configured everything as per the video description

  • @clovekhacker4154
    @clovekhacker4154 2 роки тому

    Hello. I saw that you added time in and time out but i dont know which program for arduino is right. Or its new?

  • @mohnizar28
    @mohnizar28 5 років тому

    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

  • @LowkeyLife1010
    @LowkeyLife1010 5 років тому +1

    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!!

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      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.

    • @LowkeyLife1010
      @LowkeyLife1010 5 років тому

      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.

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      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.

  • @saisreevatsa2813
    @saisreevatsa2813 4 роки тому

    Why the RFID is not displayed on serial monitor of arduino ide?
    And I am having problem with phpmyadmin login

  • @reneruiz5
    @reneruiz5 5 років тому

    Is it possible to make this with Arduino UNO and send the data through a GSM SIM800L module??

  • @parthasarathys6434
    @parthasarathys6434 3 роки тому

    sir in your code its "post data" and in the code provided its get data will this make a change in the overall running?

  • @Digitallife-tv
    @Digitallife-tv Рік тому

    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

  • @k_orsd
    @k_orsd 4 роки тому +1

    How to validate if the card that is reading the RFID is registered in database?

  • @calvinmhongwe2169
    @calvinmhongwe2169 3 роки тому

    so if you use does it work if you use your pc hotspot to connect to the NodeMCU?

  • @pavitraelasha8424
    @pavitraelasha8424 5 років тому

    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???

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      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

  • @fakhrulfauzan7155
    @fakhrulfauzan7155 5 років тому +1

    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..

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      Hi, leave your email to send you the modified file.

    • @itsiam3839
      @itsiam3839 2 роки тому

      @@ElectronicsTechHaIs Can you please send me the file? Thanks.

  • @jmrtsl2890
    @jmrtsl2890 3 роки тому +2

    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

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  3 роки тому

      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?

    • @jmrtsl2890
      @jmrtsl2890 3 роки тому

      @@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?

    • @amannegi8256
      @amannegi8256 3 роки тому

      did you find solution to this

    • @amannegi8256
      @amannegi8256 3 роки тому

      @@ElectronicsTechHaIs sir please solution to this problem iamalso facing same issue

    • @malinthiperera4198
      @malinthiperera4198 3 роки тому

      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

  • @konstantinosperakis8319
    @konstantinosperakis8319 5 років тому +1

    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

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      thanks for your notice, I will upgrade the website and it will be available next Sunday.
      I'm going to fix these bugs.

  • @sivanvithamuralimohan7628
    @sivanvithamuralimohan7628 2 роки тому

    Can u tell me how can I use our university I'd cards for scanning instead of RFID cards??

  • @christianmaroy8889
    @christianmaroy8889 3 роки тому

    hello sir i wanted to know if it posible to make this project with an ethernet shield also

  • @carryadityanugroho8133
    @carryadityanugroho8133 5 років тому

    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

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      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.

  • @ProGamer6470
    @ProGamer6470 5 років тому

    how can i change the look of the server? like the background img i tried to replace it but it dosnt change

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому +1

      You should change it here: background-image:url("image/2.jpg");

  • @pangeranaritonang185
    @pangeranaritonang185 4 роки тому

    I have a problem. There " hard bersetting via rts pin" . Can you help me about this problem?

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 роки тому

      Try to press the flash button on the board when you see "connecting....."

  • @HimanshuKumar-tc5nw
    @HimanshuKumar-tc5nw 7 місяців тому

    What to do if we want to demonstrate it using mobile hotspot

  • @user-in6kp9zw8c
    @user-in6kp9zw8c 5 років тому

    if i want to put a buzzer on board and Beep. when RFID tag touch to RFID reader. How to do this

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому +1

      You just need to put the buzzer after "
      for (byte i = 0; i < mfrc522.uid.size; i++) {
      CardID += mfrc522.uid.uidByte[i];
      } "

  • @janmelisek2945
    @janmelisek2945 5 років тому

    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

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      As many cards you want because everything will be stored in a database, not on the nodeMCU.

  • @johnnycharlene1743
    @johnnycharlene1743 4 роки тому

    Hi how do you do this with a ethernet shield i do not have a esp8266

  • @houssamaldeen
    @houssamaldeen 5 років тому

    can you please help me what is the type of " date , time in , time out " in the database?

  • @enricorivera8650
    @enricorivera8650 5 років тому

    SALAMAT PO NG MARAMI!!!!!!

  • @sadiaafrin3258
    @sadiaafrin3258 Рік тому

    I am facing a problem, data is not entering to user log, could you please give me a solution ? It's urgent for me

  • @hamzaalzaaim7424
    @hamzaalzaaim7424 5 років тому

    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

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      I see, Could you send me more information on how you done it? or Have you used my code?

  • @zeeshansyed8195
    @zeeshansyed8195 3 роки тому

    How do I change the website Title to 'XYZ University Attendance portal' instead of 'RFID auto recorder' ?

  • @kishorerabha8920
    @kishorerabha8920 5 років тому

    Hi i'm using lamp on ubuntu. How do i configure httpd.conf? Pleas help asap

  • @shaileshkumarbhadani5688
    @shaileshkumarbhadani5688 5 років тому

    whenever i will try to upload nodemcu code in board at that time i receive this error 'SPI' was not declared in this scope

  • @rahmat2843
    @rahmat2843 2 роки тому +1

    Hello, how do we add multiple arrival time and leave time.

  • @hakancirit4730
    @hakancirit4730 4 роки тому

    Hi,
    Can 2X16 LCD IC2 be connected to your project?
    can you help with this.

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 роки тому

      Hi, Yes you can.
      connect the I2C LCD pins instead of the LEDs pins.

  • @adrian10anm10
    @adrian10anm10 5 років тому +2

    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

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      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.

    • @nurulain8577
      @nurulain8577 5 років тому

      may i know how do you enter the coding at first because i cannot do that

    • @syedmuhammadumer4693
      @syedmuhammadumer4693 5 років тому +1

      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

    • @syedmuhammadumer4693
      @syedmuhammadumer4693 5 років тому

      @@ElectronicsTechHaIs but after following all of your steps, the CardID doesn't appear on AddCard.php page! PLease let me know :))

    • @i.m.shubhamkr
      @i.m.shubhamkr 5 років тому

      @@syedmuhammadumer4693 thanks bro❤️ it works

  • @brahhhhh1296
    @brahhhhh1296 5 років тому

    can i do it with the webpage without the nodemcu ? just using the arduino uno and rfid

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      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.

  • @loppert123
    @loppert123 5 років тому

    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.

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      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.

  • @mohammedomar8593
    @mohammedomar8593 5 років тому

    My wifi cannot connect to the server ,,,what is the problem
    It shows for example abcd is connecting ......................
    ......

  • @addilalatif4410
    @addilalatif4410 5 років тому

    Hello, have you tried doing RFID with Wifi Shield Cytron? Do you have any idea on how to combine both source code?

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому +1

      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.

  • @vasanthvasee9206
    @vasanthvasee9206 5 років тому

    I have an plan to host this in an cloud server but how to do that and deal with Ip address n stuff??

  • @HiAMDAnZiele
    @HiAMDAnZiele 4 роки тому

    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 ?

  • @sharilazri5970
    @sharilazri5970 5 років тому +1

    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.

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      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.

    • @sharilazri5970
      @sharilazri5970 5 років тому

      so in this case is it possible because i dont have xampp??

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      Yes it's possible, however, xampp is a bit easier

    • @sharilazri5970
      @sharilazri5970 5 років тому

      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!

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      send some screenshots to my facebook page or my email.

  • @illogicalthings1511
    @illogicalthings1511 3 роки тому

    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

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  3 роки тому

      Try to turn off the firewall and later try another WiFi network.

  • @charantiruvuri8545
    @charantiruvuri8545 5 років тому

    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.

  • @himanshusaroj5390
    @himanshusaroj5390 5 років тому

    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...

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      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.

  • @rishirajbhagwat9016
    @rishirajbhagwat9016 2 роки тому

    How can I set up multiple log in and log out for a single id

  • @josegabrieladriangarcia6817
    @josegabrieladriangarcia6817 5 років тому

    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

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      Hi, It should work, if you made the right modification on the code.

  • @rabiatuladawiyah7299
    @rabiatuladawiyah7299 Рік тому

    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

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  Рік тому

      Yes, you just need to give the device(reader) permission to access location and it will work

  • @therisingedge755
    @therisingedge755 5 років тому

    cant find the changes you made in wamp server please help meeout regarding this

  • @nwbstplyr
    @nwbstplyr 2 роки тому

    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 ☺☺

  • @nurulain8577
    @nurulain8577 5 років тому

    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

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      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.

  • @Producthuntvideos
    @Producthuntvideos 5 років тому

    Can you please share me your httpd.config file i tried every thing it shows only -1 and error 403 forbidden .Need help!

  • @ashutosshguptaa6697
    @ashutosshguptaa6697 5 років тому

    I have issue of
    It shows after uploading
    Leaving
    Hard restting via RTS pin....
    Plz help uh

  • @ainamir4231
    @ainamir4231 3 роки тому

    can I know what kind of type NodeMCU that you use?? Is that NodeMCU V2 or NodeMCU V3??

  • @Know-Tree
    @Know-Tree 3 роки тому

    Master, how can add second shift time in same data base ?

  • @vasanthvasee9206
    @vasanthvasee9206 5 років тому

    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!!

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      Hi, you just need to copy the website files into xampp/htdocs folder without editing any file.

  • @AbhishekSingh-wr7bm
    @AbhishekSingh-wr7bm 4 роки тому

    Sir we switch off at daily night after worktime so, it will save last recording or not?

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 роки тому

      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.

  • @poulamimajumder3395
    @poulamimajumder3395 4 роки тому

    Sir I want to apply machine learning on the obtained exel file can you suggest me the algorithm I could use .

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 роки тому

      If you want it on the website side then you can use either MobileNets or using python.

  • @henrycedeno9315
    @henrycedeno9315 5 років тому

    oh great teacher there is no problem if I do it with the module
    esp32 ?

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      Thanks,
      Yes, you can use ESP32, but the diagram is a bit different.

  • @nathanielluke2084
    @nathanielluke2084 5 років тому

    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

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      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"

    • @nathanielluke2084
      @nathanielluke2084 5 років тому

      @@ElectronicsTechHaIs wow thanks haha

  • @definitelynotjin
    @definitelynotjin 3 роки тому

    can i use firebase as my server? or is it exclusively xampp and wampserver?

  • @fahedkhalil9815
    @fahedkhalil9815 5 років тому

    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?

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      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.

    • @MoreGanesh
      @MoreGanesh 4 роки тому

      Yeah the card id doesn't show up on webpage nor on the serial monitor

  • @ventyc91
    @ventyc91 4 роки тому

    Hello, i use xampp and i wanna know where should i put the IP in httpd.conf ?. Thank you

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 роки тому

      Hi, you don't need to modify that file while using xampp.

    • @ventyc91
      @ventyc91 4 роки тому

      @@ElectronicsTechHaIs ohhh okay. Thanks for responding my comment. Have a nice day!

  • @tareqkhedr8410
    @tareqkhedr8410 4 роки тому

    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 ?

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 роки тому

      Hi, open your Arduino IDE then from file go to preferences then insert the ESP link into the custom link box.

  • @AKSHAY-kx3ln
    @AKSHAY-kx3ln 5 років тому

    Thanks bro it worked for me

  • @freddiebatson113
    @freddiebatson113 4 роки тому

    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.

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 роки тому

      Hello,
      Make sure that the connectDB page has the right phpmyadmin credentials.

    • @freddiebatson113
      @freddiebatson113 4 роки тому

      @@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?

  • @Ganesh010598
    @Ganesh010598 3 роки тому

    Hi sir..I am having some problem in reading the rfid card.. Can you help me sir?

  • @user-dt6zq7oi9z
    @user-dt6zq7oi9z 5 років тому

    Hi , Thank a lot ... This is work very fine.

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      Hi, Good to hear that, My pleasure.

    • @user-dt6zq7oi9z
      @user-dt6zq7oi9z 5 років тому

      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...

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 років тому

      Oh, I see, yes you can make that. Leave your email and I will send you the modified page.

    • @user-dt6zq7oi9z
      @user-dt6zq7oi9z 5 років тому

      @@ElectronicsTechHaIs yasehbahari@gmail.com ,, thank you.

  • @chengupark1725
    @chengupark1725 4 роки тому

    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

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 роки тому

      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.

  • @lahirunimeshka7383
    @lahirunimeshka7383 4 роки тому

    Sir, add user procedure is working correctly. But attendance system is not working. please help me to solve this

  • @muzakkari
    @muzakkari 3 роки тому

    I want to use this with UNO and NANO boards, how do I go about it?

  • @douglasvitor7453
    @douglasvitor7453 4 роки тому

    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.

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 роки тому

      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?

    • @douglasvitordejesus1567
      @douglasvitordejesus1567 4 роки тому

      @@ElectronicsTechHaIs I'm using wamp. I think my computer supports it, but if it doesn't accept what should I do?

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 роки тому

      Try xampp server.
      and test if you can access the website via the PC IP from your mobile browser.

  • @gwynapoli8627
    @gwynapoli8627 2 роки тому

    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😊