php - Last inserted record id cannot be retrieved in laravel

Solution:

check your data array there is nothing insterting that is why id not getting

$dataArray = [
            'column_name' => $request->inputFieldName,
                  ];
$AppPayment = DB::table('subscriptions')->insertGetId($dataArray);
Copy code

Solution:

you need to insert record here! This should be the place to insert the record.

    $id = DB::table('subscriptions')->insertGetId(['foo'=>'bar']);

dd($id);
Copy code

Update if you use cashier, check this code.

public function subscribe(Request $request)
    {

        $user = auth()->user();
        $paymentMethod = $request->payment_method;
        $appId = $request->appId;
        $planId = $request->plan;
        $subscription = $user->newSubscription('main', $planId)->create($paymentMethod);
        dd($subscription->id);
        return $AppPayment;

       $this->activateApp($appId);


    }
Copy code

Solution:

This should work after you create the subscription:

$user->subscription->id;
Copy code