How to use PHP to write inventory query function code in the inventory management system

How to use PHP to write the inventory query function code in the inventory management system

Introduction:
For an inventory management system, the inventory query function is very important. It can help us quickly understand the inventory situation, grasp inventory changes, and provide timely inventory reports. In this article, we will use PHP to write a simple inventory query function code example to help readers understand how to implement this function.

1. Create a database table
First, we need to create a database table to store inventory information. Suppose our table is named "inventory" and contains the following fields:

• id (primary key, auto-increment)
• name (product name)
• quantity (inventory Quantity)
• price (commodity price)
  You can use the following SQL statement to create this table:

CREATE TABLE inventory (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(255) NOT NULL,
quantity int(11) NOT NULL,
price decimal(10,2) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

2. Connect to the database
At the beginning of the code, we need to connect to the database so that we can perform subsequent inventory query operations. You can use the following code to connect to the database:

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "inventory_db";

// Create database connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check Whether the connection is successful
if ($conn->connect_error) {

die("连接数据库失败: " . $conn->connect_error);

}

echo "Successfully connected to the database!";
?>

Please note that you need to modify the values ​​of $servername, $username, $password and $dbname according to your actual situation.

3. Write the code for the inventory query function
Now we can write the code for the inventory query function. First, we need to get the inventory information from the database and display it on the web page. You can use the following code to achieve this:

// Query inventory information
$sql = "SELECT * FROM inventory";
$result = $conn->query ($sql);

if ($result->num_rows > 0) {

// 输出每一行的数据
while($row = $result->fetch_assoc()) {
    echo "商品名称: " . $row["name"]. " - 库存数量: " . $row["quantity"]. " - 商品价格: $" . $row["price"]. "
";
}

} else {

echo "没有库存信息";

}

// Close the database connection
$conn->close();
?>

This code executes a simple SELECT query statement and obtains all the "inventory" table from the database data. Then, the data of each row is output through a loop, including product name, inventory quantity and product price.

Conclusion:
Through the above code examples, we have learned how to use PHP to write inventory query function code in the inventory management system. This simple example gives a basic framework that you can modify and extend according to your own needs. I hope this article will help you understand how to write the inventory query function!

The above is the detailed content of How to use PHP to write inventory query function code in the inventory management system. For more information, please follow other related articles on the PHP Chinese website!