'cleft', 'right'=> 'cright', 'level'=> 'clevel', ); require_once "database.php"; require_once "dbtree.php"; $dbh=new CDataBase("arttest4", "localhost", "arttest4", "artwebtest4"); $dbh->query("set names cp1251"); $Tree = new CDBTree($dbh, $table, $id_name, $field_names); // ñîçäàåì "êîðíåâóþ" çàïèñü (ñì. ïîÿñíåíèÿ ê ñòàòüå) $ids=$Tree->clear(array("title"=>"Êàòàëîã ðåñóðñîâ")); $i = 0; $c = 0; $r = array($ids); $y = array($ids); function viewRubricsAll($id = 0,$f = 0){ global $Tree,$dbh,$ids,$r,$y,$p,$c; $i++; $sql = "select * from catalogs_rubrics where parent_id='$id' order by sort asc"; $res = $dbh->query($sql); //$y[0][0]=$ids; //$i=0; $f = $f +1; //$y = array(); while ($row = $dbh->fetch_array($res)){ //$y[$f] = $f; $c++; // print_r($y); $y[$f] = $Tree->insert($y[$f-1],array("title"=>$row['name'],'parent_id'=>$y[$f-1])); saveProd($y[$f],$row['id']); print $f.'_'.$c; if($f==1)$p = $i; print'('.$y[$f-1].')'; print $row['name'].'
'; viewRubricsAll($row['id'],$f); } //print_r($y); //exit; } function saveProd($id,$rub){ global $Tree,$dbh,$ids; $sql = "select * from catalogs_products where rubric_id='$rub'"; $res = $dbh->query($sql); while ($row = $dbh->fetch_array($res)){ //print $row['name']; $d = $Tree->insert($id,array("title"=>mysql_escape_string($row['name']),'parent_id'=>$id)); if($row['name']=='BOCK 20"09' OR $row['name']=='BOCK 24"09')saveMod($d,$row['id']); } } function saveMod($id,$rub){ global $Tree,$dbh,$ids; $sql = "select * from catalogs_modifications where product_id='$rub'"; $res = $dbh->query($sql); while ($row = $dbh->fetch_array($res)){ //print $row['name']; $d = $Tree->insert($id,array("title"=>mysql_escape_string($row['code']),'parent_id'=>$id)); } } viewRubricsAll(0); /* $level_2=array(); $level_2[0]=$Tree->insert($id,array("title"=>"Ïðîãðàììèðîâàíèå")); $level_2[1]=$Tree->insert($id,array("title"=>"Íîâîñòè")); $level_2[2]=$Tree->insert($id,array("title"=>"Ñîïðò")); $level_2[3]=$Tree->insert($id,array("title"=>"Ðàçíîå")); // òåïåðü ñîçäàäèì íåñêîëüêî çàïèñåé òðåòüåãî óðîâíÿ $level_3=array(); $level_3[0]=$Tree->insert($level_2[0],array("title"=>"PHP")); $level_3[1]=$Tree->insert($level_2[0],array("title"=>"Perl")); $level_3[2]=$Tree->insert($level_2[0],array("title"=>"Delphi")); $level_3[3]=$Tree->insert($level_2[1],array("title"=>"Êðèìèíàë")); $level_3[4]=$Tree->insert($level_2[2],array("title"=>"Ôóòáîë")); $level_3[5]=$Tree->insert($level_2[2],array("title"=>"Øàõìàòû")); $level_3[6]=$Tree->insert($level_2[3],array("title"=>"Ìåäèöèíà")); $level_3[7]=$Tree->insert($level_2[3],array("title"=>"Ýêîëîãèÿ")); $level_3[8]=$Tree->insert($level_2[3],array("title"=>"Ïðîìûøëåííîñòü")); // è äëÿ íåêîòîðûõ ñäåëàåì ÷åòâåðòûé óðîâåíü $Tree->insert($level_3[0],array("title"=>"PEAR")); $Tree->insert($level_3[8],array("title"=>"Ìåòàëëóðãèÿ")); $Tree->insert($level_3[6],array("title"=>"Ìîðãè")); */ echo "Òàáëèöà çàïîëíåíà."; ?>