yii2: delete values in two tables using single controller action?

Question

I have two tables table1 and table2 and I am trying to delete row in these two table.I have same values on both table but id is different so i tried like this, my controller,

 public function actionDelete($id)
 {
 $this->findModel($id);
 $select = Employee::find()
            ->select('Name')
            ->where(['Id' => $id])
            ->all();
$deluser=Employee::find()->where(['Id' => $id])->one()->delete() AND User::find()->where(['Name' =>$select])->one();
$deluser->delete();
 return $this->redirect(['index','select'=>$select]);
}

pls anyone help me Thanks in advance

pls put it back, what you have change in your question

Muhammad Shahzad
– Muhammad Shahzad

2016-06-16 05:42:05 +00:00
Commented Jun 16, 2016 at 5:42 — Muhammad Shahzad
– Muhammad Shahzad, Commented Jun 16, 2016 at 5:42

Muhammad Shahzad · Accepted Answer · 2016-06-15 08:10:34Z

3

Employee class is object.

Try this:

public function actionDelete($id)
{
    $this->findModel($id);
    $select = Employee::find()
                ->select('Name')
                ->where(['Id' => $id])
                ->all();

    Employee::find()->where(['id' => $id])->one()->delete();

    User::find()->where(['id' =>$id])->one()->delete();

    return $this->redirect(['index','select'=>$select]);
}

edited Jun 15, 2016 at 8:10

answered Jun 15, 2016 at 8:05

Muhammad Shahzad

9,68022 gold badges90 silver badges130 bronze badges

Sign up to request clarification or add additional context in comments.

12 Comments

Ammu Over a year ago

I tried this way but PHP Fatal Error – yii\base\ErrorException Call to a member function delete() on a non-object getting this error

Ammu Over a year ago

both table have different id value so i can't delete using $id in user table. But both table have column Name and same value so , how to find name in employee table using $id and based on that name ,delete row in the user table.

Muhammad Shahzad Over a year ago

Why name? why not use some kind of relation, like put user id into employee table as foreign key?

Ammu Over a year ago

ok i created employee id in user table as foreign key instead of you said then how to change my delete query?

Muhammad Shahzad Over a year ago

what is field name in user table? User::find()->where(['employee_id' =>$id])->one()->delete();

|

Collectives™ on Stack Overflow

yii2: delete values in two tables using single controller action?

1 Answer 1

12 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

12 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related