mysql建立修改表存储过程_mysql里建立一个存储过程来实现对某个表的插入，修改，删除，查询操作...

//事务处理在PHP+MySQL中的用法实例

include( "../function/config.php ");

header( "Content-Type:text/html;charset=big5 ");

if(!(UserRight(5,10,1))){header( "Location:../Administrator/select.php ");}

?>

$StockInCode   =   $_POST[ "StockInCode "];

$StockInDate   =   $_POST[ "StockInDate "];

$PartnerCode   =   $_POST[ "PartnerCode "];

$SiteID     =   $_POST[ "SiteID "];

$Remarks   =   $_POST[ "Remarks "];

$CreateUserID   =   $_SESSION[ 'Userid '];

$CreateDate   =   date( "Y-m-d   H:i:s ");

$input_num   =   $_POST[ "input_num "];

$sql= "select   *   from   stockin   where   StockInCode= '$StockInCode ' ";

$result=mysql_fetch_row(mysql_query($sql));

if($result)

{

echo   ( " ");

exit();

}

else

{

mysql_query( "SET   AUTOCOMMIT=0 ");

mysql_query( "BEGIN ");

for   ($i=0;$i

$ProgramCode   =   $_POST[ "ProgramCode ".$i];

$ItemCode   =   $_POST[ "ItemCode ".$i];

$ItemQTY   =   $_POST[ "ItemQTY ".$i];

if(empty($ItemQTY)){

$ItemQTY   =   0;

}

if(!(empty($ProgramCode))){

$sql_sb   =   "select   *   from   stockbalance   where   PartnerCode= '$PartnerCode '   and   ProgramCode= '$ProgramCode '   and   ItemCode= '$ItemCode '   and   SiteID= '$SiteID ' ";

$result_sb   =   mysql_fetch_row(mysql_query($sql_sb));

if($result_sb){

$sql_up_sb   =   "update   stockbalance   set   QTY=QTY+$ItemQTY,UpdateUserID= '$CreateUserID ',LastUpdate= '$CreateDate '   where   PartnerCode= '$PartnerCode '   and   ProgramCode= '$ProgramCode '   and   ItemCode= '$ItemCode '   and   SiteID= '$SiteID ' ";

//echo   $sql_up_sb. "
";

//mysql_query($sql_up_sb);

if(!mysql_query($sql_up_sb)){mysql_query( "ROOLBACK ");}

}else{

$sql_in_sb= "insert   into   stockbalance   (PartnerCode,SiteID,ProgramCode,ItemCode,QTY,CreateUserID,CreateDate)   values( '$PartnerCode ', '$SiteID ', '$ProgramCode ', '$ItemCode ', '$ItemQTY ', '$CreateUserID ', '$CreateDate ') ";

//echo   $sql_in_sb. "
";

//mysql_query($sql_in_sb);

if(!mysql_query($sql_in_sb)){mysql_query( "ROOLBACK ");}

}

$sql_il   =   "insert   into   stockinitem   (PartnerCode,SiteID,ProgramCode,StockInCode,ItemCode,QTY)   values( '$PartnerCode ', '$SiteID ', '$ProgramCode ', '$StockInCode ', '$ItemCode ', '$ItemQTY ') ";

//echo   $sql_il. "
";

//mysql_query($sql_il);

if(!mysql_query($sql_il)){mysql_query( "ROOLBACK ");}

}

}

$sql_is= "insert   into   stockin   (StockInCode,StockInDate,PartnerCode,SiteID,Remarks,CreateUserID,CreateDate)   values( '$StockInCode ', '$StockInDate ', '$PartnerCode ', '$SiteID ', '$Remarks ', '$CreateUserID ', '$CreateDate ') ";

//echo   $sql_is. "
";

//mysql_query($sql_is);

if(!mysql_query($sql_is)){mysql_query( "ROOLBACK ");}

mysql_query( "COMMIT ");

echo   ( " ");

}

?>

作者: yangyu112654374

发布时间: 2007-07-06