Gecko [ 122.154.134.11 ]

Name	Size	Permission
answer_qtn.php	20.81 KB	-rw-r--r--
create_qtn.php	9.78 KB	-rw-r--r--
create_question.php	18.13 KB	-rw-r--r--
create_use_qtn_detail.php	6.47 KB	-rw-r--r--
create_use_qtn_name.php	18.79 KB	-rw-r--r--
on_off_qtn.php	7.32 KB	-rw-r--r--
report1.php	14.43 KB	-rw-r--r--
report2.php	15.14 KB	-rw-r--r--
report3.php	5.03 KB	-rw-r--r--
school_group.php	14.59 KB	-rw-r--r--
school_group_show.php	7.51 KB	-rw-r--r--
upload_1.php	7.97 KB	-rw-r--r--
upload_2.php	1.69 KB	-rw-r--r--
view_qtn.php	16.22 KB	-rw-r--r--

Code Editor : report3.php

<?php
/** ensure this file is being included by a parent file */
defined( '_VALID_' ) or die( 'Direct Access to this location is not allowed.' );
$officer=$_SESSION['login_user_id'];

if($index==4){
$qtn_use_id=$_POST['qtn_use_id'];
$detail_index=0;
$all_sch_index=0;

$sql="select * from questionnaire_use_qtn_name where qtn_use_id='$qtn_use_id' limit 0,1";
$result=mysqli_query($connect,$sql);
$row=mysqli_fetch_array($result);
$qtn_name=$row['qtn_use_name'];
$qtn_id=$row['qtn_id'];

echo "<br/>";
echo "<TABLE cellpadding='5' cellspacing='5' border='0' width='90%' align='center'>";
echo "<TR bgcolor='#E6E6E6' height='30'>";
echo "<TD colspan=2 align='center'><B>รายงานข้อมูลทั้งหมด : $qtn_name</B></TD></TR>";
echo "</table>";
echo "<br>";

echo "<table width='100%' border='1' align='center' style='border-collapse: collapse'>";
echo "<tr>";

$sql2="select * from questionnaire_qq where qtn_id='$qtn_id' order by qtn_qq_id ";
$result2=mysqli_query($connect,$sql2);
echo "<td></td><td></td><td></td>";
while($row2=mysqli_fetch_array($result2)){
$qtn_qq_id=$row2['qtn_qq_id'];
$qtn_qq_num=$row2['qtn_qq_num'];
$qtn_qq_name=$row2['qtn_qq_name'];
$qtn_op_id=$row2['qtn_op_id'];

echo "<td colspan='$qtn_qq_num' align='center'>";
echo $qtn_qq_name;
echo "</td>";
}
echo "</tr>";

//แถวสอง
echo "<tr>";
$sql3="select * from questionnaire_qq where qtn_id='$qtn_id'  order by qtn_qq_id";
$result3=mysqli_query($connect,$sql3);
echo "<td align='center'>ที่</td><td align='center'>person_id</td><td align='center'>โรงเรียน</td>";
$N=1;
while($row3=mysqli_fetch_array($result3)){
$qtn_qq_id=$row3['qtn_qq_id'];  
$qtn_qq_num=$row3['qtn_qq_num'];
$qtn_op_id=$row3['qtn_op_id'];

$sql4="select * from questionnaire_qq_member where qtn_qq_id='$qtn_qq_id' order by qtn_qq_m_id ";
					$result4=mysqli_query($connect,$sql4);
					
					while($row4=mysqli_fetch_array($result4)){
					$qtn_qq_m_id=$row4['qtn_qq_m_id'];
					$qtn_qq_m_name=$row4['qtn_qq_m_name'];
					
					$qtn_qq_id_ar[$N]=$qtn_qq_id;
					$qtn_op_id_ar[$N]=$qtn_op_id;
					$qtn_qq_m_id_ar[$N]=$qtn_qq_m_id;
					
					echo "<td align='center'>";
					echo $qtn_qq_m_name; 
					echo "</td>";
					$N++;
					}
}

echo "</tr>";

//แถวสามเป็นต้นไป

$sql6="select DISTINCT user_id,school_code  from questionnaire_answer where qtn_use_id='$qtn_use_id' order by school_code";
$result6=mysqli_query($connect,$sql6);
$N=$N-1;
$M=1;
while($row6=mysqli_fetch_array($result6)){
$user_id=$row6['user_id'];
$school_code=$row6['school_code'];

echo "<tr><td>$M</td><td>$user_id</td><td>$school_code</td>";
			
			for($x = 1; $x <= $N; $x++){
			echo "<td>";
			$sql5="select * from questionnaire_answer where  qtn_use_id='$qtn_use_id' and qtn_qq_id='$qtn_qq_id_ar[$x]' and  qtn_qq_m_id='$qtn_qq_m_id_ar[$x]' and user_id='$user_id' ";
			$result5=mysqli_query($connect,$sql5);
			while($row5=mysqli_fetch_array($result5)){
			
					if($qtn_op_id_ar[$x]==1){
					echo $row5['qtn_value1']; 
					}
					else if($qtn_op_id_ar[$x]==2){
					echo $row5['qtn_value2']; 
					}
					else if($qtn_op_id_ar[$x]==3){
					echo $row5['qtn_value3']; 
					}
					else if($qtn_op_id_ar[$x]==4){
							$sql7="select * from questionnaire_qq_member_other where qtn_qq_mo_id='$row5[qtn_value4]' ";
							$result7=mysqli_query($connect,$sql7);
							$row7=mysqli_fetch_array($result7);
							echo $row7['qtn_qq_mo_name']; 
					}
					else if($qtn_op_id_ar[$x]==5){
							$sql8="select * from questionnaire_qq_member_other where qtn_qq_mo_id='$row5[qtn_value5]' ";
							$result8=mysqli_query($connect,$sql8);
							$row8=mysqli_fetch_array($result8);
							echo $row8['qtn_qq_mo_name']; 
							echo "  ";
					}
			} //while		
			echo "</td>";		
			} //for
			echo "</tr>";
$M++;			
}

echo "</table>";
}

if(!($index==4)){
echo "<br/>";
echo "<form id='frm1' name='frm1'>";
echo "<TABLE cellpadding='5' cellspacing='5' border='0' width='90%' align='center'>";
echo "<TR bgcolor='#E6E6E6' height='30'>";
echo "<TD colspan=2 align='center'><B>รายงานการตอบแบบสอบถาม</B></TD></TR>";

echo "<TR><TD colspan='2' align='center'>เลือกแบบสอบถาม&nbsp;&nbsp;&nbsp;&nbsp;";
echo "<select name='qtn_use_id'>";

$sql= "select * from questionnaire_use_qtn_name  order by qtn_use_id desc";
$dbquery = mysqli_query($connect,$sql);
While ($result = mysqli_fetch_array($dbquery)){
	if($qtn_use_id==$result['qtn_use_id']){
		$select="selected";}
		else{
		$select="";
		}
	echo "<option value='$result[qtn_use_id]' $select>$result[qtn_use_name]</option>";
}
	echo "</select>" ;
echo "</TD></TR>";
echo "</TABLE>";
echo "<br>";
echo "<div align='center'>";
echo "<Input Type='Submit'  Value='ตกลง' onclick='goto_url(1)'>";
echo "</div>";
echo "</form>";
}
?>
<script>
function goto_url(val){
	if(val==1){
	callfrm("?option=questionnaire&task=main/report3&index=4");  
	}
}
</script>

${this.title}

Code Editor : report3.php