dede数据库操作类

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

// 示例代码：执行SQL查询
try {
    $sql = "SELECT * FROM dede_archives WHERE id = :id";
    $stmt = $pdo->prepare($sql);
    $stmt->bindParam(':id', $id, PDO::PARAM_INT);
    $stmt->execute();
    $result = $stmt->fetchAll(PDO::FETCH_ASSOC);
    print_r($result);
} catch (PDOException $e) {
    echo "SQL查询执行失败: " . $e->getMessage();
}

// 示例代码：插入数据
try {
    $sql = "INSERT INTO dede_archives (title, content) VALUES (:title, :content)";
    $stmt = $pdo->prepare($sql);
    $stmt->bindParam(':title', $title, PDO::PARAM_STR);
    $stmt->bindParam(':content', $content, PDO::PARAM_STR);
    $stmt->execute();
    echo "数据插入成功";
} catch (PDOException $e) {
    echo "数据插入失败: " . $e->getMessage();
}