删除评论和相关图像

Question

I'm trying to delete single user comments and the pictures related with them, by deleting them from both the database records and storage. Unfortunately I keep getting errors. Below is the code I have so far.

Tables: Comments: id, comment, user_id, person_id pictures: id, image, comment_id, user_id, person_id

Relationships: Comment:

public function pictures()
{
    return $this->hasMany('App\Picture', 'comments_id', 'id');
} 

pictures:

   public function comments()
    {
        return $this->belongsTo('App\Comment', 'comments_id');
    }

Controller:

public function destroy($id)
{
    $comment = Comment::find($id);
    Storage::delete($comment->pictures());

    $comment->delete();
    Session::flash('success', 'Your comment and pictures were deleted');

    return redirect()->route('home');
} 

Any ideas?

Answer 1

You need to use pluck() to load images file names:

$files = $comment->pictures()->pluck('filename');

Then delete these files:

foreach ($files as $file) {
    Storage::delete(storage_path('images/' . $file));
}

This is just an example, you need to put correct column name instead of filename and build the correct path to the images.

To delete images from DB:

$comment->images()->delete();