eloquent - Dealing with malfromed array errors in laravel

Question

I'm getting this error :

IlluminateDatabaseQueryException
SQLSTATE[22P02]: Invalid text representation: 7 ERROR: malformed array literal: "["5","7"]" DETAIL: "[" must introduce explicitly-specified array dimensions

whenever i'm trying to store the array input result to my postgres database.

This the lines of code in my controller:

$iitems=$request->input('parcel_items', []); 

$parcel->update(['parcel_items_sku' => $iitems]);

question from:https://stackoverflow.com/questions/65860460/dealing-with-malfromed-array-errors-in-laravel

Answer 1

you can convert your array to the string with json_encode and then save it, and when you want to use it you need to decode it with json_decode, that is a solution that can help you
So convert this

$iitems=$request->input('parcel_items', []); 
$parcel->update(['parcel_items_sku' => $iitems]);

To this

$iitems=$request->input('parcel_items', []); 
$parcel->update(['parcel_items_sku' => json_encode($iitems)]);