doudong3570 2014-12-30 12:34
浏览 63
已采纳

Codeigniter - 取消链接删除文件不起作用

I have a problem with unlink or delete file with codeigniter

Here is my controller

function delete($id_post=''){
    $this->home_model->delete($id_post);
    $this->session->set_flashdata('danger', "Your photo has been deleted...");
    redirect("home");
}

And this is my model

function delete($id_post=''){
    $file_name = $this->db->query("SELECT doc FROM post WHERE post.id_post='$id_post'");
    unlink(base_url("uploads/" . $file_name));
    $sql  = "DELETE FROM post WHERE id_post=?";
    $outp = $this->db->query($sql,array($id_post));
}

Doc is the name of column that contain image.

If i click button delete, it delete a data in database and works successfully but not the image in file folder. I want, when i delete a data it is also delete image in file folder uploads. Uploads folder is in the root aplication system.

Any answer?

Many thanks...

  • 写回答

7条回答 默认 最新

  • douyou2048 2014-12-30 12:39
    关注

    The query() function returns a database result object. So replace your model code with:

    function delete($id_post=''){
        $file_name = $this->db->query("SELECT doc FROM post WHERE post.id_post='$id_post'");
        $row = $file_name->row();
        $file_name = $row['doc'];
        unlink(base_url("uploads/" . $file_name));
        $sql  = "DELETE FROM post WHERE id_post=?";
        $outp = $this->db->query($sql,array($id_post));
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(6条)

报告相同问题?