Second-hand recycling website developed using PHP supports popular tag filtering

The second-hand recycling website developed using PHP supports popular tag screening

With the development of society and the improvement of environmental awareness, the market demand for second-hand recycling is growing day by day. In order to make it easier for users to find the items they need and improve user experience, we decided to add a popular tag filtering function to the second-hand recycling website. Users can quickly find related second-hand items based on the tags they are interested in. This article will take you through how to develop this function using PHP.

First, we need to store the label information of the product in the database. We can create a table named tags, which contains two fields: tag_id and tag_name, which are used to store the unique identifier and tag name of the tag respectively. In addition, we also need to create a table named product_tags to store the relationship between products and tags. This table contains two fields: product_id and tag_id, which are used to store the unique identifier of the product and the corresponding tag respectively.

Next, we need to add the tag filtering function to the product list page. First, we get all the tags from the database and display them on the page for the user to select. Then, when the user selects one or more tags, we store the unique identifiers of those tags in an array. Finally, we query the database based on the tags selected by the user, find matching products and display them on the page.

The following is a simple sample code to implement the above functions:

<?php
// 连接数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("连接数据库失败: " . $conn->connect_error);
}

// 获取所有标签
$sql = "SELECT tag_id, tag_name FROM tags";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    echo "<form action='product_list.php' method='GET'>";
    while ($row = $result->fetch_assoc()) {
        $tag_id = $row['tag_id'];
        $tag_name = $row['tag_name'];
        echo "<input type='checkbox' name='tags[]' value='$tag_id'>$tag_name ";
    }
    echo "<button type='submit'>筛选</button>";
    echo "</form>";
}

// 处理筛选结果
if (isset($_GET['tags'])) {
    $selected_tags = $_GET['tags'];
    
    $sql = "SELECT p.* FROM products p
    INNER JOIN product_tags pt ON p.product_id = pt.product_id
    WHERE pt.tag_id IN (" . implode(",", $selected_tags) . ")";
    
    $result = $conn->query($sql);
    
    if ($result->num_rows > 0) {
        // 显示筛选结果
        while ($row = $result->fetch_assoc()) {
            echo $row['product_name'];
        }
    } else {
        echo "没有找到匹配的商品。";
    }
}

$conn->close();
?>

In the above code, we first connect to the database and query all tags. Then, display these tags on the page and create a form to get the user's selected tags. When the user clicks the filter button, we construct the unique tag ID obtained into a query statement and query the matching products. Finally, we display the matching products on the page.

Through the above code example, we can implement the function of supporting popular tag filtering on a second-hand recycling website developed using PHP. Users can select the tags of interest based on their own needs and quickly find related second-hand items. This not only improves the user experience, but also enables more efficient product inquiry and transactions.

The above is the detailed content of Second-hand recycling website developed using PHP supports popular tag filtering. For more information, please follow other related articles on the PHP Chinese website!