How I can insert array data in laravel?

Question

I want to insert data by seeder:

public function run()
    {
        $projects = [
            [
                "name" => "project-one",
                "images" => ["image11.jpg", "image12.jpg", "image13.jpg"],
            ],
            [
                "name" => "project-two",
                "images" => ["image21.jpg", "image22.jpg", "image23.jpg"],
            ],
        ];

        Project::insert($projects);
}

images column is JSON, I get an array error on images insertion. How I can insert them?

Muhammad Dyas Yaskur · Accepted Answer · 2022-01-06 07:50:16Z

1

insert() method can not use any casts of the model, it will be inserted as raw. So you just need to convert the array to a json using json_encode() function.

public function run()
{
    $projects = [
        [
            "name" => "project-one",
            "images" => json_encode(["image11.jpg", "image12.jpg", "image13.jpg"]),
        ],
        [
            "name" => "project-two",
            "images" => json_encode(["image21.jpg", "image22.jpg", "image23.jpg"]),
        ],
    ];

    Project::insert($projects);
}

answered Jan 6, 2022 at 7:50

Muhammad Dyas Yaskur

8,35811 gold badges62 silver badges91 bronze badges

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

Collectives™ on Stack Overflow

How I can insert array data in laravel?

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related