Store array inside of array in db using laravel

Question

I have a common array from request named complemntartData[]. from that array i get some values.i need to store these data in db table field.i used implode function but it shows array to string conversion.


    if($request->input('complementaryData')){
       foreach($request->input('complementaryData') as $name => $value){
          $data = explode ("_", $name);
          $A = [];
          $B = [];
          if($data[0]=="TextField"){
            $B["id"] = $data[1];
            $A["TextField"] = &$B;
            $B["data"] = $value;
           }
           if($data[0]=="Archive"){
              $B["id"] = $data[1];
              $A["Archive"] = &$B;
              $B["data"] = $value;
           }
           if($data[0]=="MultipleChoice"){
              $B["id"] = $data[1];
              $A["MultipleChoice"] = &$B;
              $B["sub"] = $value;
           }
           $eventParticipants->complementaryData = implode(',',$A);
           //dd($eventParticipants->complementaryData);
        }
   }

Peter Szalay · Accepted Answer · 2020-04-27T07:48:45.883

0

implode(',', $A['Archive']);

The error comes from you passing a multidimensional array to implode: implode-data-from-a-multi-dimensional-array

Also if you want to store array data in single field, I would rather use serialize: serialize($A) can be easily unpacked using the unserialize() function

edited Apr 27 '20 at 07:48

answered Apr 27 '20 at 07:30

Peter Szalay

376
3
13

i only gets the last if not the all if – Sindhu Diya Apr 27 '20 at 07:50
the implode and seralize is working only for the last if – Sindhu Diya Apr 27 '20 at 07:54
$complementaryData = [ "TextField_123" => "hhhhhhh", "Archive_131" => "pink.jpg", "MultipleChoice_132" => "arar" ]; print_r(serialize(*A)); – Peter Szalay Apr 27 '20 at 08:17
You should only get the last one, because you are looping through $request->input('complementaryData') with a foreach. $A = []; shoud be before the foreach loop, if you want all key values in one. – Peter Szalay Apr 27 '20 at 08:21
$A = [];foreach($complementaryData as $name => $value){ – Peter Szalay Apr 27 '20 at 08:22
I presume $request->input('complementaryData') is the array in the image. You are looping through it by key value, but your array $A is recreated at the beginning of each loop as an empty array. – Peter Szalay Apr 27 '20 at 08:32

Store array inside of array in db using laravel

1 Answers1