How to select / get values from database in laravel?

1
2
3
4
5
6
7
8

// Retrieve all records from a table
$users = User::all();

// Retrieve a single record by its primary key
$user = User::find(1);

// Retrieve records based on a condition
$users = User::where('name', 'John')->get();

1
2
3
4
5
6
7
8

// Retrieve all records from a table
$users = DB::table('users')->get();

// Retrieve a single record by its primary key
$user = DB::table('users')->where('id', 1)->first();

// Retrieve records based on a condition
$users = DB::table('users')->where('name', 'John')->get();

1
2
3
4
5
6
7
8

// Retrieve all records from a table
$users = DB::select('SELECT * FROM users');

// Retrieve a single record by its primary key
$user = DB::select('SELECT * FROM users WHERE id = ?', [1]);

// Retrieve records based on a condition
$users = DB::select('SELECT * FROM users WHERE name = ?', ['John']);