数据库$query = "SELECT * FROM tree "; 怎么把模拟数据改成读取数据库？

Question

php代码如下：//模拟数据库$data=array(array('id'=>1,'pid'=>0,'name'=>'栏目一'),array('id'=>2,'pid'=>1,'name'=>'子栏目'),array('id'=>3,'pid'=>1,'name'=>'二级栏目一'),array('id'=>4,'pid'=>3,'name'=>'三级栏目一'),array('id'=>5,'pid'=>4,'name'=>'四级栏目一'),array('id'=>6,'pid'=>0,'name'=>'一级栏目一'),array('id'=>7,'pid'=>2,'name'=>'一级栏目二'),array('id'=>8,'pid'=>1,'name'=>'二级栏目一'),array('id'=>9,'pid'=>2,'name'=>'三级栏目一'),array('id'=>10,'pid'=>3,'name'=>'四级栏目一'),);//转换数据$tree_data=array();foreach ($data as $key=>$value){$tree_data[$value['id']]=array('id'=>$value['id'],'parentid'=>$value['pid'],'name'=>$value['name']);}/*** 输出树形结构*/$tree=new Tree();$tree->init($tree_data);echo "<div class='tree well'>";echo $tree->get_treeview(0, $str);echo "</div>";

Answer 1

$query = "SELECT id,pid,name FROM tree ";
$tree_data=array();
if ($res=mysql_query($query)) while ($row=mysql_fetch_array($res)) $tree_data[]=$row;