Gecko [ 122.154.134.11 ]

Name	Size	Permission
building_show.php	4.58 KB	-rw-r--r--
livesearch1.php	787 B	-rw-r--r--
livesearch_202.php	5.82 KB	-rw-r--r--
livesearch_2021.php	4.86 KB	-rw-r--r--
livesearch_204.php	11.9 KB	-rw-r--r--
livesearch_2041.php	9.97 KB	-rw-r--r--
livesearch_2044.php	11.8 KB	-rw-r--r--
livesearch_20441.php	9.83 KB	-rw-r--r--
livesearch_206.php	11.79 KB	-rw-r--r--
livesearch_2061.php	9.79 KB	-rw-r--r--
livesearch_301.php	3.16 KB	-rw-r--r--
livesearch_302.php	3.36 KB	-rw-r--r--
livesearch_ach.php	7.15 KB	-rw-r--r--
livesearch_ach_2.php	7.85 KB	-rw-r--r--
livesearch_allperson.php	1.59 KB	-rw-r--r--
livesearch_amphoe_school.php	1.53 KB	-rw-r--r--
livesearch_budget.php	10.99 KB	-rw-r--r--
livesearch_building.php	3.14 KB	-rw-r--r--
livesearch_chart2.php	625 B	-rw-r--r--
livesearch_chart3.php	872 B	-rw-r--r--
livesearch_chart3_2.php	987 B	-rw-r--r--
livesearch_chart3_3.php	1.37 KB	-rw-r--r--
livesearch_chart3_4.php	847 B	-rw-r--r--
livesearch_chart3_5.php	883 B	-rw-r--r--
livesearch_chart3_6.php	879 B	-rw-r--r--
livesearch_chart3_7.php	922 B	-rw-r--r--
livesearch_chart4.php	607 B	-rw-r--r--
livesearch_chart4_2.php	1.05 KB	-rw-r--r--
livesearch_computer.php	4.46 KB	-rw-r--r--
livesearch_g_ach_2.php	8.67 KB	-rw-r--r--
livesearch_health1.php	9.7 KB	-rw-r--r--
livesearch_health2.php	8.81 KB	-rw-r--r--
livesearch_khetopportunity.php	3.74 KB	-rw-r--r--
livesearch_khetopportunity2.ph...	3.8 KB	-rw-r--r--
livesearch_khetopportunity3.ph...	3.74 KB	-rw-r--r--
livesearch_khetperson.php	1.44 KB	-rw-r--r--
livesearch_nt.php	2.68 KB	-rw-r--r--
livesearch_nt2.php	3.05 KB	-rw-r--r--
livesearch_nt3.php	5.26 KB	-rw-r--r--
livesearch_opportunity.php	8 KB	-rw-r--r--
livesearch_opportunity2.php	8 KB	-rw-r--r--
livesearch_opportunity3.php	8.01 KB	-rw-r--r--
livesearch_plan.php	4.3 KB	-rw-r--r--
livesearch_plc.php	5.71 KB	-rw-r--r--
livesearch_plc2.php	3.15 KB	-rw-r--r--
livesearch_read.php	7.91 KB	-rw-r--r--
livesearch_sch_person.php	1.51 KB	-rw-r--r--
livesearch_school.php	2.19 KB	-rw-r--r--
livesearch_school_group.php	2.64 KB	-rw-r--r--
livesearch_school_group2.php	2.3 KB	-rw-r--r--
livesearch_small_school.php	1.95 KB	-rw-r--r--
livesearch_smss_std.php	5.28 KB	-rw-r--r--
livesearch_std.php	11.24 KB	-rw-r--r--
livesearch_std2.php	11.05 KB	-rw-r--r--
livesearch_std3.php	7.02 KB	-rw-r--r--
livesearch_std4.php	6.91 KB	-rw-r--r--
livesearch_std_check.php	3.31 KB	-rw-r--r--
livesearch_std_check2.php	3.28 KB	-rw-r--r--
livesearch_student.php	3.96 KB	-rw-r--r--
livesearch_student2.php	4.17 KB	-rw-r--r--
livesearch_student3.php	10.44 KB	-rw-r--r--
livesearch_student_list.php	5.22 KB	-rw-r--r--
livesearch_supervision.php	13.24 KB	-rw-r--r--
permission.php	11.13 KB	-rw-r--r--
school_report_1.php	52.88 KB	-rw-r--r--
school_report_2.php	36.59 KB	-rw-r--r--

