• 企业400电话
  • 微网小程序
  • AI电话机器人
  • 电商代运营
  • 全 部 栏 目

    企业400电话 网络优化推广 AI电话机器人 呼叫中心 网站建设 商标✡知产 微网小程序 电商运营 彩铃•短信 增值拓展业务
    getdata table表格数据join mysql方法
    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}%' ";

    总结

    以上就是这篇文章的全部内容了,希望本文的内容对大家的学习或者工作具有一定的参考学习价值,谢谢大家对脚本之家的支持。如果你想了解更多相关内容请查看下面相关链接

    您可能感兴趣的文章:
    • Mysql忘记密码的几种解决方案
    • Tomcat+Mysql高并发配置优化讲解
    • 为什么MySQL数据库索引选择使用B+树?
    • Mysql的水平分表与垂直分表的讲解
    • CMD命令操作MySql数据库的方法详解
    • Mysql5.6修改root密码教程
    • MySql闪退和服务无法启动的解决方法
    • Mysql5.7修改root密码教程
    • Mysql Update批量更新的几种方式
    • MySQL存储引擎MyISAM与InnoDB区别总结整理
    上一篇:MySQL开启Slow慢查询的方法示例
    下一篇:mysql的集群模式 galera-cluster部署详解
  • 相关文章
  • 

    © 2016-2020 巨人网络通讯 版权所有

    《增值电信业务经营许可证》 苏ICP备15040257号-8

    getdata table表格数据join mysql方法 getdata,table,表格,数据,join,