getdata table表格数据join mysql方法
publicfunctionjson_product_list($where,$order){
global$_M;
$this->table=load::sys_class('tabledata','new');
$p=$_M['table']['product'];
$s=$_M['table']['shopv2_product'];
if($_M['config']['shopv2_open']){//开启在线订购时
$table=$p.'LeftJOIN'.$s."ON({$p}.id={$s}.pid)";
$where="{$p}.lang='{$_M['lang']}'and({$p}.recycle='0'or{$p}.recycle='-1'){$where}";
}else{
$table=$p;
$where="lang='{$_M['lang']}'and(recycle='0'orrecycle='-1'){$where}";
}
$data=$this->table->getdata($table,'*',$where,$order);
foreach($dataas$key=>$val){
if(!$val['pid'])$data[$key]['pid']=$val['id'];
}
return$data;
}
例子一：
$u=$_M['table']['user'];
$o=$_M['table']['shopv2_order'];
$d=$u.'LeftJOIN'.$o."ON{$u}.id={$o}.uid";
functiondotable_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?"andusernamelike'%{$term1}%'":'';//增加查询报名表编号
$table=load::sys_class('tabledata','new');
//$where="lang='cn'{$search}{$search1}";//在条件语句中加入查询条件$search
$u=$_M['table']['user'];
$o=$_M['table']['shopv2_order'];
$d=$u.'LeftJOIN'.$o."ON{$u}.id={$o}.uid";
//$table=$u.'LeftJOIN'.$a."ON(find_in_set(u.id,a.user_id)!=0)";
$where="{$u}.lang='{$_M['lang']}'";
$order="{$u}.idDESC";
$array=$table->getdata($d,'*',$where,$order);
//$data=$this->table->getdata($table,'*',$where,$order)
//$time=date('Y-m-dH:i:s',time());
foreach($arrayas$key=>$val){
//会员组
$rs_user_group=DB::get_one("SELECTid,nameFROM".$_M['table']['user_group']."whereid='$val[groupid]'");
//状态
//班型
//$rs1=DB::get_all("SELECTs.class_id,a.user_id,a.id,a.number,cc.classhourFROM".$_M['table']['my_application']."asaINNERJOIN".$_M['table']['my_application_subject']."assONa.number=s.numberINNERJOIN".$_M['table']['my_class']."ascONs.class_id=c.idINNERJOIN".$_M['table']['my_class_course']."asccONcc.class_id=c.idwheres.class_id<>0ands.type_11=0andc.teachers_id='$val[id]'andcc.endtime>'$time'");
$list=array();
$list[]="{$val['username']}";
$list[]="{$rs_user_group['name']}";
$list[]="";
$list[]="";
$list[]="";
$list[]="";
$list[]="";
$list[]="";
$list[]="";
$list[]="错题集";
$list[]="";
$list[]="";
$rarray[]=$list;
}
//dump($rarray);
$table->rdata($rarray);//返回数据
}
例子二：joinfind_in_set
$u=$_M['table']['user'];
$a=$_M['table']['my_application'];
$d=$u.'LeftJOIN'.$a."ONfind_in_set({$u}.id,{$a}.user_id)!=0";
functiondotable_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?"andusernamelike'%{$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.'LeftJOIN'.$o."ON{$u}.id={$o}.uid";
$d=$u.'LeftJOIN'.$a."ONfind_in_set({$u}.id,{$a}.user_id)!=0";
$where="{$u}.lang='{$_M['lang']}'";
$order="{$u}.idDESC";
$array=$table->getdata($d,'*',$where,$order);
//$data=$this->table->getdata($table,'*',$where,$order)
//$time=date('Y-m-dH:i:s',time());
foreach($arrayas$key=>$val){
//会员组
$rs_user_group=DB::get_one("SELECTid,nameFROM".$_M['table']['user_group']."whereid='$val[groupid]'");
//状态
//班型
//$rs1=DB::get_all("SELECTs.class_id,a.user_id,a.id,a.number,cc.classhourFROM".$_M['table']['my_application']."asaINNERJOIN".$_M['table']['my_application_subject']."assONa.number=s.numberINNERJOIN".$_M['table']['my_class']."ascONs.class_id=c.idINNERJOIN".$_M['table']['my_class_course']."asccONcc.class_id=c.idwheres.class_id<>0ands.type_11=0andc.teachers_id='$val[id]'andcc.endtime>'$time'");
$list=array();
$list[]="{$val['username']}";
$list[]="{$rs_user_group['name']}";
$list[]="";
$list[]="";
$list[]="";
$list[]="";
$list[]="";
$list[]="";
$list[]="";
$list[]="错题集";
$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}.usernamelike'%{$term1}%'";
总结
以上就是这篇文章的全部内容了，希望本文的内容对大家的学习或者工作具有一定的参考学习价值，谢谢大家对毛票票的支持。如果你想了解更多相关内容请查看下面相关链接