public function json_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.' left join '.$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' or recycle = '-1') {$where}"; } $data = $this->table->getdata($table, '*', $where, $order); foreach($data as $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”;
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}%' ";
总结
以上就是这篇文章的全部内容了，希望数据库技术:getdata table表格数据join mysql方法的内容对大家的学习或者工作具有一定的参考学习价值，谢谢大家对<计算机技术网(www.ctvol.com)!!>的支持。如果你想了解更多相关内容请查看下面相关链接
需要了解更多数据库技术:getdata table表格数据join mysql方法，都可以关注数据库技术分享栏目—计算机技术网(www.ctvol.com)!
本文来自网络收集，不代表计算机技术网立场，如涉及侵权请联系管理员删除。
ctvol管理联系方式QQ:251552304
本文章地址：https://www.ctvol.com/dtteaching/831524.html