Laravel: How can I show error message using query builder

Question

I want to update a row on my table with this query builder.

$new_item = DB::table('peminjams')
            ->where('id', $dipinjam->id_peminjam)
            ->update([
                 'nama' => $request->nama,
                 'cp' => $request->cp,
                 'jaminan' => $request->jaminan
             ]);

when I dd($new_item) it return false, the item did not update.

I still don't know why it failed since its only gives an boolean value.

try to debug your code. first check ->where('id', $dipinjam->id_peminjam)->first() whether it returns any value. then check the request values. — zahid hasan emon
– zahid hasan emon, Commented Sep 17, 2021 at 4:12
try dd($dipinjam->id_peminjam) can this return any value or not — Umer Fayyaz
– Umer Fayyaz, Commented Sep 17, 2021 at 5:04
Make sure those attributes of your model are not in $guarded property, because if they are, they won't be mass assignable. Or if you're using $fillable instead, make sure those attributes are in there. — Jonatan Lavado
– Jonatan Lavado, Commented Sep 17, 2021 at 6:17

Pravina Upadhyay · Accepted Answer · 2021-09-17 06:33:27Z

1

try {
        // Validate the value...
    } catch (Exception $e) {
        echo $exception->getMessage();exit;

    }

OR

if ($exception instanceof \HttpException || $exception instanceof \ErrorException) {

                $exceptionArry = [
                    'file'    => $exception->getFile(),
                    'code'    => $exception->getCode(),
                    'line'    => $exception->getLine(),
                    'message' => $exception->getMessage(),
                ];
                dd($exceptionArry);
            }

https://laravel.com/docs/5.8/errors

answered Sep 17, 2021 at 6:33

Pravina Upadhyay

296 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Fefar Ravi · Accepted Answer · 2021-09-17 08:42:23Z

1

First, we check first() method to returns value. if return value is null it will return false.

$new_item = DB::table('peminjams')->where('id', $dipinjam->id_peminjam)->first();

if(is_null($new_item)) {
    return false;
} else {
    DB::table('peminjams')
        ->where('id', $dipinjam->id_peminjam)
        ->update([
            'nama' => $request->nama,
            'cp' => $request->cp,
            'jaminan' => $request->jaminan
        ]);
}

using eloquent

$new_item = Peminjams::findOrFail($dipinjam->id_peminjam);

$new_item->nama = $request->nama;
$new_item->cp = $request->cp;
$new_item->jaminan = $request->jaminan;
$new_item->update();

answered Sep 17, 2021 at 8:42

Fefar Ravi

9598 silver badges20 bronze badges

Collectives™ on Stack Overflow

Laravel: How can I show error message using query builder

2 Answers 2

Comments

using eloquent

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

using eloquent

Comments

Your Answer

Sign up or log in

Post as a guest

Related