How to use if condition in laravel select query?

By Hardik Savani | May 29, 2019 | | 27290 Viewer | Category : Laravel MySql


We will learn how to use if condition in laravel select query. we can use mysql case when statement with db raw in laravel. If you want to use mysql function then you must have to use db raw function. in this example i will show you laravel select query with if condition.

In minor case we need to use if else condition in laravel 5 Eloquent. It might be use when you just need to send data to import or api etc.

I will give you example when you can use this kind of when case statement in mysql query. If you take "status" fields in users table with following meaning:

0 => User

1 => Admin

2 => SuperAdmin

So at this time we store 0 1 or 2 values in database table but when we select at that time it should become "User" "Admin" and "SuperAdmin".

We can write mysql query like this way:

SELECT '(CASE

WHEN users.status = "0" THEN "User"

WHEN users.status = "1" THEN "Admin"

ELSE "SuperAdmin"

END) AS status_lable'

FROM users

But you can write this query in Laravel like this way:

$users = User::select("*",

\DB::raw('(CASE

WHEN users.status = "0" THEN "User"

WHEN users.status = "1" THEN "Admin"

ELSE "SuperAdmin"

END) AS status_lable'))

->get();

dd($users);

I hope it can help you....




Hardik Savani
My name is Hardik Savani. I'm a full-stack developer, entrepreneur and owner of Aatman Infotech. I live in India and I love to write tutorials and tips that can help to other artisan. I am a big fan of PHP, Javascript, JQuery, Laravel, Codeigniter, VueJS, AngularJS and Bootstrap from the early stage.
Follow Me: Github Twitter
***Do you want me hire for your Project Work? Then Contact US.

We are Recommending you: