📄 create.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/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'];
}
$query_create = "CREATE TABLE `".$TABLE_NAME."` (";
$query = "select * from IK_FIELD where TABLE_ID='{$TABLE_ID}' order by FIELD_INDEX desc,FIELD_ID";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$FIELD_NAME = $ROW['FIELD_NAME'];
$FIELD_TYPE = $ROW['FIELD_TYPE'];
$FIELD_LEN = $ROW['FIELD_LEN'];
$FIELD_INDEX = $ROW['FIELD_INDEX'];
if ( $FIELD_TYPE == "N" )
{
$FIELD_TYPE_DESC = "INT";
}
else if ( $FIELD_TYPE == "C" )
{
$FIELD_TYPE_DESC = "CHAR({$FIELD_LEN})";
}
else if ( $FIELD_TYPE == "D" )
{
$FIELD_TYPE_DESC = "DATETIME";
$FIELD_LEN = "";
}
else if ( $FIELD_TYPE == "T" )
{
$FIELD_TYPE_DESC = "TEXT";
}
if ( $FIELD_INDEX == "1" )
{
$query_create .= "`{$FIELD_NAME}` {$FIELD_TYPE_DESC} NOT NULL AUTO_INCREMENT ,";
$query_create2 = ",PRIMARY KEY (`{$FIELD_NAME}`) ";
}
else
{
$query_create .= "`{$FIELD_NAME}` {$FIELD_TYPE_DESC},";
}
}
$STR_LEN = strlen( $query_create );
$query_create = substr( $query_create, 0, $STR_LEN - 1 );
$query_create .= $query_create2.");";
if ( exequery( $connection, $query_create ) )
{
message( "表".$TABLE_NAME."创建成功！", "" );
}
else
{
message( "<font color=#FFFFFF>表".$TABLE_NAME."创建失败！</font>", "" );
}
button_back( );
echo "\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -