📄 edit.php
字号:
<?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\r\n";
echo "<S";
echo "CRIPT language=javascript>\r\nfunction check_form()\r\n{\r\n if(document.form1.FIELD_NAME.value == \"\")\r\n {\r\n alert(\"字段名称不能为空!\");\r\n return false;\r\n }\r\n\r\n return true;\r\n}\r\n</SCRIPT>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\" onload=\"document.form1.FIELD_NAME.focus();\">\r\n\r\n";
if ( $FIELD_ID != "" )
{
$TITLE = "编辑表字段";
}
else
{
$TITLE = "新建表字段";
}
echo "\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/edit.gif\" WIDTH=\"22\" HEIGHT=\"20\" align=\"absmiddle\">";
echo "<s";
echo "pan class=\"big3\"> ";
echo $TITLE;
echo "</span><br>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n";
$connection = openconnection( );
if ( $FIELD_ID != "" )
{
$query = "SELECT * from IK_FIELD where FIELD_ID={$FIELD_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$FIELD_ID = $ROW['FIELD_ID'];
$TABLE_ID = $ROW['TABLE_ID'];
$FIELD_NAME = $ROW['FIELD_NAME'];
$FIELD_DESC = $ROW['FIELD_DESC'];
$FIELD_TYPE = $ROW['FIELD_TYPE'];
$FIELD_LEN = $ROW['FIELD_LEN'];
$FIELD_DEFVALUE = $ROW['FIELD_DEFVALUE'];
$FIELD_AUTOVALUE = $ROW['FIELD_AUTOVALUE'];
$FIELD_INDEX = $ROW['FIELD_INDEX'];
$FIELD_CODE_FIX = $ROW['FIELD_CODE_FIX'];
$FIELD_CODE_SQL = $ROW['FIELD_CODE_SQL'];
$FIELD_INTERFACE_TYPE = $ROW['FIELD_INTERFACE_TYPE'];
$FIELD_RELATION = $ROW['FIELD_RELATION'];
}
}
echo "\r\n<hr width=\"95%\" height=\"1\" align=\"left\" class=\"big1\">\r\n\r\n<table border=\"0\" width=\"450\" cellpadding=\"2\" cellspacing=\"1\" align=\"center\" bgcolor=\"#000000\" class=\"small\">\r\n <form action=\"";
if ( $FIELD_ID != "" )
{
echo "update";
}
else
{
echo "insert";
}
echo ".php\" method=\"post\" name=\"form1\" onSubmit=\"return check_form();\">\r\n <tr>\r\n <td nowrap class=\"TableData\">字段名：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"FIELD_NAME\" size=\"20\" maxlength=\"30\" class=\"BigInput\" value=\"";
echo $FIELD_NAME;
echo "\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">字段描述：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"FIELD_DESC\" size=\"20\" maxlength=\"100\" class=\"BigInput\" value=\"";
echo $FIELD_DESC;
echo "\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\">字段类型：</td>\r\n <td class=\"TableData\">\r\n ";
echo "<s";
echo "elect name=\"FIELD_TYPE\" class=\"BigSelect\">\r\n <option value=\"C\" ";
if ( $FIELD_TYPE == "C" )
{
echo "selected";
}
echo ">CHAR</option>\r\n <option value=\"N\" ";
if ( $FIELD_TYPE == "N" )
{
echo "selected";
}
echo ">NUMBER</option>\r\n <option value=\"D\" ";
if ( $FIELD_TYPE == "D" )
{
echo "selected";
}
echo ">DATETIME</option>\r\n <option value=\"T\" ";
if ( $FIELD_TYPE == "T" )
{
echo "selected";
}
echo ">TEXT</option>\r\n </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td valign=\"top\" nowrap class=\"TableContent\">字段长度：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"FIELD_LEN\" size=\"10\" maxlength=\"50\" class=\"BigInput\" value=\"";
echo $FIELD_LEN;
echo "\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">索引字段：</td>\r\n <td class=\"TableData\">\r\n ";
echo "<s";
echo "elect name=\"FIELD_INDEX\" class=\"BigSelect\">\r\n <option value=\"0\" ";
if ( $FIELD_INDEX == "0" )
{
echo "selected";
}
echo "> </option>\r\n <option value=\"1\" ";
if ( $FIELD_INDEX == "1" )
{
echo "selected";
}
echo ">自增</option>\r\n <option value=\"2\" ";
if ( $FIELD_INDEX == "2" )
{
echo "selected";
}
echo ">唯一</option>\r\n </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td valign=\"top\" nowrap class=\"TableData\">字段默认值：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"FIELD_DEFVALUE\" size=\"10\" class=\"BigInput\" value=\"";
echo $FIELD_DEFVALUE;
echo "\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">自动取值：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"FIELD_AUTOVALUE\" size=\"2\" maxlength=\"2\" class=\"BigInput\" value=\"";
echo $FIELD_AUTOVALUE;
echo "\"> 如果是日期型，D表示取当前日期，T表示取当前时间，可以为DT\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">代码列表：固定值：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"FIELD_CODE_FIX\" size=\"50\" class=\"BigInput\" value=\"";
echo $FIELD_CODE_FIX;
echo "\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">代码列表：SQL：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"FIELD_CODE_SQL\" size=\"50\" class=\"BigInput\" value=\"";
echo $FIELD_CODE_SQL;
echo "\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\">字段界面类型：</td>\r\n <td class=\"TableData\">\r\n ";
echo "<s";
echo "elect name=\"FIELD_INTERFACE_TYPE\" class=\"BigSelect\">\r\n <option value=\"1\" ";
if ( $FIELD_INTERFACE_TYPE == "1" )
{
echo "selected";
}
echo ">单行输入框</option>\r\n <option value=\"2\" ";
if ( $FIELD_INTERFACE_TYPE == "2" )
{
echo "selected";
}
echo ">多行输入框</option>\r\n <option value=\"3\" ";
if ( $FIELD_INTERFACE_TYPE == "3" )
{
echo "selected";
}
echo ">下拉菜单</option>\r\n <option value=\"4\" ";
if ( $FIELD_INTERFACE_TYPE == "4" )
{
echo "selected";
}
echo ">代码列表窗</option>\r\n <option value=\"5\" ";
if ( $FIELD_INTERFACE_TYPE == "5" )
{
echo "selected";
}
echo ">单选框</option>\r\n </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\">关联字段：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"FIELD_RELATION\" size=\"20\" maxlength=\"40\" class=\"BigInput\" value=\"";
echo $FIELD_RELATION;
echo "\">\r\n </td>\r\n </tr>\r\n <tr align=\"center\" class=\"TableControl\">\r\n <td colspan=\"2\" nowrap>\r\n <input type='hidden' value=\"";
echo $TABLE_ID;
echo "\" name=\"TABLE_ID\">\r\n <input type='hidden' value=\"";
echo $FIELD_ID;
echo "\" name=\"FIELD_ID\">\r\n <input type=\"submit\" value=\"保存\" class=\"BigButton\" name=\"submit\"> \r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" name=\"back\" onClick=\"history.back();\">\r\n </td>\r\n </tr>\r\n </form>\r\n</table>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -