findOrCreate in laravel

Question

I want to create data but if the data already in database, it will update. but if the data not already in database, it will create new data.

this my controller

public function store(Request $request)
{      
    $real = SpentTime::findOrCreate([
        'plan_id' => $request->get ('plan_id'),
        'daily_spent_time' => $request->get ('daily_spent_time'),
        'daily_percentage' => $request->get ('daily_percentage'),
        'reason' => $request->get ('reason')
    ]);

    return redirect()->route('real.index', compact( 'reals'));
}

this my model

public static function findOrCreate($plan_id)
{
    $real = SpentTime::find($plan_id);
    return $real ?: new SpentTime;
}

when I make data already in the database, the data is not updated.

Use `updateOrCreate()`: https://laravel.com/docs/eloquent#inserting-and-updating-models — Jonas Staudenmeir, Oct 10 '18 at 04:53

score 3 · Answer 1 · answered Oct 10 '18 at 06:25

3

Try like this

$user = User::firstOrNew(array('name' => Input::get('name')));
$user->foo = Input::get('foo');
$user->save()

answered Oct 10 '18 at 06:25

Parth kharecha

6,135
4
25
41

in my controller ? – Na Koriah Oct 10 '18 at 06:32
@NaKoriah yes you need to add this in your controller – Lakhwinder Singh Oct 10 '18 at 06:38
nothing change. nothing to updated – Na Koriah Oct 10 '18 at 06:40
this is laravel internal function you can read this here `https://laravel.com/docs/5.7/eloquent#retrieving-single-models` and find this `firstOrCreate`. – Lakhwinder Singh Oct 10 '18 at 06:41

Jignesh Joisar · Answer 2 · 2018-10-10T06:57:28.947

0

try this one

public function store(Request $request)
{      
    $real = SpentTime::findOrCreate($request->get('plan_id'),[
        'plan_id' => $request->get ('plan_id'),
        'daily_spent_time' => $request->get ('daily_spent_time'),
        'daily_percentage' => $request->get ('daily_percentage'),
        'reason' => $request->get ('reason')
    ]);

    return redirect()->route('real.index', compact( 'reals'));
}

public static function findOrCreate($plan_id,$data)
{
    $real = static::where('plan_id',$plan_id)->first();
    if (is_null($real)) {
        return static::create($data);
    } else {
        return $real->update($data);
    }
}

edited Oct 10 '18 at 06:57

answered Oct 10 '18 at 04:52

Jignesh Joisar

13,720
5
57
57

error [errors](https://4.bp.blogspot.com/-vssiRY-vaW8/W72WZL-8OcI/AAAAAAAAA4I/zsSHX281kQkeRCzQqAkdtGalSaRHJU4PACLcBGAs/s1600/Capture.JPG) – Na Koriah Oct 10 '18 at 06:05
@NaKoriah check i updated my answer – Jignesh Joisar Oct 10 '18 at 06:08
what is wrong ? https://3.bp.blogspot.com/-7TLnRJtLOwo/W72aKhRlP9I/AAAAAAAAA4U/ZVGbfYFgT7MlApT4iTwJvImabANm6fyzwCLcBGAs/s1600/Capture.JPG – Na Koriah Oct 10 '18 at 06:22
@NaKoriah again u try – Jignesh Joisar Oct 10 '18 at 06:24
the error is `Undefined variable: record` – Na Koriah Oct 10 '18 at 06:27
it works. thanks a lot sir. just change the `$record` to `$real` – Na Koriah Oct 10 '18 at 06:44
@NaKoriah welcome – Jignesh Joisar Oct 10 '18 at 06:57

findOrCreate in laravel

2 Answers2