Gecko [ 122.154.134.11 ]

Name	Size	Permission
achievement.php	6.34 KB	-rw-r--r--
building.php	2.28 KB	-rw-r--r--
nt.php	1.7 KB	-rw-r--r--
opportunity.php	7.56 KB	-rw-r--r--
opportunity2.php	7.56 KB	-rw-r--r--
opportunity3.php	7.57 KB	-rw-r--r--
person.php	1.48 KB	-rwxr-xr-x
plc.php	530 B	-rw-r--r--
read.php	2.47 KB	-rw-r--r--
school_basic.php	1.79 KB	-rw-r--r--
school_computer.php	1.44 KB	-rw-r--r--
standard.php	7.45 KB	-rw-r--r--
standard2.php	2.89 KB	-rw-r--r--
standard2021.php	2.31 KB	-rw-r--r--
standard2041.php	10.38 KB	-rw-r--r--
standard3.php	11.49 KB	-rw-r--r--
standard4.php	2.86 KB	-rw-r--r--
student.php	2.12 KB	-rw-r--r--
student2.php	885 B	-rw-r--r--
student_expand1.php	1.23 KB	-rw-r--r--
student_expand2.php	6.25 KB	-rw-r--r--
warning.php	81 B	-rwxr-xr-x
xml.php	1.36 KB	-rwxr-xr-x

Code Editor : achievement.php

<?php
defined( '_VALID_' ) or die( 'Direct Access to this location is not allowed.' );

?>
<info>
	<warning><?php echo base64_encode($warning_text);?></warning>
	<ach>
<?php

//ส่วนของปีการศึกษา  ป.6
 	$strQuery = "select distinct ed_year from achievement_main where  test_type='1' and test_class='6' and school='$_GET[school_code]' order by ed_year ";
	$result = mysqli_query($connect,$strQuery);
	$year_num=1;
	$year_now=0;
	while($ors = mysqli_fetch_array($result)) {
	$ed_year_ar[$year_num]=$ors['ed_year'];
	$year_now=$ors['ed_year'];
	$year_num++;
	}
$year_num_p6=$year_num-1;  //จำนวนปีที่แสดง
$year_now_p6=$year_now;

for($x=1;$x<=$year_num_p6;$x++){
  		$strQuery = "select thai, math, science, social, english, health, art, vocation, score_avg from achievement_main where test_type='1' and test_class='6' and ed_year='$ed_year_ar[$x]' and school='$_GET[school_code]' ";
		$result = mysqli_query($connect,$strQuery);
		$ors = mysqli_fetch_array($result);  
		
		$thai=number_format($ors['thai'],2);
		$math=number_format($ors['math'],2);
		$science=number_format($ors['science'],2);
		$social=number_format($ors['social'],2);
		$english=number_format($ors['english'],2);
		$health=number_format($ors['health'],2);
		$art=number_format($ors['art'],2);
		$vocation=number_format($ors['vocation'],2);
		$score_avg=number_format($ors['score_avg'],2);							
  		$ed_year=$ed_year_ar[$x];
		?>
		<item>
				<thai><?php echo base64_encode($thai);?></thai>
				<math><?php echo base64_encode($math);?></math>
				<science><?php echo base64_encode($science);?></science>
				<social><?php echo base64_encode($social);?></social>
				<english><?php echo base64_encode($english);?></english>
				<health><?php echo base64_encode($health);?></health>
				<art><?php echo base64_encode($art);?></art>
				<vocation><?php echo base64_encode($vocation);?></vocation>
				<score_avg><?php echo base64_encode($score_avg);?></score_avg>
				<ed_year><?php echo base64_encode($ed_year);?></ed_year>
		</item>
		<?php	
}

//ส่วนของปีการศึกษา  ม.3
 	$strQuery = "select distinct ed_year from achievement_main where  test_type='1' and test_class='9' and school='$_GET[school_code]' order by ed_year ";
	$result = mysqli_query($connect,$strQuery);
	$year_num=1;
	$year_now=0;
	while($ors = mysqli_fetch_array($result)) {
	$ed_year_ar[$year_num]=$ors['ed_year'];
	$year_now=$ors['ed_year'];
	$year_num++;
	}
$year_num_p9=$year_num-1;  //จำนวนปีที่แสดง
$year_now_p9=$year_now;

