php超市管理系统

try {
    $conn = new PDO("mysql:host=your_host;dbname=your_db", "your_user", "your_password");
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}

function checkStock($productId, $quantity) {
    global $conn;
    $stmt = $conn->prepare("SELECT stock FROM products WHERE id = :productId");
    $stmt->bindParam(':productId', $productId);
    $stmt->execute();
    $row = $stmt->fetch(PDO::FETCH_ASSOC);
    if ($row['stock'] < $quantity) {
        return false;
    }
    return true;
}

<?php
// 数据库连接
try {
    $conn = new PDO("mysql:host=your_host;dbname=your_db", "your_user", "your_password");
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}

// 添加商品
function addProduct($name, $price, $stock) {
    global $conn;
    $stmt = $conn->prepare("INSERT INTO products (name, price, stock) VALUES (:name, :price, :stock)");
    $stmt->bindParam(':name', $name);
    $stmt->bindParam(':price', $price);
    $stmt->bindParam(':stock', $stock);
    $stmt->execute();
}

// 查询商品
function getProducts() {
    global $conn;
    $stmt = $conn->query("SELECT * FROM products");
    return $stmt->fetchAll(PDO::FETCH_ASSOC);
}

// 更新商品库存
function updateStock($productId, $newStock) {
    global $conn;
    $stmt = $conn->prepare("UPDATE products SET stock = :newStock WHERE id = :productId");
    $stmt->bindParam(':newStock', $newStrategy);
    $stmt->bindParam(':productId', $productId);
    $stmt->execute();
}

// 删除商品
function deleteProduct($productId) {
    global $conn;
    $stmt = $conn->prepare("DELETE FROM products WHERE id = :productId");
    $stmt->bindParam(':productId', $productId);
    $stmt->execute();
}
?>