I want to update my table/model
. The scenario is, I have a 'status' column, I want to SET
this column to a value then update the model based on the id
. I want to do something like update
statement.
Update 'table' SET status = 'status value' where id = 'myid'
My action controller
look like
$model = $this->findModel($id);
$ogp_id = $model->id;
$status = $model->status;
I have searched for it but couldn't find a solution
Any help would be highly appreciated
This Works for me
I added a function
protected function findModel($id)
{
if (($model = Ogpheader::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
Then access it inside the controller
$model = $this->findModel($id);
$ogp_id = $model->id;
Then while saving my model I have done the following
if($m->save())
{
$model->status = Ogpheader::$status_titles[1];
$model->update();
//my other code
}
This has updated my table and set the column as required