How to push an array value into database with Laravel 6?

Question

I want to add multiple values to a names column in my database. I've set the casts in the model to make this an array.

Controller

public function add() {
   $id = 1;
   $db = Article::find($id)->first();
   $start = $db->names;
   $db->names = array_push($db->names,'value');
}

Model

class Article extends Model
{
    protected $casts = [
        'names' => 'array'
    ];
}

This gives me an error message back Indirect modification of overloaded property App\Article::$names has no effect

How do I push (or remove) a value to the array in my database?

I think this is more a concept of OO. You need to create a setter and getter function for your column to modify them correctly. Similar to this: stackoverflow.com/questions/57100550/… — William Prigol Lopes
– William Prigol Lopes, Commented Nov 28, 2019 at 22:20

Danny Ebbers · Accepted Answer · 2019-11-28 22:56:11Z

1

This happens because the $db->name is not an array, it is an laravel eloquent magic property.

You can either

array_push($start, 'newvalue');
$db->names = $start;
$db->save();

Or use indeed a setter, laravel also offers a "Magic" method of defining model setters, as in mutators

See: https://laravel.com/docs/6.x/eloquent-mutators#defining-a-mutator

I would also consider, not using array push, if it's just a flat array

$originalArray = $db->names;
$originalArray[] = 'Additional Value';
$db->names = $originalArray;
$db->save();

Would work the same, and might be easyer to read.

edited Nov 28, 2019 at 22:56

answered Nov 28, 2019 at 22:38

Danny Ebbers

9195 silver badges11 bronze badges

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

5 Comments

n212 Over a year ago

Hi, thank you for your answer. I tried the first thing and it seems to store the number "2" instead of pushing it to the existing array in the database. Do you know why this is?

Danny Ebbers Over a year ago

Yes, i actually worked from your sample. But array_push does not return the new array but, the actual number of elements on the array. The first argument is modifed by reference: see php.net/manual/en/function.array-push.php

Arcesilas Over a year ago

What about using array_merge instead? $db->names = array_merge($db->names, ['newValue']);

n212 Over a year ago

@Arcesilas Thank you, that solution worked as well.

Danny Ebbers Over a year ago

Even more fancy, if you would have php 7.4 $db->names = [...$db->names, 'newValue'] laravel-news.com/…

Collectives™ on Stack Overflow

How to push an array value into database with Laravel 6?

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related