PHP를 사용하여 CMS에서 이메일 전송 및 관리 모듈을 개발하는 방법

composer require phpmailer/phpmailer

require 'vendor/autoload.php';

$mail = new PHPMailerPHPMailerPHPMailer();

$mail->isSMTP();
$mail->Host = 'smtp.gmail.com';
$mail->SMTPAuth = true;
$mail->Username = 'your-email@example.com'; // 发送者邮箱地址
$mail->Password = 'your-email-password'; // 发送者邮箱密码
$mail->SMTPSecure = 'tls';
$mail->Port = 587;

$mail->setFrom('your-email@example.com', 'Your Name'); // 发送者姓名和邮箱地址
$mail->addAddress('recipient-email@example.com', 'Recipient Name'); // 收件人姓名和邮箱地址
$mail->addReplyTo('your-email@example.com', 'Your Name'); // 回复地址和姓名

$mail->isHTML(true);
$mail->Subject = 'Subject goes here';
$mail->Body    = '<p>HTML message body goes here</p>';

if(!$mail->send()) {
  echo 'Message could not be sent.';
  echo 'Mailer Error: ' . $mail->ErrorInfo;
} else {
  echo 'Message has been sent';
}

CREATE TABLE `emails` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `to` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `body` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

<?php

$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database_name";

// 创建连接
$conn = mysqli_connect($servername, $username, $password, $dbname);

// 检查连接是否成功
if (!$conn) {
  die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";

<?php

// 数据库连接代码

$sql = "SELECT * FROM emails ORDER BY created_at DESC"; // 查询所有电子邮件
$result = mysqli_query($conn, $sql);

// 显示电子邮件列表
if (mysqli_num_rows($result) > 0) {
  while($row = mysqli_fetch_assoc($result)) {
    echo "<h2>" . $row["subject"] . "</h2>";
    echo "<p><strong>To:</strong> " . $row["to"] . "</p>";
    echo "<p>" . $row["body"] . "</p>";
    echo "<a href='edit.php?id=" . $row["id"] . "'>Edit</a>";
    echo "<a href='delete.php?id=" . $row["id"] . "'>Delete</a>";
    echo "<hr>";
  }
} else {
  echo "No emails found";
}

mysqli_close($conn);
?>

<?php

// 数据库连接代码

if ($_SERVER["REQUEST_METHOD"] == "POST") {
  $to = $_POST["to"];
  $subject = $_POST["subject"];
  $body = $_POST["body"];

  $sql = "INSERT INTO emails (to, subject, body)
  VALUES ('$to', '$subject', '$body')";

  if (mysqli_query($conn, $sql)) {
    echo "Email added successfully";
  } else {
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
  }

  mysqli_close($conn);
}

?>

<form method="post">
  <label for="to">To:</label>
  <input type="text" name="to" id="to"><br><br>

  <label for="subject">Subject:</label>
  <input type="text" name="subject" id="subject"><br><br>

  <label for="body">Body:</label>
  <textarea name="body" id="body"></textarea><br><br>

  <input type="submit" value="Send">
</form>

<?php

// 数据库连接代码

$id = $_GET["id"];

if ($_SERVER["REQUEST_METHOD"] == "POST") {
  $to = $_POST["to"];
  $subject = $_POST["subject"];
  $body = $_POST["body"];

  $sql = "UPDATE emails SET to='$to', subject='$subject', body='$body' WHERE id='$id'";

  if (mysqli_query($conn, $sql)) {
    echo "Email updated successfully";
  } else {
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
  }

  mysqli_close($conn);
}

$sql = "SELECT * FROM emails WHERE id='$id'";
$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {
  $row = mysqli_fetch_assoc($result);
} else {
  echo "Email not found";
}

mysqli_close($conn);
?>

<form method="post">
  <label for="to">To:</label>
  <input type="text" name="to" id="to" value="<?php echo $row["to"]; ?>"><br><br>

  <label for="subject">Subject:</label>
  <input type="text" name="subject" id="subject" value="<?php echo $row["subject"]; ?>"><br><br>

  <label for="body">Body:</label>
  <textarea name="body" id="body"><?php echo $row["body"]; ?></textarea><br><br>

  <input type="submit" value="Update">
</form>

<?php

// 数据库连接代码

$id = $_GET["id"];

$sql = "DELETE FROM emails WHERE id='$id'";

if (mysqli_query($conn, $sql)) {
  echo "Email deleted successfully";
} else {
  echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

mysqli_close($conn);
?>