prepare("SELECT credits FROM users WHERE id = ?");
$stmt->execute([$user_id]);
$user = $stmt->fetch();
// Handle traffic exchange
if (isset($_POST['view_blog'])) {
$stmt = $pdo->prepare("SELECT id, url FROM blogs ORDER BY RAND() LIMIT 1");
$stmt->execute();
$blog = $stmt->fetch();
if ($blog) {
$stmt = $pdo->prepare("UPDATE users SET credits = credits + 1 WHERE id = ?");
$stmt->execute([$user_id]);
header("Location: " . $blog['url']);
exit();
}
}
// Handle email sending
if (isset($_POST['send_email']) && $user['credits'] >= 5) {
$to = $_POST['email'];
$subject = $_POST['subject'];
$message = $_POST['message'];
$headers = "From: admin@yourwebsite.com";
if (mail($to, $subject, $message, $headers)) {
$stmt = $pdo->prepare("UPDATE users SET credits = credits - 5 WHERE id = ?");
$stmt->execute([$user_id]);
echo "Email sent successfully!";
} else {
echo "Failed to send email.";
}
}
?>
Traffic Exchange & Mailer
Welcome to the Traffic Exchange
Your credits:
Send an Email
No comments:
Post a Comment