菜鸟求助，想实现两项功能，1、将数据库中主要字段spliter_name，up_spliter两项树形结构输出到IE,在此编写了树形输出代码，请给与指教看是否符合要求，2.将数据库中这两项输出到a.txt，结果如a.txt中所示，绞尽脑汁实在力不从心，请各位大神给与指教。以下为数据库、树形输出、欲实现效果等文件，谢谢！
************************** tb_spliter.sql **********************
— phpMyAdmin SQL Dump
— version 3.5.4
— http://www.phpmyadmin.net
—
— 主机: localhost
— 生成日期: 2013 年 05 月 01 日 11:02
— 服务器版本: 5.5.18
— PHP 版本: 5.4.0RC4
SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;
SET time_zone =
搞代gaodaima码
“+00:00”;
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
—
— 数据库: `oa`
—
— ——————————————————–
—
— 表的结构 `tb_spliter`
—
CREATE TABLE IF NOT EXISTS `tb_spliter` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`spliter_name` varchar(50) NOT NULL,
`spliter_cap` int(4) NOT NULL,
`spliter_city` varchar(50) NOT NULL,
`spliter_top_device` varchar(50) NOT NULL,
`spliter_top_cable` varchar(50) NOT NULL,
`up_spliter` int(11) NOT NULL,
`p_id` int(6) NOT NULL,
`p_name` varchar(50) NOT NULL,
`i_state` int(1) NOT NULL,
`complet_date` datetime NOT NULL,
`project_name` varchar(50) NOT NULL,
`project_content` text,
`table_type` int(1) NOT NULL,
`relate_depart` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312 COMMENT=’分光器表’ AUTO_INCREMENT=91 ;
—
— 转存表中的数据 `tb_spliter`
—
INSERT INTO `tb_spliter` (`id`, `spliter_name`, `spliter_cap`, `spliter_city`, `spliter_top_device`, `spliter_top_cable`, `up_spliter`, `p_id`, `p_name`, `i_state`, `complet_date`, `project_name`, `project_content`, `table_type`, `relate_depart`) VALUES
(81, ‘a1’, 1, ‘xt’, ‘a’, ‘无’, 69, 217, ‘hhh’, 0, ‘2013-04-28 00:24:52’, ‘0’, ‘0’, 1, ‘qd’),
(80, ‘a2’, 1, ‘xt’, ‘a’, ‘无’, 69, 217, ‘hhh’, 0, ‘2013-04-28 00:24:52’, ‘0’, ‘0’, 1, ‘qd’),
(79, ‘a3’, 1, ‘xt’, ‘a’, ‘无’, 69, 217, ‘hhh’, 0, ‘2013-04-28 00:24:52’, ‘0’, ‘0’, 1, ‘qd’),
(78, ‘a4’, 1, ‘xt’, ‘a’, ‘无’, 69, 217, ‘hhh’, 0, ‘2013-04-28 00:24:52’, ‘0’, ‘0’, 1, ‘qd’),
(69, ‘a’, 1, ‘xt’, ‘无’, ‘无’, 0, 217, ‘hhh’, 0, ‘2013-04-28 00:15:20’, ‘0’, ‘1’, 1, ‘qh’),
(82, ‘b’, 1, ‘xt’, ‘无’, ‘无’, 0, 217, ‘hhh’, 0, ‘2013-05-01 10:22:51’, ‘0’, ‘1’, 3, ‘qh’),
(83, ‘b1’, 1, ‘xt’, ‘b’, ‘无’, 82, 217, ‘hhh’, 0, ‘2013-05-01 10:23:53’, ‘0’, ‘0’, 3, ‘qh’),
(84, ‘b2’, 1, ‘xt’, ‘b’, ‘无’, 82, 217, ‘hhh’, 0, ‘2013-05-01 10:23:53’, ‘0’, ‘0’, 3, ‘qh’),
(85, ‘b3’, 1, ‘xt’, ‘b’, ‘无’, 82, 217, ‘hhh’, 0, ‘2013-05-01 10:23:53’, ‘0’, ‘0’, 3, ‘qh’),
(86, ‘b4’, 1, ‘xt’, ‘b’, ‘无’, 82, 217, ‘hhh’, 0, ‘2013-05-01 10:23:53’, ‘0’, ‘0’, 3, ‘qh’),
(87, ‘b5’, 1, ‘xt’, ‘b’, ‘无’, 82, 217, ‘hhh’, 0, ‘2013-05-01 10:23:53’, ‘0’, ‘0’, 3, ‘qh’),
(88, ‘b6’, 1, ‘xt’, ‘b’, ‘无’, 82, 217, ‘hhh’, 0, ‘2013-05-01 10:23:53’, ‘0’, ‘0’, 3, ‘qh’),
(89, ‘b61’, 1, ‘xt’, ‘b’, ‘无’, 88, 217, ‘hhh’, 0, ‘2013-05-01 10:23:53’, ‘0’, ‘0’, 3, ‘qh’),
(90, ‘b62’, 1, ‘xt’, ‘b’, ‘无’, 88, 217, ‘hhh’, 0, ‘2013-05-01 10:23:53’, ‘0’, ‘0’, 3, ‘qh’);
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
********************** tree.php **********************
<?php
$filename = ‘a.txt’;
$fff=iconv(‘gb2312′,’utf-8’,$fff);
if (!$handle = fopen($filename, ‘w’)) {
echo “cannot open $filename”;
exit;
}
include “../conn/conn.php”;
$sql=”select * from tb_spliter where up_spliter = ‘0’”;//选择出所有顶级设备
$result=mysql_query($sql,$conn);
$m=0;
while($rows=mysql_fetch_row($result)){
$sqlstr1=”select * from tb_spliter where up_spliter = ‘”.$rows[0].”‘”; //判断顶级设备下的一级设备
$result1=mysql_query($sqlstr1,$conn);
$num=mysql_num_rows($result1);
if(!$num){ //如果不存在一级设备
echo “\$a=”.$rows[1].” “.$m.”没有下级
“;
}else{
echo “\$b=”.$rows[1].” “.$m.”有下级
“;
list_first($rows[0],$m); //list_first轮询一级设备
}
$m+=1;
}
function list_first($aa,$m){
include “../conn/conn.php”;
$sql=”select * from tb_spliter where up_spliter = ‘”.$aa.”‘”;//list_first轮询一级设备
$result = mysql_query($sql,$conn);
while($rows2 = mysql_fetch_row($result)){
$sqlstr1 = “select * from tb_spliter where up_spliter = ‘”.$rows2[0].”‘”; //判断一级设备下是否有分支设备
$result1 = mysql_query($sqlstr1,$conn);
$nu = mysql_num_rows($result1);
if(!$nu){
echo $rows2[1].” “.$m.”没有下级
“;
}else{
echo $rows2[1].” “.$m.”有下级
“;
list_first($rows2[0],$m); //list_first轮询设备
}
$m+=1;
}
}
?>
********************** a.txt（想要的结果） **********************
a–>a1;
a–>a2;
a–>a3;
a–>a4;
b–>b1;
b–>b2;
b–>b3;
b–>b4;
b–>b5;
b–>b6;
b6–>b61;
b6–>b62;
转载请注明原文链接：如何将tree结果输出到文件
