实现如下效果
php程式代码
*
* php递归实现的无限分类
*
CREATE TABLE `article_class` (
`pcid` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`pcname` VARCHAR( 50 ) NOT NULL ,
`level` INT NOT NULL ,
`parentid` INT NOT NULL
) ENGINE = MYISAM ;
* __________________________________________________________*/
error_reporting(E_ALL);
//mysql_connect ...
$link = mysql_connect('localhost','root','');
mysql_select_db('test');
function tree($parentid) {
$result = mysql_query('Select * FROM `article_class` Where `parentid` = '.$parentid) OR die("Invalid query: " . mysql_error());;
while($r = mysql_fetch_array($result)) {
echo str_repeat(' ',$r['level']).$r['pcname'].'<br />';
tree($r['pcid']);
}
}
if(($parentid + 0) < 1){
$parentid = 0;
}
tree($parentid);
?>
评论