query("SELECT DISTINCT email, name FROM users WHERE id IN (SELECT user_id FROM orders WHERE status='completed')"); } else { // Everyone $stmt = $pdo->query("SELECT email, name FROM users"); } $users = $stmt->fetchAll(); // Prepare Email Headers $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type:text/html;charset=UTF-8" . "\r\n"; $headers .= "From: Pro Subscription Offers " . "\r\n"; // Loop & Send $count = 0; foreach ($users as $user) { $personal_msg = "

Pro Subscription Offers

Hi " . htmlspecialchars($user['name']) . ",

" . nl2br($message_body) . "

Visit Store

You received this email because you are a registered member of Pro Subscription Offers.
"; // Suppress errors to keep loop running if(@mail($user['email'], $subject, $personal_msg, $headers)) { $count++; } } $msg = "Marketing Blast Sent to $count users!"; $msgClass = "success"; } // 2. HANDLE ABANDONED CART RECOVERY (Optional Feature Logic) if (isset($_POST['send_recovery'])) { // Logic to fetch abandoned carts (requires 'abandoned_carts' table) // For now, we just show a message as placeholder functionality try { $carts = $pdo->query("SELECT * FROM abandoned_carts WHERE status='pending' AND created_at < NOW() - INTERVAL 1 HOUR")->fetchAll(); $rec_count = 0; foreach ($carts as $c) { $to = $c['email']; $subject = "You left something behind! 🛒"; $rec_msg = "

Hi,

We noticed you didn't finish your order. Use code SAVE5 to complete it now!

Go to Cart

"; $headers = "MIME-Version: 1.0" . "\r\n" . "Content-type:text/html;charset=UTF-8" . "\r\n" . "From: Pro Subscription Offers "; if(@mail($to, $subject, $rec_msg, $headers)) { $pdo->prepare("UPDATE abandoned_carts SET status='recovered' WHERE id=?")->execute([$c['id']]); $rec_count++; } } $msg = "Recovery emails sent to $rec_count users!"; $msgClass = "success"; } catch (Exception $e) { $msg = "Error: Abandoned Cart table not found or setup."; $msgClass = "error"; } } // Stats $total_users = $pdo->query("SELECT COUNT(*) FROM users")->fetchColumn(); $total_buyers = $pdo->query("SELECT COUNT(DISTINCT user_id) FROM orders WHERE status='completed'")->fetchColumn(); ?> Marketing Blaster

Email Marketing Blaster

Total Users:
Verified Buyers:

Send Newsletter

Note: Use <b> for bold, <br> for new line.

Abandoned Cart Recovery

Send a reminder email to users who left items in their cart more than 1 hour ago.