submit.php

来自「通达网络办公 - Office Anywhere 2008 增强版100％源码(」· PHP 代码 · 共 37 行

<?php

include_once( "inc/auth.php" );
include_once( "inc/check_type.php" );
if ( !is_number( $ORDER_NO ) )
{
	message( "错误", "排序号应为数字！" );
	button_back( );
	exit( );
}
$SEND_TIME = date( "Y-m-d H:i:s", time( ) );
$BEGIN_DATE = date( "Y-m-d", time( ) );
$query = "SELECT * from TRAIN_SURVEY_TITLE where SURVEY_ID='".$SURVEY_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$PARENT_ID = $ROW['PARENT_ID'];
	$FROM_ID = $ROW['FROM_ID'];
	$CONTENT = $ROW['CONTENT'];
	$TYPE = $ROW['TYPE'];
	$PUBLISH = $ROW['PUBLISH'];
}
$query = "insert into TRAIN_SURVEY_TITLE(PARENT_ID,FROM_ID,ORDER_NO,SUBJECT,CONTENT,SEND_TIME,BEGIN_DATE,TYPE,PUBLISH) values ('".$PARENT_ID."','{$FROM_ID}','{$ORDER_NO}','{$SUBJECT}','{$CONTENT}','{$SEND_TIME}','{$BEGIN_DATE}','{$TYPE}','{$PUBLISH}')";
exequery( $connection, $query );
$CLONE_SUB_SURVEY_ID = mysql_insert_id( );
$query1 = "SELECT * from TRAIN_SURVEY_ITEM where SURVEY_ID='".$SURVEY_ID."' order by ITEM_ID asc";
$cursor1 = exequery( $connection, $query1 );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
	$ITEM_NAME = $ROW['ITEM_NAME'];
	$ITEM_NAME = addslashes( $ITEM_NAME );
	$query2 = "insert into TRAIN_SURVEY_ITEM(SURVEY_ID,ITEM_NAME) values ('".$CLONE_SUB_SURVEY_ID."','{$ITEM_NAME}')";
	exequery( $connection, $query2 );
}
header( "location: ../survey.php?PARENT_ID=".$PARENT_ID1."&CUR_PAGE=1" );
?>