ทำการค้นหาข้อมูลที่ต้องการเมือแสดงข้อมูลที่ค้นหาถ้ามีมากกว่า20รายการให้แสดงข้อมูลทีเหลือในหน้าถัดไป

<?

include("../system/include/class_main.inc"); 
include("../system/include/functionWeb.php");

	require('thaipdfclass.php');
	include("cdate.php");

	class PDF extends ThaiPDF
	{
	var $B;
	var $I;
	var $U;
	var $HREF;

	function PDF($orientation='P',$unit='mm',$format='A4')
	{
		//Call parent constructor
		$this->ThaiPDF($orientation,$unit,$format);
		//Initialization
		$this->B=0;
		$this->I=0;
		$this->U=0;
		$this->HREF='';
	}

	function WriteHTML($html)
	{
		//HTML parser
		$html=str_replace("\n",' ',$html);
		$a=preg_split('/<(.*)>/U',$html,-1,PREG_SPLIT_DELIM_CAPTURE);
		foreach($a as $i=>$e)
		{
			if($i%2==0)
			{
				//Text
				if($this->HREF)
					$this->PutLink($this->HREF,$e);
				else
					$this->Write(5,$e);
			}
			else
			{
				//Tag
				if($e{0}=='/')
					$this->CloseTag(strtoupper(substr($e,1)));
				else
				{
					//Extract attributes
					$a2=explode(' ',$e);
					$tag=strtoupper(array_shift($a2));
					$attr=array();
					foreach($a2 as $v)
					{
						if(preg_match('/([^=]*)=["\']?([^"\']*)/',$v,$a3))
							$attr[strtoupper($a3[1])]=$a3[2];
					}
					$this->OpenTag($tag,$attr);
				}
			}
		}
	}

	function OpenTag($tag,$attr)
	{
		//Opening tag
		if($tag=='B' or $tag=='I' or $tag=='U')
			$this->SetStyle($tag,true);
		if($tag=='A')
			$this->HREF=$attr['HREF'];
		if($tag=='BR')
			$this->Ln(5);
	}

	function CloseTag($tag)
	{
		//Closing tag
		if($tag=='B' or $tag=='I' or $tag=='U')
			$this->SetStyle($tag,false);
		if($tag=='A')
			$this->HREF='';
	}

	function SetStyle($tag,$enable)
	{
		//Modify style and select corresponding font
		$this->$tag+=($enable ? 1 : -1);
		$style='';
		foreach(array('B','I','U') as $s)
			if($this->$s>0)
				$style.=$s;
		$this->SetFont('',$style);
	}

	function PutLink($URL,$txt)
	{
		//Put a hyperlink
		$this->SetTextColor(0,0,255);
		$this->SetStyle('U',true);
		$this->Write(5,$txt,$URL);
		$this->SetStyle('U',false);
		$this->SetTextColor(0);
	}
	}


	 $pdf=new PDF("L", "mm", "A3");
		$pdf->SetThaiFont();
		$str = "การประเมินของคณะกรรมการพิจารณาทุนการศึกษา ปีการศึกษา".$_GET[year_id];
		$pdf->SetHeader($str, 1, 'C', 1);
		//$pdf->SetFooter('การประเมินของคณะกรรมการพิจารณาทุนการศึกษา' , 1, 'C', 1);
		$pdf->AddPage();
		$pdf->SetFont('CordiaNew','',8); 
		$pdf->SetTextColor(0,0,255);
		$pdf->SetLeftMargin(10);
		$pdf->SetFontSize(8);


$db = new admin_control();
$db1 = new admin_control();
$db2 = new admin_control();

	$strsql ="select * from tb_app,tb_score where tb_app.app_stuid = tb_score.app_stuid  and tb_score.year_id = '$_GET[year_id]' "; 

if($_GET[sby] == "1")
	 {
$strsql = $strsql." order by  tb_app.a_gpa_last desc ";
	 }
	 else if($_GET[sby] == "2")
	 {
$strsql = $strsql." order by  tb_app.app_stuid desc ";
	 }
	 	 else if($_GET[sby] == "3")
	 {
$strsql = $strsql." order by  tb_app.in_sum asc ";
	 }
	 	 else if($_GET[sby] == "4")
	 {
$strsql = $strsql." order by  tb_score.ssum desc ";
	 }


$db->send_cmd($strsql);

