Monday, November 23, 2020
therichposts@gmail.com
laravel 7.2MysqlPhp

Laravel 7.2 Best Practices Database Queries

Laravel 7.2 routing with route group auth guard check with prefix

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

Ajay Malhotra
the authorAjay Malhotra
Hello to all. Welcome to therichpost.com. Myself Ajay Malhotra and I am freelance full stack developer. I love coding. I know Wordpress, Core php, Angularjs, Angular 2, Angular 6, Angular 7, Angular 8, Angular 9, Angular 10, Angular 11, Nodejs, laravel, Codeigniter, Shopify, Squarespace, Jquery, Google Map Api, Vuejs, Reactjs, Bigcommerce etc.

5 Comments

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.