modify.php

来自「极限网络智能办公系统 - Office Automation 2008 官方10」· PHP 代码 · 共 57 行

PHP
57
字号
<?php
 

include_once( "inc/auth.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  <input type=\"text\" name=\"FIELDNO\" class=\"smallInput\" size=\"10\" value=\"";
echo $showname;
echo "\">\r\n  <input type=\"text\" name=\"";
echo $tablename;
echo $fieldname;
echo "ORDER\" class=\"smallInput\" size=\"10\" value=\"";
echo $ORDER;
echo "\">\r\n  <input type=\"text\" name=\"";
echo $tablename;
echo $fieldname;
echo "TYPE\" class=\"smallInput\" size=\"10\" value=\"";
echo $TYPE;
echo "\">\r\n  <input type=\"text\" name=\"";
echo $tablename;
echo $fieldname;
echo "TYPECODE\" class=\"smallInput\" size=\"10\" value=\"";
echo $TYPECODE;
echo "\">\r\n  <input type=\"text\" name=\"";
echo $tablename;
echo $fieldname;
echo "ISQUERY\" class=\"smallInput\" size=\"10\" value=\"";
echo $ISQUERY;
echo "\">\r\n  <input type=\"text\" name=\"";
echo $tablename;
echo $fieldname;
echo "ISGROUY\" class=\"smallInput\" size=\"10\" value=\"";
echo $ISGROUY;
echo "\">\r\n  <input type=\"text\" name=\"TYPENAME\" class=\"smallInput\" size=\"10\" value=\"";
echo $TYPENAME;
echo "\">\r\n  <input type=\"text\" name=\"TYPEVALUE\" class=\"smallInput\" size=\"10\" value=\"";
echo $TYPEVALUE;
echo "\">\r\n  <br>\r\n";
$count = 0;
$connection = openconnection( );
$query = "select count(*) from FIELDSETTING where TABLENAME='".$tablename."' and FIELDNO='{$fieldname}'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$count = $ROW[0];
}
if ( $count == 0 )
{
	$query = "insert into FIELDSETTING(TABLENAME,FIELDNO,FIELDNAME,ORDERNO,STYPE,TYPENAME,TYPEVALUE,TYPECODE,ISQUERY,ISGROUY) values ('".$tablename."','{$fieldname}','{$showname}','{$ORDER}','{$TYPE}','{$TYPENAME}','{$TYPEVALUE}','{$TYPECODE}','{$ISQUERY}','{$ISGROUY}')";
}
else
{
	$query = "update FIELDSETTING set FIELDNAME='".$showname."',ORDERNO='{$ORDER}',STYPE='{$TYPE}',TYPENAME='{$TYPENAME}',TYPEVALUE='{$TYPEVALUE}',TYPECODE='{$TYPECODE}',ISQUERY='{$ISQUERY}',ISGROUY='{$ISGROUY}' where TABLENAME='{$tablename}' and FIELDNO='{$fieldname}'";
}
exequery( $connection, $query );
header( "location: index.php" );
echo "\r\n</body>\r\n</html>\r\n";
?>

⌨️ 快捷键说明

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