Skip to content
  • Github
  • Facebook
  • twitter
  • About Us
  • Contact Us
  • Privacy Policy
  • Terms & Conditions
  • Site Map

XpertPhp

Expertphp Is The Best Tutorial For Beginners

  • Home
  • Javascript
    • Jquery
    • React JS
    • Angularjs
    • Angular
    • Nodejs
  • Codeigniter
  • Laravel
  • Contact Us
  • About Us
  • Live Demos
How to get last inserted id from table in Laravel

How to get last inserted id from table in Laravel

Posted on August 6, 2019December 17, 2022 By XpertPhp No Comments on How to get last inserted id from table in Laravel

In this tutorial, we will explain to you about how to get last inserted id from table in laravel. so we will give you a simple example of a get the Last Inserted Id Using Laravel.

Sometimes when we need first table reference ID to insert to another table at that time we have to need last inserted ID of the first table.

If you want to get last inserted ID from the table. laravel provides the Eloquent library method such as save(), create(), insertGetId() and getPdo().

So you can see below steps for laravel get last insert id.

Using The save() Method

PHP
1
2
3
4
5
6
7
8
9
10
11
public function store(Request $request)
{
        $student = new Student([
            'first_name' => $request->get('txtFirstName'),
            'last_name'=> $request->get('txtLastName'),
            'address'=> $request->get('txtAddress')
        ]);
        $student->save();
        
        print_r($student->id);
}

Using The create() Method

PHP
1
2
3
4
5
6
7
8
9
10
11
public function store(Request $request)
{
        $data = array();
        $data['first_name'] = $request->get('txtFirstName');
        $data['last_name'] = $request->get('txtLastName');
        $data['address'] = $request->get('txtAddress');
        
        $student = Student::create($data);
        
        print_r($student->id);
}

Using The insertGetId() Method

See also  Laravel 6 jquery form validation example tutorial
PHP
1
2
3
4
5
6
7
8
9
10
public function store(Request $request)
{
        $data = array();
        $data['first_name'] = $request->get('txtFirstName');
        $data['last_name'] = $request->get('txtLastName');
        $data['address'] = $request->get('txtAddress');
 
        $id = DB::table('students')->insertGetId($data);
        print_r($id);
}

Using The getPdo() Method

PHP
1
2
3
4
5
6
7
8
9
10
11
public function store(Request $request)
{
        $data = array();
        $data['first_name'] = $request->get('txtFirstName');
        $data['last_name'] = $request->get('txtLastName');
        $data['address'] = $request->get('txtAddress');
 
        DB::table('students')->insert($data);
        $id = DB::getPDO()->lastInsertId();
        print_r($id);
}

Laravel, MySql Tags:get last inserted id, Laravel 6 Eloquent, laravel from scratch, laravel get last insert id, laravel insert get id

Post navigation

Previous Post: How to get or select last row from the Table in laravel
Next Post: How to import and export CSV files using PHP and MySQL

Latest Posts

  • Laravel 12 Ajax CRUD Example
  • Laravel 12 CRUD Example Tutorial
  • How to Create Dummy Data in Laravel 11
  • Laravel 11 Yajra Datatables Example
  • Laravel 11 Ajax CRUD Example
  • Laravel 11 CRUD Example Tutorial
  • Laravel 10 Ajax CRUD Example Tutorial
  • Laravel 10 CRUD Example Tutorial
  • How to disable button in React js
  • JavaScript Interview Questions and Answers

Tools

  • Compound Interest Calculator
  • Hex to RGB Color Converter
  • Pinterest Video Downloader
  • Birthday Calculator
  • Convert JSON to PHP Array Online
  • JavaScript Minifier
  • CSS Beautifier
  • CSS Minifier
  • JSON Beautifier
  • JSON Minifier

Categories

  • Ajax
  • Angular
  • Angularjs
  • Bootstrap
  • Codeigniter
  • Css
  • Htaccess
  • Interview
  • Javascript
  • Jquery
  • Laravel
  • MongoDB
  • MySql
  • Nodejs
  • Php
  • React JS
  • Shopify Api
  • Ubuntu

Tags

angular 10 tutorial angular 11 ci tutorial codeigniter 4 image upload Codeigniter 4 Tutorial codeigniter tutorial CodeIgniter tutorial for beginners codeigniter with mysql crud operation eloquent relationships file upload File Validation form validation Image Upload jQuery Ajax Form Handling jquery tutorial laravel 6 Laravel 6 Eloquent Laravel 6 Model laravel 6 relationship laravel 6 relationship eloquent Laravel 6 Routing laravel 7 Laravel 7 Eloquent laravel 7 routing laravel 7 tutorial Laravel 8 laravel 8 example laravel 8 tutorial laravel 9 example laravel 9 tutorial Laravel Framework laravel from scratch laravel social login learn jquery nodejs pagination payment gateway php with mysql react js example react js tutorial send mail validation wysiwyg editor wysiwyg html editor

Copyright © 2018 - 2025,

All Rights Reserved Powered by XpertPhp.com