Introduction: Wireless Attendance System Using Wi-Fi (ESP8266)with MySQL

Picture of Wireless Attendance System Using Wi-Fi (ESP8266)with MySQL

We Start our Project with RFID RC522 and Node MCU( Wi-Fi Module)

Step 1: Introduction to Our Project

Picture of Introduction to Our Project

Here We are going to connect Node MCU ESP8266 and RFID- RC522 with MYSQL Database. So for that first we should connect our Node MCU ESP8266 Board with RFID Module. By using the RFID Module we are going to scan our RFID card and tag which are allow or not. And by using our ESP8266 we are going to send that data to our MYSQL Database which is connect through a php page.

In this case we are using php script as well. From arduino code we are making a get request to our php page. Make sure that php page you have to put inside /var/www/html.

Step 2: Installation of All Software

Picture of Installation of All Software

a) Installation of LAMP Server and PHPMYADMIN:

First of all let us clear one thing that we are using LAMP Server for this project. In case if you don't know what is LAMP, it is an abbreviation of Linux, Apache, MySQL and PHP. So if you have windows or may be MAC then you have to install WAMP and MAMP respectively.

So what we are explaining that is only for LAMP server:

and here are the steps for installing LAMP server

1. Install Apache

sudo apt-get install apache2

2. Install MySQL:

sudo apt-get install mysql-server

3. Install PHP:

sudo apt-get install php5 libapache2-mod-php5

4. Restart Server:

sudo /etc/init.d/apache2 restart

5. Check Apache

http://localhost/

if you install these steps successfully then you will get the apche page like the image above

Here we are using PHPMYADMIN that is the web interface of MySQL so for that you have to install that also

and the command for that is:

sudo apt-get install phpmyadmin

b) Installation of Arduino IDE: You can download the latest Arduino IDE from this link:

https://www.arduino.cc/en/Main/Software

Step 3: How to Used NodeMCU in Arduino IDE

Picture of How to Used NodeMCU in Arduino IDE

Step1:

Firstly open the Arduino IDE.

Step2:

Go to the File then click on preferences tab like Figure 1.

Now you have to copy in the additional board manager URL-

http://arduino.esp8266.com/stable/package_esp8266c...

then click ok

Step 3:

Now go to the Tools then select Board Manager. open window like figure 2. Just Scroll down on that window and search for esp8266 by ESP8266 Community and then click on install button.

Step4: Restart your Arduino IDE

Step5: Now goto Tools then Select like figure 3

Step 4: Component Used:

Picture of Component Used:

For this project you need :

1) Node MCU V3

2) RFID RC522 Reader with Tag

3) Jumper Wire

1) Node MCU V3 :

Node MCU is an open source IOT platform. It includes firmware which runs on the ESP8266 Wi- Fi SoC from hardware which is based on the ESP-12 module. The term "Node MCU" by default refers to the firmware rather than the dev kits.

2) RFID RC522 Reader with Tag:

There are cheap RFID modules that can read and write Mifare's tags and being sold at several web stores, like eBay and included with many "starter kits" nowadays. Simply search RFID-RC522 (MF-RC522). The microcontroller and card reader uses SPI for communication (chip supports I2C and UART protocols but not implemented on library). The card reader and the tags communicate using a 13.56MHz electromagnetic field.

Step 5: Circuit Diagram

Picture of Circuit Diagram

Circuit Diagram of this project is given above.

Here are the connections of our circuit:

RFID-RC522 NODE MCU


SDA(SS) -- GPIO-------D4

MOSI -- GPIO13--------D7

MISO -- GPIO12--------D6

SCK -- GPIO14---------D5

GND -- GND

3.3V -- 3.3V

RST -- not connected

IRQ -- not connected

Step 6: Importing Necessary Library for NodeMCU

Here we are using RFID RC522. So you have to import MFRC522. Here is a GitHub link:

https://github.com/miguelbalboa/rfid

Step 7: Code for Project

Picture of Code for Project

We already posted our source code and documentation of this project in github you can check it out: here

Step 8: Video of Project

The whole project description are given in the above video

And if you want to learn about how to make php program and where to put that file you can go to another video: here

we've given our level of best to make you understand this project. Still if you have any doubt feel free comment us below

So finally if all things will go well. Definitely you will enjoy this project.


you also mail us on info@deligence.com

And if you want to learn more about these type of project then feel free to visit our youtube channel : here

Thanks & Regards,

Deligence Technologies

Comments

About This Instructable

3,285views

47favorites

License:

Bio: We are a team of IoT & Embedded Systems developers. We are working in Raspberry Pi and Arduino.
More by deligence:Over the Air(OTA) Update of Nodemcu(esp8266) Using MQTT)Raspberry Pi Web GPIO With Live Streaming Creating a Virtual World  Using Arduino and Python
Add instructable to: