<?
  $connect=mysql_connect("127.0.0.1","root","root");
  mysql_select_db("ebusiness");
  $message="";
  $query="select CategoryName from Categories where CategoryID="$category;
  $result=mysql_query($query);
  $categoryname=mysql_fetch_object($result)->CategoryName;
  $query="insert into Product (ProductName,Category,Price,Color,Size,Count,Detail)
          values('";
          $query=$query.$productname."','";
          $query=$query.$categoryname."',";
          $query=$query.$price.",'".$color."','";
          $query=$query.$size."',0,'";
          $query=$query.$detail."')";
          if(mysql_query($query))
          {
              $message="已加入新商品".$productname;
          }
          //選擇對應的商品ID，將圖片名改為相應的商品ID，并復制到圖片目錄下
          $cmd="select ProductID from Product where ProductName='".$productname."'
                and Size='".$size."' and Color='".$color."'";
                $result=mysql_query($cmd);
                $obj=mysql_fetch_object($result);
                $ProductID=$obj->ProductID;
                copy($pic,"pic/".$ProductID.".jpg");
          //斷開數據庫
                mysql_close($connect);
                header("Location:productmanage.php?message=$message");
?>