Laravel Store/Insert Array Values to Database Mysql

Question

my problem here in my code is I cannot store or insert array values in Database MySQL, here is my controller code please help me. thank you. My Code in Controller has no array or any so.. I dont have any clue how to turn it into array.

Controller

    public function store(Request $request)
{
    $this->validate($request,[
        'city' => 'required'

    ]); 


   $citi = new City;
   $citi->city = $request->input('city');
   $citi->save();

   return redirect('/lugar')->with('success', 'Data Inserted');
}

View

<td> {{Form::text('city[]', '', ['class' => 'form-control name_list', 'placeholder' => 'Add Country'])}} </td>

here, see _Argument 1 passed to Illuminate\Database\Grammar::parameterize() must be of the type array, string given _ — user10665294
– user10665294, Commented Nov 24, 2018 at 22:54
Possible duplicate of Argument 1 passed to Illuminate\Database\Grammar::parameterize() must be of the type array, string given — George Udosen
– George Udosen, Commented Nov 24, 2018 at 23:01

Adis Azhar · Accepted Answer · 2018-11-25 00:52:58Z

0

You can't store arrays in MySQL, its different if you compared it with Mongo (NoSQL).

What you can do is, turn that array into a json string. So json_encode($request->city) and save it.

Then if you want to modify it's values once retrieved from DB, you can use json_decode($data->city) which turns it back to an array.

answered Nov 25, 2018 at 0:52

Adis Azhar

1,0221 gold badge20 silver badges37 bronze badges

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

Comments

kapitan · Accepted Answer · 2018-11-25 01:16:44Z

0

you can actually save this using serialize or json_encode.

Using serialize:

$citi->city = serialize($request->input('city'));

Using json_encode:

$citi->city = json_encode($request->input('city'));

then just use unserialize and json_decode on your blade file.

answered Nov 25, 2018 at 1:16

kapitan

2,2523 gold badges23 silver badges35 bronze badges

4 Comments

user10665294 Over a year ago

how can I unserialized it??

user10665294 Over a year ago

Arrays are now in my database but they are serialized.. how can I unserialized them? they have the value of this a:2:{i:0;s:7:"New York";i:1;s:8:"Chicago";}

user10665294 Over a year ago

hey @kapitan, all works fine except for the a:2:{i:0;s:7: for this serial code.. can i remove that and change it to normal? help me so i can upvote your answer and marked it as an asnwer ty

kapitan Over a year ago

unserialize($myvariable) or json_decode($myvariable)

Collectives™ on Stack Overflow

Laravel Store/Insert Array Values to Database Mysql

2 Answers 2

Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related