Esempio n. 1
0
function getCatTree($fold_id)
{
    $query = "SELECT name, pid FROM cat WHERE id = {$fold_id};";
    $result = mysql_query($query);
    $row = mysql_fetch_array($result);
    if ($row[1] != 0) {
        $tree = getCatTree($row[1]) . $row[0] . "/";
    } elseif ($row[0] != false) {
        $tree = "/" . $row[0] . "/";
    } else {
        $tree = "/";
    }
    return $tree;
}
Esempio n. 2
0
 /**
  *This function generates an absolute URL for given article or category.
  *Only $article_id OR $cat_id should be provided!
  *This method functions as a wrapper for getCatTree.
  *
  *@param		int $article_id
  *@param		int $cat_id
  *@param		resource current valid link to database
  *@return	string absolute URL for provided article or category
  *
  */
 public function generateURL($article_id, $cat_id, $link_identifier)
 {
     if (isset($article_id)) {
         $query = "SELECT cat_id, title FROM article WHERE id = {$article_id};";
         $result = mysql_query($query, $link_identifier);
         $row = mysql_fetch_array($result);
         $cat_id = $row[0];
         $tree = self::getCatTree($cat_id, $link_identifier);
         $URL = $tree . $row[1] . ".html";
         return $URL;
     } elseif (isset($cat_id)) {
         $URL = getCatTree($cat_id, $link_indentifier);
         return $URL;
     } else {
         return false;
     }
 }