webEdition - Forum

Code: Alles auswählen

$DocID = $we_doc->ID;
$DocCats = f("SELECT Category FROM tblFile WHERE ID='$DocID'","Category",$DB_WE);
$Cats = explode (",",$DocCats);
$Cats = array_slice ($Cats, 1, -1);
foreach($Cats as $Value)
{
$CatName = f("SELECT Category FROM tblCategorys WHERE ID='$Value'","Category",$DB_WE);
$CatPath = f("SELECT Path FROM tblCategorys WHERE ID='$Value'","Path",$DB_WE);
}

Code: Alles auswählen

<?php
  $a_Categories = array();
  $out = (string) '';
  $docID = (int) $GLOBALS['we_doc']->ID;
  // alle Kategorie IDs auslesen für das aktuelle Dokument
  $docCats = (string) f("SELECT Category FROM ".FILE_TABLE." WHERE ID = '$docID'",'Category',$GLOBALS['DB_WE']);
  // String teilen und in eine Array schreiben
  $a_cats = explode(',', $docCats);
  // führendes und letztes Komma entfernen
  $a_cats = array_slice($a_cats, 1, -1);
  // für jeden Array-Eintrag Werte ausgeben
  $a_Categories = array();
  foreach($a_cats as $key => $value)
  {
    $a_result = (array) getHash("SELECT Category,Path FROM ".CATEGORY_TABLE." WHERE ID = '".$value."'",$GLOBALS['DB_WE']);
    $a_Categories[$key]['Name'] = (string) $a_result['Category'];
    $a_Categories[$key]['Path'] = (string) $a_result['Path'];
  }
  // p_r($a_Categories); /* Debug-Ausgabe */
  $out = (string) '';
  foreach($a_Categories as $key => $value)
  {
    $out .= 'Name: ' . $a_Categories[$key]['Name'] . '<br />';
    $out .= 'Pfad + Name: ' . $a_Categories[$key]['Path'] . '<br />';
    $out .= '<hr />';
  }
  echo $out;
?>

Code: Alles auswählen

$categories=we_tag('category',array('showpath'=>true,'separator'=>'-'));