[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!