blocks|key|4676611|text|下面是一个例子：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4676612|public+static+function+saveTutorial(){

++++$data+=+Input::all();

++++$Tut+=+new+Tutorial;
++++$Tut->title+=+$data['title'];
++++$Tut->tutorial+=+$data['tutorial'];+++
++++$Tut->save();
++++$LastInsertId+=+$Tut->id;

++++return+Response::json(array('success'+=>+true,'last_id'=>$LastInsertId),+200);
}|code-block|syntax|javascript|4676613|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Here's an example:

<pre><code>public static function saveTutorial(){

 $data = Input::all();

 $Tut = new Tutorial;
 $Tut-&gt;title = $data['title'];
 $Tut-&gt;tutorial = $data['tutorial']; 
 $Tut-&gt;save();
 $LastInsertId = $Tut-&gt;id;

 return Response::json(array('success' =&gt; true,'last_id'=&gt;$LastInsertId), 200);
}
</code></pre>

blocks|key|4676639|text|xdazz在这种情况下是正确的，但为了将来可能使用DB::statement或DB::insert的访问者的利益，还有另一种方法：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4676640|DB::getPdo()->lastInsertId();|code-block|syntax|javascript|4676641|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/21084888/662581^0|P|D|13|A|0|5|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]|$9|V|A|W|B|C]]|D|@$9|X|A|Y|1|Z]]|E|$]]|$1|F|3|G|5|H|7|10|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|11|8|@]|D|@]|E|$]]]|L|$M|$5|N|O|P|E|$Q|R]]]]

<a href="https://stackoverflow.com/a/21084888/662581">xdazz</a> is right in this case, but for the benefit of future visitors who might be using <code>DB::statement</code> or <code>DB::insert</code>, there is another way:

<pre><code>DB::getPdo()-&gt;lastInsertId();
</code></pre>

blocks|key|170780|text|在laravel+5中:你可以这样做：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|170781|use+App\Http\Requests\UserStoreRequest;
class+UserController+extends+Controller+{
++++private+$user;
++++public+function++__construct(+User+$user+)
++++{
++++++++$this->user+=+$user;
++++}
++++public+function+store(+UserStoreRequest+$request+)
++++{
+++++++$user=+$this->user->create([
++++++++++++'name'++++++++++++++=>+$request['name'],
++++++++++++'email'+++++++++++++=>+$request['email'],
++++++++++++'password'++++++++++=>+Hash::make($request['password'])
++++++++]);
++++++++$lastInsertedId=+$user->id;
++++}
}|code-block|syntax|javascript|170782|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

In laravel 5: you can do this: 

<pre><code>use App\Http\Requests\UserStoreRequest;
class UserController extends Controller {
 private $user;
 public function __construct( User $user )
 {
 $this-&gt;user = $user;
 }
 public function store( UserStoreRequest $request )
 {
 $user= $this-&gt;user-&gt;create([
 'name' =&gt; $request['name'],
 'email' =&gt; $request['email'],
 'password' =&gt; Hash::make($request['password'])
 ]);
 $lastInsertedId= $user-&gt;id;
 }
}
</code></pre>

blocks|key|4676686|text|这对我在laravel+4.2中很有效。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4676687|$id+=+User::insertGetId([
++++'username'+=>+Input::get('username'),
++++'password'+=>+Hash::make('password'),
++++'active'+++=>+0
]);|code-block|syntax|javascript|4676688|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This worked for me in laravel 4.2

<pre><code>$id = User::insertGetId([
 'username' =&gt; Input::get('username'),
 'password' =&gt; Hash::make('password'),
 'active' =&gt; 0
]);
</code></pre>

