doufu1970 2016-08-24 07:13
浏览 36
已采纳

yii 2 Active Query中的数学运算

Is there a way to subtract a value in a int column to say by 1?I have a button that when it is clicked it will call a function to save the data in the table but I want to know how to subtracting a number in a database using yii 2 I have tried the following code below but it had no effect. Can someone help me how to make math operations in yii 2?

public static function AddSubject($subjectid, $clientid){
    $subject = ActiveCurriculum::findOne(['subjectid' => $subjectid]);

    $activesubject = new ActiveSubject();
    $activesubject->clientid = $clientid;
    $activesubject->subjectid = $subject->subjectid;
    $activesubject->subjectcode = $subject->subjectcode;
    $activesubject->days = $subject->days;
    $activesubject->time = $subject->time;
    $activesubject->section = $subject->section;
    $activesubject->room = $subject->room;
    $activesubject->units = $subject->units;
    $subject->units = $subject->units - 1; //this should subtract the number 
    //of slots by 1 but now it is not working.
    $activesubject->save();

    return true;

    //return static::findOne(['subjectid' => $subjectid]);
                //->where(['subjectid' => $subjectid]);

  }
  • 写回答

2条回答 默认 最新

  • doumen9709 2016-08-24 07:32
    关注

    When You made some changes in your AR object and want your changes to be saved you should execute ->save():

    $subject->units = $subject->units - 1; 
    $subject->save();
    

    Looks like You just forgot to do that.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 微信会员卡等级和折扣规则
  • ¥15 微信公众平台自制会员卡可以通过收款码收款码收款进行自动积分吗
  • ¥15 随身WiFi网络灯亮但是没有网络,如何解决?
  • ¥15 gdf格式的脑电数据如何处理matlab
  • ¥20 重新写的代码替换了之后运行hbuliderx就这样了
  • ¥100 监控抖音用户作品更新可以微信公众号提醒
  • ¥15 UE5 如何可以不渲染HDRIBackdrop背景
  • ¥70 2048小游戏毕设项目
  • ¥20 mysql架构,按照姓名分表
  • ¥15 MATLAB实现区间[a,b]上的Gauss-Legendre积分