exec("CREATE TABLE IF NOT EXISTS subscription(id INTEGER PRIMARY KEY, mac_address TEXT, expire_date TEXT)");
$res = $db->query('SELECT * FROM subscription');
if (isset($_GET['index'])) {
$index = $_GET['index'];
} else {
$index = "";
}
if (isset($_POST['submit'])) {
$expireDate = strtotime($_POST['expire_date']);
$formattedExpireDate = date('Y-m-d', $expireDate);
$macAddress = strtoupper($_POST['mac_address']);
$checkQuery = "SELECT COUNT(*) as count FROM subscription WHERE mac_address = :macAddress";
$stmt = $db->prepare($checkQuery);
$stmt->bindValue(':macAddress', $macAddress, SQLITE3_TEXT);
$result = $stmt->execute();
$row = $result->fetchArray(SQLITE3_ASSOC);
if ($row['count'] > 0) {
echo '';
} else {
$insertQuery = "INSERT INTO subscription (mac_address, expire_date) VALUES (:macAddress, :formattedExpireDate)";
$stmt = $db->prepare($insertQuery);
$stmt->bindValue(':macAddress', $macAddress, SQLITE3_TEXT);
$stmt->bindValue(':formattedExpireDate', $formattedExpireDate, SQLITE3_TEXT);
$stmt->execute();
$db->close();
header('Location: mRTXSubscription.php');
}
}
include 'includes/header.php';
?>