Gecko [ 122.154.134.11 ]

Name	Size	Permission
area_check1.php	8.55 KB	-rw-r--r--
area_pop.php	12.51 KB	-rw-r--r--
area_pop_insert.php	22.78 KB	-rw-r--r--
khet_area.php	6.77 KB	-rw-r--r--
livesearch.php	665 B	-rw-r--r--
moo_list.php	14.93 KB	-rw-r--r--
out_school_report_1.php	21.51 KB	-rw-r--r--
out_school_report_2.php	21.52 KB	-rw-r--r--
out_school_report_3.php	21.51 KB	-rw-r--r--
report1.php	5.44 KB	-rw-r--r--
report2.php	9.34 KB	-rw-r--r--
report3.php	11.05 KB	-rw-r--r--
report4.php	11.57 KB	-rw-r--r--
report5.php	12.43 KB	-rw-r--r--
return_ajax_amphoe.php	603 B	-rw-r--r--
return_ajax_tambon.php	616 B	-rw-r--r--
return_ajax_village.php	662 B	-rw-r--r--
sch_operation.php	4.52 KB	-rw-r--r--
school_area.php	19.99 KB	-rw-r--r--
search.php	19.35 KB	-rw-r--r--
search2.php	19.36 KB	-rw-r--r--
search2_khet.php	18.75 KB	-rw-r--r--
search3.php	19.28 KB	-rw-r--r--
search3_khet.php	18.69 KB	-rw-r--r--
search_insert.php	17.01 KB	-rw-r--r--
search_khet.php	19.05 KB	-rw-r--r--

Code Editor : area_check1.php

<?php
/** ensure this file is being included by a parent file */
defined( '_VALID_' ) or die( 'Direct Access to this location is not allowed.' );

//ส่วนหัว
echo "<br />";
echo "<table width='50%' border='0' align='center'>";
echo "<tr align='center'><td><font color='#006666' size='3'><strong>ตรวจสอบแต่ละหมู่บ้านมีสถานศึกษารับผิดชอบหรือไม่</strong></font></td></tr>";
echo "</table>";

//ส่วนแสดงผล
//ส่วนของการแยกหน้า
$sql ="select * from opportunity_khet_area";
$dbquery = mysqli_query($connect,$sql);
$num_rows=mysqli_num_rows($dbquery); //นำไปแยกหน้า

$pagelen=1 ; // 1.กำหนดแถวต่อหน้า
$url_link="option=opportunity&task=main/area_check1";  // 2_กำหนดลิงค์
$totalpages=ceil($num_rows/$pagelen);

if(!isset($_REQUEST['page'])){
$_REQUEST['page']="";
}
if($_REQUEST['page']==""){
$page=$totalpages;
		if($page<2){
		$page=1;
		}
}
else{
		if($totalpages<$_REQUEST['page']){
		$page=$totalpages;
					if($page<1){
					$page=1;
					}
		}
		else{
		$page=$_REQUEST['page'];
		}
}

$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 "<a href=$PHP_SELF?$url_link&page=$i>[$i]</a>";
					}
			}
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){
			$f_page1=$page-1;
			echo "<<a href=$PHP_SELF?$url_link&page=1>หน้าแรก </a>";
			echo "<<<a href=$PHP_SELF?$url_link&page=$f_page1>หน้าก่อน </a>";
			}
			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 "<a href=$PHP_SELF?$url_link&page=$i>[$i]</a>";
					}
			}
			if($page<$totalpages)	{
			$f_page2=$page+1;
			echo "<a href=$PHP_SELF?$url_link&page=$f_page2> หน้าถัดไป</a>>>";
			echo "<a href=$PHP_SELF?$url_link&page=$totalpages> หน้าสุดท้าย</a>>";
			}
			echo " <select onchange=\"location.href=this.options[this.selectedIndex].value;\" size=\"1\" name=\"select\">";
			echo "<option  value=\"\">หน้า</option>";
				for($p=1;$p<=$totalpages;$p++){
				echo "<option  value=\"?$url_link&page=$p\">$p</option>";
				}
			echo "</select>";
echo "</div>";  
}					
//จบแยกหน้า

$N=(($page-1)*$pagelen)+1;  //*เกี่ยวข้องกับการแยกหน้า
echo  "<table width='90%' border='0' align='center'>";
echo "<Tr bgcolor='#FFCCCC' align='center'><Td>อำเภอ จังหวัด</Td><Td>ตำบล</Td><Td>หมู่บ้าน</Td><Td width='150'>ก่อนประถมศึกษา</Td><td width='150'>ประถมศึกษา</Td><td width='150'>มัธยมศึกษาตอนต้น</Td><td width='150'>มัธยมศึกษาตอนปลาย</Td></Tr>";

