PHP recursion infinite classification and return array example

/**
* Recursive infinite classification returns array
* link: bbs.it-home.org
* date: 2013/2/21
*/
$conn = mysql_connect('localhost','root','123456');
mysql_select_db('test');
mysql_query("set names 'utf8'");
function getCate($pid = 0)
{
$sql = "select * from cate where pid=".$pid;
 $res = mysql_query($sql);
if($res)
{
while($row = mysql_fetch_assoc($res)){
$categories[] = $row;
}
}
< ;p>if(0 < count($categories))
{
for($i = 0; $i < count($categories); $i++)
{
$categories[$i]['child' ] = getCate($categories[$i]['id']);
}
}
return $categories;
}
//Call
$cate = getCate(0);
?>

Articles you may be interested in: php infinite classification recursive function Extended code for php to implement infinite-level caching classes Unlimited scalable menu made with php and js Unlimited classification implemented by php and mysql php generates an array class from infinite classification Analysis of infinite classification in ecshop Infinite level selectTree class written in php php uses recursive method to implement infinite classification code