blocks|key|4676803|text|对于任何喜欢Jeffrey+Way在他的Laracast5教程中使用Model::create()的人来说，他只是将请求直接发送到数据库中，而不是显式地在控制器中设置每个字段，并使用模型的$fillable进行大量赋值(对于任何使用这种方法的新手来说非常重要)：我读到了很多使用insertGetId()的人，但不幸的是，这并不尊重$fillable白名单，所以在尝试插入_token和数据库中任何非字段的内容时，您会遇到错误，最终设置您想要过滤的内容，等等。因为我想使用批量赋值，并且在可能的情况下写更少的代码。幸运的是，Eloquent的create+method只是包装了保存方法(上面的@xdazz引用了这个方法)，所以您仍然可以提取最后创建的ID……|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4676804|public+function+store()+{

++++$input+=+Request::all();
++++$id+=+Company::create($input)->id;

++++return+redirect('company/'.$id);
}|code-block|syntax|javascript|4676805|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/illuminate/database/blob/master/Eloquent/Model.php#L525^0|Y|F|2M|9|3V|D|4M|9|7J|6|7J|D|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]|$9|V|A|W|B|C]|$9|X|A|Y|B|C]|$9|Z|A|10|B|C]|$9|11|A|12|B|C]]|D|@$9|13|A|14|1|15]]|E|$]]|$1|F|3|G|5|H|7|16|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|17|8|@]|D|@]|E|$]]]|L|$M|$5|N|O|P|E|$Q|R]]]]

For anyone who also likes how Jeffrey Way uses <code>Model::create()</code> in his Laracasts 5 tutorials, where he just sends the Request straight into the database without explicitly setting each field in the controller, and using the model's <code>$fillable</code> for mass assignment (very important, for anyone new and using this way): I read a lot of people using <code>insertGetId()</code> but unfortunately this does not respect the <code>$fillable</code> whitelist so you'll get errors with it trying to insert _token and anything that isn't a field in the database, end up setting things you want to filter, etc. That bummed me out, because I want to use mass assignment and overall write less code when possible. Fortunately Eloquent's <a href="https://github.com/illuminate/database/blob/master/Eloquent/Model.php#L525"><code>create</code> method</a> just wraps the save method (what @xdazz cited above), so you can still pull the last created ID...

<pre class="lang-php prettyprint-override"><code>public function store() {

 $input = Request::all();
 $id = Company::create($input)-&gt;id;

 return redirect('company/'.$id);
}
</code></pre>

blocks|key|170954|text|保存模型后，初始化后的实例id为：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|170955|$report+=+new+Report();
$report->user_id+=+$request->user_id;
$report->patient_id+=+$request->patient_id;
$report->diseases_id+=+$request->modality;
$isReportCreated+=+$report->save();
return+$report->id;++//+this+will+return+the+saved+report+id|code-block|syntax|javascript|170956|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

After saving model, the initialized instance has the id:

<pre><code>$report = new Report();
$report-&gt;user_id = $request-&gt;user_id;
$report-&gt;patient_id = $request-&gt;patient_id;
$report-&gt;diseases_id = $request-&gt;modality;
$isReportCreated = $report-&gt;save();
return $report-&gt;id; // this will return the saved report id
</code></pre>

blocks|key|170988|text|在Laravel+5.2中，我会让它尽可能的干净：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|170989|public+function+saveContact(Request+$request,+Contact+$contact)
{
+++$create+=+$contact->create($request->all());
+++return+response()->json($create->id,++201);
}|code-block|syntax|javascript|170990|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

In Laravel 5.2 i would make it as clean as possible:

<pre><code>public function saveContact(Request $request, Contact $contact)
{
 $create = $contact-&gt;create($request-&gt;all());
 return response()-&gt;json($create-&gt;id, 201);
}
</code></pre>

blocks|key|4676887|text|*为Laravel+*|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4676888|首先创建一个对象，然后为该对象设置属性值，然后保存对象记录，然后获取最后插入的id。比如|4676889|$user+=+new+User();++++++++

$user->name+=+'John';++

$user->save();|code-block|syntax|javascript|4676890|//现在获取最后插入的id|4676891|$insertedId+=+$user->id;

echo+$insertedId+;|4676892|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

**** For Laravel ****

Firstly create an object, Then set attributes value for that object, Then save the object record, and then get the last inserted id. such as

<pre><code>$user = new User(); 

$user-&gt;name = 'John'; 

$user-&gt;save();
</code></pre>

// Now Getting The Last inserted id

<pre><code>$insertedId = $user-&gt;id;

echo $insertedId ;
</code></pre>

