Attendance System Using Arduino with MySQL

/Attendance System Using Arduino with MySQL
Attendance System Using Arduino with MySQL2018-08-01T13:39:06+00:00

Project Description

Description

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.

 

Details

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

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

 

0 18 0

Leave a Reply