blocks|key|321946|text|尝尝这个|type|unstyled|depth|inlineStyleRanges|entityRanges|data|321947|function+add_post($post_data){
+++$this->db->insert('posts',+$post_data);
+++$insert_id+=+$this->db->insert_id();

+++return++$insert_id;
}|code-block|syntax|javascript|321948|在多个插入的情况下，可以使用|321949|$this->db->trans_start();
$this->db->trans_complete();|321950|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|$]]

Try this

<pre><code>function add_post($post_data){
 $this-&gt;db-&gt;insert('posts', $post_data);
 $insert_id = $this-&gt;db-&gt;insert_id();

 return $insert_id;
}
</code></pre>

In case of multiple inserts you could use 

<pre><code>$this-&gt;db-&gt;trans_start();
$this-&gt;db-&gt;trans_complete();
</code></pre>

blocks|key|104939|text|$id+=+$this->db->insert_id();|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|104940|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>$id = $this-&gt;db-&gt;insert_id();
</code></pre>

blocks|key|104976|text|这里不需要事务，这应该足够了：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|104977|function+add_post($post_data)+{
++++$this->db->insert('posts',$post_data);
++++return+$this->db->insert_id();
}|code-block|syntax|javascript|104978|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|$]]

A transaction isn't needed here, this should suffice:

<pre><code>function add_post($post_data) {
 $this-&gt;db-&gt;insert('posts',$post_data);
 return $this-&gt;db-&gt;insert_id();
}
</code></pre>

blocks|key|322049|text|您必须使用$lastId+=+$this->db->insert_id();|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|322050|entityMap^0|5|X|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

You must use <code>$lastId = $this-&gt;db-&gt;insert_id();</code>

blocks|key|322090|text|由于您已经启动了事务的数据插入，所以，首先检查事务是否完成。启动事务后，应根据事务的状态进行提交或回滚；|type|unstyled|depth|inlineStyleRanges|entityRanges|data|322091|function+add_post($post_data){
++$this->db->trans_begin()+
++$this->db->insert('posts',$post_data);
++$this->db->trans_complete();
++if+($this->db->trans_status()+===+FALSE){
++++$this->db->trans_rollback();
++++return+0;
++}else{
++++$this->db->trans_commit();
++++return+$this->db->insert_id();
++}
}``|code-block|syntax|javascript|322092|在上面的代码中，我们已经提交了成功事务的数据，即使您获得了时间戳|322093|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|$]]

because you have initiated the Transaction over the data insertion so,
The first check the transaction completed or not. once you start the transaction, it should be committed or rollback according to the status of the transaction;

<pre><code>function add_post($post_data){
 $this-&gt;db-&gt;trans_begin() 
 $this-&gt;db-&gt;insert('posts',$post_data);
 $this-&gt;db-&gt;trans_complete();
 if ($this-&gt;db-&gt;trans_status() === FALSE){
 $this-&gt;db-&gt;trans_rollback();
 return 0;
 }else{
 $this-&gt;db-&gt;trans_commit();
 return $this-&gt;db-&gt;insert_id();
 }
}``
</code></pre>

in the above, we have committed the data on the successful transaction even you get the timestamp

blocks|key|322142|text|完成本主题:如果您使用主键和自动增量设置表，则可以省略手动递增id的过程。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|322143|看看这个例子|322144|if+(!$CI->db->table_exists(db_prefix()+.+'my_table_name'))+{
++++$CI->db->query('CREATE+TABLE+`'+.+db_prefix()+.+"my_table_name`+(
++`serviceid`+int(11)+NOT+NULL+PRIMARY+KEY+AUTO_INCREMENT,
++`name`+varchar(64)+NOT+NULL,
++`hash`+varchar(32)+NOT+NULL,
++`url`+varchar(120)+NOT+NULL,
++`datecreated`+datetime+NOT+NULL,
++`active`+tinyint(1)+NOT+NULL+DEFAULT+'1'
)+ENGINE=InnoDB+DEFAULT+CHARSET="+.+$CI->db->char_set+.+';');|code-block|syntax|javascript|322145|现在可以插入行了|322146|$this->db->insert(db_prefix().+'my_table_name',+[
++++++++++++'name'+++++++++=>+$data['name'],
++++++++++++'hash'++++++++++++=>+app_generate_hash(),
++++++++++++'url'+++++=>+$data['url'],
++++++++++++'datecreated'+++++=>+date('Y-m-d+H:i:s'),
++++++++++++'active'++++++++++=>+$data['active']
++++++++]);|322147|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|$]]

Just to complete this topic:
If you set up your table with primary key and auto increment you can omit the process of manually incrementing the id.

Check out this example

