Search by Queries/Bugs/Errors

How to check column value of a record is null or not in laravel

Created at 12-Sep-2021 , By samar

In this tutorial, we will try to find the solution to "How to check column value of a record is null or not in laravel" through programming.

You can check if the column value of a record is null or not in laravel using whereNotNull() and exists() method. exists() method returns false if the column value of a record in the table is null and it returns true if column value is not null.

Laravel whereNotNull() with exists() method to check if the column value is null or not
```
$hasImage = User::where('id', Auth::user()->id)->whereNotNull('image')->exists();
dd($hasImage);
```
Output :
```
true
```
or
```
false
```
It returns true if record does not have null value in column and return false if record have null value in column.

Back to code snippet queries related laravel

If you like what you are reading, please consider buying us a coffee ( or 2 ) as a token of appreciation.

Don't forget to share this article! Help us spread the word by clicking the share button below.

We appreciate your support and are committed to providing you valuable and informative content.

We are thankful for your never ending support.

Bootstrap C C++ Cmd CodeIgniter Css Drupal Git Html Java Javascript Jquery Laravel Nodejs Php Python React Sql Typescript Wordpress

How to check column value of a record is null or not in laravel

Laravel whereNotNull() with exists() method to check if the column value is null or not

Random Code Snippet Queries: Laravel

Latest Code Snippets