update.php

礼品系统主要提供顾客和供应商之间完成零件交易的功能

<?
include("../../../include/include.inc");


$GetProduct = mysql_db_query($_dbname,"SELECT primid FROM tbl_product WHERE name='$name' AND primid<>'$id'");
if(mysql_num_rows($GetProduct)>0)
{
	print("<script langue=javascript>alert(\"更新产品资料失败，该产品名称已经存在！\")</script>");
	print("<script langue=javascript>history.back();</script>");
}
else
{
	$primid = $id;
	mysql_db_query($_dbname,"UPDATE tbl_product SET name='$name',id='$productid',type='$type',pricetype='$price',supply='$supply',special='$special',comment='$comment',detail='$detail' WHERE primid='$primid'");

	if($img != "")
	{
		$ImgArr = explode(".",$img_name);
		$ImgName = $ImgArr[0];
		$ImgExt = $ImgArr[1];
		$CopyResult = copy($img,"../../../upload/product/$primid.$ImgExt");
		mysql_db_query($_dbname,"UPDATE tbl_product SET ext='$ImgExt' WHERE primid='$primid'");
	}
	if($smallimg != "")
	{
		$SmallImgArr = explode(".",$smallimg_name);
		$SmallImgName = $SmallImgArr[0];
		$SmallImgExt = $SmallImgArr[1];
		$CopyResult = copy($smallimg,"../../../upload/product/s$primid.$SmallImgExt");
		mysql_db_query($_dbname,"UPDATE tbl_product SET small_ext='$SmallImgExt' WHERE primid='$primid'");
	}	
}
print("<meta HTTP-EQUIV='Refresh' Content='0;URL=../../index.php?inc=product&id=$id'>");
?>