When i use pluck with multiple columns i get this:

{"Kreis 1 \/ Altstadt":"City","Kreis 2":"Enge","Kreis 3":"Sihifeld","Kreis 4":"Hard","Kreis 5 \/ Industriequartier":"Escher Wyss","Kreis 6":"Oberstrass","Kreis 7":"Witikon","Kreis 8 \/ Reisbach":"Weinegg","Kreis 9":"Altstetten","Kreis 10":"Wipkingen","Kreis 11":"Seebach","Kreis 12 \/ Schwamendingen":"Hirzenbach"

But i need this?

["Rathaus","Hochschulen","Lindenhof","City","Wollishofen","Leimbach","Enge","Alt-Wiedikon","Friesenberg","Sihifeld","Werd","Langstrasse","Hard","Gewerbechule","Escher Wyss","Unterstrass","Oberstrass","Fluntern","Hottingen","Hirslanden","Witikon","Seefeld","M\u00fchlebach","Weinegg","Albisrieden","Altstetten","H\u00f6ngg","Wipkingen","Affoltern","Oerlikon","Seebach","Saatlen","Schwamendingen-Mitte","Hirzenbach"]

Any suggestion how can i do that? This is my method:

    public function autocomplete_districts(Request $request)
   {
      $district = $request->input('query');
      // $ass = /DB::table('districts')->select(array('district', 'region'))->get();
      // dd($ass);
      $data = Districts::whereRaw('LOWER(district) like ?', [strtolower('%'.$district . '%')])->orWhereRaw('LOWER(region) like ?', [strtolower('%'.$district . '%')])->pluck('region','district');

      return response()->json($data);
   }

推荐答案

因为这就是勇气的运作方式.试试这个吧.

$data = Districts::whereRaw('LOWER(district) like ?', [strtolower('%'.$district . '%')])->orWhereRaw('LOWER(region) like ?', [strtolower('%'.$district . '%')])->select('region', 'district')->get();

$data = collect($data->toArray())->flatten()->all();

Laravel相关问答推荐

为什么在Blade 文件中输出用户通知时出现错误?

如何在 laravel 中使用 str_replace

laravel:如何在 Eloquent Query 中使用 LOWERCASE 函数?

SQLSTATE [HY000]:一般错误:1005 无法创建表 - Laravel 4

从 sqlite DB 登录 Laravel,得到PDOException 找不到驱动程序

如何在 laravel blade中进行一次性推送

如何在 Laravel 中实现数组类型路由?

如何从不是控制器方法的方法发送响应?

如果 Laravel 中的值不为空,如何验证输入字段

Laravel 5.3 通知 - 仅使用Electron邮件地址通知

如何清理 Laravel Bootstrap 缓存配置文件?

assets资源不引用公用文件夹(Laravel)

Laravel 数据库模式中的 MediumBlob

Laravel 5 new auth:获取当前用户以及如何实现角色?

是否可以在 Laravel 的不同数据库中引用外键?

如何在特定项目中禁用初始化 JS/TS 语言功能?

Laravel 部署……有标准的方式吗?

Laravel 5.2 验证错误未出现在Blade中

Distinct values with pluck

Laravel 4 控制器模板/Blade - 正确的方法?