$dbx = new admin_control();

	$dby = new admin_control();
											$strsql = "select   * from  tb_score_setup   ";
		$dby -> send_cmd($strsql);
		$rsy = $dby->fetch_data();
		$dby->close();	


$txt1 = 'คะแนน ('.$rsy[sco1].')';
		$txt2 = 'คะแนน ('.$rsy[sco2].')';
		$txt3 = 'คะแนน ('.$rsy[sco3].')';
		$txt4= 'คะแนน ('.$rsy[sco4].')';
		$txt5 = 'คะแนน ('.$rsy[sco5].')';
		$txt6 = 'คะแนน ('.$rsy[sco6].')';

$pdf->Cell(10,7,'ลำดับ','LT',0,'C'); 
				$pdf->Cell(30,7,'ชื่อ-สกุล','RLT',0,'C'); 
			$pdf->Cell(40,7,'สาขา','RLT',0,'C'); 
			$pdf->Cell(10,7,'เกรดเฉลี่ย','RLT',0,'C'); 
$pdf->Cell(20,7,$txt1,'RLT',0,'C'); 
$pdf->Cell(20,7,'รายได้ต่อครอบครัว','RLT',0,'C'); 
$pdf->Cell(20,7,$txt2,'RLT',0,'C'); 
$pdf->Cell(40,7,'สถานะภาพครอบครัว','RLT',0,'C'); 
$pdf->Cell(20,7,$txt3,'RLT',0,'C'); 
$pdf->Cell(40,7,'การแต่งกายและความประพฤติ','RLT',0,'C'); 
$pdf->Cell(20,7,$txt4,'RLT',0,'C'); 
$pdf->Cell(20,7,'กู้เงิน กยศ.','RLT',0,'C'); 
$pdf->Cell(20,7,$txt5,'RLT',0,'C'); 
$pdf->Cell(20,7,'การมีส่วนร่วม.','RLT',0,'C'); 
$pdf->Cell(20,7,$txt6,'RLT',0,'C'); 
$pdf->Cell(50,7,'หมายเหตุ (รวม 100).','RLT',0,'C'); 

$pdf->Ln(7);
	$rowmenu=1;
 while($rs = $db->fetch_data()){




			$pdf->Cell(10,7,$rowmenu,'LTB',0,'C'); 
			$pdf->Cell(30,7,$rs['a_name']." ".$rs['a_surname'],'LTB',0,'L'); 
			$pdf->Cell(40,7,$rs['app_room'],'LTB',0,'L'); 
			$pdf->Cell(10,7,$rs['a_gpa_last'],'LTB',0,'C'); 
			$sql1 = "select * from tb_grade where '$rs[a_gpa_last]' between g_start and g_end";
			$db1->send_cmd($sql1);
			$rs1 = $db1->fetch_data();
			

			$pdf->Cell(20,7,$rs1[g_point],'LTB',0,'C'); 
			$pdf->Cell(20,7,$rs['in_sum'],'LTB',0,'C'); 
			$sql1 = "select * from tb_income where '$rs[in_sum]' between in_smore and in_emore ";
		//	$sql1 = "select * from tb_income where '$rs[in_sum]' > in_smore order by in_smore asc ";
			$db2->send_cmd($sql1);
			$rs2 = $db2->fetch_data();

	 $sum = $rs[familypoint] + $rs[suitpoint] + $rs[loanpoint] + $rs[activitypoint] + $rs2[in_point] + $rs1[g_point];

			$pdf->Cell(20,7,$rs2[in_point],'RLTB',0,'C'); 

			$pdf->Cell(40,7,$rs['family'],'LTB',0,'C'); 
			$pdf->Cell(20,7,$rs['familypoint'],'RLTB',0,'C'); 

			
$pdf->Cell(40,7,$rs['suit'],'RLTB',0,'C'); 
			$pdf->Cell(20,7,$rs['suitpoint'],'RLTB',0,'C'); 

$pdf->Cell(20,7,$rs['loan'],'RLTB',0,'C'); 
$pdf->Cell(20,7,$rs['loanpoint'],'RLTB',0,'C'); 
$pdf->Cell(20,7,$rs['activity'],'RLTB',0,'C'); 
$pdf->Cell(20,7,$rs['activitypoint'],'RLTB',0,'C'); 

$pdf->Cell(50,7, $sum,'RLTB',0,'C'); 




			$pdf->Ln(7);
			$rowmenu++;
}

			
		$pdf->Output("test.pdf");

?> 
<body onload="window.open('test.pdf','_self');return true;">  
 </BODY>