📄 modify.php
字号:
<?
include_once("inc/auth.php");
?>
<html>
<head>
<title>修改字段信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor">
<input type="text" name="FIELDNO" class="smallInput" size="10" value="<?=$showname?>">
<input type="text" name="<?=$tablename?><?=$fieldname?>ORDER" class="smallInput" size="10" value="<?=$ORDER?>">
<input type="text" name="<?=$tablename?><?=$fieldname?>TYPE" class="smallInput" size="10" value="<?=$TYPE?>">
<input type="text" name="<?=$tablename?><?=$fieldname?>TYPECODE" class="smallInput" size="10" value="<?=$TYPECODE?>">
<input type="text" name="<?=$tablename?><?=$fieldname?>ISQUERY" class="smallInput" size="10" value="<?=$ISQUERY?>">
<input type="text" name="<?=$tablename?><?=$fieldname?>ISGROUY" class="smallInput" size="10" value="<?=$ISGROUY?>">
<input type="text" name="TYPENAME" class="smallInput" size="10" value="<?=$TYPENAME?>">
<input type="text" name="TYPEVALUE" class="smallInput" size="10" value="<?=$TYPEVALUE?>">
<br>
<?
$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");
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -