Answers for "display content in table in drupal 7"

PHP
0

none

<?php
  echo show_table('blocks', 50);

function show_table($table = NULL, $rows_per_page = 20) {
  if (!$table || !db_table_exists($table)) {
	  drupal_set_message(t('You must supply a valid database table name.'), 'error');
		drupal_access_denied();
	}

  // We get the first (or only) part of the Primary key to be added to the sort sequence.
  $result = db_query("SHOW INDEX FROM {$table}");
  $x = db_fetch_array($result);
  if ($x === FALSE) {
    drupal_set_message(t("The '@table' table has no index defined. This is probably normal.", array('@table' => $table)), 'notice');
    $first_key = NULL;
  }
  else {
    $first_key = $x['Column_name'];
  } 

  drupal_set_title(t('@table Table Contents', array('@table' => ucwords($table))));
  $output = '<p>'. t('Click on a column title to sort by that column.') .'</p><br/>';
  $rows = array();

  // Now we get the column names from the table and build the header.
  $header = array();
  $result = db_query("SHOW COLUMNS FROM {$table}");

  while ($col_desc = db_fetch_array($result)) {
    $header
Posted by: Guest on January-01-1970

Browse Popular Code Answers by Language