origins.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'];
	$origin=$_POST['origin'];
	
	if ($action=='create') {
		
		$re_check=mysql_query("select origin_id from origins where origin_name ='$origin'", $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 origins (origin_name) values ('$origin')";
		mysql_query($sql_insert,$conn) or die ("操作失败;".mysql_error());
		}
		else {
		$origin_id=$_GET['originid'];
		
		if ($action=='delete') {
			$sql_delete="delete from origins where origin_id='$origin_id'";
			mysql_query($sql_delete,$conn) or die ("操作失败;".mysql_error());
			}
		if ($action=='edit') {
		
			$re_check=mysql_query("select origin_id from origins where origin_name ='$origin'", $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_edit="update origins set origin_name='$origin' where origin_id='$origin_id'";
			mysql_query($sql_edit,$conn) or die ("操作失败;".mysql_error());
			}
		}
	header("Location:originslist.php");
	}
	?>