织梦删除数据库文章

// 示例代码：删除文章
function deleteArticle($articleId) {
    $db = new PDO('mysql:host=localhost;dbname=dedecms', 'username', 'password');
    $stmt = $db->prepare("DELETE FROM `dede_archives` WHERE `id` = :articleId");
    $stmt->bindParam(':articleId', $articleId);
    $stmt->execute();
}

// 示例代码：删除文章及其关联数据
function deleteArticleWithRelations($articleId) {
    $db = new PDO('mysql:host=localhost;dbname=dedecms', 'username', 'password');
    $db->beginTransaction();
    try {
        // 删除文章
        $stmt = $db->prepare("DELETE FROM `dede_archives` WHERE `id` = :articleId");
        $stmt->bindParam(':articleId', $articleId);
        $stmt->execute();

        // 删除关联评论
        $stmt = $db->prepare("DELETE FROM `dede_comment` WHERE `aid` = :articleId");
        $stmt->bindParam(':articleId', $articleId);
        $stmt->execute();

        // 删除关联附件
        $stmt = $db->prepare("DELETE FROM `dede_addonarticle` WHERE `aid` = :articleId");
        $stmt->bindParam(':articleId', $articleId);
        $stmt->execute();

        $db->commit();
    } catch (Exception $e) {
        $db->rollBack();
        throw $e;
    }
}