prepare($query); $stmt->bindValue(':id', $updateId, SQLITE3_TEXT); $res = $stmt->execute(); $row = $res->fetchArray(SQLITE3_ASSOC); // Store user data in variables $id = $row['id']; $macAddress = $row['mac_address']; $expireDate = $row['expire_date']; // Handle form submission if (isset($_POST['submit'])) { $expireDateTimestamp = strtotime($_POST['expire_date']); $formattedExpireDate = date('Y-m-d', $expireDateTimestamp); $updateQuery = 'UPDATE subscription SET mac_address=:mac_address, expire_date=:expire_date WHERE id=:id'; $updateStmt = $db->prepare($updateQuery); $updateStmt->bindValue(':mac_address', $_POST['mac_address'], SQLITE3_TEXT); $updateStmt->bindValue(':expire_date', $formattedExpireDate, SQLITE3_TEXT); $updateStmt->bindValue(':id', $_POST['id'], SQLITE3_TEXT); $updateStmt->execute(); // Close the database connection and redirect $db->close(); header('Location: mRTXSubscription.php'); } // Include the header include 'includes/header.php'; // Store user data in variables for use in the HTML form $userUpdateId = $row['id']; $userUpdateMacAddress = $row['mac_address']; $userUpdateExpireDate = $row['expire_date']; ?>

Subscription

Update Subscription