Posted By

berkes on 08/01/08

Tagged

Versions (?)

Last Edited at 08/01/08 12:02pm

Statistics

Viewed 1022 times

Favorited by 1 user(s)

Related snippets

Drupal function to return contents of a databasetable (for Debugging)

/ Published in: PHP

Drupal helper function to debug a table. Returns the contents and some explanation of a database table in a rendered format (HTML table).

**NOTE** You REALLY do not want to put this function behind any kind of menu_callback and/or on other pages. Use it for debugging only: Because we return any contents, regardless of permissions and so forth, you potentially open up your site to data mining and or session hijacking!

Highlighted TextExpand

function helpers_database_render_table($table_name) {
  $columns = $header = $rows = array();

$result = db_queryd('SHOW columns in {%s}', $table_name);
  while ($column = db_fetch_object($result)) {
    $header[] = t('@columnname (@columntype)', array('@columnname' => $column->Field, '@columntype' => $column->Type));
    $columns[] = $column->Field;
  }

$result = pager_query('SELECT * FROM {%s}', 50, 0, NULL, $table_name);
  while ($record = db_fetch_object($result)) {
    foreach($columns as $column) {
      //@TODO: include spans with title=fullresult on large results, and add ellipses in that case.
      $row[$column] = drupal_substr($record->$column, 0, 36);
    }
    $rows[] = $row;
  }

$count = db_result(db_query("SELECT count(%s) FROM {%s}", $columns[0], $table_name));

$caption = t('SELECT * FROM {%table_name} resulted in %count results', array('%table_name' => $table_name, '%count' => $count));

return theme('table', $header, $rows, array(), $caption) . theme('pager');
}

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.