📄 update.php
字号:
<?php
include_once( "../auth1.php" );
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/utility.php" );
include_once( "../utility.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\" topmargin=\"5\">\r\n\r\n";
$connection = openconnection( );
$query = "select TABLE_NAME from IK_TABLE where TABLE_ID={$TABLE_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$TABLE_NAME = $ROW['TABLE_NAME'];
}
$FLAG = false;
$NAME_VALUE_STR = "";
$FIELD_NAME_STR_ARRAY = explode( ",", $FIELD_NAME_STR );
$FIELD_NAME_STR_NUM = sizeof( $FIELD_NAME_STR_ARRAY );
$I = 0;
for ( ; $I < $FIELD_NAME_STR_NUM; ++$I )
{
$FIELD_NAME = $FIELD_NAME_STR_ARRAY[$I];
$FIELD_VALUE = $$FIELD_NAME_STR_ARRAY[$I];
$query = "select * from IK_FIELD where FIELD_NAME='{$FIELD_NAME}' and TABLE_ID={$TABLE_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$FIELD_DESC = $ROW['FIELD_DESC'];
$FIELD_TYPE = $ROW['FIELD_TYPE'];
$FIELD_AUTOVALUE = $ROW['FIELD_AUTOVALUE'];
$FIELD_INTERFACE_TYPE = $ROW['FIELD_INTERFACE_TYPE'];
}
if ( $FIELD_INTERFACE_TYPE == 5 )
{
if ( $FIELD_VALUE != "" )
{
$FIELD_VALUE = 1;
}
else
{
$FIELD_VALUE = 0;
}
}
if ( $FIELD_TYPE == "D" && $FIELD_AUTOVALUE != "" )
{
$FIELD_TYPE = $FIELD_AUTOVALUE;
}
if ( !type_check( $FIELD_VALUE, $FIELD_TYPE ) )
{
if ( $FIELD_TYPE == "C" )
{
$TYPE_STR = "字符";
}
else if ( $FIELD_TYPE == "N" )
{
$TYPE_STR = "数字";
}
else if ( $FIELD_TYPE == "D" )
{
$TYPE_STR = "日期";
}
else if ( $FIELD_TYPE == "DT" )
{
$TYPE_STR = "日期时间";
}
else if ( $FIELD_TYPE == "T" )
{
$TYPE_STR = "文本";
}
$MESSAGE .= "<font color=#000000>".$FIELD_DESC."</font>字段应为<font color=#000000>".$TYPE_STR."</font>类型！<br>";
$FLAG = true;
}
$NAME_VALUE_STR .= $FIELD_NAME."='".$FIELD_VALUE."',";
}
if ( $FLAG )
{
message( "", $MESSAGE );
button_back( );
}
else
{
$NAME_VALUE_STR = substr( $NAME_VALUE_STR, 0, strlen( $NAME_VALUE_STR ) - 1 );
$query = "update {$TABLE_NAME} set {$NAME_VALUE_STR} where {$ID}='{$ID_VALUE}'";
exequery( $connection, $query );
$query = "SELECT * from IK_APP where APP_ID={$APP_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$APP_RETURN = $ROW['APP_RETURN'];
}
header( "location: {$APP_RETURN}" );
}
echo "\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -