import serial
import datetime
ser = serial.Serial('COM4',9600)
print("Serial input ready..")
import mysql.connector
mydb = mysql.connector.connect(
  host="localhost",
  user="rfid",
  passwd="rfidpasswd",
  database="rfid"
)
mycursor = mydb.cursor()
try:
  while True:
    line = ser.readline().strip()
    data = line.decode('ascii').split(':')
    rid = data[0]
    tag = data[1]
    time = datetime.datetime.now()
    c1 = "select * from tag_logs where reader_id = 'Reader_001' and timestamp > time= time - 60 and tag_no = tag"
    if
    c1 = 1
    //returns value then open door (write to serial)
    mycursor.execute(c1)

    command2 = "INSERT INTO tag_logs (reader_id, tag_no) VALUES ('" +rid+ "','" +tag+ "')"
    print(command)
    mycursor.execute(command)
    mydb.commit()
except KeyboardInterrupt:
  pass

#include <RFID.h>
#include <SPI.h>
#define SS_PIN 10
#define RST_PIN 9

RFID rfid(SS_PIN, RST_PIN);
int serNum[5];
String cardno;
int interval = 15000; // millisec
long now = 0;
long lasttime = millis();
// change Reader ID to your name
String readerID = "Reader_002";

void setup() {
Serial.begin(9600);
SPI.begin();
rfid.init();
pinMode(MISO, OUTPUT);

}

void loop() {
now = millis();
if (now > lasttime + interval) {
lasttime = now;
Serial.print(readerID);
Serial.print(":");
Serial.println("I am alive");
}
if (rfid.isCard()) {
if (rfid.readCardSerial()) {
lasttime = now;
cardno = String(rfid.serNum[0]) +
String(rfid.serNum[1]) +
String(rfid.serNum[2]) +
String(rfid.serNum[3]) +
String(rfid.serNum[4]);



//if(tagvalue == HIGH)
Serial.print(readerID);
Serial.print(":");
Serial.println(cardno);
}
}
rfid.halt();
delay(1000);
}