prepare("SELECT * FROM affiliates WHERE id = ?"); $stmt->execute([$affiliate_id]); $affiliate = $stmt->fetch(); if (!$affiliate) { header('Location: supply.php'); exit; } // Fetch attachments $attachStmt = $pdo->prepare("SELECT * FROM affiliate_attachments WHERE affiliate_id = ?"); $attachStmt->execute([$affiliate_id]); $attachments = $attachStmt->fetchAll(); // Fetch signups $signupsStmt = $pdo->prepare(" SELECT * FROM affiliate_signups WHERE affiliate_id = ? ORDER BY clicked_at DESC LIMIT 100 "); $signupsStmt->execute([$affiliate_id]); $signups = $signupsStmt->fetchAll(); } catch (Exception $e) { error_log("View affiliate error: " . $e->getMessage()); header('Location: supply.php'); exit; } $signup_url = 'https://relevantreflex.com/signup.php?ref=' . $affiliate['affiliate_code']; include 'includes/header.php'; ?>

Affiliate Details

Complete information for

✏️ Edit Affiliate ← Back to List

Affiliate Code & Signup Link

Basic Information

Type
Company Name
In-charge Name
State
Location

PIN:
Mobile
Email
Website/URL
Signup Reward
₹
Status
Created

Performance Statistics

Total Signups
Verified Signups
Total Rewards Paid
₹
Conversion Rate
0 ? ($affiliate['total_verified_signups'] / $affiliate['total_signups'] * 100) : 0; echo number_format($conversion, 1); ?>%

Attachments ()


KB • Uploaded on
📥 Download

Recent Signups (Last 100)

No signups yet

Email Clicked At Signed Up Verified Reward Status
Not completed'; ?> ✅ Pending ✅ Not verified ₹ Pending Complete Awaiting Verification Clicked Only