Get the latest inserted ID

[GePraxa]

This is not working, as I have to?

<?php
if(isset($_POST['submit'])) {

$db = DB::getInstance();

$fields=array(
'var1' => $var1,
'var2' => $var2
);
if($db->insert('table',$fields)){
$yes[] = 'text';
}else{
$no[] = 'text';
}

$last_id = $db->lastId();
}
?>

[mudmin]

I think it is an issue of scope. You are trying to pull back the lastId outside of the if statement. It should be...

if($db->insert(‘table’,$fields)){
$last_id = $db->lastId();
$yes[] = ‘text’;
}else{
$no[] = ‘text’;
}
}
?>

[plb]

I agree that your code, Mudmin, is better because it doesn't try to get the $last_id if the insert was unsuccessful. But I've never heard of scope issues like this in PHP related to an if statement...

@GePraxa, when you say it wasn't working, what was not working? Is it possible your insert was failing and that was causing the problem?

[mudmin]

Maybe I'm wrong there, but I've seem to remember that if you don't pull the lastId back almost immediately I've had a hard time getting it back.