How to insert an array in MySQL table with Laravel ORM

Question

I am trying to insert an entire api response into a MySQL table using Laravel Eloquent but I am getting 'Array to string conversion' error. How do I solve this?

Please note, it is compulsory that I save the entire API response.

My API call

$response = Curl::to($url.$request->account_number)
                    ->withData($data)
                    ->asJson(true)
                    ->get();

My Query

 TransactionLog::create([
                        'payer' => $request->payer,
                        'amount' => $request->amount,
                        'phone' => $request->phone,
                        'response' => $response

                    ]);

Seva Kalashnikov · Accepted Answer · 2017-11-15 19:13:58Z

1

Looks like you using ixudra/curl ?

With asJson(true) you will receive json_decode response, so if your plan is to save raw json response in the database you'll have to json_encode it like:

TransactionLog::create([
  'payer' => $request->payer,
  'amount' => $request->amount,
  'phone' => $request->phone,
  'response' => json_encode($response)
]);

answered Nov 15, 2017 at 19:13

Seva Kalashnikov

4,4522 gold badges26 silver badges37 bronze badges

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

Collectives™ on Stack Overflow

How to insert an array in MySQL table with Laravel ORM

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