Since the id of the record is Auto_Increment, I don’t need to write a line like $data->id=…;and save it.
But the problem is I have the other table which is working together with this table and use primary key of that table as a foreign key.
How do i do that?Thanks!
If the save is successful it will load the primary key into the model, so in your case you just use $data->id after saving it.
have u ever realize in the blog postController, actionCreate look like this
when it saved, view will redirect into new id?
say you have a newly created model in $model
echo $model->id; // nothing NULL
$model->save(); // AR saves the model to DB and fills in the blanks with defaults
echo $model->id; // INT (the id columns value)
Is that what you where looking for?
(Maurizio Domba Cerin)
NOTE: merged duplicate thread
$last = Yii::app()->db->getLastInsertID();
Thank you all,I’ve solved this problem using gandaliter’s method! Simple and useful.