Professional attendance system using NodeMCU with a website and a Database.

แชร์
ฝัง
  • เผยแพร่เมื่อ 17 ต.ค. 2018
  • 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/InfinityWorldHI/No...
    In case you want to use Arduino with SIM800L instead of NodeMCU then use this code:
    github.com/InfinityWorldHI/RF...
    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.com/stable/pac...
    you can download the wampServer from this link:
    www.wampserver.com/en/#downloa...
    Or xampp server:
    www.apachefriends.org/downloa...
    **************************************
    If you want to buy the components:
    NodeMCU: www.gearbest.com/transmitters...
    RFID-RC522: www.gearbest.com/development-...
    **************************************
    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.
  • วิทยาศาสตร์และเทคโนโลยี

ความคิดเห็น • 1K

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

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

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

    We Respect and Love you don't stop helping peoples

  • @tesla-martin
    @tesla-martin 4 ปีที่แล้ว

    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

  • @robloxianfilipinocars
    @robloxianfilipinocars 2 ปีที่แล้ว

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

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

  • @enricorivera8650
    @enricorivera8650 4 ปีที่แล้ว

    SALAMAT PO NG MARAMI!!!!!!

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

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

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 ปีที่แล้ว

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

    • @imranraza1957
      @imranraza1957 4 ปีที่แล้ว

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

  • @sheravsingh9421
    @sheravsingh9421 5 ปีที่แล้ว

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

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

  • @raheels.1068
    @raheels.1068 5 ปีที่แล้ว

    Nice work.

  • @DjLight.
    @DjLight. 5 ปีที่แล้ว +1

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

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

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

    Thx works pretty well

  • @AKSHAY-kx3ln
    @AKSHAY-kx3ln 5 ปีที่แล้ว

    Thanks bro it worked for me

  • @Producthuntvideos
    @Producthuntvideos 5 ปีที่แล้ว

    Can u make a exemple RFID credits system.. to chagre credit and use it and also show what balance left on card.

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

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

    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?

  • @sheravsingh9421
    @sheravsingh9421 5 ปีที่แล้ว

    best

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

    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😊

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

  • @pradnyaparhar5643
    @pradnyaparhar5643 4 ปีที่แล้ว +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.

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

  • @calvinmhongwe2169
    @calvinmhongwe2169 2 ปีที่แล้ว

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

  • @christianmaroy8889
    @christianmaroy8889 2 ปีที่แล้ว

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

  • @reneruiz5
    @reneruiz5 5 ปีที่แล้ว

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

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

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

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

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

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

  • @saisreevatsa2813
    @saisreevatsa2813 4 ปีที่แล้ว

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

  • @Know-Tree
    @Know-Tree 3 ปีที่แล้ว

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

  • @rishirajbhagwat9016
    @rishirajbhagwat9016 2 ปีที่แล้ว

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

  • @adityakamath6999
    @adityakamath6999 4 ปีที่แล้ว

    Hey, great video! What changes must I make if I want this system to work for an already existing database? What I mean is, I have an already existing database and I want the logs and users tables to be added to it and I want the system to work for this already existing database. What changes in code must I make to do this?

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 ปีที่แล้ว

      Hi,
      Create the tables inside the existence Database than replace the database credentials in connectDB.php with yours.

  • @johnnycharlene1743
    @johnnycharlene1743 4 ปีที่แล้ว

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

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

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

    @ElectronicsTechHals how should we install plx-daq

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

  • @armenmkrtchyan5552
    @armenmkrtchyan5552 5 ปีที่แล้ว

    Thank you very much, it is very usful. Please tell, me it is possible to connect to this project for example M590 Neoway GSM/GPRS module and connect to the server on cloud via GPRS. If there is like this project you please let me to see it. Thanks

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 ปีที่แล้ว

      You're welcome. yes, it's possible. If you want more information you can contact me through my E-mail or my facebook page.

  • @HimanshuKumar-tc5nw
    @HimanshuKumar-tc5nw 2 หลายเดือนก่อน

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

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

  • @irfanseptiansuherman1828
    @irfanseptiansuherman1828 5 ปีที่แล้ว

    Thank you for the video, can you help me? I want to modify it by adding a relay, what program is used?

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 ปีที่แล้ว

      You're Welcome.
      you can add the relay into this condition if you want it to turn on while login.
      if(response == "login")

    • @irfanseptiansuherman1828
      @irfanseptiansuherman1828 5 ปีที่แล้ว

      @@ElectronicsTechHaIs Thanks sir.
      How if the rfid card number on addcard.php is refreshed automatically (only the no card part is not all pages).

  • @revanthmogalluri3272
    @revanthmogalluri3272 4 ปีที่แล้ว

    sir how to do these project with esp32 module .could you please help me

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

    Thank you so much for the amazing projects that you share.
    but I have a question about the nodeMCU IP because it's changing every time I restart it. So how can I fix this problem?
    I don't prefer changing the nodeMCU IP in the config file of the wampserver every time.
    Thanks.

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 ปีที่แล้ว

      You're welcome.
      open the code and put these line into it:
      // config static IP
      //IPAddress ip(192, 168, xx, xx); // where xx is the desired IP Address for the nodeMCU
      //IPAddress gateway(192, 168, xx, xx); // set gateway to match your network
      //IPAddress subnet(255, 255, 255, 0); // set subnet mask to match your network
      in setup() section:
      // Static IP Setup Info
      //WiFi.config(ip, gateway, subnet);
      WiFi.begin(SSID, password);//connect to the wifi

    • @pcibra5401
      @pcibra5401 5 ปีที่แล้ว

      @@ElectronicsTechHaIs
      Thank you so much, I did as you said and everything went well.
      Keep it up.

  • @mohammedomar8593
    @mohammedomar8593 5 ปีที่แล้ว

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

  • @ochirerdenechoijilsuren4572
    @ochirerdenechoijilsuren4572 5 ปีที่แล้ว

    WampServer download link doesn't work in my computer. Help me

  • @kishorerabha8920
    @kishorerabha8920 5 ปีที่แล้ว

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

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

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

    Mysqli_num_row expert parameter 1 to be mysqli result.
    This show on add user page what to do

  • @bitolcance2011
    @bitolcance2011 4 ปีที่แล้ว

    Hi there, at first thank you for this wonderful video !
    I was wondering is there any way to make this works on a web server, not on a local wamp or xamp.
    Thanks

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

      Hi, Glad you liked it,
      Of course, you can use a public webserver, you just need to put the webserver domain name instead of the computer IP(Local Sever).

    • @bitolcance2011
      @bitolcance2011 4 ปีที่แล้ว

      @@ElectronicsTechHaIs Thank you for your answer but i have a weird situation constantly getting -1 with the card ID I've checked many times the server IP address is correct (I've tried with numbers IP and the name of the web server same situation) ...any idea..Best regards

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 ปีที่แล้ว

      Are you using Local server or public server?

    • @bitolcance2011
      @bitolcance2011 4 ปีที่แล้ว

      @@ElectronicsTechHaIs At first sorry for my late reply, I'm using public server

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 ปีที่แล้ว

      First, check if the domain name is correct.
      Did you put the website files directly inside your public directory?
      Second, Does your public server use HTTPS or HTTP?

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

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

  • @henrycedeno9315
    @henrycedeno9315 4 ปีที่แล้ว

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

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 ปีที่แล้ว

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

  • @muzaazira2459
    @muzaazira2459 3 ปีที่แล้ว

    Very good! Since you using a personal localhost, how can i apply this into a localhost phpmyadmin with xampp server?

    • @christianmaroy8889
      @christianmaroy8889 3 ปีที่แล้ว

      it now working
      proper sir thank so i wanted to know if it's posible to change the website background

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  3 ปีที่แล้ว

      Check the header.css file for the styling.

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  3 ปีที่แล้ว

      Just copy the website files into "htdocs" folder

  • @meenalsharma2492
    @meenalsharma2492 4 ปีที่แล้ว

    Could you please tell us the LED connections with RFID and the Node MCU

  • @Digitallife-tv
    @Digitallife-tv 4 ปีที่แล้ว

    it's working perfectly for me ,thank you very much.
    only problem its only taking one time login/logout per day, what to do if we need multiple logins/logouts per day?

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 ปีที่แล้ว

      Good to hear that, Leave your email and I will send you the modified page.

    • @Digitallife-tv
      @Digitallife-tv 4 ปีที่แล้ว

      @@ElectronicsTechHaIs Thx .my email is: emmymartella@gmail.com

    • @Digitallife-tv
      @Digitallife-tv 4 ปีที่แล้ว

      hy am still waiting ur reply

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

      I've sent it.

    • @ardhakurniawan818
      @ardhakurniawan818 4 ปีที่แล้ว

      @@ElectronicsTechHaIs Sir can you send the modified code for me too ? Thanks before
      email :tekomasik54@gmail.com

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

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

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

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

  • @suvadipsamanta7654
    @suvadipsamanta7654 4 ปีที่แล้ว

    Thanks for the video, Can you please help me out , how I connect 0.96 oled i2c with this project . To show who's card is swiped and give a small greeting on oled.

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

      You're welcome, You need to remove the two LEDs and connect the OLED display instead of them, then download the Adfruit library for OLED and modify the code as you want.

    • @suvadipsamanta7654
      @suvadipsamanta7654 4 ปีที่แล้ว

      Thank You 😊 Electronic Tech
      Do you have any code , like you use in your biometric attendance project

    • @suvadipsamanta7654
      @suvadipsamanta7654 4 ปีที่แล้ว

      I tried with oled but it facing some issue , can you please help me out

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 ปีที่แล้ว

      @@suvadipsamanta7654 Send me the code that you are working on.

    • @suvadipsamanta7654
      @suvadipsamanta7654 4 ปีที่แล้ว

      @@ElectronicsTechHaIs I send this to fb messenger

  • @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");

  • @alextan8609
    @alextan8609 4 ปีที่แล้ว

    Hi Sir, Thank you very much for sharing.This is a powerful project. I am new learner and just wonder that how can we add multiple logins/logouts per day?

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

      Hi,
      Leave your email and I send it to you.

    • @alextan8609
      @alextan8609 4 ปีที่แล้ว

      My email: alexttan@yahoo.com Thank you very much.

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

      I've sent it.

    • @fritzgeraldodena7391
      @fritzgeraldodena7391 4 ปีที่แล้ว

      @@ElectronicsTechHaIs sir good pm can i have also the method on adding multiple logins/logout per day?
      email: ftmclone@gmail.com
      thank you sir for the great project.

    • @MoreGanesh
      @MoreGanesh 4 ปีที่แล้ว

      Electronics Tech how to add multiple logins and logouts times per day? Could you please forward me code for the same?
      Email: moreganesh804@gmail.com

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

  • @vasanthvasee9206
    @vasanthvasee9206 4 ปีที่แล้ว

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

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 ปีที่แล้ว

      Just put the domain name of your website instead of the IP.

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

  • @syahri1998
    @syahri1998 5 ปีที่แล้ว

    Hi, Nice Project sir,
    I;m still learn, and i want ask some question
    is it possible to connect NodeMCU+RFID with Arduino+2x16 LCD?

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 ปีที่แล้ว

      Actually, Using OLED display instead of LCD is more efficient and it might the LCD doesn't work with NodeMCU correctly.

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

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

  • @definitelynotjin
    @definitelynotjin 2 ปีที่แล้ว

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

  • @vasanthvasee9206
    @vasanthvasee9206 4 ปีที่แล้ว

    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  4 ปีที่แล้ว

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

  • @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];
      } "

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

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

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

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

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 ปีที่แล้ว

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

  • @rezckyseptian1549
    @rezckyseptian1549 4 ปีที่แล้ว

    Thanks for this video .. i have a project that I have to create attendance system using database..and i solved it from this video. Thanks a lot for this.. but i have any questions.. can i change the background of the web?
    Or the tittle of th site?

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  4 ปีที่แล้ว

      You're welcome.
      Of course, you can modified as you want.

    • @douglasvitor7453
      @douglasvitor7453 4 ปีที่แล้ว

      @@ElectronicsTechHaIs how does the background change?

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

      From Style: background-image

    • @rezckyseptian1549
      @rezckyseptian1549 4 ปีที่แล้ว

      @@ElectronicsTechHaIs thanks.. now the background has changed

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

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

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

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

  • @nathanielluke2084
    @nathanielluke2084 4 ปีที่แล้ว

    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  4 ปีที่แล้ว

      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 4 ปีที่แล้ว

      @@ElectronicsTechHaIs wow thanks haha

  • @ainamir4231
    @ainamir4231 3 ปีที่แล้ว

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

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

  • @zeeshansyed8195
    @zeeshansyed8195 3 ปีที่แล้ว

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

  • @AbhishekSingh-wr7bm
    @AbhishekSingh-wr7bm 3 ปีที่แล้ว

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

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  3 ปีที่แล้ว

      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.

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

  • @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 ปีที่แล้ว

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

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

  • @houssamaldeen
    @houssamaldeen 5 ปีที่แล้ว

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

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 ปีที่แล้ว

      Date is date type, time in and time out is time type.

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

    When scanning card no output seen on serial monitor

  • @therisingedge755
    @therisingedge755 4 ปีที่แล้ว

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

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

    timed out for packet error it says in arduino

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

  • @pavitraelasha8424
    @pavitraelasha8424 5 ปีที่แล้ว

    deos the esp8266 library works well on arduino mega2560?

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

      No, doesn't work, ESP8266 has his own libraries because his chip is different from the Arduino chip.

    • @pavitraelasha8424
      @pavitraelasha8424 5 ปีที่แล้ว

      Thank you so much sir

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

  • @miso1585
    @miso1585 5 ปีที่แล้ว

    Hi friend, thank you for your super project!
    Everything works fine, but the system has 1 error - when I scan my card a second time, TimeOut is written. When I attach it again, the TimeOut time is updated again.
    Is it possible to disable TimeOut time update? Thank you !

    • @ElectronicsTechHaIs
      @ElectronicsTechHaIs  5 ปีที่แล้ว

      Hello, You're welcome. Of course, you can do that.
      I will send you the file if you want it just leave your E-mail.

  • @fakhrulfauzan7155
    @fakhrulfauzan7155 4 ปีที่แล้ว +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  4 ปีที่แล้ว

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

    • @itsiam3839
      @itsiam3839 2 ปีที่แล้ว

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

  • @syaifulwatoni3993
    @syaifulwatoni3993 5 ปีที่แล้ว

    How about control relay? I've tried but not work, thank you..

  • @josegabrieladriangarcia6817
    @josegabrieladriangarcia6817 4 ปีที่แล้ว

    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  4 ปีที่แล้ว

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

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

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

  • @brettweaver9942
    @brettweaver9942 4 ปีที่แล้ว

    Does anyone know if there is a way to put all the information in an excel spreadsheet without having the rfid scanner connected into the computer..is there anyway to upload the data on to an SD card then transfer it from the card into an excel spreadsheet

    • @brettweaver9942
      @brettweaver9942 4 ปีที่แล้ว

      That way I could have the scanner as it’s own separate unit

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

      Here you don't have to connect the NodeMCU to computer just power it up by 5v then put it wherever you want, all the data will be sent to the website.
      You can export the log to an excel spreadsheet from user log very simple.

    • @brettweaver9942
      @brettweaver9942 4 ปีที่แล้ว

      Electronics Tech Thank you for the help. I’m still very new to this and trying to figure it all out.