Просмотр сообщений
1
PHP / Помогите сделать вывод данных из базы данных MySQL в PHP в виде дерева
« : 22 Ноября 2004, 22:12:25 »
Вот мой скрипт отображения категорий:
function print_cats_8() {
$qq = "
<script language=javascript>
function undisplayNews5(id)
{
document.getElementById(\\"cat\\"+id).style.display = \\"none\\";
}
function displayNews5(id)
{
o = document.getElementById(\\"cat\\"+id).style;
o.display = (o.display == \\"none\\") ? \\"\\" : \\"none\\";
return false;
}
function montre(id) {
if (document.getElementById) {document.getElementById(id).style.display=\'block\';}
}
function cache(id) {
if (document.getElementById) {document.getElementById(id).style.display=\'none\';}
}
</script>
";
$query = "SELECT * FROM `cat` WHERE `name` BETWEEN \'П%\' AND \'С%\' ORDER by name;";
// $query = "SELECT * FROM `refs` WHERE `cat_id` =33 AND `scat_id` =24 AND `type_id` =2;";
$rez = sql_query($query);
while (list ($id, $name) = mysql_fetch_array($rez)) {
$qq .= "<SPAN id=t1 class=\\"style20\\">+ </SPAN>";
$app_2 = "onclick=\\"cache(\'a1\'); cache(\'t2\'); montre(\'t1\'); return displayNews5(".$id.");\\" ";
$qq .= " ";
\\n</SPAN>";
//
\\n</SPAN>";
//
//\\n";
\\n";
}
return $qq;
}
function print_cats_8() {
$qq = "
<script language=javascript>
function undisplayNews5(id)
{
document.getElementById(\\"cat\\"+id).style.display = \\"none\\";
}
function displayNews5(id)
{
o = document.getElementById(\\"cat\\"+id).style;
o.display = (o.display == \\"none\\") ? \\"\\" : \\"none\\";
return false;
}
function montre(id) {
if (document.getElementById) {document.getElementById(id).style.display=\'block\';}
}
function cache(id) {
if (document.getElementById) {document.getElementById(id).style.display=\'none\';}
}
</script>
";
$query = "SELECT * FROM `cat` WHERE `name` BETWEEN \'П%\' AND \'С%\' ORDER by name;";
// $query = "SELECT * FROM `refs` WHERE `cat_id` =33 AND `scat_id` =24 AND `type_id` =2;";
$rez = sql_query($query);
while (list ($id, $name) = mysql_fetch_array($rez)) {
$query2 = "SELECT * FROM scat WHERE cat_id=\'".$id."\' ORDER by name;";
$rez2 = sql_query($query2);
if (mysql_num_rows($rez2) != 0) {
$qq .= "<SPAN id=t1 class=\\"style20\\">+ </SPAN>";
$qq .= "<SPAN id=t2 style=\\"DISPLAY: none\\">-</SPAN>";
$app_1 = "onclick=\\"return displayNews5(".$id.");\\" ";
$app_2 = "onclick=\\"cache(\'a1\'); cache(\'t2\'); montre(\'t1\'); return displayNews5(".$id.");\\" ";
} else {
$qq .= " ";
$qq .= "<SPAN id=t2 style=\\"DISPLAY: none\\">-</SPAN>";
$app_1 = "";
$app_2 = "";
}
$qq .= "<SPAN id=a1 style=\\"DISPLAY: visible\\"><img src=\\"pics/UnSelected.jpg\\" width=\\"7\\" height=\\"9\\"> <a ".$app_1." href=\\"?mode=cat&id=".$id."\\" class=\\"tree\\">".$name."</a>
\\n</SPAN>";
//
$qq .= "<SPAN id=a2 style=\\"DISPLAY: none\\"><img src=\\"pics/UnSelected.jpg\\" width=\\"7\\" height=\\"9\\"> <a ".$app_2." href=\\"?mode=cat&id=".$id."\\" class=\\"tree\\">".$name."</a>
\\n</SPAN>";
if (mysql_num_rows($rez2) != 0) {
//
$qq .= " <img src=\\"pics/corner.jpg\\" width=\\"12\\" height=\\"10\\"> <a ".$app." href=\\"?mode=cat&id=".$id."\\" class=\\"treecat\\">Разделы</a>
//\\n";
$qq .= "<div id=\\"cat".$id."\\" style=\\"display: none;\\">\\n";
while( list ($id2, $cat_id, $name2) = mysql_fetch_array($rez2)) {
$qq .= " <img src=\\"pics/UnSelected.jpg\\" width=\\"7\\" height=\\"9\\"> <a href=\\"?mode=item&id=".$id."&sid=".$id2."\\" class=\\"subtree\\">".$name2."</a>
\\n";
}
$qq .="</div>\\n";
}
}
return $qq;
}
)