db->createCommand($sql1)->execute(); // 将 name=mall/setting/memory 的记录的 pid 更新为 2823 $sql2 = <<db->createCommand($sql2)->execute(); // 查找第二个 name=mall/setting 的记录的 id $sql3 = <<db->createCommand($sql3)->queryScalar(); // 如果找到了第二个记录，则更新其 status 为 -1 if ($secondRecordId !== false) { $sql4 = <<db->createCommand($sql4)->bindValue(':id', $secondRecordId)->execute(); } } catch (\Exception $e) { \Yii::error('更新权限菜单错误了：' . $e->getMessage()); } } /** * {@inheritdoc} */ public function safeDown() { echo "M240627092257QimallRbacAuthItemUpdate cannot be reverted.\n"; return false; } /* // Use up()/down() to run migration code without a transaction. public function up() { } public function down() { echo "M240627092257QimallRbacAuthItemUpdate cannot be reverted.\n"; return false; } */ }