Laravel DBクラス

Controller

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
class DatabaseController extends Controller
{
    public function index(Request $request){
    	if(isset($request->id)){
    		//パラメーター結合（配列を用意しプレースホルダーを利用）
    		$param = ['id' => $request->id];
    		$items = DB::select('SELECT * FROM people WHERE id = :id',$param);

    	}else{
    		//SQLクエリを発行し、結果セットを取得
    		$items = DB::select('select * from people');
    	}
    	return view('hello.database',['items' => $items]);
    }
}