order by and select raw laravel code example Example: DB::table('users')->get(); DB::table('users')->where('name', Input::get('name'))->get();