getdata table表格数据join mysql方法
作者:我是高手高手高高手 时间:2024-01-25 17:55:08
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}%' ";
来源:https://blog.csdn.net/haibo0668/article/details/83903812
标签:join,mysql,getdata,table,表格数据


猜你喜欢
python 文件读写和数据清洗
2021-02-10 22:58:43
《写给大家看的设计书》阅读笔记之对齐原则
2009-07-09 16:32:00

python元组的概念知识点
2022-01-03 19:29:19
JS使用ajax从xml文件动态获取数据显示的方法
2024-04-19 10:06:36
mysql主从服务器同步心得体会第1/2页
2024-01-18 13:34:20
Python标准库笔记struct模块的使用
2024-01-01 14:21:45
如何使用Python程序完成描述性统计分析需求
2021-01-11 22:11:20

python起点网月票榜字体反爬案例
2021-03-11 02:56:05

源码解析python的内存回收机制
2023-05-19 18:12:16
Python学习笔记之文件的读写操作实例分析
2023-08-28 04:29:06
PHPStudy hosts文件可能不存在或被阻止打开及同步hosts失败问题
2023-06-08 10:29:10

教你轻松恢复/修复SQL Server的MDF文件
2024-01-28 17:30:49
python爬虫之异常捕获及标签过滤详解
2021-08-10 07:32:06

python监控linux内存并写入mongodb(推荐)
2022-02-04 11:28:01
Python实现四个经典小游戏合集
2021-08-16 12:17:35

MySQL中对于NULL值的理解和使用教程
2024-01-27 22:51:02
python IDLE添加行号显示教程
2022-03-30 18:55:52

Python列表推导式与生成器表达式用法示例
2023-05-31 01:30:40
Appium+Python自动化测试之运行App程序示例
2023-07-29 01:54:20

Django url,从一个页面调到另个页面的方法
2021-08-08 03:51:51