prepare("SELECT referral_code, wallet_balance FROM users WHERE id = ?");
$stmt->execute([$user_id]);
$user = $stmt->fetch();
// Fetch History
$hist = $pdo->prepare("
SELECT r.*, u.name as invited_name
FROM referrals r
JOIN users u ON r.referred_user_id = u.id
WHERE r.referrer_id = ?
ORDER BY r.created_at DESC
");
$hist->execute([$user_id]);
$referrals = $hist->fetchAll();
$ref_link = "https://prosubscriptionoffers.com/register.php?ref=" . $user['referral_code'];
?>
Invite & Earn
Share your link. When your friends buy, you earn ₹50 in wallet credit!