$est_data = Establishments::where('status',0)->where('city','=',$data['location'])->get(array('id'));
return $est_data;
result:
[{"id":43},{"id":71},{"id":41},{"id":39}]
This is my above laravel condition and result, i want the result to be like 43,71,41,39.
Can anyone please help me, how can be this done using php. i tried with implode() function, but getting error, please help...thank you
Laravel pluck method will select required fields only:
$est_data = Establishments::where('status',0)->where('city','=',$data['location'])->pluck('id');
return $est_data;
As commented by @apokryfos for your laravel version (4.2) lists method should be used, so it is:
$est_data = Establishments::where('status',0)->where('city','=',$data['location'])->lists('id');
return $est_data;
pluck is only supported in QueryBuilder not EloquentBuilder. Just checked, both supports pluck
pluck was called lists in laravel 4.2 and confusingly laravel 4.2 also had a function called pluck which is now called value so the logic here is sound but the question should have had the correct laravel version mentioned
You can use the laravel array_flatten() array helper:
The array_flatten function flattens a multi-dimensional array into a single level array:
$array = array('name' => 'Joe', 'languages' => array('PHP', 'Ruby'));
$array = array_flatten($array);
// array('Joe', 'PHP', 'Ruby');
In your case:
$est_data = Establishments::where('status',0)->where('city','=',$data['location'])->pluck('id');
return array_flatten($est_data);
$result = implode(',',$est_data[0]);
This will solve your problem. You should read about implode(convert to string) and explode (string to array). They are really useful php functions.
Reading your comment, your error is coming from the fact that you try to access $set_data and not $set_data[0] where you values are based on the output you provided us.
Use the php array_column function, specifying the id:
$est_data = Establishments::where('status',0)->where('city','=',$data['location'])->pluck('id');
return array_column("id", $est_data);
