Functional Guide to Implementing Product Inventory Tracking and Traceability with PHP

PHP functional guide to implement commodity inventory tracking and tracing

Introduction:
With the rapid development of e-commerce, commodity inventory management has become a must Few tasks. For e-commerce platforms or physical stores, it is very important to be able to accurately track product inventory, which can help them effectively manage inventory and avoid sell-outs and overstocking. This article will introduce how to use PHP language to implement the function of commodity inventory tracking and tracing.

1. Create database table
   First, we need to create a database table to store product information and inventory quantities. You can use the following SQL statement to create a table named "products":

CREATE TABLE products (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    quantity INT NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

2. Connect to the database
   Use the following code example to connect to the database:

$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = mysqli_connect($servername, $username, $password, $dbname);

if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

3. Add items to the database
   Use the following code example to add item information and inventory quantities to the database:

$name = "iPhone 12";
$quantity = 10;

$sql = "INSERT INTO products (name, quantity) VALUES ('$name', $quantity)";

if (mysqli_query($conn, $sql)) {
    echo "Product added successfully";
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

4. Update item inventory
   Use the following code example to update The inventory quantity of goods in the database:

$id = 1;
$quantity = 5;

$sql = "UPDATE products SET quantity = $quantity WHERE id = $id";

if (mysqli_query($conn, $sql)) {
    echo "Product quantity updated successfully";
} else {
    echo "Error updating product quantity: " . mysqli_error($conn);
}

5. Query the inventory of goods
   Use the following code example to query the stock quantity of goods in the database:

$sql = "SELECT * FROM products WHERE id = $id";
$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {
    $row = mysqli_fetch_assoc($result);
    echo "Product: " . $row["name"] . "<br>";
    echo "Quantity: " . $row["quantity"] . "<br>";
} else {
    echo "Product not found";
}

6. Delete Item
   Use the following code example to delete an item from the database:

$id = 1;

$sql = "DELETE FROM products WHERE id = $id";

if (mysqli_query($conn, $sql)) {
    echo "Product deleted successfully";
} else {
    echo "Error deleting product: " . mysqli_error($conn);
}

7. Close the database connection
   Use the following code example to close the database connection:

mysqli_close($conn);

Conclusion:
Through the above code example, we can realize the function of product inventory tracking and tracing. Using PHP language to operate the database can help us manage the inventory quantity of products and easily query, update and delete product information. Effective inventory management can improve the controllability and sales efficiency of the product life cycle, and bring better operational results to e-commerce platforms and physical stores.

The above is the detailed content of Functional Guide to Implementing Product Inventory Tracking and Traceability with PHP. For more information, please follow other related articles on the PHP Chinese website!