for($x=1;$x<=$year_num_p9;$x++){
  		$strQuery = "select thai, math, science, social, english, health, art, vocation, score_avg from achievement_main where test_type='1' and test_class='9' and ed_year='$ed_year_ar[$x]' and school='$_GET[school_code]' ";
		$result = mysqli_query($connect,$strQuery);
		$ors = mysqli_fetch_array($result);  
		
		$thai=number_format($ors['thai'],2);
		$math=number_format($ors['math'],2);
		$science=number_format($ors['science'],2);
		$social=number_format($ors['social'],2);
		$english=number_format($ors['english'],2);
		$health=number_format($ors['health'],2);
		$art=number_format($ors['art'],2);
		$vocation=number_format($ors['vocation'],2);
		$score_avg=number_format($ors['score_avg'],2);							
  		$ed_year=$ed_year_ar[$x];
		?>
		<item2>
				<thai><?php echo base64_encode($thai);?></thai>
				<math><?php echo base64_encode($math);?></math>
				<science><?php echo base64_encode($science);?></science>
				<social><?php echo base64_encode($social);?></social>
				<english><?php echo base64_encode($english);?></english>
				<health><?php echo base64_encode($health);?></health>
				<art><?php echo base64_encode($art);?></art>
				<vocation><?php echo base64_encode($vocation);?></vocation>
				<score_avg><?php echo base64_encode($score_avg);?></score_avg>
				<ed_year><?php echo base64_encode($ed_year);?></ed_year>
		</item2>
		<?php	
}

//ส่วนของปีการศึกษา  ม.6
 	$strQuery = "select distinct ed_year from achievement_main where  test_type='1' and test_class='12' and school='$_GET[school_code]' order by ed_year ";
	$result = mysqli_query($connect,$strQuery);
	$year_num=1;
	$year_now=0;
	while($ors = mysqli_fetch_array($result)) {
	$ed_year_ar[$year_num]=$ors['ed_year'];
	$year_now=$ors['ed_year'];
	$year_num++;
	}
$year_num_p12=$year_num-1;  //จำนวนปีที่แสดง
$year_now_p12=$year_now;

for($x=1;$x<=$year_num_p12;$x++){
  		$strQuery = "select thai, math, science, social, english, health, art, vocation, score_avg from achievement_main where test_type='1' and test_class='12' and ed_year='$ed_year_ar[$x]' and school='$_GET[school_code]' ";
		$result = mysqli_query($connect,$strQuery);
		$ors = mysqli_fetch_array($result);  
		
		$thai=number_format($ors['thai'],2);
		$math=number_format($ors['math'],2);
		$science=number_format($ors['science'],2);
		$social=number_format($ors['social'],2);
		$english=number_format($ors['english'],2);
		$health=number_format($ors['health'],2);
		$art=number_format($ors['art'],2);
		$vocation=number_format($ors['vocation'],2);
		$score_avg=number_format($ors['score_avg'],2);							
  		$ed_year=$ed_year_ar[$x];
		?>
		<item3>
				<thai><?php echo base64_encode($thai);?></thai>
				<math><?php echo base64_encode($math);?></math>
				<science><?php echo base64_encode($science);?></science>
				<social><?php echo base64_encode($social);?></social>
				<english><?php echo base64_encode($english);?></english>
				<health><?php echo base64_encode($health);?></health>
				<art><?php echo base64_encode($art);?></art>
				<vocation><?php echo base64_encode($vocation);?></vocation>
				<score_avg><?php echo base64_encode($score_avg);?></score_avg>
				<ed_year><?php echo base64_encode($ed_year);?></ed_year>
		</item3>
		<?php	
}

?>
	</ach>
<year_num_p6><?php echo base64_encode($year_num_p6);?></year_num_p6>
<year_now_p6><?php echo base64_encode($year_now_p6);?></year_now_p6>
<year_num_p9><?php echo base64_encode($year_num_p9);?></year_num_p9>
<year_now_p9><?php echo base64_encode($year_now_p9);?></year_now_p9>	
<year_num_p12><?php echo base64_encode($year_num_p12);?></year_num_p12>
<year_now_p12><?php echo base64_encode($year_now_p12);?></year_now_p12>	
</info>

${this.title}

Code Editor : achievement.php