Laravel Database Queries: A Complete Guide

You can use Eloquent ORM in Laravel to perform database queries. Here are some common examples of database query operations.

1. Retrieving all data:

$users = User::all();

1. Retrieve a single record:

$user = User::find($id);

1. Query data based on conditions.

$users = User::where('age', '>', 18)->get();

1. Query data using multiple conditions.

$users = User::where('age', '>', 18)
             ->where('city', 'New York')
             ->get();

1. Retrieve data using a sort query.

$users = User::orderBy('created_at', 'desc')->get();

1. Accessing data through pagination:

$users = User::paginate(10);

1. Query data using raw SQL:

$users = DB::select('SELECT * FROM users WHERE age > ?', [18]);

These are some common examples of database query operations, you can use different query methods to operate the database based on your specific needs.