blocks|key|4676904|text|如果该表具有自动递增的id，请使用insertGetId方法插入一条记录，然后检索该ID：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4676905|$id+=+DB::table('users')->insertGetId([
++++'email'+=>+'john@example.com',
++++'votes'+=>+0
]);|code-block|syntax|javascript|4676906|参考：https://laravel.com/docs/5.1/queries#inserts|offset|length|4676907|entityMap|0|LINK|mutability|MUTABLE|url|https://laravel.com/docs/5.1/queries#inserts^0|0|0|3|18|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

If the table has an auto-incrementing id, use the insertGetId method to insert a record and then retrieve the ID:

<pre><code>$id = DB::table('users')-&gt;insertGetId([
 'email' =&gt; 'john@example.com',
 'votes' =&gt; 0
]);
</code></pre>

Refer: <a href="https://laravel.com/docs/5.1/queries#inserts" rel="noreferrer">https://laravel.com/docs/5.1/queries#inserts</a>

blocks|key|4676932|text|保存$data->save()后。所有数据都被推送到$data中。因为这是一个对象，而当前行最近才保存在$data中。因此，最后一个insertId将在$data->id中找到。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4676933|响应代码为：|4676934|return+Response::json(array('success'+=>+true,+'last_insert_id'+=>+$data->id),+200);|code-block|syntax|javascript|4676935|entityMap^0|2|D|Q|5|1G|5|1U|8|24|9|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]|$9|T|A|U|B|C]|$9|V|A|W|B|C]|$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Z|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|10|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|11|8|@]|D|@]|E|$]]]|N|$]]

After Saving <code>$data-&gt;save()</code>. all data is pushed inside <code>$data</code>. As this is an object and the current row is just saved recently inside <code>$data</code>. so last <code>insertId</code> will be found inside <code>$data-&gt;id</code>. 

Response code will be:

<pre><code>return Response::json(array('success' =&gt; true, 'last_insert_id' =&gt; $data-&gt;id), 200);
</code></pre>

blocks|key|171073|text|您可以这样做：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|171074|$result=app('db')->insert("INSERT+INTO+table...");

$lastInsertId=app('db')->getPdo()->lastInsertId();|code-block|syntax|javascript|171075|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can do this:

<pre><code>$result=app('db')-&gt;insert("INSERT INTO table...");

$lastInsertId=app('db')-&gt;getPdo()-&gt;lastInsertId();
</code></pre>

blocks|key|171089|text|public+function+store(+UserStoreRequest+$request+)+{
++++$input+=+$request->all();
++++$user+=+User::create($input);
++++$userId=$user->id+
}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|171090|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>public function store( UserStoreRequest $request ) {
 $input = $request-&gt;all();
 $user = User::create($input);
 $userId=$user-&gt;id 
}
</code></pre>

blocks|key|4676994|text|对于在数据库中获取最后插入的id，您可以使用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4676995|$data+=+new+YourModelName;
$data->name+=+'Some+Value';
$data->email+=+'abc@mail.com';
$data->save();
$lastInsertedId+=+$data->id;|code-block|syntax|javascript|4676996|在这里，$lastInsertedId将给你最后一次插入的自动增量id。|4676997|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

For get last inserted id in database
You can use

<pre><code>$data = new YourModelName;
$data-&gt;name = 'Some Value';
$data-&gt;email = 'abc@mail.com';
$data-&gt;save();
$lastInsertedId = $data-&gt;id;
</code></pre>

here $lastInsertedId will gives you last inserted auto increment id.

blocks|key|4677007|text|$objPost+=+new+Post;
$objPost->title+=+'Title';
$objPost->description+=+'Description';+++
$objPost->save();
$recId+=+$objPost->id;+//+If+Id+in+table+column+name+if+other+then+id+then+user+the+other+column+name

return+Response::json(['success'+=>+true,'id'+=>+$recId],+200);|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|4677008|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>$objPost = new Post;
$objPost-&gt;title = 'Title';
$objPost-&gt;description = 'Description'; 
$objPost-&gt;save();
$recId = $objPost-&gt;id; // If Id in table column name if other then id then user the other column name

return Response::json(['success' =&gt; true,'id' =&gt; $recId], 200);
</code></pre>

