php mysql进销存完整源码

<?php
// 数据库连接
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "inventory_system";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 插入进货记录
function insertPurchase($product_id, $quantity, $price) {
    global $conn;
    $sql = "INSERT INTO purchases (product_id, quantity, price) VALUES (?, ?, ?)";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("idd", $product_id, $quantity, $price);
    if ($stmt->execute()) {
        echo "进货记录插入成功";
    } else {
        echo "Error: " . $sql . "<br>" . $conn->error;
    }
}

// 查询库存
function getStock($product_id) {
    global $conn;
    $sql = "SELECT quantity FROM stock WHERE product_id = ?";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("i", $product_id);
    $stmt->execute();
    $result = $stmt->get_result();
    if ($row = $result->fetch_assoc()) {
        return $row['quantity'];
    } else {
        return 0;
    }
}

// 示例调用
insertPurchase(1, 10, 50);
echo "当前库存: " . getStock(1);

$conn->close();
?>