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_student2.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="70%";
 }

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

//ชั้น
$school_class_ar[0]="0";
$school_class_ar[1]="01";
$school_class_ar[2]="02";
$school_class_ar[3]="03";
$school_class_ar[4]="04";
$school_class_ar[5]="05";
$school_class_ar[6]="06";
$school_class_ar[7]="07";
$school_class_ar[8]="08";
$school_class_ar[9]="09";
$school_class_ar[10]="10";
$school_class_ar[11]="11";
$school_class_ar[12]="12";
$school_class_ar[13]="13";
$school_class_ar[14]="14";
$school_class_ar[15]="15";

$school_class_ar2[0]="ไม่ระบุ";
$school_class_ar2[1]="อนุบาล1";
$school_class_ar2[2]="อนุบาล 2";
$school_class_ar2[3]="อนุบาล 3";
$school_class_ar2[4]="ประถมศึกษาปีที่ 1";
$school_class_ar2[5]="ประถมศึกษาปีที่ 2";
$school_class_ar2[6]="ประถมศึกษาปีที่ 3";
$school_class_ar2[7]="ประถมศึกษาปีที่ 4";
$school_class_ar2[8]="ประถมศึกษาปีที่ 5";
$school_class_ar2[9]="ประถมศึกษาปีที่ 6";
$school_class_ar2[10]="มัธยมศึกษาปีที่ 1";
$school_class_ar2[11]="มัธยมศึกษาปีที่ 2";
$school_class_ar2[12]="มัธยมศึกษาปีที่ 3";
$school_class_ar2[13]="มัธยมศึกษาปีที่ 4";
$school_class_ar2[14]="มัธยมศึกษาปีที่ 5";
$school_class_ar2[15]="มัธยมศึกษาปีที่ 6";

echo "<br>";
echo "<table border='1' style='border-collapse: collapse' width='$width_1' align='center'>";
echo  "<Tr bgcolor='#FFCCCC' align='center' ><Td width='25%'>ชั้น</Td><Td width='25%'>ชาย</Td><Td width='25%'>หญิง</Td><Td width='25%'>รวม</Td></Tr>";
$M=1;
$total_m_gender=0;  
$total_f_gender=0;  
$total_student=0; 
for ($i=0; $i<=15 ; $i++)	{

$sql = "select count(student_main_main.id) as student from student_main_main left join system_school on student_main_main.school_code=system_school.school_code where system_school.school_type='1' and student_main_main.classlevel=$school_class_ar[$i] and student_main_main.ed_year='$year_active_result[ed_year]' ";

$sql_gender= "select  count(student_main_main.sex) as gender from student_main_main left join system_school on student_main_main.school_code=system_school.school_code where system_school.school_type='1' and student_main_main.ed_year='$year_active_result[ed_year]' and  student_main_main.classlevel=$school_class_ar[$i] and student_main_main.sex='ช' ";

$dbquery = mysqli_query($connect,$sql);
$result = mysqli_fetch_array($dbquery);
$dbquery_gender= mysqli_query($connect,$sql_gender);
$result_gender = mysqli_fetch_array($dbquery_gender);

$student = $result['student'];
		$m_gender=$result_gender['gender'];
		$f_gender=$student-$m_gender;
		$total_m_gender +=$m_gender;
		$total_f_gender +=$f_gender;
		$total_student +=$student;
		
			if(($M%2) == 0)
		$color="#F2F2F2";
		else  $color="";
$m_gender=number_format($m_gender,0);
$f_gender=number_format($f_gender,0);
	if($student>0){
	echo "<Tr bgcolor='$color' align='center'><Td align='left'>&nbsp;&nbsp;&nbsp;&nbsp;$school_class_ar2[$i]</Td><Td>$m_gender</Td><Td>$f_gender</Td>";
	$student=number_format($student,0);
	echo "<Td>$student</Td>";
	echo "</Tr>";
	$M++;
	}
} //loop for
		$total_m_gender =number_format($total_m_gender,0);
		$total_f_gender =number_format($total_f_gender,0);
		$total_student =number_format($total_student,0);

echo "<Tr bgcolor=#FFCCCC align='center' ><Td>รวมทั้งหมด</Td><Td>$total_m_gender</Td><Td align='center'> $total_f_gender</Td><Td>$total_student</Td></Tr>";
echo "</table>";
echo "<br>";

${this.title}

Code Editor : livesearch_student2.php