如何在PHP中删除图片？

Question

如何在PHP中删除图片？

3

我正在尝试在一个ajax php文件中删除一张图片。我有以下代码：

<?php
define('IS_AJAX', true);   

$id = $db->real_escape_string($_GET['photo_id']);    
$files = $db->query("SELECT * FROM uploaded_photos WHERE id=".$id);        
$files = $files->fetch_object();

$file = $files->path;

if($file){    
unlink("../uploads/".$file);    
$db->query("DELETE FROM uploaded_photos WHERE id='".$id);

}

在这种情况下，"path"指的是图像，例如1.jpg。它确实删除了表格行，但它并没有删除上传文件夹中的图像。希望有人能帮助我解决这个问题。提前感谢您的努力。

- Aurora

3

可能存在两个问题：1. Apache/php 没有正确的权限来删除文件。2. 传递给函数的文件名不正确，因此请检查 $file 变量，并确保它相对于工作目录是正确的。 - Cave Johnson

1

unlink在失败时应生成E_WARNING级别的错误。您的日志中是否有相应的记录？ - Ivan Burlutskiy

@ Andrew - 我已经检查了文件名，是正确的。我不知道是 PHP 还是 Apache 拥有正确的权限，我该如何检查呢？ - Aurora

你可能需要使用类似于if(is_file($filename = "../uploads/".$file)) unlink($filename); else die('File not found at '.$filename);的语句来检查文件是否存在于你认为的位置。 - Rasclatt

@Shpionus 我的错误日志中没有 e_warning。 - Aurora

显示剩余7条评论

1个回答

网页内容由stack overflow 提供, 点击上面的

可以查看英文原文，
原文链接

- Poiz · Accepted Answer

您可能需要重新检查您的代码。您有一个未关闭的单引号。请参见下面的代码...

        define('IS_AJAX', true);

        $id     = $db->real_escape_string($_GET['photo_id']);
        $files  = $db->query("SELECT * FROM uploaded_photos WHERE id=".$id);
        $files  = $files->fetch_object();

        $file   = $files->path;

        // NOTE THAT if($file) WOULD ALMOST ALWAYS RETURN TRUE SO LONG AS IT CONTAINS ANY STRING
        // HOWEVER file_exists WILL CHECK IF THE FILE PHYSICALLY EXIST ON THE PATH/LOCATION OR NOT.
        // PREFER file_exists IN THIS SCENARIO INSTEAD.
        if(file_exists("../uploads/" . $file)){
            // CHANGE THE FILE PERMISSION ON THE IMAGE SO THAT YOU CAN WORK WITH IT...
            chmod("../uploads/" . $file, 0755);   // <== GIVES YOU PERMISSION TO DEAL WITH THE FILE...
            unlink("../uploads/".$file);
            // BY THE WAY;  HERE IS A PROBLEM... YOU HAVE AN UNCLOSED SINGLE QUOTE AFTER THE EQUAL SIGN.
            // I REALLY WONDER HOW THE TABLE ROW DELETES WITH THE TYPO...
            // TRY REMOVING OR COMPLETING IT THOUGH:        
            //$db->query("DELETE FROM uploaded_photos WHERE id='".$id);   <=== SEE THAT SINGLE QUOTE AFTER "=" THERE? THAT'S YOUR ENEMY.
            $db->query("DELETE FROM uploaded_photos WHERE id=".$id);
        }

更新：不带评论

    <?php

        define('IS_AJAX', true);

        $id     = $db->real_escape_string($_GET['photo_id']);
        $files  = $db->query("SELECT * FROM uploaded_photos WHERE id='{$id}'" );
        $files  = $files->fetch_object();       
        $file   = $files->path;

        if(file_exists("../uploads/" . $file)){
            chmod("../uploads/" . $file, 0777); 
            unlink("../uploads/".$file);    
            $db->query("DELETE FROM uploaded_photos WHERE id='{$id}'");
        }