Laravel pluck Array to string conversion

Question

I am create complaint For that while inserting department for their complaint I am using pluck() method to retrieve data from department table and display complaint in select dropdown as array but the problem is it is not working as it says

Array to string conversion (View: C:\xampp\htdocs\test\resources\views\complaint\create.blade.php)

ComplaintController

 $department = Department::pluck('name','id')->all();

    return view('complaint.create',compact('department'));

create.blade.php

<strong>Department : </strong>
{!! Form::select('dep_id',$department,null,['class'=>'form-control']) !!}

Please help!

Check this question : https://stackoverflow.com/q/29508297/2815635 — Niklesh Raut, Nov 27 '17 at 09:41
Please try dd($department); and paste output in your question — NoOorZ24, Nov 27 '17 at 09:59
you can't `pluck` two fields & show them in dropdown box, instead pluck one field & use it to populate dropbox. — Manish Yadav, Nov 27 '17 at 10:00

kunal · Accepted Answer · 2017-11-27T09:51:29.850

1

If it is not working try this:-

$department = Department::select('id','name')->get();
return view('complaint.create')->with(compact('department'));

Now your view like this:-

<strong>Department : </strong>
<select class="form-control" name="any-name">
@foreach($department as $dept)
 <option value="{{$dept->id}}">{{$dept->name}}</option>
@endforeach

Hope it helps!

edited Nov 27 '17 at 09:51

answered Nov 27 '17 at 09:46

kunal

4,122
12
40
75

Department table having data and echo all data see its coming or not? – kunal Nov 27 '17 at 09:52
this data from dd($department) array:2 [▼ 1 => "IT" 2 => "HK" ] – story ks Nov 27 '17 at 09:53
Now try to compact on that blade file see my code how i compact – kunal Nov 27 '17 at 09:53
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/159883/discussion-between-kunal-and-story-ks). – kunal Nov 27 '17 at 09:54

score -1 · Answer 2 · edited Nov 27 '17 at 13:30

-1

{!! Form::select('dep_id',$department,old('dep_id'),['class'=>'form-control', 'placeholder'=>'Select Any name']) !!}

edited Nov 27 '17 at 13:30

Inzimam Tariq IT

6,548
8
42
69

answered Nov 27 '17 at 11:41

Ramakrishna Parimi

17
2

Laravel pluck Array to string conversion

2 Answers2