ns.php
3.13 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
<?
$table="categories"; // òàáëèöà êàòåãîðèé
$id_name="cid"; // èìÿ ïîëÿ ïåðâè÷íîãî êëþ÷à
$field_names = array( // èìåíà ïîëåé òàáëèöû
'left' => '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'].'<br>';
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 "Òàáëèöà çàïîëíåíà.";
?>