Home > Article > Backend Development > How to use PHP to write price adjustment function code in inventory management system
How to use PHP to write price adjustment function code in inventory management system
- PHPzOriginal
- 2023-08-07 17:01:051084browse
How to use PHP to write price adjustment function code in an inventory management system
In an inventory management system, commodity prices often need to be adjusted to adapt to market demand and changes. This requires us to implement a price adjustment function in the system to facilitate administrators to modify and update product prices. In this article, we will explain how to code the price adjustment function in an inventory management system using PHP and provide some code examples.
First, we need to create a page in the system to display product information and price adjustment functions. This page can be designed and laid out using HTML and CSS. This page can include a table showing the name of the item, its current price, and input boxes for adjusting the price.
<!DOCTYPE html>
<html>
<head>
<title>库存管理系统 - 价格调整</title>
<style>
/* CSS样式 */
</style>
</head>
<body>
<h1>库存管理系统</h1>
<h2>价格调整</h2>
<table>
<thead>
<th>商品名称</th>
<th>当前价格</th>
<th>调整价格</th>
</thead>
<tbody>
<!-- 商品信息以及价格调整输入框 -->
</tbody>
</table>
<!-- 其他页面元素 -->
</body>
</html>Next, we need to process the user’s adjustment of the product price. We can use PHP to receive and process the form data and save the updated prices to the database. Assume that our product information is stored in a database table named products, and there is a column named price used to store product prices.
<?php
// 连接数据库
$con = mysqli_connect("localhost", "username", "password", "database");
// 检查连接是否成功
if (mysqli_connect_errno()) {
echo "连接数据库失败: " . mysqli_connect_error();
}
// 处理价格调整表单的提交
if ($_SERVER["REQUEST_METHOD"] == "POST") {
// 获取商品ID和调整后的价格
$productID = $_POST["product_id"];
$newPrice = $_POST["new_price"];
// 更新商品价格
$query = "UPDATE products SET price = $newPrice WHERE id = $productID";
$result = mysqli_query($con, $query);
// 检查查询是否成功
if ($result) {
echo "价格调整成功！";
} else {
echo "价格调整失败：" . mysqli_error($con);
}
}
// 获取商品信息并显示在表格中
$query = "SELECT * FROM products";
$result = mysqli_query($con, $query);
if ($result) {
while ($row = mysqli_fetch_assoc($result)) {
echo "<tr>";
echo "<td>" . $row["name"] . "</td>";
echo "<td>" . $row["price"] . "</td>";
echo "<td>";
echo "<form method='POST' action=''>";
echo "<input type='hidden' name='product_id' value='" . $row["id"] . "'>";
echo "<input type='number' name='new_price' step='0.01'>";
echo "<input type='submit' value='调整价格'>";
echo "</form>";
echo "</td>";
echo "</tr>";
}
} else {
echo "获取商品信息失败：" . mysqli_error($con);
}
// 关闭数据库连接
mysqli_close($con);
?>We will put this PHP code into the appropriate position of the previously created HTML page to complete the entire price adjustment function. Users can enter new prices into the form and click the "Adjust Price" button to submit the form. The system will receive the form data and update the price of the corresponding product. The user will then see a success or failure message.
Summary:
This article introduces how to use PHP to write the price adjustment function code in the inventory management system. By creating a page to display product information and price adjustment functions, and using PHP to receive and process form data, we can easily modify and update product prices. With this code example, you can add price adjustment functionality to your inventory management system to make your system more flexible and easier to use.
The above is the detailed content of How to use PHP to write price adjustment function code in inventory management system. For more information, please follow other related articles on the PHP Chinese website!