How to update data in the database using artisan Tinker

Question

First,I call artisan tinker using the command below

$ php artisan tinker

Then, I plan to get all of the model in Admin to update the name as "admin", then I save the update by using command below

$admin = App\Admin::get()->name="admin"->save()

//Admin is my model
//name is the table structure of Admin table
//then I save it with save()

However, it pop out an error as shown below :-

PHP Error: Call to a member function save() on string in Psy Shell code on line 1

give us your full code. – Sand Of Vega Apr 24 '18 at 11:08 — Sand Of Vega, Apr 24 '18 at 11:08
sir, can u specific which code u want..? Is it model code ? – Ho Wei Kang Apr 24 '18 at 11:12 — Ho Wei Kang, Apr 24 '18 at 11:12
No, it's ok. I just misunderstood. – Sand Of Vega Apr 24 '18 at 11:17 — Sand Of Vega, Apr 24 '18 at 11:17

Volkan Yılmaz · Accepted Answer · 2018-04-24T11:36:54.623

5

With update method.

$admin = App\Admin::query()->update(['name' => 'admin']);

In Admin model:

protected $fillable = 'name';

edited Apr 24 '18 at 11:36

answered Apr 24 '18 at 11:12

Volkan Yılmaz

Thank for the reply sir. But it show an error `PHP Deprecated: Non-static method Illuminate/Database/Eloquent/Model::update() should not be called statically in Psy Shell code on line 1` – Ho Wei Kang Apr 24 '18 at 11:22
Try this at your project. Not in tinker. @HoWeiKang – Sand Of Vega Apr 24 '18 at 11:26
Try again please. – Volkan Yılmaz Apr 24 '18 at 11:37

score 0 · Answer 2 · answered Oct 21 '21 at 15:02

0

The problem with the code is that you're chaining a method on a string.

Use update next time, like this:

$admin = App\Admin::get()->update(['name' => 'admin'])

2 Answers2