**

Drupal7 數(shù)據庫查詢

**
多數(shù)據庫切換
db_set_active(‘china_led’);

條數(shù)據查詢
單條查詢

db_select('表名', '別名')->fields('別名',數(shù)組字段)->condition('key',value)->execute()->fetchAssoc();

多條查詢返回數(shù)組ID為KEY

db_select('表名', '別名')->fields('別名',數(shù)組字段)->condition('key',value)->execute()->fetchAllAssoc('id');

分頁

$query=db_select('node', 'n')->fields('n',['nid','title'])->fields('fdfs',['field_status_value'])->condition('u.name',$user_name)->condition('c.nid',0,'<>')->condition('c.replay_id',null)->condition('n.type','works_show');$query->leftJoin('users','u','u.uid=n.uid');$query->leftJoin('表名','c','c.nid=n.nid');$query->leftJoin('表名','fdfs','fdfs.entity_id=n.nid');$query->groupBy('taxonomy_term_data.tid');$list =$query->groupBy('nid')->orderBy('n.nid','desc')->extend('PagerDefault')->limit($pagesize)->execute()->fetchAllAssoc('nid'); 更新 $res=db_update('表名')->condition('userid', $user_name)->fields(['turn_num'=>$user_info['turn_num']+1])->execute();插入 db_insert('表名')->fields($fields)->execute(); db_delete('表名')->condition('nid', $nid)->execute(); 打印sql echo (string)$query;exit; 緩存 $cache_key='hh_'.date('Ymd',$start).date('Ymd',$end);if($cached = cache_get($cache_key, 'cache')) {return $cached->data;} cache_set($cache_key,$data, 'cache', time()+24*60*60);

總結

以上是生活随笔為你收集整理的Drupal7 数据库查询的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。