unable delete all selected checkbox rows in yii2

Question

can anybody explain me how to delete only selected row or all selected row by checkbox it have below code but giving me error sql exception

Exception (Database Exception) 'yii\db\Exception' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'where clause'
The SQL being executed was: DELETE FROM usermaster WHERE id='28'' 

 public function actionMultipledelete() {
        if (\Yii::$app->request->post()) {

            $keys=array();
           $keys = \Yii::$app->request->post('id'); // id is array
        }

        UsermasterModel::deleteAll(['IN','id',$keys]);
            return $this->redirect(['index']);

    }

Yasar Arafath · Accepted Answer · 2016-11-03 04:59:15Z

0

Simply use this

$keys = implode(',', $array);

$connection = Yii::$app->db; $command = $connection->createCommand("DELETE FROM usermaster where id IN (".$keys.")");

answered Nov 3, 2016 at 4:59

Yasar Arafath

6231 gold badge10 silver badges31 bronze badges

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

Collectives™ on Stack Overflow

unable delete all selected checkbox rows in yii2

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related