How to get last insert id after call $dw->save();

[timothy259856]

Hello guys!

When I execute an insert item to my table use $dw->save(); how can I get the id which created after call save()?

I know that Zend support the $db->lastInsertId() but where to do this? Do I need do anything in the DataWriter?

Thank you!

 

[Chris D]

$dw->get('whatever_your_id_field_is_called');

 

[timothy259856]

$dw->get('whatever_your_id_field_is_called');

Understood! Thanks for your support

 

[timothy259856]

$dw->get('whatever_your_id_field_is_called');

Sorry but look like it cannot get the key of table, I have defined the key with name is "id" auto increasment but after call $dw->save(), it's return null when get the "id".

 

[Chris D]

In that case, try:

$dw->save();
$record = $dw->getMergedData();
$id = $record['id'];

 

[timothy259856]

In that case, try:

$dw->save();
$record = $dw->getMergedData();
$id = $record['id'];

Error: Undefined index: id

 

[Chris D]

What is the name of your auto increment field in the database?

 

[timothy259856]

What is the name of your auto increment field in the database?

"id" , I try to var_dump the $recod and saw that it's contain all field except the "id".

 

[Chris D]

Are you sure the $dw->save(); actually worked without errors? You're not forcing the errors to be silent? Can you see the data in the database at that point?

This approach is used throughout XenForo to get the data that's just been saved to the database.

 

[timothy259856]

Are you sure the $dw->save(); actually worked without errors? You're not forcing the errors to be silent? Can you see the data in the database at that point?

This approach is used throughout XenForo to get the data that's just been saved to the database.

Yes, I do the check, I saw the data was insert in database. I can get others field but not for the key.

 

[Chris D]

Is your id field marked as "autoIncrement" in the _getFields function in your datawriter?

 

[timothy259856]

Is your id field marked as "autoIncrement" in the _getFields function in your datawriter?

Oops! Missing that mark, it's work now. Thanks Chris

 

[HQCoder]

What is the name of your auto increment field in the database?

$dw->getMergedData
how to use it in xenforo 2.0?