1

I have created a custom module & used below code to display data from Database. But I want to show that data in the form of html table. Please help.

<?php
function custom_table_menu(){
 $items = array();
 $items['custom_table'] = array(
  'title' => 'Custom Table',
  'page callback' => 'custom_table_page_display',
  'access callback' => TRUE,
);
 return $items;
}


function custom_table_page_display() {
$result = db_query('SELECT * FROM {users}');
  $records = $result->fetchAll();

  $content = '<pre>' . print_r($records, TRUE) . '</pre>';

  return $content;
}
?>

2 Answers 2

2

Try this example to output your data in table format with Pager (ie. table with page. 1,2,3.. )

function custom_table_page_display() {

  $header = array(
    array('data' => t('Name'), 'field' => 'id', 'sort' => 'desc'),
    array('data' => t('Address'), 'colspan' => 3),
  );

  $query = db_select('users', 'u');

  $query->fields('u', array('name','address'));  // select your required fields here

  $table_sort = $query->extend('TableSort') // Add table sort extender.

                      ->orderByHeader($header); // Add order by headers.

  $pager = $table_sort->extend('PagerDefault')

                      ->limit(20);  // here you can limit the number of data per page.

  $result = $pager->execute();

  $rows = array();
  foreach($result as $res) {
    $rows[] = array($res->id, 
                    $res-> title,);
  }
  // If rows are not empty theme and display the rows.

  $output = '';

  if (!empty($rows)) {

    $output = theme('table', array('header' => $header, 'rows' => $rows, 'attributes' => array('id' => 'sort-table')));

    $output .= theme('pager');

  }

  else {

    $output .= t("No results found.");

  }

  return $output;

}
10
  • @Shrish... its working... thanx...
    – Nishant
    Jul 8, 2014 at 6:22
  • you can use 'sort' => 'asc' to sort the table ascending, glad that helped :)
    – shrish
    Jul 8, 2014 at 6:29
  • because of already define db variable in drupal we can fetch data directly without creating connection... but if we want to fetch data from external table... then what can i do...
    – Nishant
    Jul 8, 2014 at 7:38
  • check my answer here stackoverflow.com/questions/23519390/…
    – shrish
    Jul 8, 2014 at 8:01
  • @shrish.. thanx...
    – Nishant
    Jul 8, 2014 at 8:37
1

Below is the Code, you can create the listing page with sortable header and pagination. This code using the 'TableSort' theme.

function custom_table_menu(){
 $items = array();
 $items['custom_table'] = array(
  'title' => 'Custom Table',
  'page callback' => 'order_listing',
  'access callback' => TRUE,
);
 return $items;
}

function order_listing() {
    global $base_url;

        $header = array(
            array(
                'data' => t('OrderID'),
                'field' => 't.OrderID',
            ),
            array(
                'data' => t('OrderDate'),
                'field' => 't.OrderDate',
            ),
            array(
                'data' => t('PaymentAmount'),
                'field' => 't.PaymentAmount',
            ),
            array(
                'data' => t('BillingFirstName'),
                'field' => 't.BillingFirstName',
            ),
            array(
                'data' => t('BillingLastName'),
                'field' => 't.BillingLastName',
            ),
            array(
                'data' => t('OrderStatus'),
                'field' => 't.OrderStatus',
            ),
            array(
                'data' => t('ShipDate'),
                'field' => 't.ShipDate',
            ),
        );
        $cust_id = arg(2);

                        $query = db_select('Orders', 't')->extend('TableSort');
        $query->fields('t', array('OrderID', 'OrderDate', 'PaymentAmount', 'BillingFirstName', 'BillingLastName', 'OrderStatus', 'ShipDate'));


        $table_sort = $query->extend('TableSort')->orderByHeader($header);
        $pager = $table_sort->extend('PagerDefault')->limit(50); // 5 rows per page.

        $result = $pager->execute();


        $rows = array();
        foreach ($result as $row) {
            $rows[] = array('data' => array( $row->OrderID, $row->OrderDate, $row->PaymentAmount, $row->BillingFirstName, $row->BillingLastName, $row->OrderStatus, $row->ShipDate));


        }
        $output .= theme('pager');
        $output .= theme('table', array('header' => $header, 'rows' => $rows, "empty" => t("No Records Found"), 'attributes' => array('id' => 'sort-table', 'class' => array('tbl-data'))));
        $output .= theme('pager');

    return $output;
}
2
  • @Parvind.. thanx... its working...
    – Nishant
    Jul 8, 2014 at 6:37
  • @niks88, If solution works for you, please mark this as answer. It will be helpful for someone else.
    – Parvind
    Jul 8, 2014 at 6:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.