check if record exist in Laravel 5.5

Question

I have a dynamic input form, I want to check if the record exists, if no then it can not insert data

my controller

$user = Master::where('id_a','=',$request->get('id_a'))->where('id_b','=',$request->get('id_b'))->get();

   if($user->isEmpty()){
      // insert
   }else{
     //message "cannot input"
   }

if insert one data, success.. but if insert array in my controller not check.. why in input array data always insert???

$input = $request->all(); for ($i=0; $i < count($request->get('id_b')); ++$i) { $var = new Master; $var->value= $input['value'][$i]; $var->save(); } — Dunhill, Dec 19 '17 at 03:13
if insert one data, always check to database, but if insert array data not check. — Dunhill, Dec 19 '17 at 03:14
is $request->get('id_b') contain an array. In that case you have to use `whereIn` not `where` — Felix, Dec 19 '17 at 03:15
@HoàngĐăng i got error "Invalid argument supplied for foreach()" if use whereIn — Dunhill, Dec 19 '17 at 03:19
i posted if you need more explain, tell me, but my solution still not perfect way — Felix, Dec 19 '17 at 03:51
Possible duplicate of [Laravel checking if record exists](https://stackoverflow.com/questions/27095090/laravel-checking-if-record-exists) — ndrwnaguib, Dec 19 '17 at 04:03

Felix · Answer 1 · 2017-12-19T04:13:06.067

1

This is pseudo for only check id_b

   $data = [1,2,3,4];
   $data_a = [1,2,3,4];

    $masters = Master::whereIn('id_b', $data)->whereIn('id_a', $data_a)->get();

    foreach($data as $key => $value) {
        $isExisted = false;

        foreach ($masters as $master) {
            if ($master->id_b == $value[$key] && $master->id_a == $data_a[$key])
            {
                $isExisted = true;
                break;
            }
        }

        if ( ! $isExisted) {
            $master = new Banner();
            $master->value = your_data;
            $master->save();
        }
    }

edited Dec 19 '17 at 04:13

answered Dec 19 '17 at 03:43

Felix

571
14
34

thanks but not work :( – Dunhill Dec 19 '17 at 03:54
check your `$request->get('id_a')` and `id_b` is an array, if not parse them to array – Felix Dec 19 '17 at 03:58
if you have code in github I can debug for u – Felix Dec 19 '17 at 03:59
i not use github.. but thanks.. i check in `dd()` `$request->get('id_b')` null.. why? – Dunhill Dec 19 '17 at 04:02
re-check in browser. Did you sent it – Felix Dec 19 '17 at 04:05
ops i check in browser, $request return array.. whats wrong? – Dunhill Dec 19 '17 at 04:06
try dd($request->all()) – Felix Dec 19 '17 at 04:08
$request return array.. – Dunhill Dec 19 '17 at 04:13
if i use `whereIn` error invalid argument supplied foreach() – Dunhill Dec 19 '17 at 04:17
because $request->get('id_b') is not an array, you have to find where is your 'id_b' array gone – Felix Dec 19 '17 at 04:18

score 0 · Answer 2 · answered Dec 19 '17 at 04:00

0

You could use exists()

if(Master::where('id_a','=',$request->get('id_a'))->where('id_b','=',$request->get('id_b'))->exists()) {
do something
}

Also I would suggest you reduce the amount of in-line stuff you're doing, instead something like this:

$id_a = $request->get('id_a');
$id_b = $request->get('id_b');

if(Master::where('id_a','=', $id_a)->where('id_b','=',$id_b)->exists()) {
do something
}

answered Dec 19 '17 at 04:00

hylian

550
1
4
19

$id_a, $id_b is an array for his case – Felix Dec 19 '17 at 04:07

score 0 · Answer 3 · answered Dec 19 '17 at 04:06

0

If I understand correctly, you want to insert a Master if a given id_a and id_b doesn't already exists for one Master

If so, you could actually use firstOrCreate :

Master::firstOrCreate(
  ['id_a' => $request->get('id_a'), 'id_b' => $request->get('id_b')], 
  ['yourcolumntocreate' => columnvalue, ...]
)

answered Dec 19 '17 at 04:06

Plotisateur

476
9
23

if i use firstOrCreate old data has been replace.. – Dunhill Dec 19 '17 at 04:11
You could `firstOrNew` then, but I think it's not your problem... – Plotisateur Dec 19 '17 at 04:17

check if record exist in Laravel 5.5

3 Answers3