/PHP/How to get last id in database codeigniter 4

How to get last id in database codeigniter 4

Last insert id model codeigniter

function add_post($post_data){
   $this->db->insert('posts', $post_data);
   $insert_id = $this->db->insert_id();

   return  $insert_id;
}

2

Source: stackoverflow.com

How to get last id in database codeigniter 4

  $db = db_connect();
  $query = $db->query("SELECT * FROM users ORDER BY id DESC LIMIT 1");
  $result = $query->getRow();

1

Codeigniter return last inserted id

   $this->db->insert('posts', $post_data);
   $insert_id = $this->db->insert_id();
   return  $insert_id;

0

Similar codes

5 votes155 views4 answers
Create database from migration laravel for all
PHP Laravel
0 vote118 views2 answers
Iframe site bi link laravel
PHP
1 vote137 views1 answer
Maximum execution time of 60 seconds exceeded laravel 8
PHP Laravel
3 votes110 views3 answers
Seconds to days hours minutes seconds php
PHP
0 vote114 views1 answer
Strtotime add 1 hour
PHP
15 votes105 views3 answers
Laravel date set timezone
PHP
9 votes129 views6 answers
How to receive json data in php
PHP
0 vote132 views1 answer
Laravel get current domain
PHP Laravel
2 votes88 views2 answers
Jquery click function not working
PHP
6 votes139 views2 answers
Laravel debugbar disable in production
PHP Laravel

Share