这篇文章主要为大家展示了“getdata table表格数据join mysql方法的示例分析”，内容简而易懂，条理清晰，希望能够帮助大家解决疑惑，下面让小编带领大家一起研究并学习一下“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.' Left JOIN '.$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'];//获取搜索关键词$search2=$term1?"andusernamelike'%{$term1}%'":'';//增加查询报名表编号$table=load::sys_class('tabledata','new');//$where="lang='cn'{$search}{$search2}";//在条件语句中加入查询条件$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[]="<aclass='btnbtn-dangerview_error'lay-id='{$val['id']}'href='javascript:;'><iclass='glyphiconglyphicon-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";

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'];//获取搜索关键词$search2=$term1?"andusernamelike'%{$term1}%'":'';//增加查询报名表编号$table=load::sys_class('tabledata','new');//$where="lang='cn'{$search}{$search2}";//在条件语句中加入查询条件$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[]="<aclass='btnbtn-dangerview_error'lay-id='{$val['id']}'href='javascript:;'><iclass='glyphiconglyphicon-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}.usernamelike'%{$term1}%'";

以上是“getdata table表格数据join mysql方法的示例分析”这篇文章的所有内容，感谢各位的阅读！相信大家都有了一定的了解，希望分享的内容对大家有所帮助，如果还想学习更多知识，欢迎关注亿速云行业资讯频道！