The first method should be where(), since it find()works only with primary keys. Also at the end you need to call get()or first()to execute the request:
$user = Attendances::where(DB::raw('concat (firstname, " ",lastname)'), 'like', Input::get('student_name'))
->where('section_name', 'like', Input::get('section_name'))
->where('teacher_id', '=', Auth::user()->id)
->where('subject_code', 'like', Input::get('subject_code'))
->first();
source
share