exec("CREATE TABLE IF NOT EXISTS `affiliate_products` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `product_name` VARCHAR(255) NOT NULL, `affiliate_link` VARCHAR(2048) NOT NULL, `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP )"); // Handle form submission for adding a new product if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['add_product'])) { $product_name = trim($_POST['product_name']); $affiliate_link = trim($_POST['affiliate_link']); if (!empty($product_name) && !empty($affiliate_link) && filter_var($affiliate_link, FILTER_VALIDATE_URL)) { $stmt = $pdo->prepare("INSERT INTO affiliate_products (product_name, affiliate_link) VALUES (?, ?)"); $stmt->execute([$product_name, $affiliate_link]); header("Location: products.php?status=success"); exit; } else { $error = "Invalid input. Please provide a valid product name and URL."; } } // Handle deletion if (isset($_GET['action']) && $_GET['action'] === 'delete' && isset($_GET['id'])) { $id = filter_var($_GET['id'], FILTER_VALIDATE_INT); if ($id) { $stmt = $pdo->prepare("DELETE FROM affiliate_products WHERE id = ?"); $stmt->execute([$id]); header("Location: products.php?status=deleted"); exit; } } // Fetch all products $products = $pdo->query("SELECT * FROM affiliate_products ORDER BY created_at DESC")->fetchAll(PDO::FETCH_ASSOC); } catch (PDOException $e) { $error = "Database error: " . $e->getMessage(); $products = []; } ?> Affiliate Product Management

Affiliate Product Management

Product added successfully!

Product deleted.

Add New Product

Existing Products

Product Name	Affiliate Link	Actions
No products found.
		Delete