将两个查询变量传递给jquery返回数据

Question

I want to send two query variables and want to send those values to jquery ajax data value.Now I get nothing in ajax page.If I use one query statement and passed one value I get some output

$.ajax({
  url: 'get-details',
  type: 'GET',
  data: 'id='+user_id,
  dataType: 'JSON',
  success: function(data,data1,textStatus, jqXHR){ //want to add data1
    var id = data.id;
    var alt=data1.column; 
    alert(data1.column);
  },
  error: function(jqXHR, textStatus, errorThrown){

  },
});  

public function getDetails(Request $request)
{
  $request_data = $request->all();
$user_id = $request_data['id'];
$user_data =DB::table('travel_request')
        ->join('department', 'travel_request.department_id', '=', 'department.id')
         ->select('travel_request.*')->where('travel_request.id',$user_id)->first();  
$req=DB::table('traveling_details')->select('traveling_details.*')->get(); //has multiple value
return response()->json($user_data,$req);
}  

Answer 1

Try like this if it works

$data['user_data'] = DB::table('travel_request')
        ->join('department', 'travel_request.department_id', '=', 'department.id')
         ->select('travel_request.*')->where('travel_request.id',$user_id)->first();  

$data['req'] = DB::table('traveling_details')->select('traveling_details.*')->get(); //has multiple value

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

And You ajax function in view file should be like this

$.ajax({
  url: 'get-details',
  type: 'GET',
  data: 'id='+user_id,
  dataType: 'JSON',
  success: function(data){ //want to add data1

      var user_data = data.user_data;
      var req = data.req;

      console.log(user_data);
      console.log(req);

      // to access the column of the user_data
      var YourVariableName = user_data.ColumnNameHere;

  },
  error: function(jqXHR, textStatus, errorThrown){

  },
});