我好像写了一个死循环

xt_yxl 2008-03-20 12:03:29

递归输出分类问题 . 这个FUNCTION好像问题多多. 请高手帮我看看. 给出修改意见/代码 .

以前搞ASP的. PHP 不知道怎么判断WHILE 和 FUNCTION 的退出了.

function nextclass($str1,$str2,$classid){

	$sql = "select * from jh_newsclass where parentid = $classid";

	$result = $GLOBALS['mysqli']->query($sql);

	$row = $result->fetch_row();

	if (empty($row)) {

		exit();

	}

	else {

		$GLOBALS['newsclasscontent'] = $GLOBALS['newsclasscontent'] . '<div class="forumlist_groups"><DIV align=left><ul>';

		print_r($GLOBALS['newsclasscontent']);

		while ($row = $result->fetch_row()){

			$GLOBALS['newsclasscontent'] = $GLOBALS['newsclasscontent'] . '<li class="forumli">';

			$sqltwo = "select * from jh_newsclass where parentid = $row[0]";

			$resulttwo = $GLOBALS['mysqli']->query($sqltwo);

			$rowtwo = $resulttwo->fetch_row();

			if (!empty($rowtwo)) {

				$GLOBALS['newsclasscontent'] = $GLOBALS['newsclasscontent'] . '<a href="news.php?classid=' . $rowtwo[0] . '&newsclassid=' . $rowtwo[0] ;

				if ($rowtwo[3] == 1) {

					$GLOBALS['newsclasscontent'] = $GLOBALS['newsclasscontent'] . '&ispro=true';

				}

				$GLOBALS['newsclasscontent'] = $GLOBALS['newsclasscontent'] . '" target="main">' . $str1 . $str2 ;

				$GLOBALS['newsclasscontent'] = $GLOBALS['newsclasscontent'] . '<img id="folder180" src="images/leaf.gif" width="18" height="18" align="absmiddle"><font color="">' . $rowtwo[1] . '</font></a>' ;

			}

			else {

				$GLOBALS['newsclasscontent'] = $GLOBALS['newsclasscontent'] . $str1 . $str2 . '<img id="folder180" src="images/leaf.gif" width="18" height="18" align="absmiddle">' . $row[1] ;

			}

			$resulttwo->close();

			$GLOBALS['newsclasscontent'] = $GLOBALS['newsclasscontent'] . '</li>';

			nextclass($str1,$str2.'--',$classid);

		}

		$GLOBALS['newsclasscontent'] = $GLOBALS['newsclasscontent'] . '</ul></div></div>';

	}

	$result->close();

}



$sql = "select * from jh_newsclass where parentid = 0";

$result = $mysqli->query($sql);

$newsclasscontent = '';

while ($row = $result->fetch_row()) {

	$sqltwo = "select * from jh_newsclass where parentid = $row[0]";

	$resulttwo = $mysqli->query($sqltwo);

	$rowtwo = $resulttwo->fetch_row();

	if (!empty($rowtwo)) {

		$newsclasscontent = $newsclasscontent . '<DIV class="bg03">';

		$newsclasscontent = $newsclasscontent . $row[2];

		$newsclasscontent = $newsclasscontent . '</div>';

		nextclass('+','--',$row[0]);

	}

	else {

		$newsclasscontent = $newsclasscontent . '<DIV class="bg03">';

		$newsclasscontent = $newsclasscontent . '<a href="news.php?classid=';

		$newsclasscontent = $newsclasscontent . $row[0] . '&newsclass=' . $row[0];

		if ($row[3] == 1) {

			$newsclasscontent = $newsclasscontent . '&ispro=true';

		}

		$newsclasscontent = $newsclasscontent . '" target="main">';

		$newsclasscontent = $newsclasscontent . $row[2] . '</a>';

		$newsclasscontent = $newsclasscontent . '</div>';

	}

}