欧美bbbwbbbw肥妇,免费乱码人妻系列日韩,一级黄片

getdata table表格數(shù)據(jù)join mysql方法

 更新時間：2019年02月27日 14:50:35   作者：我是高手高手高高手  
今天小編就為大家分享一篇關于getdata table表格數(shù)據(jù)join mysql方法，小編覺得內(nèi)容挺不錯的，現(xiàn)在分享給大家，具有很好的參考價值，需要的朋友一起跟隨小編來看看吧
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]' ");
    //狀態(tài)
     //班型
    //$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);//返回數(shù)據(jù)
  }

例子二：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]' ");
    //狀態(tài)
     //班型
    //$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);//返回數(shù)據(jù)
  }

注意：

1、列出全部數(shù)據(jù)

$data = $this->table->getdata($table, '*', $where, $order)

2、只列出指定字段數(shù)據(jù)

$array = $table->getdata($d, "{$u}.username,{$u}.groupid", $where, $order);

3、模糊查詢

$where = "{$u}.lang='{$_M['lang']}' and {$u}.username like '%{$term1}%' ";

總結

以上就是這篇文章的全部內(nèi)容了，希望本文的內(nèi)容對大家的學習或者工作具有一定的參考學習價值，謝謝大家對腳本之家的支持。如果你想了解更多相關內(nèi)容請查看下面相關鏈接

相關文章

  • MySQL Innodb表導致死鎖日志情況分析與歸納

    MySQL Innodb表導致死鎖日志情況分析與歸納

    發(fā)現(xiàn)當備份表格的sql語句與刪除該表部分數(shù)據(jù)的sql語句同時運行時，mysql會檢測出死鎖，并打印出日志
    2012-12-12

    • 最新評論