📄 survey_data.php
字号:
<?php
function ParseItemName( $ITEM_NAME, $ITEM_ID, $COUNT = 1 )
{
$POS = strpos( $ITEM_NAME, "{" );
if ( $POS === FALSE )
{
return $ITEM_NAME;
}
if ( substr( $ITEM_NAME, $POS, 6 ) == "{text}" )
{
return substr( $ITEM_NAME, 0, $POS )."<a href=\"#INPUT_ITEM_".$ITEM_ID."_".$COUNT++."\" style=\"text-decoration: underline;\">？？？</a>".parseitemname( substr( $ITEM_NAME, $POS + 6 ), $ITEM_ID, $COUNT );
}
if ( substr( $ITEM_NAME, $POS, 8 ) == "{number}" )
{
return substr( $ITEM_NAME, 0, $POS )."<a href=\"#INPUT_ITEM_".$ITEM_ID."_".$COUNT++."\" style=\"text-decoration: underline;\">？？？</a>".parseitemname( substr( $ITEM_NAME, $POS + 8 ), $ITEM_ID, $COUNT );
}
if ( substr( $ITEM_NAME, $POS, 10 ) == "{textarea}" )
{
return substr( $ITEM_NAME, 0, $POS )."<a href=\"#INPUT_ITEM_".$ITEM_ID."_".$COUNT++."\" style=\"text-decoration: underline;\">？？？</a>".parseitemname( substr( $ITEM_NAME, $POS + 10 ), $ITEM_ID, $COUNT );
}
return substr( $ITEM_NAME, 0, $POS + 1 ).parseitemname( substr( $ITEM_NAME, $POS + 1 ), $ITEM_ID );
}
function ParseItemName2( $ITEM_NAME, &$ARRAY )
{
$POS = strpos( $ITEM_NAME, "{" );
if ( $POS === FALSE )
{
return;
}
if ( substr( $ITEM_NAME, $POS, 6 ) == "{text}" )
{
$ARRAY[count( $ARRAY )] = "text";
parseitemname2( substr( $ITEM_NAME, $POS + 6 ), &$ARRAY );
}
else if ( substr( $ITEM_NAME, $POS, 8 ) == "{number}" )
{
$ARRAY[count( $ARRAY )] = "number";
parseitemname2( substr( $ITEM_NAME, $POS + 8 ), &$ARRAY );
}
else if ( substr( $ITEM_NAME, $POS, 10 ) == "{textarea}" )
{
$ARRAY[count( $ARRAY )] = "textarea";
parseitemname2( substr( $ITEM_NAME, $POS + 10 ), &$ARRAY );
}
else
{
parseitemname2( substr( $ITEM_NAME, $POS + 1 ), &$ARRAY );
}
}
include_once( "inc/auth.php" );
echo "<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";
$query = "SELECT * from TRAIN_SURVEY_TITLE where SURVEY_ID=".$SURVEY_ID;
$cursor2 = exequery( $connection, $query );
if ( $ROW2 = mysql_fetch_array( $cursor2 ) )
{
$SUBJECT = $ROW2['SUBJECT'];
$PARENT_ID = $ROW2['PARENT_ID'];
$query = "SELECT * from TRAIN_SURVEY_TITLE where SURVEY_ID=".$PARENT_ID;
$cursor2 = exequery( $connection, $query );
if ( $ROW2 = mysql_fetch_array( $cursor2 ) )
{
$ANONYMITY = $ROW2['ANONYMITY'];
}
}
echo "<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big3\" align=\"center\">";
echo $SUBJECT;
echo "</td>\r\n </td>\r\n </tr>\r\n</table>\r\n <table class=\"TableBlock\" width=\"100%\" align=\"center\">\r\n";
$query = "SELECT * from TRAIN_SURVEY_ITEM where SURVEY_ID=".$SURVEY_ID;
$cursor2 = exequery( $connection, $query );
while ( $ROW2 = mysql_fetch_array( $cursor2 ) )
{
$ITEM_ID = $ROW2['ITEM_ID'];
$ITEM_NAME = $ROW2['ITEM_NAME'];
if ( !strstr( $ITEM_NAME, "{text}" ) || !strstr( $ITEM_NAME, "{number}" ) || !strstr( $ITEM_NAME, "{textarea}" ) )
{
}
else
{
$ARRAY = array( );
parseitemname2( $ITEM_NAME, &$ARRAY );
$ITEM_NAME = parseitemname( $ITEM_NAME, $ITEM_ID );
echo " <tr class=\"TableHeader\">\r\n <td colspan=\"2\">\r\n ";
echo $ITEM_NAME;
echo " </td>\r\n </tr>\r\n <tr class=\"TableData\">\r\n <td>\r\n";
$I = 0;
for ( ; $I < count( $ARRAY ); ++$I )
{
echo " <a name=\"INPUT_ITEM_";
echo $ITEM_ID;
echo "_";
echo $I + 1;
echo "\"><b>【输入项";
echo $I + 1;
echo "】：</b></a><br>\r\n";
if ( $ARRAY[$I] == "number" )
{
$query = ( "SELECT FIELD_DATA,count(*) from TRAIN_SURVEY_DATA where ITEM_ID='".$ITEM_ID."' and FIELD_NAME='".( $I + 1 ) )."' group by FIELD_DATA";
$cursor1 = exequery( $connection, $query );
while ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
echo "<li>".$ROW1[0]."(".$ROW1[1]."票)</li><br>";
}
echo ( "【输入项".( $I + 1 ) )."详细信息】：<br>";
}
$query = ( "SELECT * from TRAIN_SURVEY_DATA where ITEM_ID='".$ITEM_ID."' and FIELD_NAME='".( $I + 1 ) )."'";
$cursor1 = exequery( $connection, $query );
while ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$USER_ID = $ROW1['USER_ID'];
$FIELD_DATA = $ROW1['FIELD_DATA'];
if ( $USER_ID != "" )
{
$query = "SELECT * from USER where USER_ID='".$USER_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$USER_ID = "【".$ROW['USER_NAME']."】";
}
}
echo " <li>";
echo $USER_ID;
echo $FIELD_DATA;
echo "</li><br>\r\n";
}
}
echo " </td>\r\n </tr>\r\n";
}
}
echo " <tr align=\"center\" class=\"TableControl\">\r\n <td colspan=\"2\">\r\n <input type=\"button\" value=\"关闭\" class=\"BigButton\" onClick=\"javascript:window.close();\">\r\n </td>\r\n </tr>\r\n </table>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -