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_student_list.php

<?php
session_start();
if(!(isset($_SESSION['login_user_id']))){
exit();
}
error_reporting(0);
require_once("../../../amssplus_connect.php");
require_once("../../../mainfile.php");

$q=$_GET["q"];

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

$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";

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

echo "<br>";
echo "<div align='center'><b><font color='#31B404'>ปีการศึกษา $year_active_result[ed_year]</font></b></div>";

// แยกหน้า
$sql = "select * from student_main_main  where ed_year='$year_active_result[ed_year]' and school_code='$q' and status='0' ";
$dbquery = mysqli_query($connect,$sql);
$num_rows=mysqli_num_rows($dbquery);
$pagelen=25;
$totalpages=ceil($num_rows/$pagelen);

$pre_id="103";  //กำหนดแต่ละเรื่อง
$frist_id=$pre_id.$totalpages."1";
$last_id=$pre_id.$totalpages."2";

if($_GET['val3']>0){
$page=$_GET['val3'];
}
else{
$page=$totalpages;
}

$start=($page-1)*$pagelen;

if(($totalpages>1) and ($totalpages<16)){
echo "<div align='center'>";
echo "หน้า	";
			for($i=1; $i<=$totalpages; $i++)	{
		
					if($i==$page){
					echo "[<b><font size=+1 color=#990000>$i</font></b>]";
					}
					else {
					echo "<span id='$pre_id$i' onclick=ajax_show($q,'student_list',$i,'val4') onmouseover=Over2Function($pre_id$i) onmouseout=Out2Function($pre_id$i)>[$i] </span>";
					}
		}
echo "</div>";
}

if($totalpages>15){
			if($page <=8){
			$e_page=15;
			$s_page=1;
			}
			if($page>8){
					if($totalpages-$page>=7){
					$e_page=$page+7;
					$s_page=$page-7;
					}
					else{
					$e_page=$totalpages;
					$s_page=$totalpages-15;
					}
			}
			echo "<div align=center>";
			if($page!=1){
			echo "<span id='$frist_id' onclick=ajax_show($q,'student_list','1','val4') onmouseover=Over2Function($frist_id) onmouseout=Out2Function($frist_id)><<หน้าแรก </span>";
			}
			else {
			echo "หน้า	";
			}					
			for($i=$s_page; $i<=$e_page; $i++){
					if($i==$page){
					echo "[<b><font size=+1 color=#990000>$i</font></b>]";
					}
					else {
					echo "<span id='$pre_id$i' onclick=ajax_show($q,'student_list',$i,'val4') onmouseover=Over2Function($pre_id$i) onmouseout=Out2Function($pre_id$i)>[$i] </span>";
					}
			}
			if($page<$totalpages)	{
			echo "<span id='$last_id' onclick=ajax_show($q,'student_list',$totalpages,'val4') onmouseover=Over2Function($last_id) onmouseout=Out2Function($last_id)> หน้าสุดท้าย>></span>";
			}
echo "</div>";  
}					
// จบแยกหน้า

echo "<table border='1' style='border-collapse: collapse' width='$width_1' align='center'>";
echo "<tr align='center' bgcolor='#FFCCCC'><td width='70'>ที่</td><td width='150'>เลขประจำตัวประชาชน</td><td>คำนำหน้าชื่อ</td><td>ชื่อ</td><td>นามสกุล</td><td>ชั้น</td></tr>";
$sql = "select * from student_main_main  where ed_year='$year_active_result[ed_year]' and school_code='$q' and status='0' order by classlevel,classroom limit $start,$pagelen";

$dbquery = mysqli_query($connect,$sql);

$M=1;
$N=(($page-1)*$pagelen)+1;  //*เกี่ยวข้องกับการแยกหน้า

while($result = mysqli_fetch_array($dbquery)){
$person_id=$result['person_id'];
$prename=$result['prename'];
$name=$result['name'];
$surname=$result['surname'];
$classlevel=$result['classlevel'];

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

echo "<tr bgcolor='$color' align='center'>";
			echo "<td align='center'>$N</td>";
			echo "<td align='center'>$person_id</td>";
			echo "<td align='left'>$prename</td>";
			echo "<td align='left'>$name</td>";
			echo "<td align='left'>$surname</td>";
			echo "<td align='left'>$school_class_ar2[$classlevel]</td>";
		echo "</tr>";
$M++;		
$N++;  //*เกี่ยวข้องกับการแยกหน้า
}
echo "</table>";
echo "<br>";
?>

${this.title}

Code Editor : livesearch_student_list.php