findOrCreate in laravel [duplicate]

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(): laravel.com/docs/eloquent#inserting-and-updating-models — Jonas Staudenmeir
– Jonas Staudenmeir, Commented Oct 10, 2018 at 4:53

Parth Kharecha · Accepted Answer · 2018-10-10 06:25:52Z

3

Try like this

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

answered Oct 10, 2018 at 6:25

Parth Kharecha

6,5435 gold badges29 silver badges42 bronze badges

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

4 Comments

Na Koriah Over a year ago

in my controller ?

Lakhwinder Singh Over a year ago

@NaKoriah yes you need to add this in your controller

Na Koriah Over a year ago

nothing change. nothing to updated

Lakhwinder Singh Over a year ago

this is laravel internal function you can read this here https://laravel.com/docs/5.7/eloquent#retrieving-single-models and find this firstOrCreate.

Jignesh Joisar · Accepted Answer · 2018-10-10 06:57:28Z

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);
    }
}