Hello to all, welcome to therichpost.com. In this post, I will tell, Laravel 7.2 Best Practices Database Queries.

Here are the some basics laravel database queries easy to understand. Laravel is the best php mvc framework.

1. Laravel Eloquent Insert Query :

// I am doing this in controller file

//Employees -->Modal Name
$employees = new Employees;
$employees->name = $request->name;
$employees->email = $request->email;
$employees->phone = $request->phone;
$employees->gender = $request->gender;
$employees->save();

 

2. Laravel Eloquent Select Query  and output will be json format:

//I am using this in controller file

//Employees -->Modal Name

Employees::all();

 

3. Laravel Eloquent Delete Query :

//I am doing this in controller file

//Employees -->Modal name
Employees::where('id',$request->id)->delete();

 

4. Laravel Eloquent Update Query :

//I am doing this in controller


//Employees -->Modal name

$employees = Employees::find($request->id);
$employees->name = $request->name;
$employees->email = $request->email;
$employees->phone = $request->phone;
$employees->gender = $request->gender;
$employees->save();

 

If you have any kind of query then please do comment below.

Jassa

Thank you