📄 updateedit.php
字号:
<?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\r\n";
if ( $BIRTHDAY != "" && $BIRTHDAY != "0000-00-00" )
{
$TIME_OK = is_date( $BIRTHDAY );
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='linkmanedit.php?CUSTOMER_ID=";
echo $CUSTOMER_ID;
echo "&LINKMAN_NAME=";
echo $LINKMAN_NAME;
echo "&SEX=";
echo $SEX;
echo "&BIRTHDAY=";
echo $BIRTHDAY;
echo "&POST_PRIV=";
echo $POST_PRIV;
echo "&HOBBY=";
echo $HOBBY;
echo "&ADD_HOME=";
echo $ADD_HOME;
echo "&POSTALCODE_HOME=";
echo $POSTALCODE_HOME;
echo "&TEL_NO_WORK=";
echo $TEL_NO_WORK;
echo "&TEL_NO_HOME=";
echo $TEL_NO_HOME;
echo "&MOBILE=";
echo $MOBILE;
echo "&EMAIL=";
echo $EMAIL;
echo "&OICQ=";
echo $OICQ;
echo "&ICQ=";
echo $ICQ;
echo "&MEMO=";
echo $MEMO;
echo "'\">\r\n</div>\r\n\r\n";
exit( );
}
}
$connection = openconnection( );
if ( $_REQUEST['mostly_linkman'] == NULL )
{
$mostle_linkman = 0;
}
else
{
$query = "update linkman set MOSTLY_LINKMAN=0 where CUSTOMER_ID=".$_REQUEST['CUSTOMER_ID'];
exequery( $connection, $query );
$mostle_linkman = 1;
}
if ( $LINKMAN_ID != "" )
{
$query = "UPDATE linkman SET LINKMAN_NAME = '{$LINKMAN_NAME}',\r\n\t\t\t\t\t\t\t BIRTHDAY = '{$BIRTHDAY}',\r\n\t\t\t\t\t\t\t SEX = '{$SEX}',\r\n\t\t\t\t\t\t\t ADD_HOME = '{$ADD_HOME}',\r\n\t\t\t\t\t\t\t POST_PRIV = '{$POST_PRIV}',\r\n\t\t\t\t\t\t\t POSTALCODE_HOME = '{$POSTALCODE_HOME}',\r\n\t\t\t\t\t\t\t TEL_NO_WORK = '{$TEL_NO_WORK}',\r\n\t\t\t\t\t\t\t TEL_NO_HOME = '{$TEL_NO_HOME}',\r\n\t\t\t\t\t\t\t MOBILE = '{$MOBILE}',\r\n\t\t\t\t\t\t\t HOBBY = '{$HOBBY}',\r\n\t\t\t\t\t\t\t EMAIL = '{$EMAIL}',\r\n\t\t\t\t\t\t\t OICQ = '{$OICQ}',\r\n\t\t\t\t\t\t\t ICQ = '{$ICQ}',\r\n\t\t\t\t\t\t\t MEMO = '".htmlspecialchars( $_REQUEST['MEMO'] )."',\r\n\t\t\t\t\t\t\t mostly_linkman = '{$mostle_linkman}'\r\n\t\t\t\t\t\t\t WHERE LINKMAN_ID= '{$LINKMAN_ID}' ";
}
else
{
$query = "INSERT into LINKMAN(CUSTOMER_ID,LINKMAN_NAME,SEX,BIRTHDAY,POST_PRIV,HOBBY,ADD_HOME,POSTALCODE_HOME,TEL_NO_WORK,TEL_NO_HOME,MOBILE,EMAIL,OICQ,ICQ,MEMO,MOSTLY_LINKMAN)values('{$CUSTOMER_ID}','{$LINKMAN_NAME}','{$SEX}','{$BIRTHDAY}','{$POST_PRIV}','{$HOBBY}','{$ADD_HOME}','{$POSTALCODE_HOME}','{$TEL_NO_WORK}','{$TEL_NO_HOME}','{$MOBILE}','{$EMAIL}','{$OICQ}','{$ICQ}','".htmlspecialchars( $_REQUEST['MEMO'] )."',".$mostle_linkman.")";
}
exequery( $connection, $query );
echo "</body>\r\n</html>\r\n";
echo "<s";
echo "cript language=\"javascript\" >\r\nwindow.opener.location.reload();\r\nwindow.close();\r\n</script>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -