How to update a record in Laravel Eloquent?

Question

I'm new to learning Laravel 5. I'm following a tutorial and I have the following code in my controller. What I want is to update the username with ID=10 in my login database. I follow the tutorial and also the Laravel documentation but what happens is it inserts another record instead of updating the existing. What is wrong with my code?

Routes.php:

Route::get('/users', "PagesController@login");

login.php (model)

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class login extends Model
{
    public $timestamps = false;
    protected $table = 'login';

    protected $fillable = [
        'username',
        'password'
    ];    
}

PagesController.php

<?php

    namespace App\Http\Controllers;

    use Illuminate\Http\Request;
    use App\login; //added
    use App\Http\Requests;
    use App\Http\Controllers\Controller;

    class PagesController extends Controller
    {
       public function login()
        {
          $login = new login;
          $login::find(10);
          $login->username ='updated_username';
          $login->save();
        }
    }

What's the result of var_dump($login); after $login::find(10);? — Starfish
– Starfish, Commented Sep 9, 2015 at 8:39
Try same thing in Tinker, its good for debugging just run php artisan tinker and then type the code and see the result there itself — Akshay Khale
– Akshay Khale, Commented Sep 9, 2015 at 8:55
it works now. i just configure my database the ID fields was changes to small letter id and it works. perfectly thank you all! — Nixxx27
– Nixxx27, Commented Sep 9, 2015 at 9:13

PaePae · Accepted Answer · 2015-09-09 07:59:46Z

5

By creating new login object means you are creating new record. Simply use login::find() to load your existing record.

class PagesController extends Controller
{
    public function login()
    {
      $login = login::find(10);
      $login->username ='updated_username';
      $login->save();
    }
}

answered Sep 9, 2015 at 7:59

PaePae

1,07410 silver badges13 bronze badges

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

1 Comment

Nixxx27 Over a year ago

thanks for your comment. i tried but nothing happens. but the return $login = login::find(10); shows result. its just didnt update.

Emeke Ajeh · Accepted Answer · 2016-09-11 21:16:27Z

0

class PagesController extends Controller
    {
       public function login()
        {
          $login = (new App\Login)->find(10);
          $login->username ='updated_username';
          $login->save();
        }
    }

Remember that your classname should start with an uppercase letter "use App\Login" and not "use App\login". Optionally you can reference the class directly with "new App\Login".

answered Sep 11, 2016 at 21:16

Emeke Ajeh

1,0501 gold badge11 silver badges16 bronze badges

Collectives™ on Stack Overflow

How to update a record in Laravel Eloquent?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related