close-circle
Close
0%
0%

Attendance System Using Arduino with MySQL

Here we are going to connect Arduino UNO , Ethernet Shield and RFID- RC522 with MYSQL Database.

Similar projects worth following
close
In this project I'm going to explain you about how we can get the rfid dettails in PHPMYADMIN database. So for that first we should connect our Arduino UNO which is already connected to our ethernet shield with RFID Module. By using the RFID Module as you can see in the image.we are going to scan our RFID card and tag which are allow or not. And by using our Arduino UNO with Ethernet Shield we are going to send that data to our MYSQL Database 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.

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 apache page like the below image


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

Your PHPMYADMIN page will look like this


b) Installation of Arduino IDE:

You can download the latest Arduino IDE from this link: https://www.arduino.cc/en/Main/Software

Importing Necessary Library for Arduino

Here we are using RFID RC522. So you have to import MFRC522. download the GitHub link :here

  • 1 × arduino uno Arduino/Genuino Uno is a microcontroller board based on the ATmega328P (datasheet). It has 14 digital input/output pins (of which 6 can be used as PWM outputs), 6 analog inputs, a 16 MHz quartz crystal, a USB connection, a power jack, an ICSP header and a reset button.
  • 1 × Ethernet Shield The Arduino Ethernet Shield 2 connects your Arduino to the internet in mere minutes. Just plug this module onto your Arduino Board, connect it to your network with an RJ45 cable and follow a few simple steps to start controlling your world pharmacy through the internet. As always with Arduino, every element of the platform – hardware, software and documentation – is freely available and open-source. This means you can learn exactly how it's made and use its design as the starting point for your own circuits. Hundreds of thousands of Arduino Boards are already fueling people’s creativity all over the world, every day.
  • 1 × 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.
  • 1 × Jumper Wires

  • Circuit Diagram Video and Code

    Deligence Technologies09/14/2017 at 07:51 0 comments

    Circuit Diagram

    Circuit Diagram

    Circuit Diagram of this project is given above.

    before connecting Rfid -RC522 connect ethernet shield as shown in previous image

    Here are the connections of our circuit:

    RFID-RC522 Arduino UNO Arduino Mega

    RST---------------------9-------------------- 9

    SDA(SS)--------------- 4/10---------------- 4/53

    MOSI ------------------11---------------------51

    MISO-------------------12------------------- 50

    SCK---------------------13------------------- 52

    VCC--------------------3.3 v---------------- 3.3v

    GND--------------------GND-----------------GND

    IRQ ---------------------not connected----not connected

    NOTE: As we are using two SPI devices and SDA(SS) is already taken by Ethernet shield so we have to use separate pin for SDA(SS) in case of RFID-RC522 so that there will not be any conflict between SPI devices

    Code for Project

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

    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

    Congratulations you have successfully finished your project

    If have any doubt regarding this project feel free to comment us below or you can mail us on info@deligence.com

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

    Thanks & Regards,

    Deligence Technologies

View project log

Enjoy this project?

Share

Discussions

Deligence Technologies wrote 4 days ago point

We have developed one with Raspberry Pi as well - https://github.com/DeligenceTechnologies/Attendance-system-using-mysql-with-Raspberry-pi-and-RFID-RC522 - Will be posting it here in a day or two.

  Are you sure? yes | no

Similar Projects

Does this project spark your interest?

Become a member to follow this project and never miss any updates