ecshop数据库操作

<?php
// 数据库连接配置
$db_host = 'localhost';
$db_user = 'root';
$db_pass = 'password';
$db_name = 'ecshop';

try {
    // 创建PDO实例
    $pdo = new PDO("mysql:host=$db_host;dbname=$db_name", $db_user, $db_pass);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    // 插入数据
    $stmt = $pdo->prepare("INSERT INTO ecs_goods (goods_name, goods_price) VALUES (:name, :price)");
    $stmt->bindParam(':name', $goods_name);
    $stmt->bindParam(':price', $goods_price);
    $goods_name = 'Example Product';
    $goods_price = 100.00;
    $stmt->execute();

    // 查询数据
    $stmt = $pdo->query("SELECT * FROM ecs_goods WHERE goods_id = 1");
    $row = $stmt->fetch(PDO::FETCH_ASSOC);
    echo "Product Name: " . $row['goods_name'] . ", Price: " . $row['goods_price'];

    // 更新数据
    $stmt = $pdo->prepare("UPDATE ecs_goods SET goods_price = :price WHERE goods_id = 1");
    $stmt->bindParam(':price', $new_price);
    $new_price = 120.00;
    $stmt->execute();

    // 删除数据
    $stmt = $pdo->prepare("DELETE FROM ecs_goods WHERE goods_id = 1");
    $stmt->execute();
} catch (PDOException $e) {
    echo "Database error: " . $e->getMessage();
}
?>