Gecko [ 122.154.134.11 ]

Name	Size	Permission
images	[ DIR ]	drwxr-xr-x
install	[ DIR ]	drwxr-xr-x
manual	[ DIR ]	drwxr-xr-x
picture	[ DIR ]	drwxr-xr-x
default.php	485 B	-rwxr-xr-x
index.php	745 B	-rwxr-xr-x
menu.php	3.91 KB	-rwxr-xr-x
menu_mobile.php	963 B	-rwxr-xr-x
permission.php	8.74 KB	-rwxr-xr-x
permission_sch.php	9.93 KB	-rwxr-xr-x
permission_sch_khet.php	14.62 KB	-rwxr-xr-x
pic_show.php	1.73 KB	-rwxr-xr-x
pic_show2.php	655 B	-rwxr-xr-x
return_permission_sch_khet.php	1.2 KB	-rwxr-xr-x
student_khet_career.php	91.08 KB	-rwxr-xr-x
student_sch_career.php	106.32 KB	-rwxr-xr-x
student_sch_career_report1.php	40.91 KB	-rwxr-xr-x
student_sch_career_report1_mob...	19.73 KB	-rwxr-xr-x
student_sch_career_report2.php	43.59 KB	-rwxr-xr-x
student_sch_career_report3.php	9.83 KB	-rwxr-xr-x
student_sch_career_report3_mob...	4.01 KB	-rwxr-xr-x
time_inc.php	4.99 KB	-rwxr-xr-x

Code Editor : student_sch_career_report3_mobile.php

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

//ปีงบประมาณ
$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);
if($year_active_result['ed_year']==""){
echo "<br />";
echo "<div align='center'>ยังไม่ได้กำหนดทำงานในปีการศึกษาใด ๆ  กรุณาไปที่เมนูตั้งค่าระบบ เพื่อกำหนดปีการศึกษา</div>";
exit();
}
echo "<br>";
echo "<table width='90%' border='0' align='center'>";
echo "<tr align='center'><td><font color='#006666'><strong>สรุปจำนวนนักเรียนระบบการศึกษาต่อและเลือกอาชีพ</strong></font></td></tr><tr align='center'><td><font color='#006666'> ปีการศึกษา  $year_active_result[ed_year]</font></td></tr>";
echo "</table>";

$sql = "select  * from system_school order by school_type,school_code";
$dbquery = mysqli_query($connect,$sql);
echo  "<table width=95% border='0' align='center'>";
echo "<Tr bgcolor=#FFCCCC align='center' ><Td width='50'>ที่</Td><Td align='center'>
โรงเรียน</Td><td>รวม</td></Tr>";
$M=1;
			$total_0="";
			$total_1="";
			$total_2="";
			$total_3="";
			$total_4="";
			$total_5="";
			$total_6="";
			$total_7="";
			$total_8="";
			$total_9="";
			$sum_total="";

While ($result = mysqli_fetch_array($dbquery))
	{
			if(($M%2) == 0)
			$color="#FFFFC";
			else  	$color="#FFFFF";
			$id=$result['id'];
			$sql2 = "select  career_type, COUNT(career_student_main.id) as num  from  career_student_main left join student_main_main on career_student_main.person_id=student_main_main.person_id where student_main_main.ed_year='$year_active_result[ed_year]' and career_student_main.school_code='$result[school_code]' and student_main_main.school_code='$result[school_code]' group by career_type ";
			$dbquery2 = mysqli_query($connect,$sql2);
			$career_0="";
			$career_1="";
			$career_2="";
			$career_3="";
			$career_4="";
			$career_5="";
			$career_6="";
			$career_7="";
			$career_8="";
			$career_9="";
			$total=0;
			While ($result2 = mysqli_fetch_array($dbquery2)){
					if($result2['career_type']==0){
					$career_0=$result2['num'];
					}
					if($result2['career_type']==1){
					$career_1=$result2['num'];
					}
					if($result2['career_type']==2){
					$career_2=$result2['num'];
					}
					if($result2['career_type']==3){
					$career_3=$result2['num'];
					}
					if($result2['career_type']==4){
					$career_4=$result2['num'];
					}
					if($result2['career_type']==5){
					$career_5=$result2['num'];
					}
					if($result2['career_type']==6){
					$career_6=$result2['num'];
					}
					if($result2['career_type']==7){
					$career_7=$result2['num'];
					}
					if($result2['career_type']==8){
					$career_8=$result2['num'];
					}
					if($result2['career_type']==9){
					$career_9=$result2['num'];
					}
			}
			$total=$career_0+$career_1+$career_2+$career_3+$career_4+$career_5+$career_6+$career_7+$career_8+$career_9;
			$total_0=$total_0+$career_0;
			$total_1=$total_1+$career_1;
			$total_2=$total_2+$career_2;
			$total_3=$total_3+$career_3;
			$total_4=$total_4+$career_4;
			$total_5=$total_5+$career_5;
			$total_6=$total_6+$career_6;
			$total_7=$total_7+$career_7;
			$total_8=$total_8+$career_8;
			$total_9=$total_9+$career_9;
			$sum_total=$sum_total+$total;
			
	if($total>0){			
	echo "<Tr bgcolor=$color align='center'><Td>$M</Td>";
	echo "<Td align='left'>$result[school_code] $result[school_name]</Td>";
	echo "<td>$total</td>";
	echo "</Tr>";
	$M++;
	}
}
echo "<Tr bgcolor='#99FFFF' align='center'><td colspan='2'>รวม</td><td>$sum_total</td></tr>";
echo "</Table>";
?>

${this.title}

Code Editor : student_sch_career_report3_mobile.php