• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to get the last Inserted ID after insert data using the query builder ?

#1
Hello !

Does anyone knows how to get the last Inserted ID after insert data using the query builder class?

In CI 3 I just used:
PHP Code:
$this->db->insert_id(); 

What would be the equivalent in CI 4 ?

PHP Code:
    public function insertNewCandidate($candidate) {

        $db      = \Config\Database::connect();
        $builder $db->table('dados_candidates');
        
        $query 
$builder->insert($candidate);

        if( $query ):
            
            
return ?????????????;
            
        
else: 

            return FALSE;
            
        
endif;
        
    


And YES, I do want to use query builder for this... 

I tried to find it in $db, $builder and $query... But it is not there....
Reply

#2
(10-05-2019, 07:44 PM)donpwinston Wrote: Did you try:

$query = $db->query("SOME QUERY");

$id = $query->resultID;

This worked:

PHP Code:
return $db->insertID(); 

The problem is that when you search the User Guide for "insert id" or "insert_id" it returns 0 results.... That is why I couldn´t find it.

But it is there: https://codeigniter4.github.io/userguide...lpers.html 

Thank you !

Confused
Reply

#3
Working With Databases - Query Helper Functions
What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.