Laravel - How to save an Array to Database

Question

I have an array like this :

array:4 [▼
  "*name1*" => 1
  "*name2*" => 1
  "*name3*" => 2
  "*name4*" => 1
]

And I have an table Item with 'id'; 'name'; 'time'

Then how to I can save this array into Item Table using Laravel ?

I already do this but I know it's not working. But I don't know how to save it

foreach ($data_participant[$i]['attributes']['stats']['itemGrants'] as $key => $value) {
      $itemGrants = new ItemGrant;
      $itemGrants->item = $key;
      $itemGrants->time = $value;

      $itemGrants->save();
}

What's the error ? or array $data_participant[$i]['attributes']['stats']['itemGrants'] might be empty ? — Sagar Gautam
– Sagar Gautam, Commented Jul 30, 2017 at 6:23
Is ItemGrant is an eloquent model?If yes, which table is represented by the model? — Shafi
– Shafi, Commented Jul 30, 2017 at 6:27
Hello @SagarGautam : No it's not empty. It's array as I was writing above. There is no error happens. But it not save to database. — Nguyen Hoang
– Nguyen Hoang, Commented Jul 30, 2017 at 6:28
Hello @MASh : Yes, it's an eloquent model. The table is "Item" as I was writing. — Nguyen Hoang
– Nguyen Hoang, Commented Jul 30, 2017 at 6:31
Hello all guys, this is my mistake. I forgot check my grammar table name in protected $table. My bad. I'm sorry. Thank for your time. — Nguyen Hoang
– Nguyen Hoang, Commented Jul 30, 2017 at 6:47

Luuklag · Accepted Answer · 2018-09-11 11:23:02Z

6

Just simply use json_encode function to convert from array to JSON string. You may refer to this link for further information.

For example, convert your array to JSON string format:

$array = ["name"=>1,"name2"=>2,"name3"=>3];
$json_array = json_encode($array);

Now, the output will be a JSON string:

[{"name":"1"},{"name2":"2"},{"name":"3"}];

You can save it to a database as a string in JSON format.

If you want the data back in an array, then you have to decode. For example:

$string_json = "[{"name":"1"},{"name2":"2"},{"name":"3"}]";    
$array_output = json_decode($string_json,true);

Note the true boolean parameter passed to json_decode, this is important as without it json_decode will return an array of stdObject rather than an associative array.

Now, you can get back the array as your input.

edited Sep 11, 2018 at 11:23

Luuklag

3,91412 gold badges40 silver badges59 bronze badges

answered Jul 30, 2017 at 6:26

Nere

4,0956 gold badges36 silver badges75 bronze badges

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

Collectives™ on Stack Overflow

Laravel - How to save an Array to Database

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