如何在Laravel中返回最后添加的id

Question

My controller code for adding data using laravel is given below. $request is globally declared

public function createEnquiry(Request $request){
    //my table is enquirydetails
    DB::table('enquirydetails')->insert(
        ['name' =>$request->input('name'),
        'address' =>$request->input('address') ,
        'phone' =>$request->input('phone') ,
        'created_at' => date("Y-m-d H:i:s") ,
        'updated_at' => date("Y-m-d H:i:s"),
        ]); 
}

I need to return the id after it added to db. This code is a Lumen api db insertion code. Web path is

$router->group(['prefix' => 'Enquiry','namespace' => 'Enquiry'], 
function($router){
    $router->post('new','EnquiryController@createEnquiry');
});

Answer 1

Use insertGetId method to insert a record and then retrieve the ID:

$id = DB::table('tableName')->insertGetId(
          ['name' => $request->input('name'),
           'address'=> $request->input('address')]
);
print_r($id);

for more details read Manual