laravel get model query builder code example

Example 1: laravel query builder select first

$user = DB::table('users')->where('name', 'John')->first();

var_dump($user->name);

Example 2: DB::table('users')->get();

DB::table('users')->where('name', Input::get('name'))->get();