Code Editor : livesearch_student3.php

<?php
session_start();
if(!(isset($_SESSION['login_user_id']))){
exit();
}

require_once("../../../amssplus_connect.php");
require_once("../../../mainfile.php");

if($_SESSION['user_os'] =="mobile"){
 $width_1="97%";
 }
 else{
  $width_1="85%";
 }

//ปีการศึกษา
$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);

$sql = "select *,system_school.id,system_school.school_code from system_school where school_type='1' order by school_code";
$dbquery = mysqli_query($connect,$sql);

echo "<br>";
echo "<div align='center'><font color='#31B404'><b> ปีการศึกษา $year_active_result[ed_year]</b></font></div>";
echo "<table border='1' style='border-collapse: collapse' width='$width_1' align='center'>";
echo "<Tr bgcolor='#E6E6E6' align='center'><Td width='50'>ที่</Td><Td width='100'>รหัส<br>สถานศึกษา</Td><Td>ชื่อสถานศึกษา</Td>";
echo "<td>ไม่ระบุชั้น</td><td>อ.1</td><td>อ.2</td><td>อ.3</td><td>ป.1</td><td>ป.2</td><td>ป.3</td><td>ป.4</td><td>ป.5</td><td>ป.6</td><td>ม.1</td><td>ม.2</td><td>ม.3</td><td>ม.4</td><td>ม.5</td><td>ม.6</td><td>รวม</td>";
echo "</Tr>";
$N=1; 
$M=1;
$t_0=0; $t_1=0; $t_2=0; $t_3=0; $t_4=0; $t_5=0; $t_6=0; $t_7=0; $t_8=0; $t_9=0; $t_10=0; $t_11=0; $t_12=0; $t_13=0; $t_14=0; $t_15=0;
While ($result = mysqli_fetch_array($dbquery))
	{
		$id = $result['id'];
		$school_code= $result['school_code'];
		$school_name= $result['school_name'];
		
$sql2 = "select count(id) as student_0 from student_main_main where ed_year='$year_active_result[ed_year]' and school_code='$school_code'  and classlevel='0' ";		
$dbquery2 = mysqli_query($connect,$sql2);
$result2 = mysqli_fetch_array($dbquery2);
$student_0=$result2['student_0'];
$student_0=number_format($student_0,0);

$sql2 = "select count(id) as student_1 from student_main_main where ed_year='$year_active_result[ed_year]' and school_code='$school_code'  and classlevel='1' ";		
$dbquery2 = mysqli_query($connect,$sql2);
$result2 = mysqli_fetch_array($dbquery2);
$student_1=$result2['student_1'];
$student_1=number_format($student_1,0);

$sql2 = "select count(id) as student_2 from student_main_main where ed_year='$year_active_result[ed_year]' and school_code='$school_code'  and classlevel='2' ";		
$dbquery2 = mysqli_query($connect,$sql2);
$result2 = mysqli_fetch_array($dbquery2);
$student_2=$result2['student_2'];
$student_2=number_format($student_2,0);

$sql2 = "select count(id) as student_3 from student_main_main where ed_year='$year_active_result[ed_year]' and school_code='$school_code'  and classlevel='3' ";		
$dbquery2 = mysqli_query($connect,$sql2);
$result2 = mysqli_fetch_array($dbquery2);
$student_3=$result2['student_3'];
$student_3=number_format($student_3,0);

$sql2 = "select count(id) as student_4 from student_main_main where ed_year='$year_active_result[ed_year]' and school_code='$school_code'  and classlevel='4' ";		
$dbquery2 = mysqli_query($connect,$sql2);
$result2 = mysqli_fetch_array($dbquery2);
$student_4=$result2['student_4'];
$student_4=number_format($student_4,0);

$sql2 = "select count(id) as student_5 from student_main_main where ed_year='$year_active_result[ed_year]' and school_code='$school_code'  and classlevel='5' ";		
$dbquery2 = mysqli_query($connect,$sql2);
$result2 = mysqli_fetch_array($dbquery2);
$student_5=$result2['student_5'];
$student_5=number_format($student_5,0);

$sql2 = "select count(id) as student_6 from student_main_main where ed_year='$year_active_result[ed_year]' and school_code='$school_code'  and classlevel='6' ";		
$dbquery2 = mysqli_query($connect,$sql2);
$result2 = mysqli_fetch_array($dbquery2);
$student_6=$result2['student_6'];
$student_6=number_format($student_6,0);

$sql2 = "select count(id) as student_7 from student_main_main where ed_year='$year_active_result[ed_year]' and school_code='$school_code'  and classlevel='7' ";		
$dbquery2 = mysqli_query($connect,$sql2);
$result2 = mysqli_fetch_array($dbquery2);
$student_7=$result2['student_7'];
$student_7=number_format($student_7,0);

$sql2 = "select count(id) as student_8 from student_main_main where ed_year='$year_active_result[ed_year]' and school_code='$school_code'  and classlevel='8' ";		
$dbquery2 = mysqli_query($connect,$sql2);
$result2 = mysqli_fetch_array($dbquery2);
$student_8=$result2['student_8'];
$student_8=number_format($student_8,0);

$sql2 = "select count(id) as student_9 from student_main_main where ed_year='$year_active_result[ed_year]' and school_code='$school_code'  and classlevel='9' ";		
$dbquery2 = mysqli_query($connect,$sql2);
$result2 = mysqli_fetch_array($dbquery2);
$student_9=$result2['student_9'];
$student_9=number_format($student_9,0);

//มัธยม
$sql2 = "select count(id) as student_10 from student_main_main where ed_year='$year_active_result[ed_year]' and school_code='$school_code'  and classlevel='10' ";		
$dbquery2 = mysqli_query($connect,$sql2);
$result2 = mysqli_fetch_array($dbquery2);
$student_10=$result2['student_10'];
$student_10=number_format($student_10,0);

$sql2 = "select count(id) as student_11 from student_main_main where ed_year='$year_active_result[ed_year]' and school_code='$school_code'  and classlevel='11' ";		
$dbquery2 = mysqli_query($connect,$sql2);
$result2 = mysqli_fetch_array($dbquery2);
$student_11=$result2['student_11'];
$student_11=number_format($student_11,0);

$sql2 = "select count(id) as student_12 from student_main_main where ed_year='$year_active_result[ed_year]' and school_code='$school_code'  and classlevel='12' ";		
$dbquery2 = mysqli_query($connect,$sql2);
$result2 = mysqli_fetch_array($dbquery2);
$student_12=$result2['student_12'];
$student_12=number_format($student_12,0);

$sql2 = "select count(id) as student_13 from student_main_main where ed_year='$year_active_result[ed_year]' and school_code='$school_code'  and classlevel='13' ";		
$dbquery2 = mysqli_query($connect,$sql2);
$result2 = mysqli_fetch_array($dbquery2);
$student_13=$result2['student_13'];
$student_13=number_format($student_13,0);

$sql2 = "select count(id) as student_14 from student_main_main where ed_year='$year_active_result[ed_year]' and school_code='$school_code'  and classlevel='14' ";		
$dbquery2 = mysqli_query($connect,$sql2);
$result2 = mysqli_fetch_array($dbquery2);
$student_14=$result2['student_14'];
$student_14=number_format($student_14,0);

$sql2 = "select count(id) as student_15 from student_main_main where ed_year='$year_active_result[ed_year]' and school_code='$school_code'  and classlevel='15' ";		
$dbquery2 = mysqli_query($connect,$sql2);
$result2 = mysqli_fetch_array($dbquery2);
$student_15=$result2['student_15'];
$student_15=number_format($student_15,0);

$total=$student_0+$student_1+$student_2+$student_3+$student_4+$student_5+$student_6+$student_7+$student_8+$student_9+$student_10+$student_11+$student_12+$student_13+$student_14+$student_15;
$total=number_format($total,0);

$t_0=$t_0+$student_0; 
$t_1=$t_1+$student_1; 
$t_2=$t_2+$student_2; 
$t_3=$t_3+$student_3; 
$t_4=$t_4+$student_4; 
$t_5=$t_5+$student_5; 
$t_6=$t_6+$student_6; 
$t_7=$t_7+$student_7; 
$t_8=$t_8+$student_8; 
$t_9=$t_9+$student_9; 
$t_10=$t_10+$student_10; 
$t_11=$t_11+$student_11; 
$t_12=$t_12+$student_12; 
$t_13=$t_13+$student_13; 
$t_14=$t_14+$student_14; 
$t_15=$t_15+$student_15;

if(($M%2) == 0)
			$color="#FFFFC";
			else  	$color="#FFFFFF";

echo "<Tr  bgcolor=$color align='center'><Td>$N</Td> <td>$school_code</Td><Td align='left'>$school_name</Td>";
		if($student_0==0){
		$student_0="";
		}
		if($student_1==0){
		$student_1="";
		}
		if($student_2==0){
		$student_2="";
		}
		if($student_3==0){
		$student_3="";
		}
		if($student_4==0){
		$student_4="";
		}
		if($student_5==0){
		$student_5="";
		}
		if($student_6==0){
		$student_6="";
		}
		if($student_7==0){
		$student_7="";
		}
		if($student_8==0){
		$student_8="";
		}
		if($student_9==0){
		$student_9="";
		}
		if($student_10==0){
		$student_10="";
		}
		if($student_11==0){
		$student_11="";
		}
		if($student_12==0){
		$student_12="";
		}
		if($student_13==0){
		$student_13="";
		}
		if($student_14==0){
		$student_14="";
		}
		if($student_15==0){
		$student_15="";
		}
		
		echo "<td>$student_0</td><td bgcolor='#FAFAFA'>$student_1</td><td bgcolor='#FAFAFA'>$student_2</td><td bgcolor='#FAFAFA'>$student_3</td><td bgcolor='#E6E6E6'>$student_4</td><td bgcolor='#E6E6E6'>$student_5</td><td bgcolor='#E6E6E6'>$student_6</td><td bgcolor='#E6E6E6'>$student_7</td><td bgcolor='#E6E6E6'>$student_8</td><td bgcolor='#E6E6E6'>$student_9</td><td bgcolor='#FAFAFA'>$student_10</td><td bgcolor='#FAFAFA'>$student_11</td><td bgcolor='#FAFAFA'>$student_12</td><td bgcolor='#E6E6E6'>$student_13</td><td bgcolor='#E6E6E6'>$student_14</td><td bgcolor='#E6E6E6'>$student_15</td>";
		echo "<Td align='center'>$total</Td></Tr>";
$M++;
$N++;  //*เกี่ยวข้องกับการแยกหน้า
	}
	
