Hi Guys,


In case some of you have experence this error that says "Call to undefined method Illuminate\Database\Eloquent\Collection::save()"

when using eloquent in laravel here is the solution,

firstly a typical update statement in laravel using eloquent may look like this below

$account = Account::find(10);

$account->name ="Ademola Plumptre";

$account-->save();

The code above means that there is a table in the database represented by "Account::"

so you are trying to update the field called name where the id is 10 , which should work perfectly but there are times

where you might not have the id but perhaps there is a field called gender so you might want to do something like this below

but this will give you and error

<!--  This will throw an error  -->
$account = Account::where('gender','=','male');

$account->name ="Ademola Plumptre";

$account-->save();

looking at the code above, its trying to update the name where the gender is male ... you will get an error that says

Call to undefined method Illuminate\Database\Eloquent\Collection::save()

Basically the problem is that it will retrieve all rows from that model (filtered by where condition ).

So you are getting a Collection instead of an instance of the model.

so what you need to do is to make sure you get just an instance by using first , view the code below

$account = Account::where('gender','=','male')->first();

$account->name ="Ademola Plumptre";

$account-->save();

if you want to see more stuffs visit http://overallheuristic.com/blog/

site : http://overallheuristic.com
twitter : @dplumptre
fb :https://www.facebook.com/

Nice one bro

OK no problem. But can you please change that $user->save() to $account->save().

You can also do this Account::find(10)->update(['name' => 'new name']); but don't forget the mass assignment settings in the model.

Guys, I need your help in another thread
https://www.nairaland.com/2559716/populating-select-menu-model-user

@jidez007 thanks av updated the code , leaving it that way might just bring confusion to peeps.

All multi-result sets returned by Eloquent, either via the get method or a relationship, will return a collection object.

Simple put... If the result of your query is likely to return more than one value, Laravel returns a collection.

Understanding query methods that returns a Collection would save you the problem of calling an Eloquent model method on a Collection..

$account = Account::find(10);

$account->name ="Ademola Plumptre";

$account-->save();

In the Above, We're trying to find an Account in the database that has an id of 10 .... so this query is always going to return a single Object or none from the database. so an Eloquent Model object of Account would be returned from the database if there is an Account with an id of 10 in the database. With the returned Eloquent model, we can update the name field and call the save method directly.

$account = Account::where('gender','=','male');

$account->name ="Ademola Plumptre";

$account->save();

In the Above, We're trying to find all Accounts in the database that has the value of 'male' as gender or that is owned by a male .... so this query is most likely to return more than one record from the database or none from the database. This would cause 'Eloquent' to return a Collection even if the number of records found is One/1.. Because the the returned value is a Collection, we would need to loop through the returned set to have access to the individual Model.

In the above, the value returned to $account is a Collection. so trying to access a property or an Eloquent method on the result would cause an error...
The above can be rewritten as

$accounts = Account::where('gender','=','male');

$accounts->each(function($account)
{
    $account->name ="Ademola Plumptre";
    $account->save();
});

We're now changing the name of all male account holders to "Ademola Plumptre";

If we only want to change the name of the first Account in the DB that is owned by a male then we chain our where with first method... Note ... the result of first can only be one record, so Eloquent returns an Eloquent model of the first Account which we can modify after fetched..

$account = Account::where('gender','=','male')->first();

$account->name ="Ademola Plumptre";

$account-->save();

Laravel folks are taking over!

Urine:
Laravel folks are taking over!

or you mean Pseudo Symfony folks.

pcguru1:



or you mean Pseudo Symfony folks.

Lmao! Don't let us start that argument.

pcguru1:



or you mean Pseudo Symfony folks.

Ha ha.... why are you MEAN na... lol.

Don't mind me jor, you Laravel guys get all the tools and nice concepts as in so many awesome things i've seen in Laravel but too much learning curve to jump ship from Yii2 to L5.

OctoberCMS is something I wish was on Yii2 it's just cool

pcguru1:
Don't mind me jor, you Laravel guys get all the tools and nice concepts as in so many awesome things i've seen in Laravel but too much learning curve to jump ship from Yii2 to L5.

Jump ship, the level of support is crazy.

$accounts = Account::where('gender','=','male');

$accounts->each(function($account)
{
    $account->name ="Ademola Plumptre";
    $account->save();
});

The code above works by @jacob05 but you can also do it this way below , there are different ways really, its always good to just pick the one , you

are comfortable with.

$accounts = Account::where('gender','=','male')->get();
       
foreach($accounts as $account){ 
          
    $account->name ="Ademola Plumptre";
    $account->save();
                  
       }

Its good to know we have laravel peeps in the house I will try to keep the post coming and hopefully we will all learn a thing or two from ideas we

share together .

if you want to see more stuffs visit my blog http://overallheuristic.com/blog/

site : http://overallheuristic.com
twitter : @dplumptre
fb :https://www.facebook.com/

dplumptre:

$accounts = Account::where('gender','=','male');

$accounts->each(function($account)
{
    $account->name ="Ademola Plumptre";
    $account->save();
});

The code above works by @jacob05 but you can also do it this way below , there are different ways really, its always good to just pick the one , you

are comfortable with.

$accounts = Account::where('gender','=','male')->get();
       
foreach($accounts as $account){ 
          
    $account->name ="Ademola Plumptre";
    $account->save();
                  
       }

Its good to know we have laravel peeps in the house I will try to keep the post coming and hopefully we will all learn a thing or two from ideas we

share together .

if you want to see more stuffs visit my blog http://overallheuristic.com/blog/

site : http://overallheuristic.com
twitter : @dplumptre
fb :https://www.facebook.com/

you guys wan kill una database abi.

Imagine having 10,000 results from that collection.
The total queries that will be executed from the database will be 10,0001. Because you are looping through and updating one by one.

you should rather do
Account::where('gender','=','male')->update(['name' => "Ademola Plumptre"]);
just 1 query.

Any ebook you recommend for learning laravel5

osazekid:
Any ebook you recommend for learning laravel5

https://leanpub.com/easylaravel
http://learninglaravel.net/laravelbook
hope u ready to spare some bucks sha!