<pre><code>if (!$CI-&gt;db-&gt;table_exists(db_prefix() . 'my_table_name')) {
 $CI-&gt;db-&gt;query('CREATE TABLE `' . db_prefix() . "my_table_name` (
 `serviceid` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
 `name` varchar(64) NOT NULL,
 `hash` varchar(32) NOT NULL,
 `url` varchar(120) NOT NULL,
 `datecreated` datetime NOT NULL,
 `active` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=" . $CI-&gt;db-&gt;char_set . ';');
</code></pre>

Now you can insert rows

<pre><code>$this-&gt;db-&gt;insert(db_prefix(). 'my_table_name', [
 'name' =&gt; $data['name'],
 'hash' =&gt; app_generate_hash(),
 'url' =&gt; $data['url'],
 'datecreated' =&gt; date('Y-m-d H:i:s'),
 'active' =&gt; $data['active']
 ]);
</code></pre>

blocks|key|322164|text|**Inside+Model**
function+add_info($data){
+++$this->db->insert('tbl_user_info',$data);
+++$last_id+=+$this->db->insert_id();
+++return++$last_id;
}

**Inside+Controller**
public+function+save_user_record()+{
++$insertId+=++$this->welcome_model->save_user_info($data);
++echo+$insertId->id;
}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|322165|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>**Inside Model**
function add_info($data){
 $this-&gt;db-&gt;insert('tbl_user_info',$data);
 $last_id = $this-&gt;db-&gt;insert_id();
 return $last_id;
}

**Inside Controller**
public function save_user_record() {
 $insertId = $this-&gt;welcome_model-&gt;save_user_info($data);
 echo $insertId-&gt;id;
}
</code></pre>

blocks|key|105144|text|使用mysqli+PHP驱动程序，您不能在提交后获得insert_id。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|105145|真正的解决方案是：|105146|function+add_post($post_data){
++$this->db->trans_begin();
++$this->db->insert('posts',$post_data);

++$item_id+=+$this->db->insert_id();

++if(+$this->db->trans_status()+===+FALSE+)
++{
++++$this->db->trans_rollback();
++++return(+0+);
++}
++else
++{
++++$this->db->trans_commit();
++++return(+$item_id+);
++}
}|code-block|syntax|javascript|105147|代码结构源码：https://codeigniter.com/user_guide/database/transactions.html#running-transactions-manually|offset|length|105148|entityMap|0|LINK|mutability|MUTABLE|url|https://codeigniter.com/user_guide/database/transactions.html#running-transactions-manually^0|0|0|0|7|2J|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@$K|Y|L|Z|1|10]]|A|$]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

Using the mysqli PHP driver, you can't get the insert_id after you commit.

The real solution is this:

<pre><code>function add_post($post_data){
 $this-&gt;db-&gt;trans_begin();
 $this-&gt;db-&gt;insert('posts',$post_data);

 $item_id = $this-&gt;db-&gt;insert_id();

 if( $this-&gt;db-&gt;trans_status() === FALSE )
 {
 $this-&gt;db-&gt;trans_rollback();
 return( 0 );
 }
 else
 {
 $this-&gt;db-&gt;trans_commit();
 return( $item_id );
 }
}
</code></pre>

Source for code structure: <a href="https://codeigniter.com/user_guide/database/transactions.html#running-transactions-manually" rel="nofollow noreferrer">https://codeigniter.com/user_guide/database/transactions.html#running-transactions-manually</a>

blocks|key|322220|text|值得一提的是，其他答案与Codeigniter版本3有关。版本4(找到https://codeigniter.com/user_guide/database/helpers.html)中的答案是使用$this->db->insertID()|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|322221|entityMap|0|LINK|mutability|MUTABLE|url|https://codeigniter.com/user_guide/database/helpers.html^0|2R|L|Z|1K|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@$9|O|A|P|B|C]]|D|@$9|Q|A|R|1|S]]|E|$]]|$1|F|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|G|$H|$5|I|J|K|E|$L|M]]]]

It is worth saying that the other answers relate to Codeigniter version 3. The answer in Version 4 (found <a href="https://codeigniter.com/user_guide/database/helpers.html" rel="nofollow noreferrer">https://codeigniter.com/user_guide/database/helpers.html</a>) is to use <code>$this-&gt;db-&gt;insertID()</code>

I have an insert query (active record style) used to insert the form fields into a MySQL table. I want to get the last auto-incremented id for the insert operation as the return value of my query but I have some problems with it.

Inside the controller:

<pre><code>function add_post(){
 $post_data = array(
 'id' =&gt; '',
 'user_id' =&gt; '11330',
 'content' =&gt; $this-&gt;input-&gt;post('poster_textarea'),
 'date_time' =&gt; date("Y-m-d H:i:s"),
 'status' =&gt; '1'
 );
 return $this-&gt;blog_model-&gt;add_post($post_data);
}
</code></pre>

And inside model:

<pre><code>function add_post($post_data){
 $this-&gt;db-&gt;trans_start();
 $this-&gt;db-&gt;insert('posts',$post_data);
 $this-&gt;db-&gt;trans_complete();
 return $this-&gt;db-&gt;insert_id();
}
</code></pre>

I get nothing as the return of the add_post in model

how to get last insert id after insert query in codeigniter active record

MySQL

我有一个插入查询(活动记录样式)，用于将表单域插入到MySQL表中。我希望获得插入操作的最后一个自动递增的id作为查询的返回值，但我遇到了一些问题。在控制器内部：function add_post(){    $post_data = array(        'id'            => '',      ...

问如何在codeigniter活动记录中获取insert查询后的最后一个插入id
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在codeigniter活动记录中获取insert查询后的最后一个插入idEN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在codeigniter活动记录中获取insert查询后的最后一个插入id
EN