update.php
来自「极限网络智能办公系统—MYOA26—100%—源程序。」· PHP 代码 · 共 68 行
PHP
68 行
<?php
include_once( "inc/auth.php" );
include_once( "inc/check_type.php" );
echo "\r\n<html>\r\n<head>\r\n<title>销售记录修改提交 </title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n\r\n<body class=\"bodycolor\">\r\n";
if ( $DATE != "" && $DATE != "0000-00-00" )
{
$TIME_OK = is_date( $DATE );
if ( !$TIME_OK )
{
message( "错误", "日期格式不对,应形如 1999-1-2" );
echo "\r\n<br>\r\n<div align=\"center\">\r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='edit.php?CUSTOMER_ID=";
echo $CUSTOMER_ID;
echo "&PRODUCT_ID=";
echo $PRODUCT_ID;
echo "&PROVIDER_ID=";
echo $PROVIDER_ID;
echo "&DATE=";
echo $DATE;
echo "&AMT=";
echo $AMT;
echo "&PRICE=";
echo $PRICE;
echo "&DISCOUNT=";
echo $DISCOUNT;
echo "&SALESMAN=";
echo $SALESMAN;
echo "&MEMO=";
echo $MEMO;
echo "'\">\r\n</div>\r\n\r\n";
exit( );
}
}
if ( $AMT != "" )
{
$TIME_OK = is_number( $AMT );
if ( !$TIME_OK )
{
message( "错误", "数量错误" );
echo "\r\n<br>\r\n<div align=\"center\">\r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='new.php?CUSTOMER_ID=";
echo $CUSTOMER_ID;
echo "&PRODUCT_ID=";
echo $PRODUCT_ID;
echo "&PROVIDER_ID=";
echo $PROVIDER_ID;
echo "&DATE=";
echo $DATE;
echo "&AMT=";
echo $AMT;
echo "&PRICE=";
echo $PRICE;
echo "&DISCOUNT=";
echo $DISCOUNT;
echo "&SALESMAN=";
echo $SALESMAN;
echo "&MEMO=";
echo $MEMO;
echo "'\">\r\n</div>\r\n\r\n";
exit( );
}
}
$connection = openconnection( );
$query = "update SALE_HISTORY set CUSTOMER_ID='{$CUSTOMER_ID}',PRODUCT_ID='{$PRODUCT_ID}',DATE='{$DATE}',AMT={$AMT},PRICE='{$PRICE}',DISCOUNT='{$DISCOUNT}',SALESMAN='{$SALESMAN}',MEMO='{$MEMO}' where HISTORY_ID='{$HISTORY_ID}'";
exequery( $connection, $query );
header( "location: list.php?".$QUERY_LIST );
echo "</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?