D7 - 不用views，制作可筛选的分页列表

function mymodule_list($form_state){
  $header = array('Nid', 'Title', 'Created');

  $query = db_select('node', 'n')
    ->extend('PagerDefault')
    ->limit(5)
    ->fields('n');
  if(!empty($form_state['input']['keyword'])) {
    $results = $query->condition('n.title', $form_state['input']['keyword'])->execute();
  } else {
    $results = $query->execute();
  }

  $rows = array();
  foreach ($results as $row) {
    $rows[] = array(
      $row->nid,
      $row->title,
      $row->created
    );
  }
  $output = theme('table', array(
    'header' => $header,
    'rows' => $rows
  ));
  $output .= theme('pager');

  return $output;
}

function mymodule_form($form, &$form_state){
  $form = array();

  $form['keyword'] = array(
    '#type' => 'textfield',
    '#title' => '參考編號',
    '#default_value' => ''
  );

  $form['submit'] = array(
    '#type' => 'submit',
    '#value' => '搜索',
  );

  $form['list'] = array(
    '#markup' => mymodule_list($form_state)
  );

  return $form;
}

function mymodule_form_submit($form, &$form_state) {
  $form_state['rebuild'] = true;
}