首页 > 解决方案 > 如何将两个图像取消链接在一起?

问题描述

在此功能下方,我确实取消了一张图片的链接。现在我想在这个函数中取消链接另一个图像,比如“ imagetwo ”。

如何在这个函数中为 unlink imagetwo编写代码?

public function nameDeleteById($data){

    $delete_id = $data['delete_id'];

    $stmt = $this->pdo->prepare("SELECT * FROM name WHERE id=:delete_id");
    $stmt->bindparam(":delete_id", $delete_id);
    $stmt->execute();

    if ($stmt) {
        while ($delimg=$stmt->fetch(PDO::FETCH_ASSOC)) {
            $dellink=$delimg['image'];
            unlink($dellink);
        }
    }
    $stmt=$this->pdo->prepare("DELETE FROM name WHERE id=:delete_id");
    $stmt->bindparam(":delete_id", $delete_id);
    $stmt->execute();
    if ($stmt) {
        $msg = 'Name Deleted Secessfully';
        return $msg;
    } else {
        $msg = 'Name Not Deleted Secessfully';
        return $msg;
    }
}

标签: phpmysqlfunctionpdo

解决方案


从你的问题中不清楚,imagetwo究竟是什么。我假设它是表中的另一列name(?)。如果是这样,您可以像这样增强您的功能:

public function nameDeleteById($data){

    $delete_id = $data['delete_id'];

    $stmt = $this->pdo->prepare("SELECT * FROM name WHERE id=:delete_id");
    $stmt->bindparam(":delete_id", $delete_id);
    $stmt->execute();

    if ($stmt) {
        while ($delimg=$stmt->fetch(PDO::FETCH_ASSOC)) {
            unlink($delimg['image']);
            unlink($delimg['imagetwo']);
        }
    }
    $stmt=$this->pdo->prepare("DELETE FROM name WHERE id=:delete_id");
    $stmt->bindparam(":delete_id", $delete_id);
    $stmt->execute();
    if ($stmt) {
        $msg = 'Name Deleted Successfully';
        return $msg;
    } else {
        $msg = 'Name Not Deleted Successfully';
        return $msg;
    }
}

推荐阅读