prepare("INSERT INTO license_keys (product_id, license_key, status) VALUES (?, ?, 'available')");
foreach ($keys_array as $key) {
$key = trim($key);
if (!empty($key)) {
$stmt->execute([$product_id, $key]);
$count++;
}
}
$msg = "Success! $count keys added to inventory.";
$msgClass = "success";
}
// 2. UPDATE SINGLE KEY (Edit Feature)
if (isset($_POST['update_key'])) {
$key_id = $_POST['key_id'];
$key_val = trim($_POST['license_key']);
$status = $_POST['status'];
$return_pid = $_POST['return_pid']; // To stay on the same view
$pdo->prepare("UPDATE license_keys SET license_key = ?, status = ? WHERE id = ?")
->execute([$key_val, $status, $key_id]);
header("Location: keys.php?view_product=$return_pid&msg=updated");
exit();
}
// 3. DELETE KEY
if (isset($_GET['delete'])) {
$id = $_GET['delete'];
// Get product ID first to return to view
$chk = $pdo->prepare("SELECT product_id FROM license_keys WHERE id=?");
$chk->execute([$id]);
$pid = $chk->fetchColumn();
$pdo->prepare("DELETE FROM license_keys WHERE id = ?")->execute([$id]);
header("Location: keys.php?view_product=$pid&msg=deleted");
exit();
}
// 4. FETCH STATS (Grouped by Product)
$stats = $pdo->query("
SELECT p.id as pid, p.name,
COUNT(CASE WHEN k.status = 'available' THEN 1 END) as available_count,
COUNT(CASE WHEN k.status = 'used' THEN 1 END) as used_count
FROM products p
LEFT JOIN license_keys k ON p.id = k.product_id
GROUP BY p.id
HAVING available_count > 0 OR used_count > 0
")->fetchAll();
// 5. FETCH ALL PRODUCTS (For Dropdown)
$products = $pdo->query("SELECT id, name FROM products WHERE is_active=1")->fetchAll();
// 6. FETCH KEYS FOR SPECIFIC PRODUCT (If View Clicked)
$view_keys = [];
$view_product_name = "";
if (isset($_GET['view_product'])) {
$vpid = $_GET['view_product'];
// Get Product Name
$pnStmt = $pdo->prepare("SELECT name FROM products WHERE id = ?");
$pnStmt->execute([$vpid]);
$view_product_name = $pnStmt->fetchColumn();
// Get Keys
$vkStmt = $pdo->prepare("SELECT * FROM license_keys WHERE product_id = ? ORDER BY status ASC, id DESC");
$vkStmt->execute([$vpid]);
$view_keys = $vkStmt->fetchAll();
}
} catch (Exception $e) {
die("Database Error: " . $e->getMessage());
}
?>
Manage Keys