getdatatable表格数据joinmysql方法

 function dotable_course_user_list_json(){
 global $_M;
 $id=$_M[form]['id'];//教师模块ID
 $tid=$_M[form]['tid'];//教师登录用户ID
 $tn=$_M[form]['tn'];//教师用户名
 $term1 = $_M[form]['search_title']; //获取搜索关键词
 $search1 = $term1 ?"and username like '%{$term1}%' ":'';//增加查询报名表编号
 $table = load::sys_class('tabledata', 'new');
 //$where = "lang='cn' {$search} {$search1}"; //在条件语句中加入查询条件 $search
 $u = $_M['table']['user'];
 $o = $_M['table']['shopv2_order'];
 $d = $u.' Left JOIN '.$o." ON {$u}.id = {$o}.uid";
 //$table = $u.' Left JOIN '.$a." ON (find_in_set(u.id,a.user_id) != 0)";
 $where = "{$u}.lang='{$_M['lang']}'";
 $order = "{$u}.id DESC";
 $array = $table->getdata($d, '*', $where, $order);
 //$data = $this->table->getdata($table, '*', $where, $order)
 //$time=date('Y-m-d H:i:s',time());
 foreach($array as $key => $val){
 //会员组
 $rs_user_group=DB::get_one("SELECT id,name FROM ".$_M['table']['user_group']." where id='$val[groupid]' ");
 //状态
 //班型
 //$rs1=DB::get_all("SELECT s.class_id,a.user_id,a.id,a.number,cc.classhour FROM ".$_M['table']['my_application']." as a INNER JOIN ".$_M['table']['my_application_subject']." as s ON a.number=s.number INNER JOIN ".$_M['table']['my_class']." as c ON s.class_id=c.id INNER JOIN ".$_M['table']['my_class_course']." as cc ON cc.class_id=c.id where s.class_id<>0 and s.type_11=0 and c.teachers_id='$val[id]' and cc.endtime>'$time'");
 $list = array();
 $list[] = "{$val['username']}";
 $list[] = "{$rs_user_group['name']}";
 $list[] = "";
 $list[] = "";
 $list[] = "";
 $list[] = "";
 $list[] = "";
 $list[] = "";
 $list[] = "";
 $list[] = "<a class='btn btn-danger view_error' lay-id='{$val['id']}' href='javascript:;'><i class='glyphicon glyphicon-edit'></i> 错题集</a>";
 $list[] = "";
 $list[] = "";
 $rarray[] = $list;
 }
 // dump($rarray);
 $table->rdata($rarray);//返回数据
 }

例子二：join find_in_set

                    $u = $_M['table']['user'];
                    $a = $_M['table']['my_application'];
                    $d = $u.' Left JOIN '.$a." ON find_in_set({$u}.id,{$a}.user_id) != 0";

 function dotable_course_user_list_json(){
 global $_M;
 $id=$_M[form]['id'];//教师模块ID
 $tid=$_M[form]['tid'];//教师登录用户ID
 $tn=$_M[form]['tn'];//教师用户名
 $term1 = $_M[form]['search_title']; //获取搜索关键词
 $search1 = $term1 ?"and username like '%{$term1}%' ":'';//增加查询报名表编号
 $table = load::sys_class('tabledata', 'new');
 //$where = "lang='cn' {$search} {$search1}"; //在条件语句中加入查询条件 $search
 $u = $_M['table']['user'];
 //$o = $_M['table']['shopv2_order'];
 $a = $_M['table']['my_application'];
 //$d = $u.' Left JOIN '.$o." ON {$u}.id = {$o}.uid";
 $d = $u.' Left JOIN '.$a." ON find_in_set({$u}.id,{$a}.user_id) != 0";
 $where = "{$u}.lang='{$_M['lang']}'";
 $order = "{$u}.id DESC";
 $array = $table->getdata($d, '*', $where, $order);
 //$data = $this->table->getdata($table, '*', $where, $order)
 //$time=date('Y-m-d H:i:s',time());
 foreach($array as $key => $val){
 //会员组
 $rs_user_group=DB::get_one("SELECT id,name FROM ".$_M['table']['user_group']." where id='$val[groupid]' ");
 //状态
 //班型
 //$rs1=DB::get_all("SELECT s.class_id,a.user_id,a.id,a.number,cc.classhour FROM ".$_M['table']['my_application']." as a INNER JOIN ".$_M['table']['my_application_subject']." as s ON a.number=s.number INNER JOIN ".$_M['table']['my_class']." as c ON s.class_id=c.id INNER JOIN ".$_M['table']['my_class_course']." as cc ON cc.class_id=c.id where s.class_id<>0 and s.type_11=0 and c.teachers_id='$val[id]' and cc.endtime>'$time'");
 $list = array();
 $list[] = "{$val['username']}";
 $list[] = "{$rs_user_group['name']}";
 $list[] = "";
 $list[] = "";
 $list[] = "";
 $list[] = "";
 $list[] = "";
 $list[] = "";
 $list[] = "";
 $list[] = "<a class='btn btn-danger view_error' lay-id='{$val['id']}' href='javascript:;'><i class='glyphicon glyphicon-edit'></i> 错题集</a>";
 $list[] = "";
 $list[] = "";
 $rarray[] = $list;
 }
 // dump($rarray);
 $table->rdata($rarray);//返回数据
 }

注意：

1、列出全部数据

$data = $this->table->getdata($table, '*', $where, $order)

2、只列出指定字段数据

$array = $table->getdata($d, "{$u}.username,{$u}.groupid", $where, $order);

3、模糊查询

$where = "{$u}.lang='{$_M['lang']}' and {$u}.username like '%{$term1}%' ";

总结