Gecko [ 122.154.134.11 ]

Name	Size	Permission
achievement.php	6.34 KB	-rw-r--r--
building.php	2.28 KB	-rw-r--r--
nt.php	1.7 KB	-rw-r--r--
opportunity.php	7.56 KB	-rw-r--r--
opportunity2.php	7.56 KB	-rw-r--r--
opportunity3.php	7.57 KB	-rw-r--r--
person.php	1.48 KB	-rwxr-xr-x
plc.php	530 B	-rw-r--r--
read.php	2.47 KB	-rw-r--r--
school_basic.php	1.79 KB	-rw-r--r--
school_computer.php	1.44 KB	-rw-r--r--
standard.php	7.45 KB	-rw-r--r--
standard2.php	2.89 KB	-rw-r--r--
standard2021.php	2.31 KB	-rw-r--r--
standard2041.php	10.38 KB	-rw-r--r--
standard3.php	11.49 KB	-rw-r--r--
standard4.php	2.86 KB	-rw-r--r--
student.php	2.12 KB	-rw-r--r--
student2.php	885 B	-rw-r--r--
student_expand1.php	1.23 KB	-rw-r--r--
student_expand2.php	6.25 KB	-rw-r--r--
warning.php	81 B	-rwxr-xr-x
xml.php	1.36 KB	-rwxr-xr-x

Code Editor : student.php

<?php
defined( '_VALID_' ) or die( 'Direct Access to this location is not allowed.' );

$sql_edyear = "select * from student_main_edyear where year_active='1'";
$dbquery_edyear = mysqli_query($connect,$sql_edyear);
$result_edyear=mysqli_fetch_array($dbquery_edyear);

/////////// แยกหน้า
$pagelen=25;  // 1_กำหนดแถวต่อหน้า
$sql = "select id from student_main_main where ed_year='$result_edyear[ed_year]' and school_code='$_GET[school_code]' and status='0'";

$dbquery = mysqli_query($connect,$sql);
$num_rows=mysqli_num_rows($dbquery);
$totalpages=ceil($num_rows/$pagelen);

if($_GET['page']<1){
$page=$totalpages;
}
else{
$page=$_GET['page'];
}
if($page<2){
$page=1;
}
$start=($page-1)*$pagelen;
///////////  end แยกหน้า

$sql = "select * from student_main_main where ed_year='$result_edyear[ed_year]' and school_code='$_GET[school_code]' and status='0' order by classlevel,classroom limit $start,$pagelen";
$objQuery = mysqli_query($connect,$sql);
?>

${this.title}

Code Editor : student.php