Laravel array to string conversion (API store in DATABASE) Json

Question

When I get info from API and want to fill it in my database, I get an error:

array to string conversion

Note: My table is json type for array from database.

Controller:

    public function fetch()
    {

        $response = Http::get('some api');
        $countries = json_decode($response, true);


        foreach ($countries as $country)
        {
            $api = new Country();
            $api['code'] = $country['code'];
            $api['name'] = ['en' => $country['name']['en'], 'ka' => $country['name']['ka']];

            $api->save();
        }

        return 'DONE';
    }

I laso tried otherwise, like, json_decode($reponse->body()) and then $api->name = $country->name->en and etc...

Paul T. · Accepted Answer · 2022-05-21 23:07:28Z

2

I believe that this save handling alternative should work:

foreach ($countries as $country)
{
    $api = new Country();
    $api->code = $country['code'];
    $api->name = json_encode(['en' => $country['name']['en'], 'ka' => $country['name']['ka']]);

    $api->save();
}

edited May 21, 2022 at 23:07

answered May 21, 2022 at 22:53

Paul T.

5,02712 gold badges48 silver badges64 bronze badges

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

Collectives™ on Stack Overflow

Laravel array to string conversion (API store in DATABASE) Json

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related