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 ]	drwxrwxrwx
upload	[ DIR ]	drwxrwxrwx
default.php	248 B	-rwxr-xr-x
ed_year.php	10.65 KB	-rwxr-xr-x
export_test.php	930 B	-rw-r--r--
export_to_excel.php	3.08 KB	-rwxr-xr-x
export_to_excel2.php	3.03 KB	-rwxr-xr-x
getxml_student.php	14.36 KB	-rw-r--r--
getxml_student.phpOLD	11.7 KB	-rwxr-xr-x
getxml_student2.php	9.39 KB	-rw-r--r--
index.php	258 B	-rwxr-xr-x
livesearch.php	625 B	-rwxr-xr-x
livesearch_2.php	640 B	-rwxr-xr-x
livesearch_3.php	629 B	-rwxr-xr-x
livesearch_mobile.php	630 B	-rwxr-xr-x
menu.php	5.64 KB	-rwxr-xr-x
menu_mobile.php	932 B	-rwxr-xr-x
permission.php	8.45 KB	-rwxr-xr-x
permission_sch.php	8.83 KB	-rwxr-xr-x
permission_sch_khet.php	13.49 KB	-rwxr-xr-x
return_permission_sch_khet.php	779 B	-rwxr-xr-x
student_getxml.php	2.51 KB	-rwxr-xr-x
student_getxml2.php	3.1 KB	-rwxr-xr-x
student_import.php	6.72 KB	-rwxr-xr-x
student_import2.php	8.26 KB	-rw-r--r--
student_import3.php	4.35 KB	-rw-r--r--
student_import_2.php	6.67 KB	-rw-r--r--
student_importx.php	6.36 KB	-rwxr-xr-x
student_khet_update.php	34.99 KB	-rwxr-xr-x
student_num.php	10.17 KB	-rw-r--r--
student_report1.php	14.48 KB	-rwxr-xr-x
student_report1_mobile.php	12.93 KB	-rwxr-xr-x
student_report2.php	9.46 KB	-rwxr-xr-x
student_report3.php	7.82 KB	-rwxr-xr-x
student_report4.php	10.73 KB	-rw-r--r--
student_report5.php	9.17 KB	-rw-r--r--
student_sch_update.php	25.93 KB	-rwxr-xr-x
student_tranfer.php	4.2 KB	-rw-r--r--

Code Editor : export_to_excel2.php

<?php
header("Content-Type: application/vnd.ms-excel");
header('Content-Disposition: attachment; filename="student.xls"');# ชื่อไฟล์ 
?>
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<HTML>
<HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</HEAD>

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

//อาเรย์สถานศึกษา
$sql = "select * from  system_school where school_type='1'";
$dbquery = mysqli_query($connect,$sql);
While ($school_result = mysqli_fetch_array($dbquery)){
$school_code=$school_result['school_code'];
$school_ar[$school_code]=$school_result['school_name'];
}

//อาเรย์ชั้น
$school_class_ar['0']="ไม่ระบุชั้น";
$school_class_ar['1']="อ.1(3ปี)";
$school_class_ar['2']="อ.1";
$school_class_ar['3']="อ.2";
$school_class_ar['4']="ป.1";
$school_class_ar['5']="ป.2";
$school_class_ar['6']="ป.3";
$school_class_ar['7']="ป.4";
$school_class_ar['8']="ป.5";
$school_class_ar['9']="ป.6";
$school_class_ar['10']="ม.1";
$school_class_ar['11']="ม.2";
$school_class_ar['12']="ม.3";
$school_class_ar['13']="ม.4";
$school_class_ar['14']="ม.5";
$school_class_ar['15']="ม.6";

$sql = "select * from student_main_main where ed_year='$_REQUEST[year_index]' and  school_code='$_REQUEST[school_index]' order by school_code,classlevel,classroom,student_id ";
$dbquery = mysqli_query($connect,$sql);

echo  "<table width='85%' border='0' align='center'>";
echo "<Tr bgcolor=#FFCCCC align='center'><Td width='150'>เลขประจำตัวนักเรียน</Td><Td width='150'>เลขประจำตัวประชาชน</Td><Td width='90'>เลขที่</Td><Td align='center'>คำนำ</Td><Td align='center'>ชื่อ</Td><Td align='center'>นามสกุล</Td><Td width='100'>เพศ</Td><Td width='90'>รหัสชั้น</Td><Td width='50'>ห้อง</Td></Tr>";
$M=1;
While ($result = mysqli_fetch_array($dbquery))
	{
		$id = $result['id'];
		$school_id = $result['school_code'];	
		$person_id = $result['person_id'];	
		$student_id = $result['student_id'];	
		$prename=$result['prename'];	
		$name= $result['name'];
		$surname = $result['surname'];
		$sex = $result['sex'];
		$school_class = $result['classlevel'];	
		$room=$result['classroom'];
		
		if($sex=='ช'){
		$sex=1;
		}
		if($sex=='ญ'){
		$sex=2;
		}
		
		if($room==1){
		$room=0;
		}
		
			if(($M%2) == 0)
			$color="#FFFFC";
			else  	$color="#FFFFFF";

echo "<Tr  bgcolor=$color align='center'><Td>$student_id</Td><Td align='left'>$person_id</Td><Td align='left'></Td>";
echo "<Td align='left'>$prename</Td><Td align='left'>$name</Td><Td align='left'>$surname</Td>";
echo "<Td align='center'>$sex</Td>";
echo "<Td align='center'>$school_class</Td>";
echo "<Td align='center'>$room</Td>";
echo "</Tr>";
$M++;
	}
echo "</Table>";
?>
</BODY>
</HTML>

${this.title}

Code Editor : export_to_excel2.php