Laravel 5.5 Call to undefined method stdClass::update()

Question

Laravel 5.5 show me the error message:

Call to undefined method stdClass::update()

for the following codes in the Model

DB::table('adminUserLogs')
            ->where('adminUserId', $id)
            ->where('adminUserOutTime', NULL)->first()
            ->update(['adminUserOutTime' => \Carbon\Carbon::now()]);

Can't Because I need to update the first record only with matched the where conditions. — Niladri Banerjee - Uttarpara, May 08 '18 at 05:33
When using the query builder, `first()` returns a `stdClass`, a standard PHP class, which doesn't offer an `update()` method. — Camilo, May 08 '18 at 05:38

score 5 · Accepted Answer · answered May 08 '18 at 05:40

5

Try using ->limit(1) instead of ->first() in the chain.

answered May 08 '18 at 05:40

Quezler

2,376
14
29

score 2 · Answer 2 · answered May 08 '18 at 05:42

In Laravel if you wish to update only one record then you can use ->first() method of Eloquent ORM to get eloquent object and then you can simply update the object by ->save().

Laravel query builder directly not supporting update only record as Update with limit of 1 is not directly supported by mysql MySQL - UPDATE query with LIMIT

In the example you have given here is some modification to be work,

DB::table('adminUserLogs')
        ->where('adminUserId', $id)
        ->where('adminUserOutTime', NULL)
        ->update(['adminUserOutTime' => \Carbon\Carbon::now()]);

This will result in updating the records where specified conditions. To update specific record pass id column in where clause of that particular record.

Laravel 5.5 Call to undefined method stdClass::update()

2 Answers2