Gecko [ 122.154.134.11 ]

Name	Size	Permission
add_score.php	1.58 KB	-rw-r--r--
add_test.php	9.11 KB	-rwxr-xr-x
curriculum.php	7.97 KB	-rwxr-xr-x
curriculum_view.php	25.22 KB	-rwxr-xr-x
examination_set.php	320 B	-rwxr-xr-x
export_to_excel.php	4.24 KB	-rw-r--r--
frm_add_test.php	1.77 KB	-rwxr-xr-x
indicator.php	37.07 KB	-rwxr-xr-x
item_display.php	6.68 KB	-rw-r--r--
khet_paper_report_1.php	61.73 KB	-rw-r--r--
khet_paper_report_2.php	65.56 KB	-rw-r--r--
khet_report_1.php	27.49 KB	-rwxr-xr-x
khet_report_1_mobile.php	8.38 KB	-rwxr-xr-x
khet_report_2.php	68.18 KB	-rwxr-xr-x
level_log.php	1.6 KB	-rw-r--r--
level_record.php	17.37 KB	-rw-r--r--
level_report_1.php	38.07 KB	-rw-r--r--
level_report_2.php	35.32 KB	-rw-r--r--
level_report_3.php	22.22 KB	-rw-r--r--
level_report_4.php	16.65 KB	-rw-r--r--
level_test.php	22.99 KB	-rw-r--r--
livesearch.php	721 B	-rwxr-xr-x
livesearch2.php	729 B	-rw-r--r--
livesearch3.php	756 B	-rw-r--r--
livesearch4.php	727 B	-rw-r--r--
livesearch5.php	1.16 KB	-rw-r--r--
livesearch6.php	1.41 KB	-rw-r--r--
master_test_report.php	16.2 KB	-rw-r--r--
permission.php	11.69 KB	-rwxr-xr-x
print_check.php	3.52 KB	-rw-r--r--
return_ajax_indicator.php	1.64 KB	-rwxr-xr-x
return_ajax_standard.php	805 B	-rwxr-xr-x
return_ajax_substance.php	1.36 KB	-rwxr-xr-x
sch_paper_report_1.php	62.36 KB	-rw-r--r--
sch_report_1.php	65.87 KB	-rwxr-xr-x
sch_report_1_mobile.php	10.62 KB	-rwxr-xr-x
school_limit.php	13.09 KB	-rw-r--r--
standard.php	19.24 KB	-rwxr-xr-x
student_paper_report_1.php	17.6 KB	-rw-r--r--
student_report_1.php	25.54 KB	-rwxr-xr-x
student_report_1_mobile.php	5.51 KB	-rwxr-xr-x
substance.php	16.58 KB	-rwxr-xr-x
test_admin.php	46.87 KB	-rwxr-xr-x
test_admin2.php	6.86 KB	-rw-r--r--
test_admin3.php	11.27 KB	-rw-r--r--
test_admin_book.php	75.57 KB	-rw-r--r--
test_admin_book2.php	19.74 KB	-rw-r--r--
test_import.php	7.86 KB	-rw-r--r--
test_item.php	93.56 KB	-rwxr-xr-x
test_master.php	46.2 KB	-rwxr-xr-x
test_qc.php	15.46 KB	-rw-r--r--
test_qc_person.php	8.05 KB	-rw-r--r--
test_sch.php	6.1 KB	-rwxr-xr-x
test_sch_2.php	26.76 KB	-rwxr-xr-x
test_student.php	34.71 KB	-rwxr-xr-x

Code Editor : export_to_excel.php

<BODY>
<?php
require_once "../../../amssplus_connect.php";

foreach($_GET as $system_key => $system_key_val) {
   $_GET["$system_key"] =mysqli_real_escape_string($connect,$system_key_val);
}

//ปีการศึกษา
$sql = "select * from  student_main_edyear  where year_active='1' order by  ed_year desc limit 1";
$dbquery = mysqli_query($connect,$sql);
$year_active_result = mysqli_fetch_array($dbquery);
$ed_year=$year_active_result['ed_year'];

