blocks|key|2451993|text|在postgres中，你需要设置SequenceFeature：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2451994|...
use+Zend\Db\TableGateway\Feature;
...
public+function+setDbAdapter(+Adapter+$adapter+)+{
+++...
+++$this->featureSet+=+new+Feature\FeatureSet();
+++$this->featureSet->addFeature(new+Feature\SequenceFeature('YOUR_FIELD_NAME','YOUR_SEQUENCE_NAME'));
+++$this->initialize();
}|code-block|syntax|javascript|2451995|现在$this->tableGateway->getLastInsertValue();应该可以工作了。|offset|length|style|CODE|2451996|entityMap^0|0|0|2|16|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@$I|R|J|S|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

In postgres you need setup SequenceFeature:

<pre><code>...
use Zend\Db\TableGateway\Feature;
...
public function setDbAdapter( Adapter $adapter ) {
 ...
 $this-&gt;featureSet = new Feature\FeatureSet();
 $this-&gt;featureSet-&gt;addFeature(new Feature\SequenceFeature('YOUR_FIELD_NAME','YOUR_SEQUENCE_NAME'));
 $this-&gt;initialize();
}
</code></pre>

Now <code>$this-&gt;tableGateway-&gt;getLastInsertValue();</code> should work.

blocks|key|2451998|text|下面是我使用的代码：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2451999|$data+=+array()//+Your+data+to+be+saved;
$this->tableGateway->insert($data);
$id+=+$this->tableGateway->lastInsertValue;|code-block|syntax|javascript|2452000|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 is what I use:

<pre><code>$data = array()// Your data to be saved;
$this-&gt;tableGateway-&gt;insert($data);
$id = $this-&gt;tableGateway-&gt;lastInsertValue;
</code></pre>

blocks|key|5980326|text|这不适用于oracle+oci8，因为它还没有实现。查看此处：https://github.com/zendframework/zf2/blob/master/library/Zend/Db/Adapter/Driver/Oci8/Connection.php#L343|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|5980327|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/zendframework/zf2/blob/master/library/Zend/Db/Adapter/Driver/Oci8/Connection.php#L343^0|V|2W|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

This does not work with oracle oci8 because it is not implemented yet.
See here: <a href="https://github.com/zendframework/zf2/blob/master/library/Zend/Db/Adapter/Driver/Oci8/Connection.php#L343" rel="nofollow">https://github.com/zendframework/zf2/blob/master/library/Zend/Db/Adapter/Driver/Oci8/Connection.php#L343</a>

blocks|key|4563294|text|在扩展了AbstractTableGateway的App\Model\AlbumTable中，我通过$inserted_id+=+$this->lastInsertValue;获得了最后一个id|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4563295|举个例子：|4563296|+if+($id+==+0)+{
++++++++++++$this->insert($data);
++++++++++++$inserted_id+=+$this->lastInsertValue;++++
++++++++}+elseif+($this->getAlbum($id))+{
++++++++++++$this->update(
++++++++++++++++$data,+array(
++++++++++++++++'id'+=>+$id,
++++++++++++++++)
++++++++++++);
++++++++}+else+{
++++++++++++throw+new+\Exception('Form+id+does+not+exist');
++++++++}|code-block|syntax|javascript|4563297|entityMap^0|4|K|P|K|1E|12|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]]|D|@]|E|$]]|$1|F|3|G|5|6|7|V|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|W|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|X|8|@]|D|@]|E|$]]]|N|$]]

In <code>App\Model\AlbumTable</code> which extends <code>AbstractTableGateway</code> I get last id by <code>$inserted_id = $this-&gt;lastInsertValue;</code> 

as an example: 

<pre><code> if ($id == 0) {
 $this-&gt;insert($data);
 $inserted_id = $this-&gt;lastInsertValue; 
 } elseif ($this-&gt;getAlbum($id)) {
 $this-&gt;update(
 $data, array(
 'id' =&gt; $id,
 )
 );
 } else {
 throw new \Exception('Form id does not exist');
 }
</code></pre>

blocks|key|1846765|text|好吧，我知道这个问题已经有几个月了，尽管对于那些正在寻找这个问题的解决方案的人来说，获取最后一个插入值可能是有用的，但最好的方法是从适配器接口获取值|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1846766|do+your+insert+//then
$id+=+$adapter->getDriver()->getLastGeneratedValue();|code-block|syntax|javascript|1846767|这对我的mysql数据库来说工作得很好|1846768|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|$]]

Ok, I know the question is few month old, though it may be useful for those who are searching for a solution to this problem to get the last insert values the best way is to get the value from the adapter interface

<pre><code>do your insert //then
$id = $adapter-&gt;getDriver()-&gt;getLastGeneratedValue();
</code></pre>

This worked well for me for mysql database

blocks|key|5980454|text|我知道这是很久以前的事了，但是在花了大量的时间在这个特定的问题上之后，我想把这个解决方案发布给将来遇到同样问题的谷歌用户。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5980455|问题是Pgsql驱动程序需要一个序列名称来返回最后一个id，如下所示：|5980456|$adapter->getDriver()->getLastGeneratedValue("sequence_name");|code-block|syntax|javascript|5980457|这在2.3.1中有效。在2.2.2+(以及更高版本)中存在一个错误，其中名称不是驱动程序中getLastGeneratedValue的参数，因此您必须直接调用连接。|5980458|$adapter->getDriver()->getConnection()->getLastGeneratedValue|5980459|这就是我通过查看代码发现的。最好的解决方案是确保您的ZF2已更新，并使用|5980460|5980461|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|T|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|U|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|V|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|W|8|@]|9|@]|A|$]]|$1|O|3|E|5|F|7|X|8|@]|9|@]|A|$G|H]]|$1|P|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|Q|$]]

