php视图显示数据,php – Laravel 5.4：执行原始查询并在视图中显示数据

我想运行一个我在控制器中编写的原始查询,并希望在我的视图中显示数据库中的数据.

这是我的控制器功能：

public function unverified_jobs_page()

{

$query = "SELECT jd.*, cd.`company_name`, jc.`category_title`, jt.`job_type_title`, cc.`city_name`

FROM `job_details` AS jd

JOIN `company_details` AS cd ON cd.`company_id`=jd.`company_id`

JOIN `job_category` AS jc ON jc.`category_id`=jd.`category_id`

JOIN `job_type` AS jt ON jt.`job_type_id`=jd.`job_type_id`

JOIN `city` AS cc ON cc.`city_id`=jd.`city_id`

WHERE jd.`is_verified`='NO'

ORDER BY jd.`date_posted` DESC";

$sql = General_model::rawQuery($query);

return view('adminpanel.jobs.unverfied_jobs',compact($sql));

}

这是我的模型函数rawQuery()

public static function rawQuery($query)

{

return DB::select( DB::raw($query) );

}

这是我的看法：

JOB ID TITLECOMPANYCITYDATE POSTEDCLOSING DATE 

@foreach($sql as $d)

{{$d->job_id}}{{$d->job_title}}{{$d->company_name}}{{$d->city_name}}{{$d->date_posted}}{{$d->expiry_date}} DETAILS

@endforeach

现在问题是,每次我尝试运行该页面时,它都会给我以下错误：

ErrorException in 10f46e45beef75fdd05b083aa636ae7821fe6936.php line 30:

Undefined variable: sql (View: C:\AppServ\www\jobs\jobs\unverfied_jobs.blade.php)

请帮忙.