這篇文章主要為大家展示了“getdata table表格數(shù)據(jù)join mysql方法的示例分析”,內(nèi)容簡(jiǎn)而易懂,條理清晰,希望能夠幫助大家解決疑惑,下面讓小編帶領(lǐng)大家一起研究并學(xué)習(xí)一下“getdata table表格數(shù)據(jù)join mysql方法的示例分析”這篇文章吧。
創(chuàng)新互聯(lián)公司主要從事成都網(wǎng)站設(shè)計(jì)、成都做網(wǎng)站、網(wǎng)頁設(shè)計(jì)、企業(yè)做網(wǎng)站、公司建網(wǎng)站等業(yè)務(wù)。立足成都服務(wù)寧海,十載網(wǎng)站建設(shè)經(jīng)驗(yàn),價(jià)格優(yōu)惠、服務(wù)專業(yè),歡迎來電咨詢建站服務(wù):028-86922220public 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']){//開啟在線訂購時(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)鍵詞 $search2 = $term1 ?"and username like '%{$term1}%' ":'';//增加查詢報(bào)名表編號(hào) $table = load::sys_class('tabledata', 'new'); //$where = "lang='cn' {$search} {$search2}"; //在條件語句中加入查詢條件 $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[] = " 錯(cuò)題集"; $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)鍵詞 $search2 = $term1 ?"and username like '%{$term1}%' ":'';//增加查詢報(bào)名表編號(hào) $table = load::sys_class('tabledata', 'new'); //$where = "lang='cn' {$search} {$search2}"; //在條件語句中加入查詢條件 $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[] = " 錯(cuò)題集"; $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}%' ";
以上是“getdata table表格數(shù)據(jù)join mysql方法的示例分析”這篇文章的所有內(nèi)容,感謝各位的閱讀!相信大家都有了一定的了解,希望分享的內(nèi)容對(duì)大家有所幫助,如果還想學(xué)習(xí)更多知識(shí),歡迎關(guān)注創(chuàng)新互聯(lián)行業(yè)資訊頻道!