資料為JSONLaravel-有解無憂

嗨，我有一個搜索，它從中獲取資料table candidates

我的搜索代碼

public function advance(Request $request)
    {
    $data1 = ['LoggedUserInfo'=>Admin::where('id','=', session('LoggedUser'))->first()];
    $data = \DB::table('candidates');
    if( $request->name){
        $data = $data->where('name', 'LIKE', "%" . $request->name . "%");
    }
     if( $request->location){
        $data = $data->where('location', 'LIKE', "%" . $request->location . "%");
    }
     if( $request->key_skills){
        $data = $data->where('key_skills', 'LIKE', "%" . $request->key_skills . "%");
    }
    if( $request->gender){
        $data = $data->where('gender', 'LIKE', "%" . $request->gender . "%");
    }
     if( $request->pref_loc){
        $data = $data->where('pref_loc', 'LIKE', "%" . $request->pref_loc . "%");
    }
    if( $request->phoneno){
        $data = $data->where('phoneno', 'LIKE', "%" . $request->phoneno . "%");
    }
     if( $request->email){
        $data = $data->where('email', 'LIKE', "%" . $request->email . "%");
    }
    $min_np = $request->min_np;
    $max_np = $request->max_np;
     if ($min_np || $max_np) {
     $data = $data->whereRaw("CONVERT(SUBSTRING_INDEX(notice_period,' ', 1),UNSIGNED INTEGER) >= {$min_np}");
     $data = $data->whereRaw("CONVERT(SUBSTRING_INDEX(notice_period,' ', 1),UNSIGNED INTEGER) <= {$max_np}");
 }
    $min_ctc = $request->min_ctc;
    $max_ctc = $request->max_ctc;
    
 
    if ($min_ctc || $max_ctc) {
     $data = $data->whereRaw("CONVERT(SUBSTRING_INDEX(salary,' ', 1),UNSIGNED INTEGER) >= {$min_ctc}");
     $data = $data->whereRaw("CONVERT(SUBSTRING_INDEX(salary,' ', 1),UNSIGNED INTEGER) <= {$max_ctc}");
 }

     if ($request->min_exp || $request->max_exp) {
     $data = $data->whereRaw("CONVERT(SUBSTRING_INDEX(experrience,' ', 1),UNSIGNED INTEGER) >= {$request->min_exp}");
     $data = $data->whereRaw("CONVERT(SUBSTRING_INDEX(experrience,' ', 1),UNSIGNED INTEGER) <= {$request->max_exp}");
 }
    // $dataa = $data ;
    $data = $data->paginate(10);
    $data2 = $data->total();
    $dataa = $data->toJson();

    $data4 = \DB::table('admins')->get();
    $setting = DB::select('select * from logo where id=?',[1]);

    return view('search', compact('data2','data4','setting','dataa'))->with('data',$data);
}

現在我希望$data將其轉換為“陣列或 JSON”

但是當我嘗試這個時$data->toJson();，它會給我這個資料pagination以及所有頁面鏈接和分頁資料

但我想要所有資料Array or JSON

注意 - 我希望所有資料一次 bcz 將資料匯出到 csv 檔案

資料為 JSON Laravel

uj5u.com熱心網友回復：

如果您不想要分頁，請不要使用$data = $data->paginate(10); ，而是使用$data = $data->get();

uj5u.com熱心網友回復：

根據這個鏈接https://scoutapm.com/blog/php-json_encode-serialize-php-objects-to-json，你可以試試這個：

$dataJson = json_encode($data);

轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/468410.html

標籤：php 拉拉维尔

上一篇：如何在laravel框架中生成短鏈接以及與3模型的關系

下一篇：PHP通過嵌套鍵查找陣列項