Home >Backend Development >PHP Tutorial >Second-hand recycling website developed in PHP provides product subscription recommendation function
Second-hand recycling website developed in PHP provides product subscription recommendation function
- 王林Original
- 2023-07-01 17:24:11580browse
The second-hand recycling website developed in PHP provides product subscription recommendation function
With the development of society, second-hand recycling has become a sustainable business model. In order to make it easier for users to browse and find the products they need, many second-hand recycling websites have begun to introduce subscription recommendation functions. In this article, we will explore how to use PHP to develop a second-hand recycling website with product subscription recommendation function.
First, we need to create a database to store user information and product information. The following is an example of SQL code to create a user table (user) and an item table (item):
CREATE TABLE user ( id INT(11) PRIMARY KEY AUTO_INCREMENT, email VARCHAR(255) NOT NULL, password VARCHAR(255) NOT NULL ); CREATE TABLE item ( id INT(11) PRIMARY KEY AUTO_INCREMENT, name VARCHAR(255) NOT NULL, description TEXT, price DECIMAL(10,2), category VARCHAR(255), user_id INT(11), FOREIGN KEY (user_id) REFERENCES user(id) );
Next, we need to create a subscription table (subscription), which will track the user's subscription information. Here is a sample SQL code to create a subscription table:
CREATE TABLE subscription ( id INT(11) PRIMARY KEY AUTO_INCREMENT, user_id INT(11), category VARCHAR(255), FOREIGN KEY (user_id) REFERENCES user(id) );
Now, we can start building the front-end and back-end functionality of the website. First, let's create a registration page (register.php) where users can register a new account. Here is a code example for register.php:
<?php
// 数据库连接和操作代码
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$email = $_POST['email'];
$password = $_POST['password'];
// 检查是否存在相同的email地址
$query = "SELECT * FROM user WHERE email = '$email'";
$result = mysqli_query($conn, $query);
if (mysqli_num_rows($result) > 0) {
echo "该邮箱已经被注册.";
} else {
// 将用户信息插入到数据库中
$query = "INSERT INTO user (email, password) VALUES ('$email', '$password')";
mysqli_query($conn, $query);
echo "注册成功.";
}
}
?>
<!DOCTYPE html>
<html>
<head>
<title>注册</title>
</head>
<body>
<h2>注册</h2>
<form method="POST" action="">
<input type="email" name="email" placeholder="邮箱" required><br>
<input type="password" name="password" placeholder="密码" required><br>
<input type="submit" value="注册">
</form>
</body>
</html>After successful registration, users will be able to log in to their account and subscribe to specific product categories.
The following is a code example for the website's login page (login.php):
<?php
// 数据库连接和操作代码
session_start();
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$email = $_POST['email'];
$password = $_POST['password'];
// 查找与提供的邮件和密码匹配的用户
$query = "SELECT * FROM user WHERE email = '$email' AND password = '$password'";
$result = mysqli_query($conn, $query);
if (mysqli_num_rows($result) > 0) {
// 将用户信息存储在session中
$_SESSION['email'] = $email;
header('Location: dashboard.php');
} else {
echo "无效的电子邮件或密码.";
}
}
?>
<!DOCTYPE html>
<html>
<head>
<title>登录</title>
</head>
<body>
<h2>登录</h2>
<form method="POST" action="">
<input type="email" name="email" placeholder="邮箱" required><br>
<input type="password" name="password" placeholder="密码" required><br>
<input type="submit" value="登录">
</form>
</body>
</html>After a successful login, the user will be redirected to their dashboard page (dashboard.php). On the dashboard page, users can choose to subscribe to specific product categories.
The following is a code example of dashboard.php:
<?php
// 数据库连接和操作代码
session_start();
if (!isset($_SESSION['email'])) {
header('Location: login.php');
}
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$category = $_POST['category'];
// 将用户的订阅信息插入到订阅表中
$email = $_SESSION['email'];
$query = "SELECT * FROM user WHERE email = '$email'";
$result = mysqli_query($conn, $query);
$user = mysqli_fetch_assoc($result);
$user_id = $user['id'];
$query = "INSERT INTO subscription (user_id, category) VALUES ('$user_id', '$category')";
mysqli_query($conn, $query);
echo "成功订阅该类别.";
}
?>
<!DOCTYPE html>
<html>
<head>
<title>仪表盘</title>
</head>
<body>
<h2>仪表盘</h2>
<form method="POST" action="">
<input type="checkbox" name="category" value="电子产品"> 电子产品<br>
<input type="checkbox" name="category" value="家具"> 家具<br>
<input type="checkbox" name="category" value="服装"> 服装<br>
<input type="submit" value="订阅">
</form>
</body>
</html>When users successfully subscribe to a product category, they will receive the latest notifications about products in that category.
Through the above sample code, we successfully developed a second-hand recycling website using PHP and added a product subscription recommendation function. Users can register and log in to their accounts and choose to subscribe to specific categories of products. This feature not only facilitates users' subscription needs, but also improves user experience and website usability. I hope this article can help everyone understand and develop websites with similar functions.
The above is the detailed content of Second-hand recycling website developed in PHP provides product subscription recommendation function. For more information, please follow other related articles on the PHP Chinese website!