How to Get the Last Inserted Id Using Laravel Eloquent?

Introduction

The Eloquent ORM included with Laravel provides you with an easy way of interacting with your database. This simplifies all CRUD (Create, read, update, and delete) operations and any other database queries.

In this tutorial, you will learn how to get the Last Inserted Id Using Laravel Eloquent!

Prerequisites

Before you start, you would need to have a Laravel application up and running.

I will be using a DigitalOcean Ubuntu Droplet for this demo. If you wish, you can use my affiliate code to get free $100 DigitalOcean credit to spin up your own servers!

If you do not have that yet, you can follow the steps from this tutorial on how to do that:

• How to Install Laravel on DigitalOcean with 1-Click

Or you could use this awesome script to do the installation:

• LaraSail

Last Inserted Id Using Laravel Eloquent

Let's say that we have a newsletter sign up form where people could sign up, and then after successful signup, we want to get the ID of the entry.

To achieve that, you would need to already have a Model and a controller. Here is an example method that we would use:

public function signUp() {

    $subscriber = new Subscriber();
    $subscriber->name = 'Bobby';
    $subscriber->name = '[email protected]';  

    $subscriber->save();
}

Once the new subscriber is saved, we can simply use return $subscriber->id to retrieve the ID.

🤩 Our Amazing Sponsors 👇

View Website

DigitalOcean offers a simple and reliable cloud hosting solution that enables developers to get their website or application up and running quickly.

View Website

Laravel News keeps you up to date with everything Laravel. Everything from framework news to new community packages, Laravel tutorials, and more.

View Website

A Laravel Starter Kit that includes Authentication, User Dashboard, Edit Profile, and a set of UI Components. Learn more about the DevDojo sponsorship program and see your logo here to get your brand in front of thousands of developers.

So the complete method will look like this:

public function signUp() {

    $subscriber = new Subscriber();
    $subscriber->name = 'Bobby';
    $subscriber->name = '[email protected]';  

    $subscriber->save();

    return $subscriber->id;  // this will return the saved subscriber id

}

In case that you are building an API, you could return the response in JSON with:

return response()->json(array('success' => true, 'last_insert_id' => $subscriber->id), 200);

Conclusion

For more information and useful tips on Laravel Eloquent, make sure to check this tutorial here:

• Laravel Eloquent Make

I strongly suggest checking out the official Laravel Documentation:

• Laravel Eloquent