How to check if record exists or not in Laravel?

By Hardik Savani | April 13, 2016 | Category : Laravel


Today, i will let you know example of laravel check if record exists in database. We will look at example of laravel check if record not exists. This post will give you simple example of laravel check if record exists in table. let’s discuss about laravel check if record exists in database. So, let's follow few step to create example of laravel check if record not exists.

If you are new in laravel 7 and you want to determine email is exist or not then you can do it easily. IF you did use code php then we have to write long code and check but laravel provide it's own query builder so it is pretty easy. you can see following example how i check row is exists or not:

Example:

$user = User::where('email',Input::get('email'))->first();

if (is_null($user)) {

print_r("email is exists");

}

print_r("email is not exists");

exists() Example:

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\User;

class UserController extends Controller

{

/**

* Display a listing of the resource.

*

* @return \Illuminate\Http\Response

*/

public function index()

{

$isExist = User::select("*")

->where("email", "yemmerich@example.net")

->exists();

if ($isExist) {

dd('Record is available.');

}else{

dd('Record is not available.');

}

}

}

Output:

Record is available.

doesntExist() Example:

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\User;

class UserController extends Controller

{

/**

* Display a listing of the resource.

*

* @return \Illuminate\Http\Response

*/

public function index()

{

$isExist = User::select("*")

->where("email", "yemmerich@example.net")

->doesntExist();

if ($isExist) {

dd('Record is not available.');

}else{

dd('Record is available.');

}

}

}

Output:

Record is not available.

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: