Laravel Checking If a Record Exists

Question

I am new to Laravel  Please excuse the newbie question but how do I find if a record exists    user   User  where  email        Input  get  email       What can I do here to see if  user has a record

User · Answer

I think below way is the simplest way to achieving same         user   User  where  email         request- gt input  email   - gt first        if   user              user doesn t exist

User · Answer

this is simple code to check email is exist or not in database         data    request- all         user   DB  table  User  - pluck  email  - toArray        if in array  user  data  email               echo  existed email

User · Answer

This will check if particular email address exist in the table   if  isset User  where  email   Input  get  email   - gt value  email              Input  get  email   exist in the table

User · Answer

Laravel 5 6 26v   to find the existing record through primary key   email or id          user   DB  table  users  - gt where  email   email - gt first      then         if   user                  user is not found                if  user                   user found            include   use DB   and table name user become plural using the above query like user to users

User · Answer

In your Controller    this- gt validate  request             email    gt   required unique user email              In your View - Display Already Exist Message    if  count  errors   gt  0       lt div class  alert alert-danger  gt           lt ul gt               foreach   errors- gt all   as  error                   lt li gt     error    lt  li gt               endforeach          lt  ul gt       lt  div gt   endif

User · Answer

email   User  find  request- gt email   If  email- gt count   gt 0   lt h1 gt Email exist  please make new email address lt  h1 gt  endif

User · Answer

Shortest working options      if you need to do something with the user  if   user   User  whereEmail Input  get  email   - gt first                         otherwise  userExists   User  whereEmail Input  get  email   - gt exists

User · Answer

if  User  where  email    user email com  - gt first             It exists   else          It does not exist    Use first    not count   if you only need to check for existence  first   is faster because it checks for a single match whereas count   counts all matches

User · Answer

One of the best solution is to use the firstOrNew or firstOrCreate method  The documentation has more details on both

User · Answer

This will check if requested email exist in the user table   if  User  where  email    request- gt email - gt exists           email exists in user table

User · Answer

Simple  comfortable and understandable with Validator class CustomerController extends Controller       public function register Request  request                  validator   Validator  make  request- gt all                   name    gt   required string max 255                email    gt   required string email max 255 unique customers                phone    gt   required string max 255 unique customers                password    gt   required string min 6 confirmed                        if   validator- gt fails                  return response   errors    gt   validator- gt errors  - gt all     422

User · Answer

Laravel 6 or on the top  Write the table name  then give where clause condition for instance where  id    request- id    public function store Request  request                  target   DB   table  categories                   - gt where  title    request- gt name                  - gt get  - gt first            if   target     null       do what ever you need to do              cat   new Category                 cat- gt title    request- gt input  name                 cat- gt parent id    request- gt input  parent id                 cat- gt user id auth  - gt user  - gt id               cat- gt save                return redirect route  cats app   - gt with  success    App created successfully               else     match found              return redirect route  cats app   - gt with  error    App already exists

User · Answer

In laravel eloquent  has default exists   method  refer followed example   if User  where  id    user id  - gt exists         your code

User · Answer

The efficient way to check if the record exists you must use is null method to check against the query   The code below might be helpful    user   User  where  email        Input  get  email     if is null  user       user does not exist     else     user exists

User · Answer

It depends if you want to work with the user afterwards or only check if one exists   If you want to use the user object if it exists    user   User  where  email        Input  get  email   - gt first    if   user     null          user doesn t exist     And if you only want to check  if  User  where  email        Input  get  email   - gt count    gt  0          user found     Or even nicer  if  User  where  email        Input  get  email   - gt exists            user found

User · Answer

if  user- gt isEmpty            has no records     Eloquent uses collections   See the following link  https   laravel com docs 5 4 eloquent-collections

User · Answer

if  User  where  email   Input  get  email   - gt exists             exists

User · Answer

Checking for null within if statement prevents Laravel from returning 404 immediately after the query is over   if   User  find   userId       null          return  user does not exist     else        user   User  find   userId         return  user      It seems like it runs double query if the user is found  but I can t seem to find any other reliable solution

User · Answer

if   u   User  where  email         value - gt first            do something with  u    return  exists     else     return  nope       would work with try catch   - get   would still return an empty array

User · Answer

here is a link to something l think can assist https   laraveldaily com dont-check-record-exists-methods-orcreate-ornew

User · Answer

you can use laravel validation if you want to insert a unique record   validated    request- gt validate        title    gt   required unique usersTable emailAddress max 255        But you use these ways also  1  if  User  where  email     request- gt email - gt exists           object exists   else        object not found    2   user   User  where  email     request- gt email - gt first     if   user         object exists   else        object not found    3   user   User  where  email     request- gt email - gt first     if   user- gt isEmpty           object exists   else        object not found    4   user   User  where  email     request- gt email - gt firstOrCreate          email    gt   email     request- gt all

User · Answer

user   User  where  email   request  email  - gt first    return  count  user   gt  0    Email Exist     Email Not Exist

User · Answer

user   User  where  email        Input  get  email   - gt first    if   user     null          user doesn t exist     can be written as   if  User  where  email        Input  get  email   - gt first       null          user doesn t exist     This will return true or false without assigning a temporary variable if that is all you are using  user for in the original statement

User · Answer

It s simple to get to know if there are any records or not    user   User  where  email        Input  get  email   - gt get    if count  user   gt  0    echo  There is data     else echo  No data

User · Answer

Created below method  for myself  to check if the given record id exists on Db table or not   private function isModelRecordExist  model   recordId        if    recordId  return false        count    model- gt where   id    gt   recordId  - gt count         return  count   true   false        To Test  recordId   5   status    this- gt isModelRecordExist   new MyTestModel      recordId     Home It helps

User · Answer

The Easiest Way to do       public function update Request  request   id           coupon   Coupon  where  name       request- gt name - gt first          if  coupon- gt id     id            validatedData    request- gt validate                discount    gt   required                   name    gt   required unique coupons max 255                                  requestData    request- gt all         coupon   Coupon  findOrFail  id        coupon- gt update  requestData       return redirect  admin coupons  - gt with  flash message    Coupon updated

[php] Laravel Checking If a Record Exists

Examples related to php

Examples related to laravel

Examples related to laravel-5

Examples related to eloquent

Examples related to conditional