Форумы портала PHP.SU

CODE (SQL):
скопировать код в буфер обмена

 
CREATE TABLE IF NOT EXISTS `edil_categories` (
  `CategoryID` int(11) NOT NULL AUTO_INCREMENT,
  `CategoryIDRef` int(11) NOT NULL DEFAULT '0',
  `CategoryName` text NOT NULL,
  `CategoryDescription` text NOT NULL,
  `CategoryAlias` text NOT NULL,
  `CategoryLevel` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY  (`CategoryID`),
  KEY `CategoryIDRef` (`CategoryIDRef`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=363 ;
 

PHP:
скопировать код в буфер обмена

 
<?PHP 
header('Content-type: text/html;charset=utf-8');
 
$host = "";
$user = "";
$pass = "";
$db   = "";
 
$link = mysql_connect($host,$user,$pass,$db) or die(mysql_error());
mysql_select_db($db, $link) or die(mysql_error());
mysql_query("SET NAMES utf8");
 
 
$treeMas  = array();
$treeHtml = array();
$nodePath = array();
$nodeDescr = "";
 
 
$res = mysql_query("SELECT * FROM edil_categories");
if($res!=false)
 {
   while ( $row = mysql_fetch_assoc( $res )) 
    {
      $treeMas[$row['CategoryIDRef']][$row['CategoryID']] = $row;
    }   
}
 
 
function MakeTree($idRef)
{
    global $treeMas, $treeHtml;
 
    if(!isset($treeMas[$idRef]))
         return;
        
    $treeHtml[] = '<ul>';
    foreach($treeMas[$idRef] as $subTree) 
         {
        $treeHtml[] = '<li>';
        $treeHtml[] = "<a href='{$subTree['CategoryName']}'>{$subTree['CategoryName']}</a>";
        if(isset($treeMas[$subTree['CategoryID']])) 
                {
            MakeTree($subTree['CategoryID']);
        }
        $treeHtml[] = '</li>';
     }
    $treeHtml[] = '</ul>';
}
 
 
 
function GetFullPath($id)
{ 
 global $nodePath;
 $sql = "SELECT * FROM edil_categories WHERE CategoryID=$id";
 $res = mysql_query($sql);
 if($res!=false)
  {
   $row = mysql_fetch_assoc($res);   
   $idRef   = $row['CategoryIDRef'];
   $catName = $row['CategoryName'];
   $nodePath[] = $catName;
   if($idRef!=0) GetFullPath($idRef);
    else return;
  }
}
 
 
function GetDescr($id)
{
 $sql = "SELECT CategoryDescription FROM edil_categories WHERE CategoryID=$id";
 $res = mysql_query($sql);
 if($res!=false)
  {
   $row = mysql_fetch_assoc($res);
   return $row['CategoryDescription'];
  }
}
 
?>
 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
 <title></title>
 
<style>
.block
{
 border-width : 1px;
 border-color : black;
 border-style : solid;
 padding : 10px;
}
 
.path
{
 font-weight: bold;
 color: purple;
}
</style>
</head>
<body>
 
 
 
<div class="block">
<p class="path"> 
<?PHP 
list($trash,$cName) = explode('/',urldecode($_SERVER['REQUEST_URI']));
$sql = "SELECT CategoryID FROM edil_categories WHERE CategoryName='$cName'";
$res = mysql_query($sql);
if($res!=false)
 {
  $row = mysql_fetch_assoc($res);
  $id = $row['CategoryID'];
 
 GetFullPath($id);
 $RealPath = array_reverse($nodePath);
 foreach($RealPath as $item)
  echo ' / '.$item;
 
?>
</p>
 
<?PHP  echo GetDescr($id);
}
?>
</div>
 
<div>
<?PHP    
MakeTree(0);
echo join("\n",$treeHtml); 
?>
</div> 
  
</body>
</html>
 