Home › Drupal Collection › Taxonomy Tidbits

Complete Term List

This snippet produces a list of all your taxonomy terms in all vocabularies.

  $rows_per_page = 25;
  $query = "SELECT td.tid, td.vid, td.name, td.description, v.name as voc FROM {term_data} td LEFT JOIN {vocabulary} v USING (vid)";
  $header = array(
    array('data' => t('Term Name'), 'field' => 'name', 'sort' => 'asc'),
    array('data' => t('Description'), 'field' => 'description'),
    array('data' => t('Vocabulary'), 'field' => 'voc'),
    );
  $rows = array();
  $query .= tablesort_sql($header);
  $result = pager_query($query, $rows_per_page);
  while ($term = db_fetch_object($result)) {
    $rows[] = array(
      l($term->name, "admin/content/taxonomy/edit/term/$term->tid"),
      check_plain($term->description),
      l($term->voc, "admin/content/taxonomy/edit/vocabulary/$term->vid"),
      );
  }
  return theme('table', $header, $rows) . theme('pager', $rows_per_page);
Term Namesort iconDescriptionVocabulary
LinuxA Unix variant that has become very popular. It has itself spawned numerous variants, although not all of those enjoy open-source status.Glossary
Longer TitlesDrupal 6 changed the length of the title field for nodes to 255. This module brings that change to version 5.x.<br/> <a href="http://drupal.org/project/longer_titles">Project page</a> | <a href="http://drupal.org/node/200925" target="_blank">Documentation</a> | <a href="/changelog/longer_titles">Change log</a>Changelogs
ModuleAn add-on, or extension, to Drupal to provide additional functionality; written in PHP.Glossary
Must HaveThese are the modules on my <a href="http://nanwich.info/drupal_collection/must_have_modules.html">"Must Have"</a> list.Web Links
My ModulesThese are modules for which I have responsibility.Web Links
MySQLAn implementation of a relational database using the standardized SQL.Glossary
Nancy WichmannThe beautiful, intelligent woman who runs this site.Glossary
Node_Type_FilterThis is a simple module that allows for various lists, such as "taxonomy/term," to be filtered by content type.<br/> <a href="http://drupal.org/project/node_type_filter">Project page</a> | <a href="http://drupal.org/node/212245" target="_blank">Documentation page</a> | <a href="/changelog/node_type_filter">Change log</a>Changelogs
OwnI either wrote these or have taken over ownership of them, so I am the principal maintainer.Web Links
PHPRecursive acronym for "<b>P</b>HP: <b>H</b>ypertext <b>P</b>reprocessor" - is a widely-used Open Source general-purpose scripting language that is especially suited for Web development and can be embedded into HTML.Glossary
PMPProject Management Professional is a certification issued by the <a href="http://pmi.org" target="_blank">Project Management Institute</a> and is sort of like a CPA for project managers. The certification requires a certain amount of base and continuing education, experience, and passing a monstrous test. Some employers require it for project managers. Glossary
Register_CountryAre you creating a country portal or a site dedicated to a specific country?<br/> The Register Country module is designed to intercept new registrations and check if the IP address being used is registered to a country that the site administrator has chosen. In this way, you may limit sign ups to your site to specific countries.<br/> <a href="http://drupal.org/project/register_country">Project page</a> | <a href="http://drupal.org/node/160411" target="_blank">Documentation page</a> | <a href="/changelog/register_country">Change log</a>Changelogs
relational databaseA type of database that more closely resembles a flat file, yet is accessible by a full-featured query specification.Glossary
Sample SitesThese are sites that demonstrate something, mostly module uses.Web Links
siteA logically grouped set of content - also web site.Glossary
Site Design ToolsThis is a collection of places to find tools for design and development of web sites.Web Links
Site DocumentationTo simplify it a bit, the Site Documentation module picks up information from various places within the Drupal environment. Some of the information comes from internal arrays, some is derived from system calls, and some comes directly from the database tables. This information is pulled into a report that can be used to document the site. In addition, it will detect some problems that may exist in your installation, and optionally correct them.<br/> <a href="http://drupal.org/project/sitedoc">Project page</a> | <a href="http://drupal.org/node/144837" target="_blank">Documentation page</a> | <a href="/changelog/sitedoc">Change log</a>Changelogs
Site DocumentationA Drupal contributed module by Nancy Wichmann for gathering information about the installation.Glossary
Site NotesSiteNotes introduces a new content type, called, coincidentally, "sitenotes." It also creates a menu item in the Admin &raquo; Site building menu, where it's available only to privileged users; it's even protected by Access Control. So now all those little Post-Its™ and other scraps of paper can go right into your database where you can find them again. Create "How To" notes for your users, theme changes, CSS modifications, special code notes, and keep them safe AND available.<br/> <a href="http://drupal.org/project/sitenotes">Project page</a> | <a href="http://drupal.org/node/135710" target="_blank">Documentation</a> | <a href="/changelog/sitenotes">Change log</a>Changelogs
Site NotesA Drupal contributed module by Nancy Wichmann for hidden design or how-to notes.Glossary
SpamUnsolicited email or web site postings that are undesirable, usually containing links to other sites.Glossary
SpamClassification
Spam TokensThis add-on module adds another tab to the Spam administration page that allows Spam module administrators to examine and modify the tokens used by the Bayesian filters to determine the probability of content being spam.<br/> <a href="http://drupal.org/project/spam_tokens">Project page</a> | <a href="http://drupal.org/node/185113" target="_blank">Documentation</a> | <a href="/changelog/spam_tokens">Change log</a>Changelogs
Spam_TuneThe Spam_Tune module allows Spam module administrators to examine and modify system variables that are normally just defaulted in the Spam module. These variables are added to the 'Advanced' tab in the Spam settings. This module will probably never be contributed as it can be dangerous to alter the parameters exposed here.<br/> <a href="http://nanwich.info/spam_tune" target="_blank">Project page &amp; Documentation</a>Changelogs
SQL<b>S</b>tructured <b>Q</b>uery <b>L</b>anguage - a language for accessing a database.Glossary