微擎模块开发数据库

// 示例代码：检查数据库连接
try {
    $db = new PDO('mysql:host=localhost;dbname=test', 'username', 'password');
    echo "数据库连接成功";
} catch (PDOException $e) {
    echo "数据库连接失败: " . $e->getMessage();
}

// 示例代码：插入数据
try {
    $stmt = $db->prepare("INSERT INTO users (name, email) VALUES (:name, :email)");
    $stmt->bindParam(':name', $name);
    $stmt->bindParam(':email', $email);
    $name = 'John Doe';
    $email = 'john@example.com';
    $stmt->execute();
    echo "数据插入成功";
} catch (PDOException $e) {
    echo "数据插入失败: " . $e->getMessage();
}

// 示例代码：查询数据
try {
    $stmt = $db->prepare("SELECT * FROM users WHERE id = :id");
    $stmt->bindParam(':id', $id);
    $id = 1;
    $stmt->execute();
    $result = $stmt->fetchAll(PDO::FETCH_ASSOC);
    if (empty($result)) {
        echo "查询结果为空";
    } else {
        print_r($result);
    }
} catch (PDOException $e) {
    echo "查询失败: " . $e->getMessage();
}