快捷導(dǎo)航

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

更新時(shí)間：2019年02月27日 14:50:35 作者：我是高手高手高高手

今天小編就為大家分享一篇關(guān)于getdata table表格數(shù)據(jù)join mysql方法，小編覺(jué)得內(nèi)容挺不錯(cuò)的，現(xiàn)在分享給大家，具有很好的參考價(jià)值，需要的朋友一起跟隨小編來(lái)看看吧

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']){//開(kāi)啟在線訂購(gòu)時(shí)
  $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'];  //獲取搜索關(guān)鍵詞
    $search1 = $term1  ?"and username like '%{$term1}%' ":'';//增加查詢報(bào)名表編號(hào)
    $table = load::sys_class('tabledata', 'new');
    //$where = "lang='cn' {$search} {$search1}"; //在條件語(yǔ)句中加入查詢條件 $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){
    //會(huì)員組
    $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> 錯(cuò)題集</a>";
    $list[] = "";
    $list[] = "";
    $rarray[] = $list;
    }
   // dump($rarray);
   $table->rdata($rarray);//返回?cái)?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'];  //獲取搜索關(guān)鍵詞
    $search1 = $term1  ?"and username like '%{$term1}%' ":'';//增加查詢報(bào)名表編號(hào)
    $table = load::sys_class('tabledata', 'new');
    //$where = "lang='cn' {$search} {$search1}"; //在條件語(yǔ)句中加入查詢條件 $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){
    //會(huì)員組
    $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> 錯(cuò)題集</a>";
    $list[] = "";
    $list[] = "";
    $rarray[] = $list;
    }
   // dump($rarray);
   $table->rdata($rarray);//返回?cái)?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}%' ";

總結(jié)

以上就是這篇文章的全部?jī)?nèi)容了，希望本文的內(nèi)容對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值，謝謝大家對(duì)腳本之家的支持。如果你想了解更多相關(guān)內(nèi)容請(qǐng)查看下面相關(guān)鏈接

您可能感興趣的文章:

相關(guān)文章

MySQL 視圖（View）原理解析
本篇重點(diǎn)講述視圖是如何實(shí)現(xiàn)的，以及視圖如何和查詢優(yōu)化器交互，從而我們可以根據(jù)這些知識(shí)了解如何通過(guò)視圖提高性能。
2021-05-05
MySQL+Redis緩存+Gearman共同構(gòu)建數(shù)據(jù)庫(kù)緩存的方法
這篇文章主要介紹了MySQL+Redis緩存+Gearman共同構(gòu)建數(shù)據(jù)庫(kù)緩存,部署后在MySQL端進(jìn)行創(chuàng)建一個(gè)用戶給與遠(yuǎn)程登錄權(quán)限，使得Redis作為緩存可以用來(lái)同步數(shù)據(jù)使用，需要的朋友可以參考下
2022-10-10
一文帶你搞懂MySQL的MVCC機(jī)制
MySQL中的MVCC機(jī)制想必大家都有所耳聞吧，雖然在平時(shí)MySQL使用過(guò)程中基本上用不到，但是面試中出場(chǎng)率十分高，那么你對(duì)MVCC機(jī)制了解多少呢，MVCC機(jī)制是用來(lái)干嘛的呢，底層的工作原理是怎么樣的呢，本文就帶你一探究竟
2023-07-07
MySQL鎖阻塞的深入分析
這篇文章主要給大家介紹了關(guān)于MySQL鎖阻塞的相關(guān)資料，文中通過(guò)示例代碼介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值，需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)學(xué)習(xí)吧
2020-12-12
MySQL8.0新特性之支持原子DDL語(yǔ)句
這MySQL 8.0開(kāi)始支持原子數(shù)據(jù)定義語(yǔ)言（DDL）語(yǔ)句。此功能稱為原子DDL。這篇文章主要介紹了MySQL8.0新特性——支持原子DDL語(yǔ)句,需要的朋友可以參考下
2018-07-07
SQLyog的下載、安裝、破解、配置教程（MySQL可視化工具安裝）
SQLyog是一款MySQL可視化工具，他可以將部分SQL操作通過(guò)圖形化界面操作來(lái)完成，方便開(kāi)發(fā)者更好的進(jìn)行開(kāi)發(fā)及數(shù)據(jù)庫(kù)設(shè)計(jì)，這篇文章主要介紹了SQLyog的下載、安裝、破解、配置（MySQL可視化工具安裝）,需要的朋友可以參考下
2022-09-09
Linux服務(wù)器中MySQL遠(yuǎn)程連接的開(kāi)啟方法
今天在Linux服務(wù)器上安裝了msyql數(shù)據(jù)庫(kù)，在本地訪問(wèn)的時(shí)候可以訪問(wèn)，但是我想通過(guò)遠(yuǎn)程的方式訪問(wèn)的時(shí)候就不能訪問(wèn)了，查詢資料后發(fā)現(xiàn)，Linux下MySQL默認(rèn)安裝完成后只有本地訪問(wèn)的權(quán)限，沒(méi)有遠(yuǎn)程訪問(wèn)的權(quán)限，需要你給指定用戶設(shè)置訪問(wèn)權(quán)限才能遠(yuǎn)程訪問(wèn)該數(shù)據(jù)庫(kù)
2017-06-06
mysql 5.7.17 免安裝版配置方法圖文教程(windows10)
這篇文章主要為大家詳細(xì)介紹了windows10下mysql 5.7.17 免安裝版配置方法圖文教程，具有一定的參考價(jià)值，感興趣的小伙伴們可以參考一下
2017-01-01
由于程序員寫(xiě)的東西不一定是最優(yōu)的所以我們只要啟用mysql慢查詢?nèi)罩竟δ芫涂梢苑治雒恳粭lsql語(yǔ)句所運(yùn)行相關(guān)性能了，下面大家一起來(lái)看看
2017-01-01