classlist.php

电子商务---产品发布系统 采用PHP+MYSQL+APACHE的环境,非常方便的一个小系统,可以嵌入其他系统内使用

<?php
	include('dbconnect.php');
	?>
<?php
	$parent_id=$_GET['parent_id'];
	$parent_name=$_GET['parent'];
	
	?>
	
<link href="css/style.css" rel="stylesheet" type="text/css">

  <p><span class="label">种类信息维护[<a href="classesadd.php?classesid=<?php echo $parent_id ?>&action=create">添加新种类</a>]</span></p>
  <p class="data">在这里，您可以查看种类列表。也可以添加新的产地或者修改、删除现有的产地。</p>
  <table width="650" border="0">
      <tr bgcolor="#6B5973" class="location">
        <td width="59" nowrap class="style1">ID</td>
        <td width="109" class="style1">种类名称</td>
        <td width="110" class="style1">子类数</td>
        <td width="157" class="style1">操作</td>
      </tr>
      <?php
	$classes_sql="select *from classes where parent_id='$parent_id'";
	$classes_result=mysql_query($classes_sql,$conn);
	$classes_num=mysql_num_rows($classes_result);
	
	while ($classes_row=mysql_fetch_array($classes_result)){
	?>
      <tr>
        <td><?php echo $classes_row['class_id'];?>
        </td>
        <td><?php echo $classes_row['class_name'];?></td>
        <td>
          <?php 
	$classes_child_sql="select parent_id from classes where parent_id=".$classes_row['class_id'];
	$classes_child_result=mysql_query($classes_child_sql);
	$classes_child_num=mysql_num_rows($classes_child_result);
		if ($classes_child_num) {
			echo $classes_child_num;
			} else {
	         echo "没有子类";
			 }
	?>
       </td>
	 
        <td> 
		[<a href="classlist.php?parent_id=<?php echo $classes_row['class_id']; ?>">查看子类</a>] 
		[<a href="classesadd.php?classesid=<?php echo $classes_row['class_id'];?>&action=create">添加子类</a>]
		[<a href="classesadd.php?classesid=<?php echo $classes_row['class_id'];?>&action=edit">修改</a>] 
		[<a href="classes.php?classesid=<?php echo $classes_row['class_id'];?>&parentid=<?php echo $classes_row['parent_id'];?>&action=delete">删除</a>]
		</td>
      </tr>
      <?php
	}
?>
  </table>

   <p class="data"> 该类共有子分类 <?php  echo $classes_num; ?> 个 </p>