Deleting an Item from array of a table column in Laravel

Question

There is a Posts table that has a column named images. in images I store data as JSON array as:

["p1.jpg", "p2.jpg","p4.jpg","p9.jpg","p11.jpg", "p12.jpg","p13.jpg", "p14.jpg"];

I want to delete one of these images by ajax. I send the id and image by ajax and get that id and image in the controller correctly:

  public function remove() {

$imgs = Image::where('id', request()->id)->pluck('images');
return $imgs;
  }

reults in console:
[Array(8)]
0: (8) ["p1.jpg", "p2.jpg", "p4.jpg", "p9.jpg", "p11.jpg", "p12.jpg", "p13.jpg", "p14.jpg"]
length: 1
__proto__: Array(0)

also, I get the image name by request()->img from ajax.

$image = request()->img; => p12.jpg

How I can delete the $image from $images array?

what is the field images store, a string like "p1.jpg" or a JSON array? — TsaiKoga
– TsaiKoga, Commented Feb 3, 2020 at 12:13
Just use an update query to overwrite the images column with the new array? — Jerodev
– Jerodev, Commented Feb 3, 2020 at 12:15
["p1.jpg", "p2.jpg","p4.jpg","p9.jpg","p11.jpg", "p12.jpg","p13.jpg", "p14.jpg"] — Mehdi Yaghoubi
– Mehdi Yaghoubi, Commented Feb 3, 2020 at 12:16

Foued MOUSSI · Accepted Answer · 2020-02-03 13:28:16Z

1

First You may cast images attr to array in your Image model

//App\Image
protected $casts = [
        'images' => 'array'
];

Then in your remove function :

public function remove() {
  if(request()->id && request()->img) {
     $imgModel = Image::findOrFail(request()->id);
     $imgs = $imgModel->images;

     // find request()->img position inside imgs array
     $position = array_search(request()->img, $imgs);

     // delete request()->img
     unset($imgs[$position]);

     $imgModel->images = array_values($imgs);
     $imgModel->save();
  }
}

edited Feb 3, 2020 at 13:28

answered Feb 3, 2020 at 12:31

Foued MOUSSI

4,8334 gold badges21 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Mehdi Yaghoubi Over a year ago

this return the index: foreach ($imgs as $v){ $position = array_search(request()->img, $v); } => 5 or ...

Foued MOUSSI Over a year ago

COuld you dump $imgs result and paste it here ?

Mehdi Yaghoubi Over a year ago

object(Illuminate\Support\Collection)#294 (1) { ["items":protected]=> array(1) { [0]=> array(8) { [0]=> string(6) "p1.jpg" [1]=> string(6) "p2.jpg" [2]=> string(6) "p4.jpg" [3]=> string(6) "p9.jpg" [4]=> string(7) "p11.jpg" [5]=> string(7) "p12.jpg" [6]=> string(7) "p13.jpg" [7]=> string(7) "p14.jpg" } } }

Mehdi Yaghoubi Over a year ago

yes. it worked. thank you Foued, you did great. it is the best solution in StackOverflow about deleting an item from an array.

Collectives™ on Stack Overflow

Deleting an Item from array of a table column in Laravel

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related