///โรงเรียน
$sql = "select  school_name from  system_school  where school_code='$_GET[school_code]' ";
$dbquery_sch_name = mysqli_query($connect,$sql );
$result_sch_name = mysqli_fetch_array($dbquery_sch_name);
$school_name=$result_sch_name['school_name'];

$sql = "select * from bets_paper_test_1 left join  bets_group on  bets_paper_test_1.s_group=bets_group.group_code where bets_paper_test_1.id='$_GET[test_id]'";
$dbquery = mysqli_query($connect,$sql);
$result = mysqli_fetch_array($dbquery);
$item_num=$result['item_num'];
$full_score=$result['test_score'];

echo "<table width='50%' border='0' align='center'>";
echo "<tr align='left'><td colspan='5'><font><strong>วิชา $result[test_name]</strong></font></td></tr>";
echo "<tr align='left'><td colspan='5'><font><strong>โรงเรียน $school_name</strong></font></td></tr>";
echo "</table>";
echo "<br>";

echo  "<table width='85%' border='0' align='center'>";
		echo "<Tr bgcolor='#FFCCCC' align='center'><Td width='50'>ที่</Td><Td width='100'>เลขประจำตัว<br>นักเรียน</Td><Td width='100'>เลขประจำตัว<br>ประชาชน</Td><Td>ชื่อ</Td><Td width='100'>ชั้น</Td>";
		for($x=1;$x<=$item_num;$x++){
		echo "<td>ข้อ$x</td>";
		}
		echo "<Td width='90'>คะแนน<br>[เต็ม$full_score] </Td>";
		
		echo "</Tr>";
		$sql = "select * from student_main_main where classlevel='$result[class_room]' and school_code='$_GET[school_code]' and ed_year='$ed_year' order by student_id";
		$dbquery = mysqli_query($connect,$sql);
		$N=1;
		While ($result=mysqli_fetch_array($dbquery)){
					if(($N%2) == 0)
					$color="#FFFFC";
					else  	$color="#FFFFFF";
		$class_text="";
		if($result['classlevel']==4){
		$class_text="ป.1";
		}	
		else if($result['classlevel']==5){
		$class_text="ป.2";
		}		
		else if($result['classlevel']==6){
		$class_text="ป.3";
		}		
		else if($result['classlevel']==7){
		$class_text="ป.4";
		}		
		else if($result['classlevel']==8){
		$class_text="ป.5";
		}		
		else if($result['classlevel']==9){
		$class_text="ป.6";
		}		
		else if($result['classlevel']==10){
		$class_text="ม.1";
		}		
		else if($result['classlevel']==11){
		$class_text="ม.2";
		}		
		else if($result['classlevel']==12){
		$class_text="ม.3";
		}		
		else if($result['classlevel']==13){
		$class_text="ม.4";
		}		
		else if($result['classlevel']==14){
		$class_text="ม.5";
		}		
		else if($result['classlevel']==15){
		$class_text="ม.6";
		}		
	
		echo "<Tr bgcolor='$color' align='center'><Td>$N</Td><Td>$result[student_id]</Td><Td>$result[person_id]</Td><Td align='left'>$result[prename]$result[name] $result[surname]</Td><Td>$class_text</Td>";

$total_score="0";
		for($x=1;$x<=$item_num;$x++){
		echo "<td>";
		
		$sql_item = "select  id from bets_book_item  where  test_id='$_GET[test_id]' and item_number='$x' ";
		$dbquery_item = mysqli_query($connect,$sql_item);
		$result_item= mysqli_fetch_array($dbquery_item);
		$item_id=$result_item['id'];
		
		$sql_answer= "select  *  from bets_paper_answer where  test_id='$_GET[test_id]' and person_id='$result[person_id]' and item_id='$item_id' ";
		$dbquery_answer = mysqli_query($connect,$sql_answer);
		$result_answer= mysqli_fetch_array($dbquery_answer);
		$score=$result_answer['score'];
		echo $score;
		$total_score=$total_score+$score;
		echo "</td>";
		}
		echo "<td>$total_score</td>";
		echo "</Tr>";
		$N++;
		}
		echo "</table>";

?>
</BODY>
</HTML>

${this.title}

Code Editor : export_to_excel.php