$tt=$t_0+$t_1+$t_2+$t_3+$t_4+$t_5+$t_6+$t_7+$t_8+$t_9+$t_10+$t_11+$t_12+$t_13+$t_14+$t_15;	
$tt=number_format($tt,0);

$t_0=number_format($t_0,0);
$t_1=number_format($t_1,0);
$t_2=number_format($t_2,0);
$t_3=number_format($t_3,0);
$t_4=number_format($t_4,0);
$t_5=number_format($t_5,0);
$t_6=number_format($t_6,0);
$t_7=number_format($t_7,0);
$t_8=number_format($t_8,0);
$t_9=number_format($t_9,0);
$t_10=number_format($t_10,0);
$t_11=number_format($t_11,0);
$t_12=number_format($t_12,0);
$t_13=number_format($t_13,0);
$t_14=number_format($t_14,0);
$t_15=number_format($t_15,0);

if($t_0==0){
$t_0="";
}
if($t_1==0){
$t_1="";
}
if($t_2==0){
$t_2="";
}
if($t_3==0){
$t_3="";
}
if($t_4==0){
$t_4="";
}
if($t_5==0){
$t_5="";
}
if($t_6==0){
$t_6="";
}
if($t_7==0){
$t_7="";
}
if($t_8==0){
$t_8="";
}
if($t_9==0){
$t_9="";
}
if($t_10==0){
$t_10="";
}
if($t_11==0){
$t_11="";
}
if($t_12==0){
$t_12="";
}
if($t_13==0){
$t_13="";
}
if($t_14==0){
$t_14="";
}
if($t_15==0){
$t_15="";
}

echo "<tr align='center' bgcolor='#F5A9A9'><td colspan='3'></td><td>$t_0</td><td>$t_1</td><td>$t_2</td><td>$t_3</td><td>$t_4</td><td>$t_5</td><td>$t_6</td><td>$t_7</td><td>$t_8</td><td>$t_9</td><td>$t_10</td><td>$t_11</td><td>$t_12</td><td>$t_13</td><td>$t_14</td><td>$t_15</td><Td align='center'>$tt</Td></Tr>";

echo "</Table>";
echo "<br>";
?>

${this.title}

Code Editor : livesearch_student3.php