php+mysql+jquery实现父行子行折叠显示的实例

这是我写的一个控制父行与子行显示的一个页面。需要JQUERY

<?php //业务系统的首页
	include('menu.php');//加载目录
	include('head.php');//加载头文件	
?>
<link href="css/parentchild.css" rel="stylesheet" type="text/css" />
<script src="jquery-1.7.2.js" type="text/javascript"></script>
<script type="text/javascript">
$(function(){
	$('tr.parent').click(function(){   // 获取所谓的父行
			$(this)
				.toggleClass("selected")   // 添加/删除高亮
				.siblings('.child_'+this.id).toggle();  // 隐藏/显示所谓的子行
	}).click();
})
</script>

<?php
		//判断是否是环评主管科室
	$sqlqxfp="SELECT * FROM qxfp WHERE yiemian ='yw_hp_hp_add'";	
	$resultqxfp=mysql_query($sqlqxfp);
	$numrowsqxfp=mysql_num_rows($resultqxfp);	
	if ($numrowsqxfp>0)
		{
			while($dataqxfp=mysql_fetch_array($resultqxfp))
			{
				$qxfp=$dataqxfp['qxfp'];				
			}
		}
?>

<?php
	$username=$_SESSION["ywclusername"];					
	$pagesql="select hpid from hp_hp";
	$pageresult=mysql_query($pagesql);
	
	if ($pageresult)
	{
?>

<table width="100%" border="0" class="youbian" align="center" cellpadding="4" cellspacing="1">
  <caption><a href="index.php"><img src="images/home.png" class="t3"></a>环评记录</caption>
  <thead>
    <tr>
      <th colspan="16" align="left" class="touming">
<?php
	if($_SESSION['ywclkeshi']=="$qxfp")
	{
?>
        <a href="yw_hp_hp_add.php"><img src="images/add.png" class="t2" />添加</a>
<?php 
	}    
?>
      <a href="yw_hp_hp_search.php"><img src="images/search.png" alt="" class="t2" />查询</a>
      <a href="yw_hp_zl.php"><img src="images/zl.png" alt="" class="t2" />总量</a>
      <a href="javascript:window.print() ;"><img src="images/printer.png" alt="" class="t2" />打印</a>
      <a href="yw_hp_hp_export.php"><img src="images/excel.jpg" alt="" class="t2" />导出</a></th>
    </tr>
    <tr>
      <th width="4%">序号</th>
      <th width="10%">项目名称</th>
      <th width="12%">单位名称</th>
      <th width="7%">环评结论</th>
      <th width="5%">新改扩</th>
      <th width="9%">批文号</th>
      <th width="7%"><p>项目类型</p></th>
      <th width="7%">项目手续</th>
      <th width="7%">项目状态</th>
      <th width="6%">审批日期</th>
      <th width="5%">审批人</th>
      <th width="4%">验收</th>
      <th width="4%">监测</th>
      <th width="4%">总量</th>
      <th width="5%">试生产</th>
<?php
		//判断是否是环评删除管理人
	$sqlqxfp="SELECT * FROM qxfp WHERE yiemian ='hpk_delete'";	
	$resultqxfp=mysql_query($sqlqxfp);
	$numrowsqxfp=mysql_num_rows($resultqxfp);	
	if ($numrowsqxfp>0)
		{
			while($dataqxfp=mysql_fetch_array($resultqxfp))
			{
				$qxfpdelete=$dataqxfp['qxfp'];				
			}
		}
?>
<?php 
	if($_SESSION['ywclusername']=="$qxfpdelete")
	{
?>
      <th width="4%">删除</th>
<?php }?>
    </tr>
  </thead>
  <?php
			$totalnum=mysql_num_rows($pageresult);//取得记数总数
			
			include("pages.php");			
			$sql="select * from hp_hp order by sprq desc limit $startnum,$perpagenum";//读取指定记录数
			$i=$perpagenum*($page-1)+1;
			$result=mysql_query($sql);
			$numrows=mysql_num_rows($result);
			if ($numrows>0)
			{
				while($data=mysql_fetch_array($result))
				{
					$count+=1;
					$parow="row_".$count;
					$chrow="child_row_".$count;
					$hpid=$data['hpid'];
					$xgk=$data['xgk'];
					$pwh=$data['pwh'];
					$pwhlink=$data['pwhlink'];
					$sprq=$data['sprq'];
					$dwmc=$data['dwmc'];
					$xmmc=$data['xmmc'];
					$xz=$data['xz'];
					$xmdz=$data['xmdz'];
					$longitude=$data['longitude'];
					$latitude=$data['latitude'];
					$longitude=$data['longitude'];
					$latitude=$data['latitude'];
					$xmlx=$data['xmlx'];
					$xmlxlink=$data['xmlxlink'];
					$xyys=$data['xyys'];
					$xyjc=$data['xyjc'];
					$xyzl=$data['xyzl'];
					$xyssc=$data['xyssc'];
					$sscsp=$data['sscsp'];
					$sscsplink=$data['sscsplink'];
					$fr=$data['fr'];
					$frdh=$data['frdh'];
					$lxr=$data['lxr'];
					$lxrdh=$data['lxrdh'];
					$jhkgrq=$data['jhkgrq'];
					$jhjgrq=$data['jhjgrq'];
					$xmsx=$data['xmsx'];
					$xmzt=$data['xmzt'];
					$hpjbr=$data['hpjbr'];
					$hpjl=$data['hpjl'];
					$hpbz=$data['hpbz'];
					$wsqx=$data['wsqx'];
					$jtqx=$data['jtqx'];
		?>
  <tr align="center" class="parent" id="<?php echo $parow;?>">
    <td><?php echo $count+($page-1)*$perpagenum;?></td>
    <td align="left"><a href="yw_hp_hp_show.php?hpid=<?php echo $hpid;?>" target="_blank"><?php echo $xmmc;?></a></td>
    <td align="left"><?php echo $dwmc;?></td>
    <td><?php echo $hpjl;?></td>
    <td><?php echo $xgk;?></td>
    <td align="left"><?php if ($pwhlink){?><a href="<?php echo $pwhlink;?>"><?php echo $pwh;?></a><?php }else {echo $pwh;}?></td>
    <td><?php if ($xmlxlink){?><a href="<?php echo $xmlxlink;?>"><?php echo $xmlx;?></a><?php }else {echo $xmlx;}?></td>
    <td><?php echo $xmsx;?></td>
    <td><?php echo $xmzt;?></td>
    <td><?php echo $sprq;?></td>
    <td><?php echo $hpjbr;?></td>
    <td><?php if ($xyys==1){echo "是";}?></td>
    <td><?php if ($xyjc==1){echo "是";}?></td>
    <td>
		<?php
			if ($xyzl==1)
			{
				echo "<a href=\"yw_hp_zl_show.php?hpid=$hpid\">是</a>";
			}			
		?>
    </td>
    <td><?php if ($xyssc==1){echo "是";}?></td>
<?php 
	if($_SESSION['ywclusername']=="$qxfpdelete")
	{
?>
    <td><a href="yw_hp_hp_delete.php?hpid=<?php echo $hpid;?>"><img src="images/err.png" alt="" border="0" class="t1"/></a></td>
<?php }?>
  </tr>
  <tr align="center"  bgcolor="#FFFFFF" class="<?php echo $chrow?>">
    <td> </td>
    <td align="left"><?php echo $wsqx;?></td>
    <td align="left"><?php echo $jtqx;?></td>
    <td align="right">法人</td>
    <td><?php echo $fr;?></td>
    <td><?php echo $frdh;?></td>
    <td>计划开工</td>
    <td><?php echo $jhkgrq;?></td>
    <td>计划竣工</td>
    <td><?php echo $jhjgrq;?></td>
    <td>备注</td>
    <td colspan="3" align="left"><?php echo $hpbz;?></td>
    <td><?php if ($sscsplink){?><a href="<?php echo $sscsplink;?>"><?php echo $sscsp;?></a><?php }else{echo $sscsp;}?></td>
<?php 
	if($_SESSION['ywclusername']=="$qxfpdelete")
	{
?>
    <td> </td>
<?php }?>
  </tr>
  <tr align="center" bgcolor="#FFFFFF" class="<?php echo $chrow?>">
    <td><a target="_blank" href="xmdz.php?longitude=<?php echo $longitude;?>&latitude=<?php echo $latitude;?>">地图</a></td>
    <td><?php echo $longitude;?></td>
    <td><?php echo $latitude;?></td>
    <td align="right">联系人</td>
    <td><?php echo $lxr;?></td>
    <td><?php echo $lxrdh;?></td>
    <td><?php echo $xz;?></td>
    <td colspan="7" align="left"><?php echo $xmdz;?></td>
    <td> </td>
<?php 
	if($_SESSION['ywclusername']=="$qxfpdelete")
	{
?>
    <td> </td>
<?php }?>
  </tr>
  <?php } ?>
  <?php } ?>
</table>
<?php 
	include("pagesdh.php");
	}//最外层的$if ($totalnum>0)
?>
<?php
	include('foot.php');
?>