Detailed steps to implement system mail box function in PHP
With the continuous development of the Internet, email has become an indispensable part of people's daily life. Mailbox is a common email management tool that can help us easily manage inbox, sent and spam emails, etc. This article will introduce in detail how to use PHP to implement the system mail box function.
1. Create a database table
First, we need to create a table named "emails" in the database to store email-related information. You can use the following SQL statement to create:
CREATE TABLE emails (
id int(11) NOT NULL AUTO_INCREMENT,
sender varchar(255) NOT NULL,
recipient varchar(255) NOT NULL,
subject varchar(255) NOT NULL,
content text NOT NULL,
date datetime NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
This table contains 6 fields, namely id, sender, recipient, subject, content and date. Among them, id is the unique identifier of the email; sender and recipient represent the email addresses of the sender and recipient; subject represents the subject of the email; content represents the body of the email; date represents the sending time of the email.
2. Write PHP code
Next, we need to write PHP code to realize the function of the mail box. First, we need to connect to the database. You can use the following code to connect:
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check whether the connection is successful
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);}
?>
After the connection is successful, we need to write SQL Statement to obtain email-related information from the database. You can use the following code to query:
$sql = "SELECT * FROM emails ORDER BY date DESC";
$result = $conn->query($sql) ;
if ($result->num_rows > 0) {
// 输出数据
while($row = $result->fetch_assoc()) {
echo "发件人：" . $row["sender"]. " 收件人：" . $row["recipient"]. " 主题：" . $row["subject"]. " 时间：" . $row["date"]. "<br>";
}} else {
echo "还没有邮件！";
}
?>
This code uses the SELECT statement to obtain qualified email information from the database and outputs it to the browser one by one. Among them, ORDER BY date DESC means sorting in reverse order of sending time.
Next, we need to write code to implement the function of sending emails. You can use the following code to write:
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$sender = $_POST["sender"];
$recipient = $_POST["recipient"];
$subject = $_POST["subject"];
$content = $_POST["content"];
$date = date('Y-m-d H:i:s');
$sql = "INSERT INTO emails (sender, recipient, subject, content, date)
VALUES ('$sender', '$recipient', '$subject', '$content', '$date')";
if ($conn->query($sql) === TRUE) {
echo "邮件发送成功！";
} else {
echo "邮件发送失败：" . $conn->error;
}}
?>
This code uses the INSERT statement to insert new email information into the database. After the user submits the form, we get the values of each field in the form and insert them into the database. If the insertion is successful, "Email sent successfully!" will be output; if it fails, an error message will be output.
3. Make a user interface
Finally, we need to make a user interface so that users can easily use the functions of the mail box. It can be written using the following HTML code:
<title>邮箱</title>
< ;body>
收件箱
query($sql); if ($result->num_rows > 0) { // 输出数据 while($row = $result->fetch_assoc()) { echo "发件人：" . $row["sender"]. " 收件人：" . $row["recipient"]. " 主题：" . $row["subject"]. " 时间：" . $row["date"]. "
"; } } else { echo "还没有邮件！"; } ?>
发送邮件