classes.php

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

<?php
	session_start();
	
	if(!isset($_SESSION['admin'])){
	  echo "<p align=center>";
	  echo "<font color=#ff0000 size=5><strong><big>你还没有登陆,请<a href='index.php'>登陆</a>!</big></strong></font>";
	  echo "</p>";
	  exit();
	}
	else {
	include('dbconnect.php');

	$action=$_GET['action'];
	$class_name=$_POST['classes'];
	$parent_id=$_POST['parent_id'];
	
	
	if ($action=='create') {
	
		$re_check=mysql_query("select class_id from classes where class_name ='$class_name'", $conn);
		$checked=mysql_fetch_array($re_check);
			if(!empty($checked)) {
				echo "<div align=center>产品已经存在<br>";
				echo "<a href='javascript:history.back(-1)'>后退</a></div>";
				exit();
				}
				
		$sql_insert="insert into classes (class_name,parent_id) values ('$class_name','$parent_id')";
		mysql_query($sql_insert,$conn) or die ("操作失败;".mysql_error());
		}
		else {
		$class_id=$_GET['classesid'];
		$parent_id=$_GET['parentid'];
						
		if ($action=='delete') {
			$sql_delete_root="delete from classes where class_id='$class_id'";
			mysql_query($sql_delete_root,$conn);		
			
			$sql_delete_child="delete from classes where parent_id='$class_id'";//删除子类
			mysql_query($sql_delete_child,$conn) or die ("操作失败;".mysql_error());
			}
		if ($action=='edit') {
			$sql_edit="update classes set class_name='$class_name' where class_id='$class_id'";
			mysql_query($sql_edit,$conn) or die ("操作失败;".mysql_error());
			}
		}
	header("Location:classlist.php?parent_id=$parent_id");
	
	}
	?>