add.php

来自「极限网络智能办公系统—MYOA26—100%—源程序。」· PHP 代码 · 共 40 行

PHP
40
字号
<?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";
$connection = openconnection( );
$query = "select * from PROVIDER where PROVIDER_NAME='{$PROVIDER_NAME}'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	message( "错误", "供应商 ".$PROVIDER_NAME." 已存在" );
	echo "\r\n<br>\r\n<div align=\"center\">\r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='new.php?PROVIDER_NAME=";
	echo $PROVIDER_NAME;
	echo "&TEL_NO=";
	echo $TEL_NO;
	echo "&FAX_NO=";
	echo $FAX_NO;
	echo "&PROVIDER_WWW=";
	echo $PROVIDER_WWW;
	echo "&EMAIL=";
	echo $EMAIL;
	echo "&PROVIDER_ADD=";
	echo $PROVIDER_ADD;
	echo "&POSTALCODE=";
	echo $POSTALCODE;
	echo "&BANK=";
	echo $BANK;
	echo "&ACCOUNT=";
	echo $ACCOUNT;
	echo "&MEMO=";
	echo $MEMO;
	echo "'\">\r\n</div>\r\n\r\n";
	exit( );
}
$query = "INSERT into PROVIDER(PROVIDER_NAME,TEL_NO,FAX_NO,PROVIDER_WWW,EMAIL,PROVIDER_ADD,POSTALCODE,BANK,ACCOUNT,MEMO)values('{$PROVIDER_NAME}','{$TEL_NO}','{$FAX_NO}','{$PROVIDER_WWW}','{$EMAIL}','{$PROVIDER_ADD}','{$POSTALCODE}','{$BANK}','{$ACCOUNT}','{$MEMO}')";
exequery( $connection, $query );
header( "location: new.php" );
echo "</body>\r\n</html>\r\n";
?>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?