blocks|key|4677038|text|最短的方法可能是在模型上调用refresh()：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4677039|public+function+create(array+$data):+MyModel
{
++++$myModel+=+new+MyModel($dataArray);
++++$myModel->saveOrFail();
++++return+$myModel->refresh();
}|code-block|syntax|javascript|4677040|entityMap|0|LINK|mutability|MUTABLE|url|https://laravel.com/docs/5.7/eloquent#retrieving-models^0|E|9|E|9|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@$9|V|A|W|1|X]]|E|$]]|$1|F|3|G|5|H|7|Y|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|L|$M|$5|N|O|P|E|$Q|R]]]]

The shortest way is probably a call of the <a href="https://laravel.com/docs/5.7/eloquent#retrieving-models" rel="nofollow noreferrer"><code>refresh()</code></a> on the model:

<pre><code>public function create(array $data): MyModel
{
 $myModel = new MyModel($dataArray);
 $myModel-&gt;saveOrFail();
 return $myModel-&gt;refresh();
}
</code></pre>

blocks|key|4677113|text|虽然这个问题有点过时了。我的快速而棘手的解决方案如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4677114|$last_entry+=+Model::latest()->first();|code-block|syntax|javascript|4677115|但我猜它在频繁访问的数据库中容易受到竞争条件的影响。|4677116|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Although this question is a bit dated. My quick and dirty solution would look like this:

<pre><code>$last_entry = Model::latest()-&gt;first();
</code></pre>

But I guess it's vulnerable to race conditions on highly frequented databases.

blocks|key|4677153|text|可选方法为：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4677154|$lastID+=+DB::table('EXAMPLE-TABLE')
++++++++++++++++->orderBy('id',+'desc')
++++++++++++++++->first();

$lastId+=+$lastProduct->id;|code-block|syntax|javascript|4677155|Source+from+Laravel+5.8+version|offset|length|4677156|entityMap|0|LINK|mutability|MUTABLE|url|https://laravel.com/docs/5.8/queries^0|0|0|0|V|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

Optional method will be:

<pre><code>$lastID = DB::table('EXAMPLE-TABLE')
 -&gt;orderBy('id', 'desc')
 -&gt;first();

$lastId = $lastProduct-&gt;id;

</code></pre>

<a href="https://laravel.com/docs/5.8/queries" rel="nofollow noreferrer">Source from Laravel 5.8 version</a>

blocks|key|4677180|text|你可以通过调用save方法的同一个对象来获取最后插入的id；|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4677181|$data->save();
$inserted_id+=+$data->id;|code-block|syntax|javascript|4677182|所以你可以简单的写下：|4677183|if+($data->save())+{
++++return+Response::json(array('success'+=>+true,'inserted_id'=>$data->id),+200);
}|4677184|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

You can get last inserted id with same object you call save method; 

<pre><code>$data-&gt;save();
$inserted_id = $data-&gt;id;
</code></pre>

So you can simply write: 

<pre><code>if ($data-&gt;save()) {
 return Response::json(array('success' =&gt; true,'inserted_id'=&gt;$data-&gt;id), 200);
}
</code></pre>

blocks|key|4677219|text|您可以使用$this构造函数变量在当前函数或控制器中实现“最后插入的Id使用Laravel+Eloquent”(不需要添加任何额外的列)。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4677220|public+function+store(Request+$request){
++++$request->validate([
++++++++'title'+=>+'required%7Cmax:255',
++++++++'desc'+=>+'required%7Cmax:5000'
++++]);

++++$this->project+=+Project::create([
++++++++'name'+=>+$request->title,
++++++++'description'+=>+$request->desc,
++++]);

++++dd($this->project->id);++//This+is+your+current/latest+project+id
++++$request->session()->flash('project_added','Project+added+successfully.');
++++return+redirect()->back();

}|code-block|syntax|javascript|4677221|entityMap^0|5|5|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

You can use <code>$this</code> constructor variable to achieve "Last Inserted Id Using Laravel Eloquent" (without adding any extra column) in current function or controller.

<pre><code>public function store(Request $request){
 $request-&gt;validate([
 'title' =&gt; 'required|max:255',
 'desc' =&gt; 'required|max:5000'
 ]);

 $this-&gt;project = Project::create([
 'name' =&gt; $request-&gt;title,
 'description' =&gt; $request-&gt;desc,
 ]);

 dd($this-&gt;project-&gt;id); //This is your current/latest project id
 $request-&gt;session()-&gt;flash('project_added','Project added successfully.');
 return redirect()-&gt;back();

}
</code></pre>

blocks|key|4677234|text|您也可以像这样尝试：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4677235|public+function+storeAndLastInrestedId()+{
++++$data+=+new+ModelName();
++++$data->title+=+$request->title;
++++$data->save();

++++$last_insert_id+=+$data->id;
++++return+$last_insert_id;
}|code-block|syntax|javascript|4677236|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can also try like this:

<pre class="lang-php prettyprint-override"><code>public function storeAndLastInrestedId() {
 $data = new ModelName();
 $data-&gt;title = $request-&gt;title;
 $data-&gt;save();

 $last_insert_id = $data-&gt;id;
 return $last_insert_id;
}
</code></pre>

blocks|key|4677260|text|您可以轻松获取最后插入的记录Id|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4677261|$user+=+User::create($userData);
$lastId+=+$user->value('id');|code-block|syntax|javascript|4677262|这是一个很棒的技巧，可以从数据库中最后插入的记录中获取Id。|4677263|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

You can easily fetch last inserted record Id 

<pre><code>$user = User::create($userData);
$lastId = $user-&gt;value('id');
</code></pre>

It's an awesome trick to fetch Id from the last inserted record in the DB.

blocks|key|171443|text|这就是我的工作原理，我使用Laravel7时，family_id是具有自动增量功能的主键|type|unstyled|depth|inlineStyleRanges|entityRanges|data|171444|++++public+function+store(Request+$request){
++++++++$family+=+new+Family();
++++++++$family->family_name+=+$request->get('FamilyName');
++++++++$family->family_no+=+$request->get('FamilyNo');
++++++++$family->save();
++++++++//family_id+is+the+primary+key+and+auto+increment
++++++++return+redirect('/family/detail/'+.++$family->family_id);
++++}|code-block|syntax|javascript|171445|另外，在扩展Model的Model+Family文件中，应该将增量设置为true，否则上面的$family-->family_id将返回空|171446|++++public+$incrementing+=+true;|171447|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Here it is how it worked for me, family_id is the primary key with auto increment I am using Laravel7
<pre><code> public function store(Request $request){
 $family = new Family();
 $family-&gt;family_name = $request-&gt;get('FamilyName');
 $family-&gt;family_no = $request-&gt;get('FamilyNo');
 $family-&gt;save();
 //family_id is the primary key and auto increment
 return redirect('/family/detail/' . $family-&gt;family_id);
 }
</code></pre>
Also in the Model Family file which extends Model, should have the increment set to true otherwise the above $family--&gt;family_id will return empty
<pre><code> public $incrementing = true;
 
</code></pre>

I'm currently using the below code to insert data in a table:

<pre class="lang-php prettyprint-override"><code>&lt;?php

public function saveDetailsCompany()
{
 $post = Input::All();

 $data = new Company;
 $data-&gt;nombre = $post['name'];
 $data-&gt;direccion = $post['address'];
 $data-&gt;telefono = $post['phone'];
 $data-&gt;email = $post['email'];
 $data-&gt;giro = $post['type'];
 $data-&gt;fecha_registro = date("Y-m-d H:i:s");
 $data-&gt;fecha_modificacion = date("Y-m-d H:i:s");

 if ($data-&gt;save()) {
 return Response::json(array('success' =&gt; true), 200);
 }
}
</code></pre>

I want to return the last ID inserted but I don't know how to get it.

Kind regards!

Get the Last Inserted Id Using Laravel Eloquent

数据库

我目前正在使用下面的代码在表中插入数据：<?phppublic function saveDetailsCompany(){ $post = Input::All(); $data = new Company; $data->nombre = $post['name']; $data->dire...

问使用Laravel Eloquent获取最后插入的Id
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用Laravel Eloquent获取最后插入的IdEN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用Laravel Eloquent获取最后插入的Id
EN