邓_tp_笔记

<?php
namespace app\teacher\controller;
use think\Db;
use app\common\model\Classcourse;
use app\common\model\Rwtype;
use app\common\model\Score as Score_Model;
use app\common\model\Rwgl as modelRwgl;
use app\common\model\Classcoursestudent as CcsModel;

use think\Request;
class Score extends Base{

$cnt=Score_Model::where('rwglid',$this->rwglid)->count();

$mysql = Db::table('classcoursestudent')
                       ->where('classcourseid',$id)
                       ->where('no',$myno)
                       ->update($score);

$arr = DB::name('rwgl')
               ->where('classcourseid',$classcourseid)
               ->where('rwtypeid',$rwtypeid)
               //->select();
               ->column("concat(date,'<br>',name) as name","id");

$list = Db::name('Classcoursestudent a')
               ->join('Student b','a.no=b.no' )　　　　————关联数组
               ->where('a.classcourseid',$courseid)
               ->where('a.delete_time','null')
               ->where('b.delete_time','null')
               ->select();

$list=Db::table('classcoursestudent')
               ->alias('ccs')　　　　　　———————————————————别名
               ->field('no,name,groupno,null as score,null as id')　　————————字段名
               ->where('classcourseid',$this->classcourseid)
               ->select();

巴特西

邓_tp_笔记

最新文章

热门文章