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 python的qt5界面
  • ¥15 无线电能传输系统MATLAB仿真问题
  • ¥50 如何用脚本实现输入法的热键设置
  • ¥20 我想使用一些网络协议或者部分协议也行,主要想实现类似于traceroute的一定步长内的路由拓扑功能
  • ¥30 深度学习,前后端连接
  • ¥15 孟德尔随机化结果不一致
  • ¥15 apm2.8飞控罗盘bad health,加速度计校准失败
  • ¥15 求解O-S方程的特征值问题给出边界层布拉休斯平行流的中性曲线
  • ¥15 谁有desed数据集呀
  • ¥20 手写数字识别运行c仿真时,程序报错错误代码sim211-100