How to convert sql query to eloquent in laravel?

@ryan.murray 

To convert an SQL query to Eloquent in Laravel, you can use the DB facade or the Eloquent models directly. Here's an example of converting a simple SQL query to Eloquent:

1. SQL Query:

1

SELECT * FROM users WHERE id = 1

1. Eloquent Query:

1

$user = User::find(1);

In this example, we are using the find method on the User model to retrieve a user with the ID of 1.

You can also convert more complex SQL queries to Eloquent using query builder methods like where, select, join, groupBy, orderBy, etc. For example:

1. SQL Query:

1

SELECT name, email FROM users WHERE age > 18 ORDER BY name ASC

1. Eloquent Query:

1
2
3
4

$users = User::select('name', 'email')
            ->where('age', '>', 18)
            ->orderBy('name', 'asc')
            ->get();

In this example, we are using the query builder methods to select specific columns, apply a WHERE condition, and order the results by name in ascending order.

By using Eloquent, you can write database queries in a more fluent and readable way, and take advantage of Laravel's built-in features like relationships, eager loading, and query scopes.