本文目录导读：
我将为您创建一个PHP项目邮件列表与分组管理的完整解决方案。
项目结构
mailing-list/
├── config/
│ └── database.php
├── includes/
│ ├── functions.php
│ └── auth.php
├── api/
│ ├── groups.php
│ ├── subscribers.php
│ └── send.php
├── templates/
│ └── email-template.php
├── admin/
│ ├── dashboard.php
│ ├── groups.php
│ └── subscribers.php
├── index.php
└── install.php数据库配置
<?php
// config/database.php
class Database {
private $host = 'localhost';
private $db_name = 'mailing_list';
private $username = 'root';
private $password = '';
private $conn;
public function getConnection() {
$this->conn = null;
try {
$this->conn = new PDO(
"mysql:host={$this->host};dbname={$this->db_name}",
$this->username,
$this->password
);
$this->conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$this->conn->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
} catch(PDOException $e) {
echo "Connection Error: " . $e->getMessage();
}
return $this->conn;
}
}
数据库安装脚本
-- install.php
CREATE DATABASE IF NOT EXISTS mailing_list;
USE mailing_list;
-- 用户表
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(50) UNIQUE NOT NULL,
email VARCHAR(100) UNIQUE NOT NULL,
password VARCHAR(255) NOT NULL,
role ENUM('admin', 'manager', 'user') DEFAULT 'user',
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
-- 分组表
CREATE TABLE groups (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
description TEXT,
created_by INT,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (created_by) REFERENCES users(id) ON DELETE CASCADE
);
-- 订阅者表
CREATE TABLE subscribers (
id INT AUTO_INCREMENT PRIMARY KEY,
email VARCHAR(100) UNIQUE NOT NULL,
name VARCHAR(100),
status ENUM('active', 'unsubscribed', 'bounced') DEFAULT 'active',
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);
-- 分组订阅者关联表
CREATE TABLE group_subscribers (
id INT AUTO_INCREMENT PRIMARY KEY,
group_id INT NOT NULL,
subscriber_id INT NOT NULL,
subscribed_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (group_id) REFERENCES groups(id) ON DELETE CASCADE,
FOREIGN KEY (subscriber_id) REFERENCES subscribers(id) ON DELETE CASCADE,
UNIQUE KEY unique_group_subscriber (group_id, subscriber_id)
);
-- 邮件发送记录表
CREATE TABLE email_logs (
id INT AUTO_INCREMENT PRIMARY KEY,
group_id INT,
subject VARCHAR(255) NOT NULL,
content TEXT,
sent_by INT,
recipient_count INT DEFAULT 0,
success_count INT DEFAULT 0,
failed_count INT DEFAULT 0,
sent_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (group_id) REFERENCES groups(id) ON DELETE SET NULL,
FOREIGN KEY (sent_by) REFERENCES users(id) ON DELETE SET NULL
);
-- 邮件发送状态表
CREATE TABLE email_status (
id INT AUTO_INCREMENT PRIMARY KEY,
log_id INT,
subscriber_id INT,
status ENUM('pending', 'sent', 'failed') DEFAULT 'pending',
error_message TEXT,
sent_at TIMESTAMP NULL,
FOREIGN KEY (log_id) REFERENCES email_logs(id) ON DELETE CASCADE,
FOREIGN KEY (subscriber_id) REFERENCES subscribers(id) ON DELETE CASCADE
);
-- 插入管理员用户 (密码: admin123)
INSERT INTO users (username, email, password, role)
VALUES ('admin', 'admin@example.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'admin');
核心功能函数
<?php
// includes/functions.php
require_once __DIR__ . '/../config/database.php';
class MailListManager {
private $db;
private $conn;
public function __construct() {
$this->db = new Database();
$this->conn = $this->db->getConnection();
}
// 分组管理
public function createGroup($name, $description, $userId) {
$sql = "INSERT INTO groups (name, description, created_by) VALUES (?, ?, ?)";
$stmt = $this->conn->prepare($sql);
return $stmt->execute([$name, $description, $userId]);
}
public function getGroups() {
$sql = "SELECT g.*, u.username as creator_name,
(SELECT COUNT(*) FROM group_subscribers WHERE group_id = g.id) as subscriber_count
FROM groups g
LEFT JOIN users u ON g.created_by = u.id
ORDER BY g.created_at DESC";
$stmt = $this->conn->query($sql);
return $stmt->fetchAll();
}
public function getGroup($groupId) {
$sql = "SELECT g.*, u.username as creator_name
FROM groups g
LEFT JOIN users u ON g.created_by = u.id
WHERE g.id = ?";
$stmt = $this->conn->prepare($sql);
$stmt->execute([$groupId]);
return $stmt->fetch();
}
public function updateGroup($groupId, $name, $description) {
$sql = "UPDATE groups SET name = ?, description = ? WHERE id = ?";
$stmt = $this->conn->prepare($sql);
return $stmt->execute([$name, $description, $groupId]);
}
public function deleteGroup($groupId) {
$sql = "DELETE FROM groups WHERE id = ?";
$stmt = $this->conn->prepare($sql);
return $stmt->execute([$groupId]);
}
// 订阅者管理
public function addSubscriber($email, $name = null) {
$sql = "INSERT INTO subscribers (email, name) VALUES (?, ?)
ON DUPLICATE KEY UPDATE name = ?, status = 'active'";
$stmt = $this->conn->prepare($sql);
return $stmt->execute([$email, $name, $name]);
}
public function getSubscribers($page = 1, $limit = 20) {
$offset = ($page - 1) * $limit;
$sql = "SELECT s.*,
(SELECT COUNT(*) FROM group_subscribers WHERE subscriber_id = s.id) as group_count
FROM subscribers s
ORDER BY s.created_at DESC
LIMIT ? OFFSET ?";
$stmt = $this->conn->prepare($sql);
$stmt->execute([$limit, $offset]);
return $stmt->fetchAll();
}
public function getSubscriber($subscriberId) {
$sql = "SELECT * FROM subscribers WHERE id = ?";
$stmt = $this->conn->prepare($sql);
$stmt->execute([$subscriberId]);
return $stmt->fetch();
}
public function updateSubscriber($subscriberId, $email, $name, $status) {
$sql = "UPDATE subscribers SET email = ?, name = ?, status = ? WHERE id = ?";
$stmt = $this->conn->prepare($sql);
return $stmt->execute([$email, $name, $status, $subscriberId]);
}
public function deleteSubscriber($subscriberId) {
// 先删除关联
$sql1 = "DELETE FROM group_subscribers WHERE subscriber_id = ?";
$stmt1 = $this->conn->prepare($sql1);
$stmt1->execute([$subscriberId]);
$sql2 = "DELETE FROM subscribers WHERE id = ?";
$stmt2 = $this->conn->prepare($sql2);
return $stmt2->execute([$subscriberId]);
}
// 分组订阅者管理
public function addSubscriberToGroup($groupId, $subscriberId) {
$sql = "INSERT IGNORE INTO group_subscribers (group_id, subscriber_id) VALUES (?, ?)";
$stmt = $this->conn->prepare($sql);
return $stmt->execute([$groupId, $subscriberId]);
}
public function removeSubscriberFromGroup($groupId, $subscriberId) {
$sql = "DELETE FROM group_subscribers WHERE group_id = ? AND subscriber_id = ?";
$stmt = $this->conn->prepare($sql);
return $stmt->execute([$groupId, $subscriberId]);
}
public function getGroupSubscribers($groupId) {
$sql = "SELECT s.*, gs.subscribed_at
FROM subscribers s
INNER JOIN group_subscribers gs ON s.id = gs.subscriber_id
WHERE gs.group_id = ? AND s.status = 'active'
ORDER BY gs.subscribed_at DESC";
$stmt = $this->conn->prepare($sql);
$stmt->execute([$groupId]);
return $stmt->fetchAll();
}
public function getSubscriberGroups($subscriberId) {
$sql = "SELECT g.*, gs.subscribed_at
FROM groups g
INNER JOIN group_subscribers gs ON g.id = gs.group_id
WHERE gs.subscriber_id = ?
ORDER BY gs.subscribed_at DESC";
$stmt = $this->conn->prepare($sql);
$stmt->execute([$subscriberId]);
return $stmt->fetchAll();
}
// 邮件发送
public function sendEmail($groupId, $subject, $content, $userId) {
$subscribers = $this->getGroupSubscribers($groupId);
$recipientCount = count($subscribers);
if ($recipientCount == 0) {
return ['success' => false, 'message' => '该组没有订阅者'];
}
// 创建发送记录
$sql = "INSERT INTO email_logs (group_id, subject, content, sent_by, recipient_count)
VALUES (?, ?, ?, ?, ?)";
$stmt = $this->conn->prepare($sql);
$stmt->execute([$groupId, $subject, $content, $userId, $recipientCount]);
$logId = $this->conn->lastInsertId();
$successCount = 0;
$failedCount = 0;
// 创建发送状态记录
foreach ($subscribers as $subscriber) {
$sql = "INSERT INTO email_status (log_id, subscriber_id, status) VALUES (?, ?, 'pending')";
$stmt = $this->conn->prepare($sql);
$stmt->execute([$logId, $subscriber['id']]);
}
// 发送邮件
foreach ($subscribers as $subscriber) {
$emailSent = $this->sendActualEmail($subscriber['email'], $subscriber['name'], $subject, $content);
if ($emailSent) {
$sql = "UPDATE email_status SET status = 'sent', sent_at = NOW()
WHERE log_id = ? AND subscriber_id = ?";
$successCount++;
} else {
$sql = "UPDATE email_status SET status = 'failed', error_message = ?
WHERE log_id = ? AND subscriber_id = ?";
$failedCount++;
}
$stmt = $this->conn->prepare($sql);
$stmt->execute([$logId, $subscriber['id']]);
}
// 更新发送记录
$sql = "UPDATE email_logs SET success_count = ?, failed_count = ? WHERE id = ?";
$stmt = $this->conn->prepare($sql);
$stmt->execute([$successCount, $failedCount, $logId]);
return [
'success' => true,
'message' => "发送完成：成功 {$successCount}，失败 {$failedCount}",
'total' => $recipientCount,
'success_count' => $successCount,
'failed_count' => $failedCount
];
}
private function sendActualEmail($to, $name, $subject, $content) {
// 使用PHP mail()函数或第三方SMTP服务
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=UTF-8" . "\r\n";
$headers .= 'From: Your Company <noreply@yourdomain.com>' . "\r\n";
// 简单的邮件模板
$emailContent = "
<!DOCTYPE html>
<html>
<head>
<meta charset='UTF-8'>
<style>
body { font-family: Arial, sans-serif; line-height: 1.6; color: #333; }
.container { max-width: 600px; margin: 0 auto; padding: 20px; }
.header { background: #007bff; color: white; padding: 20px; text-align: center; }
.content { padding: 20px; background: #f9f9f9; }
.footer { text-align: center; padding: 10px; font-size: 12px; color: #666; }
</style>
</head>
<body>
<div class='container'>
<div class='header'>
<h2>{$subject}</h2>
</div>
<div class='content'>
<p>尊敬的 {$name}，</p>
<div>{$content}</div>
</div>
<div class='footer'>
<p>如果您不想接收此类邮件，请<a href='{$this->getUnsubscribeLink($to)}'>点击此处退订</a></p>
</div>
</div>
</body>
</html>";
return mail($to, $subject, $emailContent, $headers);
}
private function getUnsubscribeLink($email) {
return "http://yourdomain.com/unsubscribe.php?email=" . urlencode($email);
}
// 统计功能
public function getStatistics() {
$stats = [];
// 总订阅者数
$sql = "SELECT COUNT(*) as total FROM subscribers WHERE status = 'active'";
$stats['total_subscribers'] = $this->conn->query($sql)->fetch()['total'];
// 总分组数
$sql = "SELECT COUNT(*) as total FROM groups";
$stats['total_groups'] = $this->conn->query($sql)->fetch()['total'];
// 总发送数
$sql = "SELECT COUNT(*) as total FROM email_logs";
$stats['total_emails_sent'] = $this->conn->query($sql)->fetch()['total'];
// 近期活动
$sql = "SELECT e.subject, e.sent_at, g.name as group_name, e.recipient_count, e.success_count, e.failed_count
FROM email_logs e
LEFT JOIN groups g ON e.group_id = g.id
ORDER BY e.sent_at DESC
LIMIT 10";
$stats['recent_activities'] = $this->conn->query($sql)->fetchAll();
return $stats;
}
// 导入导出功能
public function importSubscribersFromCSV($filePath, $groupId = null) {
$imported = 0;
$failed = 0;
if (($handle = fopen($filePath, "r")) !== FALSE) {
fgetcsv($handle); // 跳过表头
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
$email = trim($data[0]);
$name = isset($data[1]) ? trim($data[1]) : null;
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$subscriberId = $this->addSubscriber($email, $name);
if ($subscriberId && $groupId) {
$this->addSubscriberToGroup($groupId, $subscriberId);
}
$imported++;
} else {
$failed++;
}
}
fclose($handle);
}
return ['imported' => $imported, 'failed' => $failed];
}
public function exportSubscribersToCSV($groupId = null) {
if ($groupId) {
$subscribers = $this->getGroupSubscribers($groupId);
} else {
$subscribers = $this->getSubscribers(1, 100000);
}
$filename = 'subscribers_' . date('Y-m-d') . '.csv';
header('Content-Type: text/csv');
header('Content-Disposition: attachment; filename="' . $filename . '"');
$output = fopen('php://output', 'w');
fputcsv($output, ['Email', 'Name', 'Status', 'Created At']);
foreach ($subscribers as $subscriber) {
fputcsv($output, [
$subscriber['email'],
$subscriber['name'],
$subscriber['status'],
$subscriber['created_at']
]);
}
fclose($output);
exit;
}
}
分组管理页面
<?php
// admin/groups.php
session_start();
require_once '../includes/functions.php';
// 检查登录状态
if (!isset($_SESSION['user_id'])) {
header('Location: ../login.php');
exit;
}
$manager = new MailListManager();
// 处理表单提交
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
if (isset($_POST['action'])) {
switch ($_POST['action']) {
case 'create':
$manager->createGroup($_POST['name'], $_POST['description'], $_SESSION['user_id']);
break;
case 'update':
$manager->updateGroup($_POST['group_id'], $_POST['name'], $_POST['description']);
break;
case 'delete':
$manager->deleteGroup($_POST['group_id']);
break;
case 'add_subscriber':
$manager->addSubscriber($_POST['email'], $_POST['name']);
break;
case 'add_to_group':
$manager->addSubscriberToGroup($_POST['group_id'], $_POST['subscriber_id']);
break;
}
header('Location: groups.php');
exit;
}
}
// 搜索功能
$search = isset($_GET['search']) ? $_GET['search'] : '';
if ($search) {
$groups = $manager->searchGroups($search);
} else {
$groups = $manager->getGroups();
}
?>
<!DOCTYPE html>
<html lang="zh-CN">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">分组管理 - 邮件列表系统</title>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.8.1/font/bootstrap-icons.css">
</head>
<body>
<?php include '../includes/navbar.php'; ?>
<div class="container mt-4">
<div class="d-flex justify-content-between align-items-center mb-4">
<h2>分组管理</h2>
<button type="button" class="btn btn-primary" data-bs-toggle="modal" data-bs-target="#createGroupModal">
<i class="bi bi-plus-circle"></i> 创建新分组
</button>
</div>
<!-- 搜索栏 -->
<div class="card mb-4">
<div class="card-body">
<form method="GET" class="row g-3">
<div class="col-md-8">
<input type="text" class="form-control" name="search" placeholder="搜索分组名称..." value="<?php echo htmlspecialchars($search); ?>">
</div>
<div class="col-md-4">
<button type="submit" class="btn btn-primary w-100">
<i class="bi bi-search"></i> 搜索
</button>
</div>
</form>
</div>
</div>
<!-- 分组列表 -->
<div class="row">
<?php foreach ($groups as $group): ?>
<div class="col-md-6 col-lg-4 mb-4">
<div class="card h-100">
<div class="card-body">
<div class="d-flex justify-content-between align-items-start">
<h5 class="card-title"><?php echo htmlspecialchars($group['name']); ?></h5>
<div class="dropdown">
<button class="btn btn-sm btn-link" type="button" data-bs-toggle="dropdown">
<i class="bi bi-three-dots"></i>
</button>
<ul class="dropdown-menu">
<li><a class="dropdown-item" href="#" data-bs-toggle="modal" data-bs-target="#editGroupModal"
data-group-id="<?php echo $group['id']; ?>"
data-group-name="<?php echo htmlspecialchars($group['name']); ?>"
data-group-description="<?php echo htmlspecialchars($group['description']); ?>">
<i class="bi bi-pencil"></i> 编辑
</a></li>
<li><a class="dropdown-item" href="view_group.php?id=<?php echo $group['id']; ?>">
<i class="bi bi-people"></i> 查看订阅者
</a></li>
<li><hr class="dropdown-divider"></li>
<li><a class="dropdown-item text-danger" href="#" data-bs-toggle="modal" data-bs-target="#deleteGroupModal"
data-group-id="<?php echo $group['id']; ?>"
data-group-name="<?php echo htmlspecialchars($group['name']); ?>">
<i class="bi bi-trash"></i> 删除
</a></li>
</ul>
</div>
</div>
<p class="card-text text-muted">
<?php echo htmlspecialchars(substr($group['description'], 0, 100)) ?: '暂无描述'; ?>
</p>
<div class="d-flex justify-content-between align-items-center">
<span class="badge bg-info">
<i class="bi bi-people"></i> <?php echo $group['subscriber_count']; ?> 个订阅者
</span>
<small class="text-muted">创建人: <?php echo htmlspecialchars($group['creator_name']); ?></small>
</div>
</div>
<div class="card-footer bg-transparent">
<div class="btn-group w-100">
<a href="send_email.php?group_id=<?php echo $group['id']; ?>" class="btn btn-outline-success btn-sm">
<i class="bi bi-send"></i> 发送邮件
</a>
<a href="manage_subscribers.php?group_id=<?php echo $group['id']; ?>" class="btn btn-outline-primary btn-sm">
<i class="bi bi-gear"></i> 管理订阅者
</a>
</div>
</div>
</div>
</div>
<?php endforeach; ?>
</div>
<?php if (empty($groups)): ?>
<div class="text-center py-5">
<i class="bi bi-inbox display-1 text-muted"></i>
<p class="mt-3 text-muted">暂无分组</p>
</div>
<?php endif; ?>
</div>
<!-- 创建分组模态框 -->
<div class="modal fade" id="createGroupModal" tabindex="-1">
<div class="modal-dialog">
<div class="modal-content">
<form method="POST">
<input type="hidden" name="action" value="create">
<div class="modal-header">
<h5 class="modal-title">创建新分组</h5>
<button type="button" class="btn-close" data-bs-dismiss="modal"></button>
</div>
<div class="modal-body">
<div class="mb-3">
<label for="name" class="form-label">分组名称</label>
<input type="text" class="form-control" id="name" name="name" required>
</div>
<div class="mb-3">
<label for="description" class="form-label">描述</label>
<textarea class="form-control" id="description" name="description" rows="3"></textarea>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-bs-dismiss="modal">取消</button>
<button type="submit" class="btn btn-primary">创建</button>
</div>
</form>
</div>
</div>
</div>
<!-- 编辑分组模态框 -->
<div class="modal fade" id="editGroupModal" tabindex="-1">
<div class="modal-dialog">
<div class="modal-content">
<form method="POST">
<input type="hidden" name="action" value="update">
<input type="hidden" name="group_id" id="edit_group_id">
<div class="modal-header">
<h5 class="modal-title">编辑分组</h5>
<button type="button" class="btn-close" data-bs-dismiss="modal"></button>
</div>
<div class="modal-body">
<div class="mb-3">
<label for="edit_name" class="form-label">分组名称</label>
<input type="text" class="form-control" id="edit_name" name="name" required>
</div>
<div class="mb-3">
<label for="edit_description" class="form-label">描述</label>
<textarea class="form-control" id="edit_description" name="description" rows="3"></textarea>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-bs-dismiss="modal">取消</button>
<button type="submit" class="btn btn-primary">保存</button>
</div>
</form>
</div>
</div>
</div>
<!-- 删除分组模态框 -->
<div class="modal fade" id="deleteGroupModal" tabindex="-1">
<div class="modal-dialog">
<div class="modal-content">
<form method="POST">
<input type="hidden" name="action" value="delete">
<input type="hidden" name="group_id" id="delete_group_id">
<div class="modal-header">
<h5 class="modal-title">删除分组</h5>
<button type="button" class="btn-close" data-bs-dismiss="modal"></button>
</div>
<div class="modal-body">
<p>确定要删除分组 "<span id="delete_group_name"></span>" 吗？</p>
<p class="text-danger">此操作不可恢复！</p>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-bs-dismiss="modal">取消</button>
<button type="submit" class="btn btn-danger">删除</button>
</div>
</form>
</div>
</div>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
<script>
// 编辑分组模态框数据填充
document.getElementById('editGroupModal').addEventListener('show.bs.modal', function (event) {
var button = event.relatedTarget;
var groupId = button.getAttribute('data-group-id');
var groupName = button.getAttribute('data-group-name');
var groupDescription = button.getAttribute('data-group-description');
document.getElementById('edit_group_id').value = groupId;
document.getElementById('edit_name').value = groupName;
document.getElementById('edit_description').value = groupDescription;
});
// 删除分组模态框数据填充
document.getElementById('deleteGroupModal').addEventListener('show.bs.modal', function (event) {
var button = event.relatedTarget;
var groupId = button.getAttribute('data-group-id');
var groupName = button.getAttribute('data-group-name');
document.getElementById('delete_group_id').value = groupId;
document.getElementById('delete_group_name').textContent = groupName;
});
</script>
</body>
</html>
邮件发送管理页面
<?php
// admin/send_email.php
session_start();
require_once '../includes/functions.php';
if (!isset($_SESSION['user_id'])) {
header('Location: ../login.php');
exit;
}
$manager = new MailListManager();
$groupId = isset($_GET['group_id']) ? $_GET['group_id'] : null;
if ($groupId) {
$group = $manager->getGroup($groupId);
$subscribers = $manager->getGroupSubscribers($groupId);
}
// 处理邮件发送
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['send_email'])) {
$result = $manager->sendEmail(
$_POST['group_id'],
$_POST['subject'],
$_POST['content'],
$_SESSION['user_id']
);
if ($result['success']) {
$success_message = $result['message'];
} else {
$error_message = $result['message'];
}
}
$groups = $manager->getGroups();
?>
<!DOCTYPE html>
<html lang="zh-CN">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">发送邮件 - 邮件列表系统</title>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<link href="https://cdn.jsdelivr.net/npm/summernote@0.8.18/dist/summernote-bs4.min.css" rel="stylesheet">
</head>
<body>
<?php include '../includes/navbar.php'; ?>
<div class="container mt-4">
<h2>发送电子邮件</h2>
<?php if (isset($success_message)): ?>
<div class="alert alert-success alert-dismissible fade show">
<?php echo htmlspecialchars($success_message); ?>
<button type="button" class="btn-close" data-bs-dismiss="alert"></button>
</div>
<?php endif; ?>
<?php if (isset($error_message)): ?>
<div class="alert alert-danger alert-dismissible fade show">
<?php echo htmlspecialchars($error_message); ?>
<button type="button" class="btn-close" data-bs-dismiss="alert"></button>
</div>
<?php endif; ?>
<div class="row">
<div class="col-md-8">
<div class="card">
<div class="card-body">
<form method="POST" id="emailForm">
<input type="hidden" name="group_id" value="<?php echo $groupId; ?>">
<div class="mb-3">
<label for="group_select" class="form-label">目标分组</label>
<select class="form-select" id="group_select" name="group_id" required
onchange="location.href='send_email.php?group_id='+this.value">
<option value="">选择分组...</option>
<?php foreach ($groups as $g): ?>
<option value="<?php echo $g['id']; ?>"
<?php echo ($g['id'] == $groupId) ? 'selected' : ''; ?>>
<?php echo htmlspecialchars($g['name']); ?>
(<?php echo $g['subscriber_count']; ?> 订阅者)
</option>
<?php endforeach; ?>
</select>
</div>
<div class="mb-3">
<label for="subject" class="form-label">邮件主题</label>
<input type="text" class="form-control" id="subject" name="subject" required>
</div>
<div class="mb-3">
<label for="content" class="form-label">邮件内容</label>
<textarea class="form-control" id="content" name="content" rows="10"></textarea>
</div>
<div class="mb-3">
<button type="submit" name="send_email" class="btn btn-primary"
onclick="return confirm('确定要发送邮件给选中的订阅者吗？')">
<i class="bi bi-send"></i> 发送邮件
</button>
</div>
</form>
</div>
</div>
</div>
<div class="col-md-4">
<?php if ($groupId && isset($group)): ?>
<div class="card">
<div class="card-header">
<h5 class="card-title mb-0">目标订阅者</h5>
</div>
<div class="card-body">
<p>分组: <strong><?php echo htmlspecialchars($group['name']); ?></strong></p>
<p>订阅者数量: <strong><?php echo count($subscribers); ?></strong></p>
<h6>订阅者列表:</h6>
<div class="list-group" style="max-height: 300px; overflow-y: auto;">
<?php foreach ($subscribers as $subscriber): ?>
<div class="list-group-item list-group-item-action">
<div class="d-flex w-100 justify-content-between">
<h6 class="mb-1"><?php echo htmlspecialchars($subscriber['name'] ?: '无姓名'); ?></h6>
<small><?php echo date('Y-m-d', strtotime($subscriber['subscribed_at'])); ?></small>
</div>
<p class="mb-1 text-muted small"><?php echo htmlspecialchars($subscriber['email']); ?></p>
</div>
<?php endforeach; ?>
</div>
</div>
</div>
<?php endif; ?>
</div>
</div>
</div>
<script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/summernote@0.8.18/dist/summernote-bs4.min.js"></script>
<script>
$(document).ready(function() {
$('#content').summernote({
height: 300,
toolbar: [
['style', ['style']],
['font', ['bold', 'underline', 'clear']],
['color', ['color']],
['para', ['ul', 'ol', 'paragraph']],
['table', ['table']],
['insert', ['link', 'picture', 'video']],
['view', ['fullscreen', 'codeview', 'help']]
]
});
});
</script>
</body>
</html>
API接口文件
<?php
// api/subscribers.php
header('Content-Type: application/json');
header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Methods: GET, POST, PUT, DELETE');
header('Access-Control-Allow-Headers: Content-Type');
require_once '../includes/functions.php';
$manager = new MailListManager();
$method = $_SERVER['REQUEST_METHOD'];
switch ($method) {
case 'GET':
if (isset($_GET['id'])) {
$subscriber = $manager
版权声明：NBA直播
NBA直播
NBA直播
NBA直播
NBA直播
NBA直播
NBA直播
NBA直播
NBA直播
NBA直播
NBA直播
NBA直播
NBA直播
NBA直播
NBA直播
NBA直播
NBA直播
NBA直播
CBA直播
CBA直播
CBA直播
CBA直播
CBA直播
CBA直播
CBA直播
CBA直播
CBA直播
CBA直播
CBA直播
CBA直播
CBA直播
CBA直播
CBA直播
CBA直播
CBA直播
CBA直播
足球直播
足球直播
足球直播
足球直播
足球直播
足球直播
足球直播
足球直播
足球直播
足球直播
足球直播
足球直播
足球直播
足球直播
足球直播
足球直播
足球直播
足球直播
英超直播
英超直播
英超直播
英超直播
英超直播
英超直播
英超直播
英超直播
英超直播
英超直播
英超直播
英超直播
英超直播
英超直播
英超直播
英超直播
英超直播
英超直播
