public function upkc()
{
Db::transaction(function(){
$cx['xh'] = Request::instance()->param('xh');
$kcbh['kcbh'] = Request::instance()->param('kcbh');
$sj = Db::table('student_cz')->where($cx)->field('sfxk,xb')->find();
$kcxx = Db::table('teacher')->where($kcbh)->find();
$data['xzkc1'] = $kcxx['kcmc'];
$data['rkjs1'] = $kcxx['rkjs'];
$data['kcbh1'] = $kcxx['kcbh'];
$data['sfxk'] = 1;
$data['xksj'] = date('Y-m-d H:i:s');
Db::table('student_cz')->where($cx)->update($data);/*学生表更新信息*/
Db::table('teacher')->where($kcbh)->setDec('syrs');/*教师表更新信息*/
return 0;
});
}
public function delkc()
{
Db::transaction(function(){
$cx['xh'] = Request::instance()->param('xh');
$kcbh['kcbh'] = Request::instance()->param('kcbh');
$data['xzkc'] = '';
$data['rkjs'] = '';
$data['kcbh'] = '';
$data['sfxk'] = 0;
Db::table('student')->where($cx)->update($data);/*删除学生表课程信息*/
Db::table('teacher')->where($kcbh)->setInc('syrs');/*删除教师表课程信息*/
return 0;
});
} 最佳答案
