The second-hand recycling website developed using PHP supports multi-warehouse management
With the progress of society and the enhancement of environmental awareness, second-hand recycling has gradually become an important part of people's lives. In order to better manage and operate a second-hand recycling website, it is very important to develop a website that supports multi-warehouse management. This article will introduce how to use PHP to develop a second-hand recycling website, support multi-warehouse management, and provide code examples.
First of all, we need to design the database structure to support multi-warehouse management. The following is a simplified database structure example, including three main tables: users, items, and warehouses.
User table (users):
ID | Username | Password | Warehouse ID |
---|---|---|---|
1 | user1 | 1234 | 1 |
2 | user2 | 5678 | 2 |
Item list (items):
ID | Name | Price | Quantity | Warehouse ID |
---|---|---|---|---|
1 | Item 1 | 20 | 5 | 1 |
Item2 | 30 | 10 | 2 |
Name | Address | |
---|---|---|
Warehouse 1 | Address 1 | |
Warehouse 2 | Address 2 |
// db_connect.php <?php $servername = "localhost"; $username = "root"; $password = "password"; $dbname = "database"; $conn = new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error) { die("连接失败:" . $conn->connect_error); } ?>
// get_warehouses.php <?php include "db_connect.php"; $sql = "SELECT * FROM warehouses"; $result = $conn->query($sql); if ($result->num_rows > 0) { $warehouses = array(); while ($row = $result->fetch_assoc()) { $warehouses[] = array( "id" => $row["ID"], "name" => $row["名称"], "address" => $row["地址"] ); } echo json_encode($warehouses); } else { echo "没有找到仓库数据"; } $conn->close(); ?>
// get_items.php <?php include "db_connect.php"; $warehouseId = $_GET["warehouseId"]; $sql = "SELECT * FROM items WHERE 仓库ID = $warehouseId"; $result = $conn->query($sql); if ($result->num_rows > 0) { $items = array(); while ($row = $result->fetch_assoc()) { $items[] = array( "id" => $row["ID"], "name" => $row["名称"], "price" => $row["价格"], "quantity" => $row["数量"] ); } echo json_encode($items); } else { echo "没有找到物品数据"; } $conn->close(); ?>
// login.php <?php include "db_connect.php"; $username = $_POST["username"]; $password = $_POST["password"]; $sql = "SELECT * FROM users WHERE 用户名 = '$username' AND 密码 = '$password'"; $result = $conn->query($sql); if ($result->num_rows > 0) { $row = $result->fetch_assoc(); $warehouseId = $row["仓库ID"]; header("Location: items.php?warehouseId=$warehouseId"); } else { echo "用户名或密码错误"; } $conn->close(); ?>
The above is the detailed content of Second-hand recycling website developed using PHP supports multi-warehouse management. For more information, please follow other related articles on the PHP Chinese website!