Yii :: app ()->db->lastInsertId returns 0 - MySQL

Yii 1.1 General Discussion
1

Good afternoon,

By invoking the save method, execute the function Yii :: app () -> db-> lastInsertId I value returns 0, even if it has been saved successfully.

I’ve tried to do this in a new connection to avoid duplicate connections, but without success:




$conn = Yii::app()->db;

$conn->open();

$model->save();

$id = Yii::app()->db->lastInsertID;

$conn->close();

var_dump($id); die; //return 0

My table is with AUTO_INCREMENT.

Thank you!

2

You can get it very easily:




    $model->save();

    $last_insert_id = $model->id;
3

Hello


if ($model->save()) {

    $model->refresh(); // necessary for new records only, so you could refresh only if ($model->isNewRecord)

    var_dump($model->id); // returns the newly inserted Id

}
4

Thank’s!