original_string: protected function dbUpdate($category, $key, $value)
      {
          $updated_by = \Yii::$app->user->getId();
          $this->getDb()->createCommand('
              UPDATE
                  {{setting}}
              SET
                  `value` = :value,
                  `updated_at` = NOW(),
                  `updated_by` = :updated_by
              WHERE
                  category = :category
                  AND `key` = :key
          ', compact('category', 'key', 'value', 'updated_by'))->execute();
      }
code: protected function dbUpdate($category, $key, $value)
      {
          $updated_by = \Yii::$app->user->getId();
          $this->getDb()->createCommand('
              UPDATE
                  {{setting}}
              SET
                  `value` = :value,
                  `updated_at` = NOW(),
                  `updated_by` = :updated_by
              WHERE
                  category = :category
                  AND `key` = :key
          ', compact('category', 'key', 'value', 'updated_by'))->execute();
      }
code_tokens: protected function dbUpdate ( $ category , $ key , $ value ) { $ updated_by = \ Yii :: $ app -> user -> getId ( ) ; $ this -> getDb ( ) -> createCommand ( '
              UPDATE
                  {{setting}}
              SET
                  `value` = :value,
                  `updated_at` = NOW(),
                  `updated_by` = :updated_by
              WHERE
                  category = :category
                  AND `key` = :key
          ' , compact ( 'category' , 'key' , 'value' , 'updated_by' ) ) -> execute ( ) ; }
docstring: Updates setting in database
  
  @param string $category Category name
  @param string $key Setting key
  @param string $value Setting value
  @throws \yii\db\Exception
docstring_tokens: Updates setting in database