How to check the data already exists or not laravel

I have 2 tables. Patient table and reservation table.

Patient table:

• ID
• name
• medical record number (norekmed)

Table of reservations

• ID
• idpatient
• idroom

How do I check patient data already or not if I make a reservation?

Checking is by comparing between a reservation form field with norekmed in the patient table.

If patient data already exists, we can make a reservation. And if there is no patient data, we cannot make a reservation.

If it turns out this is not good, and there is a better method, I accept that.

Reservation controller (store)

$this->validate($request,
            [
                'idpatient' => 'required|unique:reservation,idpatient',
                'idroom' => 'required',
            ]);

        Patient::where(function($query) { 
            $query->has('id')
            ->orHas('norekmed');
        })->find(1);

        $reservasi = new Reservasi();
        $reservasi->idpatient = $request->idpatient;
        $reservasi->idroom = $request->idroom;
        $reservasi->save();

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2xmZ2oO
via IFTTT