Rumah > Artikel > pembangunan bahagian belakang > php如何$_G两个数据表里的不同数据?
这是原来的调用:
$_G['db']->from('dbpre_subject');
$_G['db']->select('*');
$_G['db']->where('city_id', array(0,$_CITY['aid']));
$_G['db']->where_concat_like('name,subname', "%{$q}%");
$_G['db']->where('status', 1);
现在我要在此基础之上,在调用dbpre_subject_product_new 这个数据表里的c_product_price和c_product_content这两个字段,,,改怎么写,,,先谢谢诸位大神了
//把源码贴上
!defined('IN_MUDDER') && exit('Access Denied');
$city_id = _get('city_id', null, MF_INT_KEY);
if($city_id>0) {
<code>$citys = $_G['loader']->variable('area'); if(!$city = $citys[$city_id]) redirect('global_area_city_id_invalid'); if(!$city['enabled']) redirect('global_area_city_disabled'); init_city($city_id);</code>
}
$q = _input('keyword', '', MF_TEXT);
if(($_GET['Pathinfo'] || $_GET['Rewrite']) && $q && $_G['charset'] != 'utf-8' && $_G'cfg') {
<code>$q = charset_convert($q,'utf-8',$_G['charset']);</code>
}
$q = str_replace(array("rn","r","n") ,'', _T($q));
$_G['db']->from('dbpre_subject');
$_G['db']->select('*');
$_G['db']->where('city_id', array(0,$_CITY['aid']));
$_G['db']->where_concat_like('name,subname', "%{$q}%");
$_G['db']->where('status', 1);
$multipage = '';
if($total = $_G['db']->count()) {
<code>$_G['db']->sql_roll_back('from,select,where'); $orderby = array($post['ordersort']=>$post['ordertype']); $offset = 10; $start = get_start($_GET['page'], $offset); $_G['db']->order_by($orderby); $_G['db']->limit($start, $offset); $list = $_G['db']->get(); if($total) { $multipage = mobile_page($total, $offset, $_GET['page'], url("item/mobile/do/search/keyword/$q/page/_PAGE_")); }</code>
}
//显示模版
if($_G['in_ajax']) {
<code>include mobile_template('item_list_li'); output();</code>
}
$title = '搜索产品:'.$q;
include mobile_template('item_list');
这是原来的调用:
$_G['db']->from('dbpre_subject');
$_G['db']->select('*');
$_G['db']->where('city_id', array(0,$_CITY['aid']));
$_G['db']->where_concat_like('name,subname', "%{$q}%");
$_G['db']->where('status', 1);
现在我要在此基础之上,在调用dbpre_subject_product_new 这个数据表里的c_product_price和c_product_content这两个字段,,,改怎么写,,,先谢谢诸位大神了
//把源码贴上
!defined('IN_MUDDER') && exit('Access Denied');
$city_id = _get('city_id', null, MF_INT_KEY);
if($city_id>0) {
<code>$citys = $_G['loader']->variable('area'); if(!$city = $citys[$city_id]) redirect('global_area_city_id_invalid'); if(!$city['enabled']) redirect('global_area_city_disabled'); init_city($city_id);</code>
}
$q = _input('keyword', '', MF_TEXT);
if(($_GET['Pathinfo'] || $_GET['Rewrite']) && $q && $_G['charset'] != 'utf-8' && $_G'cfg') {
<code>$q = charset_convert($q,'utf-8',$_G['charset']);</code>
}
$q = str_replace(array("rn","r","n") ,'', _T($q));
$_G['db']->from('dbpre_subject');
$_G['db']->select('*');
$_G['db']->where('city_id', array(0,$_CITY['aid']));
$_G['db']->where_concat_like('name,subname', "%{$q}%");
$_G['db']->where('status', 1);
$multipage = '';
if($total = $_G['db']->count()) {
<code>$_G['db']->sql_roll_back('from,select,where'); $orderby = array($post['ordersort']=>$post['ordertype']); $offset = 10; $start = get_start($_GET['page'], $offset); $_G['db']->order_by($orderby); $_G['db']->limit($start, $offset); $list = $_G['db']->get(); if($total) { $multipage = mobile_page($total, $offset, $_GET['page'], url("item/mobile/do/search/keyword/$q/page/_PAGE_")); }</code>
}
//显示模版
if($_G['in_ajax']) {
<code>include mobile_template('item_list_li'); output();</code>
}
$title = '搜索产品:'.$q;
include mobile_template('item_list');
你这是什么框架呢?不同的框架有不同的语法