NFC Card Reader Data to PhpMyAdmin

by RishabhL in Circuits > Arduino

21361 Views, 68 Favorites, 0 Comments

NFC Card Reader Data to PhpMyAdmin

11021-01c.jpg

This project demonstrate how we can send the NFC card id to our mysql database using arduino. This project further can be implemented for various application such as student attendance syste, worker attendance system or in time or out time of the person by scanning card into the MFRC 522 nfc rfid reader module.

In this project I'm showing you how we can send the Id of nfc card to the server and save it to the mysql database using php. I used arduino uno with gsm sim800 module to connect with the internet service. This project is useful where wifi network is not available.

Hope you will like this simple and easy project..

What You Will Need?

2bdb29d8-c29a-4228-ada4-922170ee4fbb.jpg
88c76134-1c5e-4492-9866-f0f6aab5ef67.jpg
372bc905-8541-42b7-803c-c72bbfeaea18.jpg
f35aa098-add9-4dc8-87b8-fc88d0eeba52.jpg
P_20161220_152900.jpg
64-00.jpg

1. MFRC522 rfid reader module

2. Arduino uno

3. Gsm sim800 or sim900

4. Rfid tags

5. Breadboard

6. Wires

7. Power Supply

Circuit Diagram:

mfrc_bb.jpg

Connect the components as shown in circuit diagram.

Pin2 of arduino to Tx of Gsm.

Pin3 of Arduino to Rx. of Gsm.

Server Side:

1111.png
2222.png
3333.png
4444.png
5555.png

Take any of free php hosting with phpmysql database.

Inside phpmyadmin > click on sqlQuery, Run query " create database nfcreader " and click on Go

> click on sqlQuery, Run query inside nfcreader database " create table nfc(id varchar(30)) " and click on Go

> you can test database by inserting values, Run query " insert into nfc values('AXT67JM') " and click Go

> you can see data from table, Run Query " select * from nfc " and click on Go

Extract PHPfiles.rar

Create php for connection with database.

Php files are in attachments.

Upload these files in file manager of hosting service.

Make Change inside Conf.php

=> $con=mysqli_connect("localhost","root","--","nfcreader");

replace localhost with your database ip address

replace root with your database userid

replace -- with database password

Downloads

Uploading Code ToArduino:

Replace " APN " in the code with your sim card APN

Repalce " yourURLhere.com " with your URL into the code attached.

You'r Done!

Done with this simple project. For queries comment down below, I would like to hepl you..!