Second-hand recycling website uses user favorites management function developed in PHP

The second-hand recycling website uses the user favorites management function developed by PHP

With the rise of the second-hand market, more and more people are beginning to buy second-hand items. In order to facilitate users to better manage the second-hand item information they are interested in, many second-hand recycling websites have begun to introduce user favorites management functions. This article will introduce how to use PHP to develop this function and give code examples.

1. Requirements Analysis

The user favorites management function needs to implement the following functions:

1. User login and registration: Users need to provide basic personal information, such as user name , password, etc. to register an account and log in through the login function.

2. Product collection: After logging in, users can collect second-hand products they are interested in in their favorites.

3. Favorites display: Users can view the list of their favorite products and manage them.

4. Clear Favorites: Users can choose to clear all products in Favorites.

2. Database design

In order to realize the user favorites management function, we need to design the corresponding database table. The following are two simple table designs:

1. User table (user):

CREATE TABLE user (
user_id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(50) NOT NULL,
password VARCHAR(50) NOT NULL
);

2. Favorite table (favorite):

CREATE TABLE favorite (
fav_id INT AUTO_INCREMENT PRIMARY KEY,
user_id INT NOT NULL,
item_id INT NOT NULL,
FOREIGN KEY (user_id) REFERENCES user(user_id),
FOREIGN KEY (item_id) REFERENCES item(item_id)
);

3. Code implementation

1. Login and registration functions:

session_start();
$conn = mysqli_connect("localhost", "root", "password", "database");

if(isset($_POST['login'])) {
    $username = $_POST['username'];
    $password = $_POST['password'];

    $query = "SELECT * FROM user WHERE username='$username' AND password='$password'";
    $result = mysqli_query($conn, $query);
    $row = mysqli_fetch_assoc($result);

    if(mysqli_num_rows($result) == 1) {
        $_SESSION['user_id'] = $row['user_id'];
        $_SESSION['username'] = $username;
        header("Location: favorite.php");
        exit();
    }
}

if(isset($_POST['register'])) {
    $username = $_POST['username'];
    $password = $_POST['password'];

    $query = "INSERT INTO user (username, password) VALUES ('$username', '$password')";
    $result = mysqli_query($conn, $query);

    if($result) {
        $_SESSION['user_id'] = mysqli_insert_id($conn);
        $_SESSION['username'] = $username;
        header("Location: favorite.php");
        exit();
    }
}

?>

2 .Product collection function:

session_start();
$conn = mysqli_connect("localhost", "root", "password", "database");

if(isset($_SESSION['user_id'])) {
    $user_id = $_SESSION['user_id'];

    if(isset($_POST['add_favorite'])) {
        $item_id = $_POST['item_id'];

        $query = "INSERT INTO favorite (user_id, item_id) VALUES ('$user_id', '$item_id')";
        mysqli_query($conn, $query);
    }
}

?>

3. Favorites display and management function:

session_start();
$conn = mysqli_connect("localhost", "root", "password", "database");

if(isset($_SESSION['user_id'])) {
    $user_id = $_SESSION['user_id'];

    $query = "SELECT * FROM favorite WHERE user_id='$user_id'";
    $result = mysqli_query($conn, $query);

    if(mysqli_num_rows($result) > 0) {
        while($row = mysqli_fetch_assoc($result)) {
            $item_id = $row['item_id'];

            // 根据item_id查询商品信息，展示到页面
            // ...

            // 删除收藏夹中的商品
            if(isset($_POST['remove_favorite'])) {
                $item_id = $_POST['item_id'];

                $delete_query = "DELETE FROM favorite WHERE user_id='$user_id' AND item_id='$item_id'";
                mysqli_query($conn, $delete_query);
            }
        }
    }

    // 清空收藏夹
    if(isset($_POST['clear_favorite'])) {
        $clear_query = "DELETE FROM favorite WHERE user_id='$user_id'";
        mysqli_query($conn, $clear_query);
    }
}

?>

IV. Summary

This article introduces how to use PHP to develop user favorites management functions. Through the login and registration functions, users can create their own accounts and log in. After logging in, users can collect products of interest and operate through the display and management functions. This simple and practical function can provide users with a better shopping experience for second-hand items.

The above is the detailed content of Second-hand recycling website uses user favorites management function developed in PHP. For more information, please follow other related articles on the PHP Chinese website!