Design ideas for the mall event message push function developed in PHP

Design ideas for the mall event message push function developed in PHP

1. Background introduction
In the field of modern e-commerce, malls can effectively increase user participation and purchase intention by pushing event messages to users. This article will discuss how to design and implement the event message push function in a mall developed in PHP.

2. Functional design ideas

1. Database design
   First, we need to design a database table to store active messages. Suppose we create a database table called "activity_messages" with the following fields:
2. id: the unique identifier of the message
3. title: the message title
4. content: Message content
5. time: Message release time
6. status: Message status, such as published, expired, etc.
7. Backend management system
   We need to develop a backend for the mall Management system to facilitate administrators to publish and manage event messages. Administrators can perform the following operations by logging in to the backend management system:
8. Administrator adds new event messages
9. Modifies the title, content and release time of existing event messages
10. Delete existing active messages
11. View the list of published active messages

The following is a simplified code example that demonstrates how to complete the above operation:

<?php

// 连接数据库
$connection = mysqli_connect("localhost", "username", "password", "database");

if (!$connection) {
    die("数据库连接失败: " . mysqli_connect_error());
}

// 添加新的活动消息
function addActivityMessage($title, $content, $time) {
    global $connection;
    
    $query = "INSERT INTO activity_messages (title, content, time, status) VALUES ('$title', '$content', '$time', 'published')";
    
    if (mysqli_query($connection, $query)) {
        echo "活动消息添加成功！";
    } else {
        echo "活动消息添加失败：" . mysqli_error($connection);
    }
}

// 修改已有活动消息
function updateActivityMessage($id, $title, $content, $time) {
    global $connection;
    
    $query = "UPDATE activity_messages SET title='$title', content='$content', time='$time' WHERE id=$id";
    
    if (mysqli_query($connection, $query)) {
        echo "活动消息修改成功！";
    } else {
        echo "活动消息修改失败：" . mysqli_error($connection);
    }
}

// 删除已有活动消息
function deleteActivityMessage($id) {
    global $connection;
    
    $query = "DELETE FROM activity_messages WHERE id=$id";
    
    if (mysqli_query($connection, $query)) {
        echo "活动消息删除成功！";
    } else {
        echo "活动消息删除失败：" . mysqli_error($connection);
    }
}

// 查看已发布的活动消息列表
function getActivityMessages() {
    global $connection;
    
    $query = "SELECT * FROM activity_messages WHERE status='published' ORDER BY time DESC";
    $result = mysqli_query($connection, $query);
    
    if (mysqli_num_rows($result) > 0) {
        while ($row = mysqli_fetch_assoc($result)) {
            echo "标题：" . $row["title"] . "<br>";
            echo "内容：" . $row["content"] . "<br>";
            echo "发布时间：" . $row["time"] . "<br><br>";
        }
    } else {
        echo "没有已发布的活动消息。";
    }
}

// 使用示例
// 添加新的活动消息
addActivityMessage("暑期大促销", "7月1日-7月15日期间，所有商品均有低至5折的优惠！", "2021-06-30");

// 修改已有活动消息
updateActivityMessage(1, "国庆特惠", "10月1日-10月7日期间，所有商品额外享受8折优惠！", "2021-09-30");

// 删除已有活动消息
deleteActivityMessage(1);

// 查看已发布的活动消息列表
getActivityMessages();

// 关闭数据库连接
mysqli_close($connection);

?>

3. Front-end message push
In the front-end page of the mall, we can use JavaScript and Ajax to push event messages in real time. The following is a simple sample code that shows how to use Ajax to regularly request the server-side interface to obtain the latest activity message and display it on the page:

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script>
    function getLatestActivityMessage() {
        $.ajax({
            url: "get_latest_activity_message.php",
            success: function(response) {
                $("#latest-activity-message").html(response);
            }
        });
    }
    
    setInterval(getLatestActivityMessage, 5000);
</script>

<div id="latest-activity-message"></div>

On the server side, we can create a message called "get_latest_activity_message .php" file, used to process Ajax requests and return the latest activity message content:

<?php

// 连接数据库
$connection = mysqli_connect("localhost", "username", "password", "database");

if (!$connection) {
    die("数据库连接失败: " . mysqli_connect_error());
}

// 获取最新的活动消息
$query = "SELECT content FROM activity_messages WHERE status='published' ORDER BY time DESC LIMIT 1";
$result = mysqli_query($connection, $query);

if (mysqli_num_rows($result) > 0) {
    while ($row = mysqli_fetch_assoc($result)) {
        echo $row["content"];
    }
} else {
    echo "暂无最新的活动消息。";
}

// 关闭数据库连接
mysqli_close($connection);

?>

Through the above code example, we can implement a simple mall activity message push function. Administrators can use the backend management system to publish event messages, and the front-end page will regularly request the latest event messages from the server and display them.

4. Summary
This article discusses the design ideas of the mall activity message push function developed in PHP, and provides relevant code examples. Through reasonable database design and development of backend management system, we can easily publish and manage event messages. At the same time, by using Ajax to request the server-side interface in real time and display the latest activity news on the front-end page, it can increase user participation and purchase intention. I hope this article will be helpful to everyone when implementing the mall event message push function.

The above is the detailed content of Design ideas for the mall event message push function developed in PHP. For more information, please follow other related articles on the PHP Chinese website!