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

Поделиться
HTML-код
  • Опубликовано: 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.
  • НаукаНаука

Комментарии • 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

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

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

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

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

  • @sheravsingh9421
    @sheravsingh9421 5 лет назад

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

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

  • @robloxianfilipinocsgcars
    @robloxianfilipinocsgcars 2 года назад

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

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

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

  • @DjLight.
    @DjLight. 5 лет назад +1

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

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

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

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

  • @reneruiz5
    @reneruiz5 5 лет назад

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

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

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

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

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

  • @calvinmhongwe2169
    @calvinmhongwe2169 2 года назад

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

  • @gurmithsingh5402
    @gurmithsingh5402 4 года назад +2

    Thx works pretty well

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

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

  • @saisreevatsa2813
    @saisreevatsa2813 4 года назад

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

  • @enricorivera8650
    @enricorivera8650 4 года назад

    SALAMAT PO NG MARAMI!!!!!!

  • @christianmaroy8889
    @christianmaroy8889 3 года назад

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

  • @rishirajbhagwat9016
    @rishirajbhagwat9016 2 года назад

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

  • @johnnycharlene1743
    @johnnycharlene1743 4 года назад

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

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

  • @Know-Tree
    @Know-Tree 3 года назад

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

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

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

  • @AKSHAY-kx3ln
    @AKSHAY-kx3ln 5 лет назад

    Thanks bro it worked for me

  • @HimanshuKumar-tc5nw
    @HimanshuKumar-tc5nw 5 месяцев назад

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

  • @raheels.1068
    @raheels.1068 5 лет назад

    Nice work.

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

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

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

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

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

  • @ochirerdenechoijilsuren4572
    @ochirerdenechoijilsuren4572 5 лет назад

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

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

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

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

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

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

  • @revanthmogalluri3272
    @revanthmogalluri3272 5 лет назад

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

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

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

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

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

  • @dassajityadav5555
    @dassajityadav5555 Год назад

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

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

  • @houssamaldeen
    @houssamaldeen 5 лет назад

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

  • @meenalsharma2492
    @meenalsharma2492 4 года назад

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

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

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

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

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

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

  • @Cris_orsd
    @Cris_orsd 3 года назад +1

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

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

  • @user-ke3yk4zp9z
    @user-ke3yk4zp9z 4 месяца назад

    @ElectronicsTechHals how should we install plx-daq

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

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

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

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

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

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

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

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

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

  • @charantiruvuri8545
    @charantiruvuri8545 4 года назад

    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.

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

  • @mohammedomar8593
    @mohammedomar8593 5 лет назад

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

  • @rahmat2843
    @rahmat2843 2 года назад +1

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

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

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

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

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

  • @ainamir4231
    @ainamir4231 3 года назад

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

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

  • @therisingedge755
    @therisingedge755 4 года назад

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

  • @definitelynotjin
    @definitelynotjin 3 года назад

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

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

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

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

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

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

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

  • @ashutosshguptaa6697
    @ashutosshguptaa6697 4 года назад

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

  • @syaifulwatoni3993
    @syaifulwatoni3993 5 лет назад

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

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

  • @muzakkari
    @muzakkari 3 года назад

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

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

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