prepare("SELECT * FROM campaigns WHERE slug = ?"); $stmt->execute([$slug]); $campaign = $stmt->fetch(); if ($campaign) { // Log click $stmt = $pdo->prepare("INSERT INTO stats (campaign_id, type) VALUES (?, 'click')"); $stmt->execute([$campaign['id']]); header("Location: " . $campaign['offer_url']); exit; } else { die("Error."); } ?>