$sql = "select *,opportunity_khet_area.id from opportunity_khet_area,opportunity_amphoe,opportunity_province where opportunity_khet_area.amphoe=opportunity_amphoe.amp_code and opportunity_amphoe.prov_code=opportunity_province.prov_code order by opportunity_khet_area.province,opportunity_khet_area.amphoe limit $start,$pagelen";
		
$dbquery = mysqli_query($connect,$sql);
While ($result = mysqli_fetch_array($dbquery)){
		$id = $result['id'];
		$amp_name= $result['amp_name'];
		$prov_name= $result['prov_name'];
		echo "<Tr bgcolor='#66FFCC' align='center' valign='top'><Td align='left'>$N $amp_name $prov_name</Td><Td align='left'></Td><Td align='left'></Td><td></td><td></td><td></td><td></td></Tr>";
				
				$sql2 = "select * from opportunity_tambon where amp_code='$result[amp_code]' order by tambon_code";
				$dbquery2 = mysqli_query($connect,$sql2);
				$tambon_num=1;
				While ($result2 = mysqli_fetch_array($dbquery2)){
				$tambon_name= $result2['tambon_name'];
				echo "<Tr bgcolor='#FFFF00' align='center' valign='top'><Td align='left'></Td><Td align='left'>$tambon_num $tambon_name</Td><Td align='left'></Td><td></td><td></td><td></td><td></td></Tr>";
				$tambon_num++;
				
							$sql3 = "select * from opportunity_village where opportunity_village.tambon_code='$result2[tambon_code]' order by vill_code";
							$dbquery3 = mysqli_query($connect,$sql3);
							$M=1;
							While ($result3 = mysqli_fetch_array($dbquery3)){
							$vill_code= $result3['vill_code'];
							$vill_no=substr($vill_code, -2, 2);
							$village= $result3['vill_name'];
							
							//หาโรงเรียนที่รับผิดชอบหมู่ที่ เขตบริหารก่อนประถมศึกษา
							$sql4 = "select * from opportunity_sch_area left join system_school on opportunity_sch_area.school_code=system_school.school_code where opportunity_sch_area.village='$result3[vill_code]' and opportunity_sch_area.area_type='1'";
							$sch_text1="";
							$sch_num=1;
							$dbquery4 = mysqli_query($connect,$sql4);
							While($result4 = mysqli_fetch_array($dbquery4)){
							$sch_text1=$sch_text1.$sch_num.$result4['school_name']." ";
							$sch_num++;
							}
							
							//หาโรงเรียนที่รับผิดชอบหมู่ที่ เขตบริหารประถมศึกษา
							$sql5 = "select * from opportunity_sch_area left join system_school on opportunity_sch_area.school_code=system_school.school_code where opportunity_sch_area.village='$result3[vill_code]' and opportunity_sch_area.area_type='2'";
							$sch_text2="";
							$sch_num=1;
							$dbquery5 = mysqli_query($connect,$sql5);
							While($result5 = mysqli_fetch_array($dbquery5)){
							$sch_text2=$sch_text2.$sch_num.$result5['school_name']." ";
							$sch_num++;
							}
							
							//หาโรงเรียนที่รับผิดชอบหมู่ที่ เขตบริหารปมัธยมศึกษาตอนต้น
							$sql6 = "select * from opportunity_sch_area left join system_school on opportunity_sch_area.school_code=system_school.school_code where opportunity_sch_area.village='$result3[vill_code]' and opportunity_sch_area.area_type='3'";
							$sch_text3="";
							$sch_num=1;
							$dbquery6 = mysqli_query($connect,$sql6);
							While($result6 = mysqli_fetch_array($dbquery6)){
							$sch_text3=$sch_text3.$sch_num.$result6['school_name']." ";
							$sch_num++;
							}
							
							//หาโรงเรียนที่รับผิดชอบหมู่ที่ เขตบริหารปมัธยมศึกษาตอนต้น
							$sql7 = "select * from opportunity_sch_area left join system_school on opportunity_sch_area.school_code=system_school.school_code where opportunity_sch_area.village='$result3[vill_code]' and opportunity_sch_area.area_type='4'";
							$sch_text4="";
							$sch_num=1;
							$dbquery7 = mysqli_query($connect,$sql7);
							While($result7 = mysqli_fetch_array($dbquery7)){
							$sch_text4=$sch_text4.$sch_num.$result7['school_name']." ";
							$sch_num++;
							}
							
							if(($M%2) == 0)
							$color="#FFFFC";
							else $color="#FFFFFF";
							echo "<Tr bgcolor='$color' align='center' valign='top'><Td></Td><Td></Td><Td align='left'>$vill_no $village</Td><td align='left'>$sch_text1</td><td align='left'>$sch_text2</td><td align='left'>$sch_text3</td><td align='left'>$sch_text4</td></Tr>";
							$M++;
							}
				}
$N++;  //*เกี่ยวข้องกับการแยกหน้า
} 
?>

</script>

${this.title}

Code Editor : area_check1.php