I know this was a while back, but after spending a ton of time on this particular problem I wanted to post the solution for future Googlers experiencing the same problem.

The issue is the Pgsql driver requires a name of the sequence to return the last id like this:

<pre><code>$adapter-&gt;getDriver()-&gt;getLastGeneratedValue("sequence_name");
</code></pre>

This works in 2.3.1. There was a bug in 2.2.2 (and possibly later) where name was not a param of the getLastGeneratedValue in the driver, so you'd have to call the connection directly.

<pre><code>$adapter-&gt;getDriver()-&gt;getConnection()-&gt;getLastGeneratedValue
</code></pre>

So that's what I found by looking through the code. Best solution is to make sure you have ZF2 updated, and use

<pre><code>$adapter-&gt;getDriver()-&gt;getLastGeneratedValue("sequence_name");
</code></pre>

blocks|key|1846810|text|还有另一种可能将FeatureSet添加到TableGateway中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1846811|在Module.php中，您可以定义(例如表User+)|1846812|++++++++++++'UserTableGateway'+=>+function+($sm)+{
++++++++++++++++$dbAdapter+=+$sm->get('Zend\Db\Adapter\Adapter');
++++++++++++++++$resultSetPrototype+=+new+ResultSet();
++++++++++++++++$resultSetPrototype->setArrayObjectPrototype(new+UserEntity());
++++++++++++++++return+new+TableGateway('user',+$dbAdapter,+new+Feature\SequenceFeature('user','user_id_seq'),+$resultSetPrototype);|code-block|syntax|javascript|1846813|但是SequenceFeature中有一个bug。当您使用公共模式时，一切都是正常的。当你必须使用其他模式时，你应该使用Zend\Db\Sql\TableIdentifier；|1846814|在这种情况下，Module.php应该是：|1846815|++++++++++++'UserTableGateway'+=>+function+($sm)+{
++++++++++++++++$dbAdapter+=+$sm->get('Zend\Db\Adapter\Adapter');
++++++++++++++++$resultSetPrototype+=+new+ResultSet();
++++++++++++++++$resultSetPrototype->setArrayObjectPrototype(new+UserEntity());
++++++++++++++++return+new+TableGateway(new+TableIdentifier('user','someSchema'),+$dbAdapter,+new+Feature\SequenceFeature(new+TableIdentifier('user','someSchema'),'user_id_seq'),+$resultSetPrototype);|1846816|在这种情况下，将出现Postgresql查询SELECT+NEXTVAL错误，因为Feature\SequenceFeature将使用公共方案而不是在第一个参数中定义的方案来准备查询|1846817|SELECT+NEXTVAL('user_id_seq')|1846818|在这种情况下，sql查询应为|1846819|SELECT+NEXTVAL('someSchema'.'user_id_seq')|1846820|entityMap^0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|10|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|11|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|A|$]]|$1|M|3|N|5|F|7|13|8|@]|9|@]|A|$G|H]]|$1|O|3|P|5|6|7|14|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|15|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|16|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|17|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|X|$]]

There is another possibility to add FeatureSet to TableGateway.

In Module.php you can define (table User for example)

<pre><code> 'UserTableGateway' =&gt; function ($sm) {
 $dbAdapter = $sm-&gt;get('Zend\Db\Adapter\Adapter');
 $resultSetPrototype = new ResultSet();
 $resultSetPrototype-&gt;setArrayObjectPrototype(new UserEntity());
 return new TableGateway('user', $dbAdapter, new Feature\SequenceFeature('user','user_id_seq'), $resultSetPrototype);
</code></pre>

But there is a bug in SequenceFeature. Everything is ok, when you use public schema. When you have to use other schema you should use Zend\Db\Sql\TableIdentifier;

In this case Module.php should be:

<pre><code> 'UserTableGateway' =&gt; function ($sm) {
 $dbAdapter = $sm-&gt;get('Zend\Db\Adapter\Adapter');
 $resultSetPrototype = new ResultSet();
 $resultSetPrototype-&gt;setArrayObjectPrototype(new UserEntity());
 return new TableGateway(new TableIdentifier('user','someSchema'), $dbAdapter, new Feature\SequenceFeature(new TableIdentifier('user','someSchema'),'user_id_seq'), $resultSetPrototype);
</code></pre>

In this case will be an error with Postgresql query SELECT NEXTVAL, because Feature\SequenceFeature will use public schema instead of defined in first argument to prepare query 

SELECT NEXTVAL('user_id_seq')

In this case sql query should be

SELECT NEXTVAL('someSchema'.'user_id_seq')

I am stuck with getting last insert id with Zend framework 2 and I gave up on this...

There are tried combinations:

<pre><code>var_dump($this-&gt;tableGateway-&gt;insert($insert));
var_dump($this-&gt;tableGateway-&gt;lastInsertValue);
var_dump($this-&gt;tableGateway-&gt;getLastInsertValue());
var_dump($this-&gt;tableGateway-&gt;getAdapter()-&gt;getDriver()-&gt;getConnection()-&gt;getLastGeneratedValue());
</code></pre>

Value is inserting to table, but every line (except first, which gives int "1") returns null. Please don't tell me, that such a big framework does not give possibility to get last insert id value!?

ZF2 How to get last insert id value?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我被Zend framework 2的最后一次插入id卡住了，我放弃了……这里有一些尝试过的组合：var_dump($this->tableGateway->insert($insert));var_dump($this->tableGateway->lastInsertValue);var_dump($this->t...

问ZF2如何获取上次插入的id值？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问ZF2如何获取上次插入的id值？EN