[Drupal] Drupal7 - How to theme a table with pager.

As we know, Drupal7 has changed a lot, and we have to be familiar with it.

 

Here is an example to theme a table with pager.

 

 
      
   $output 
     
   = 
     
   '' 
   ;
   
   $header 
     
   = 
     
   array 
   (
     
   array 
   (
       
   ' 
   data 
   ' 
   => 
   t( 
   ' 
   Title 
   ' 
   ) 
   , 
   
       
   ' 
   field 
   ' 
   => 
   ' 
   n.title 
   ' 
   , 
   
    ) 
   , 
   
     
   array 
   (
       
   ' 
   data 
   ' 
     
   => 
     
   '' 
   , 
   
    ) 
   , 
   
  );

   
   $query 
     
   = 
    db_select( 
   ' 
   node 
   ' 
   , 
     
   ' 
   n 
   ' 
   ) 
   -> 
   extend( 
   ' 
   PagerDefault 
   ' 
   ) 
   -> 
   extend( 
   ' 
   TableSort 
   ' 
   );
   
   $query 
   -> 
   fields( 
   ' 
   n 
   ' 
   , 
     
   array 
   ( 
   ' 
   nid 
   ' 
   , 
     
   ' 
   title 
   ' 
   ));
   
   $ua_alias 
     
   = 
     
   $query 
   -> 
   leftJoin( 
   ' 
   users_act 
   ' 
     
   , 
   ' 
   ua 
   ' 
   , 
     
   ' 
   %alias.nid = n.nid 
   ' 
   );
   
   $query 
   -> 
   addField( 
   $ua_alias 
   , 
     
   ' 
   uid 
   ' 
   , 
     
   ' 
   ua_uid 
   ' 
   );
   
   $query 
   -> 
   addField( 
   $ua_alias 
   , 
     
   ' 
   status 
   ' 
   , 
     
   ' 
   ua_status 
   ' 
   );
   
   $query 
   -> 
   condition( 
   ' 
   n.type 
   ' 
   , 
     
   ' 
   activity 
   ' 
   );
   
   $objects 
     
   = 
     
   $query 
   -> 
   limit( 
   50 
   )
     
   -> 
   orderByHeader( 
   $header 
   )
     
   -> 
   execute()
     
   -> 
   fetchAll();
   
   $rows 
     
   = 
     
   array 
   ();
   
   foreach 
    ( 
   $objects 
     
   as 
     
   $key 
   => 
   $object 
   ) {
     
   $row 
     
   = 
     
   array 
   ();
     
   $nid 
     
   = 
     
   $object 
   -> 
   nid;
     
   $row 
   []  
   = 
    l(check_plain( 
   $object 
   -> 
   title) 
   , 
     
   ' 
   node/ 
   ' 
   . 
   $object 
   -> 
   nid 
   , 
     
   array 
   ( 
   ' 
   attributes 
   ' 
   => 
   array 
   ( 
   ' 
   target 
   ' 
   => 
   ' 
   _blank 
   ' 
   )));
     
   $row 
   []  
   = 
     
   ' 
   <a href="?nid= 
   ' 
   . 
   $nid 
   . 
   ' 
   " title= 
   ' 
   . 
   $object 
   -> 
   title 
   . 
   ' 
    target="_blank">my link</a> 
   ' 
   ;
     
   $rows 
   []  
   = 
     
   $row 
   ;
  }
   
   $output 
     
   .= 
    theme( 
   ' 
   table 
   ' 
   , 
     
   array 
   ( 
   ' 
   header 
   ' 
   => 
   $header 
   , 
     
   ' 
   rows 
   ' 
   => 
   $rows 
   , 
     
   ' 
   empty 
   ' 
   => 
   t( 
   ' 
   No result found. 
   ' 
   )));
   
   $output 
     
   .= 
    theme( 
   ' 
   pager 
   ' 
   );
 
  

  return $output; 

 

It is just an example, any details, please see in drupal.org

 

Have fun with Drupal7!