How to use PHP to develop email sending and management modules in CMS

With the rapid development of Internet technology, CMS (Content Management System) has become an important tool for managing website content. The email sending and management module is a common function in CMS. In terms of PHP development, the development of email sending and management modules are very common tasks. In this article, we will explore how to use PHP to implement email sending and management modules in CMS.

1. Development of email sending module

Email sending is a very common function. The email sending module in CMS needs to support HTML format emails and plain text emails. In PHP, we can use the PHPMailer library to quickly send emails.

1. Installing PHPMailer

Before using PHPMailer, we need to install it into our project. PHPMailer can be installed using Composer.

Open a terminal or command prompt and navigate to your project directory and run the following command:

composer require phpmailer/phpmailer

2. Send Mail Using PHPMailer

In our After installing PHPMailer, we can use it to send emails. The following is a simple sample code:

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';
}

2. Development of email management module

The email management module is usually used to manage emails sent by the website. This module needs to support basic operations such as adding, editing, deleting and viewing emails. In PHP, we can use SQL database to store email data.

1. Create Database

We need to first create a database to store email data. The following is a simple SQL statement to create a data table named "emails".

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;

2. Set up the database connection

In PHP, we need to set up the database connection so that we can read and write data from the database. The following is a sample code:

<?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";

3. Create email management page

We need to create a page for managing email. This page will display all sent emails and allow users to add, edit, and delete emails. Here is a simple code example:

<?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);
?>

4. Create the add email page

We also need to create a page for adding the email. The page will display a form where the user can fill in the recipients, subject, and content of the email. Here is a sample code:

<?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>

5. Create an edit email page

We also need to create a page for editing emails. The page will display a form that allows a user to edit the recipients, subject, and content of the email. Here is a sample code:

<?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>

6. Create Delete Email Page

Finally, we need to create a page for deleting emails. The following is a sample code:

<?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);
?>

Conclusion

In this article, we have introduced how to use PHP to develop email sending and management modules in CMS. Using the PHPMailer library, we can quickly send emails. Using SQL database we can easily store and manage email data. By using these tools, we can easily extend the functionality of the CMS and provide users with a better experience.

The above is the detailed content of How to use PHP to develop email sending and management modules in CMS. For more information, please follow other related articles on the PHP Chinese website!