Get last inserted id

Yii 1.1 General Discussion
1

How can I get last inserted id after saving model?

2

Hi,

If You are using:





if($model->save())

{

	// than you can get id just like that

	

	$model->id // this is inserted item id

}
3 



$insert_id = Yii::app()->db->getLastInsertID();
4

I prefer this method

1 Like
5

Thanx, I have got it!

6

If after save(), $model->id is not updated, it means you affect $model->id before save.

Please check this thread for more details : http://www.yiiframework.com/forum/index.php/topic/17764-save-doesnt-set-id/page__gopid__138995#entry138995

I hope it could help someone ;)

7

using

if(isset($_POST[‘ArticleCategory’])) {

        $model->attributes=$_POST['ArticleCategory'];


        $config = Yii::app()->params->notEndcodeFields;// is array('id');


        //Clean data


        $p = new CHtmlPurifier();


        $model->description = $p->purify($model->description);


        foreach($model->attributes as $key=>$val){


            if(!in_array($key, $config)){


                $model->$key = CHtml::encode($val);


            }


        }

}

8

But I thinks $model->primaryKey is better.

9

I want last id of respective table. What should I do in such scenario.

10

How do you mean by respective table?

Here are example:




$student = new Student();

$student->name = "John";

if($student->save()){

	echo $student->id;//This is the ID of a newly inserted student in a database

}

The same logic applies if you are working with any other database table.