drupal7 常用的数据读取API

so_brave

drupal7 常用的数据读取API

1. // node
   
2. node_load($nid = NULL, $vid = NULL, $reset = FALSE);
   
3. node_load_multiple($nids = array(), $conditions = array(), $reset = FALSE);
   
4. 
   
5. // user
   
6. user_load($uid, $reset = FALSE);
   
7. user_load_multiple($uids = array(), $conditions = array(), $reset = FALSE);
   
8. 
   
9. // menu tree
   
10. menu_tree_all_data($menu_name, $link = NULL, $max_depth = NULL);
    
11. menu_tree_page_data($menu_name, $max_depth = NULL, $only_active_trail = FALSE);
    
12. 
    
13. // term
    
14. taxonomy_term_load($tid) : object
    
15. taxonomy_term_load_multiple($tids = array(), $conditions = array()) : array
    
16. taxonomy_get_tree($vid, $parent = 0, $max_depth = NULL, $load_entities = FALSE) : array
    
17. 
    
18. // block
    
19. block_load($module, $delta);
    
20. 
    
21. // Pager
    
22. db_select('node', 'n')
    
23.     ->extend('PagerDefault')->limit(5)
    
24.     ->fields('n');
    
25. ->fetchField();
    
26. db_query_range('SELECT n.nid, n.title, n.created
    
27.   FROM {node} n WHERE n.uid = :uid', 0, 10, array(':uid' => $uid));
    
28. 
    
29. $fields = array('nid' => 1, 'title' => 'my title', 'body' => 'my body');
    
30. db_insert('node')->fields($fields)->execute();
    
31. 
    
32. db_update('example')
    
33.   ->condition('id', $id)
    
34.   ->fields(array('field2' => 10))
    
35.   ->execute();
    
36. 
    
37. // select
    
38. $query = db_select('comment', 'c')
    
39.   ->fields('c', array('subject', 'name'))
    
40.   ->fields('n', array('title'))
    
41.   ->extend('PagerDefault')->limit(5)
    
42.   ->condition('n.type', array('article'), 'IN')
    
43.   ->orderBy('c.cid', 'DESC');
    
44. $query->join('node', 'n', 'n.nid = c.nid');
    
45. $data = $query->execute();
    

复制代码