import pymysql
import ctypes

# Load the SDK DLL
sdk = ctypes.CDLL("C:\\Windows\\System32\\zkfinger10.dll")

# Initialize device
sdk.InitDevice()

# Capture fingerprint template (Example, adjust to SDK function)
fingerprint_data = sdk.CaptureFingerprint()

# Save fingerprint to MySQL database (assuming fingerprint is binary)
conn = pymysql.connect(host='localhost', user='root', password='yourpassword', database='attendance')
cursor = conn.cursor()

# Insert fingerprint data into MySQL table
if fingerprint_data:
    user_id = input("Enter user ID: ")
    sql = "INSERT INTO users (id, fingerprint_template) VALUES (%s, %s)"
    cursor.execute(sql, (user_id, fingerprint_data))
    conn.commit()

# Close connection
cursor.close()
conn.close()