<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <? class Paginator{ var $items_per_page; var $items_total; var $current_page; var $num_pages; var $mid_range; var $low; var $high; var $limit; var $return; var $default_ipp; var $querystring; var $url_next; function Paginator() { $this->current_page = 1; $this->mid_range = 7; $this->items_per_page = $this->default_ipp; $this->url_next = $this->url_next; } function paginate() { if(!is_numeric($this->items_per_page) OR $this->items_per_page <= 0) $this->items_per_page = $this->default_ipp; $this->num_pages = ceil($this->items_total/$this->items_per_page); if($this->current_page < 1 Or !is_numeric($this->current_page)) $this->current_page = 1; if($this->current_page > $this->num_pages) $this->current_page = $this->num_pages; $prev_page = $this->current_page-1; $next_page = $this->current_page+1; if($this->num_pages > 10) { $this->return = ($this->current_page != 1 And $this->items_total >= 5) ? "<a class=\"paginate\" href=\"".$this->url_next.$this-> $prev_page."\">« กลับหน้าเเรก</a> ":"<span class=\"inactive\" href=\"#\">« กลับหน้าเเรก</span> "; $this->start_range = $this->current_page - floor($this->mid_range/2); $this->end_range = $this->current_page + floor($this->mid_range/2); if($this->start_range <= 0) { $this->end_range += abs($this->start_range)+1; $this->start_range = 1; } if($this->end_range > $this->num_pages) { $this->start_range -= $this->end_range-$this->num_pages; $this->end_range = $this->num_pages; } $this->range = range($this->start_range,$this->end_range); for($i=1;$i<=$this->num_pages;$i++) { if($this->range[0] > 2 And $i == $this->range[0]) $this->return .= " ... "; if($i==1 Or $i==$this->num_pages Or in_array($i,$this->range)) { $this->return .= ($i == $this->current_page And $_GET['Page'] != 'All') ? "<a title=\"Go to page $i of $this->num_pages\" class=\"current\" href=\"#\">$i</a> ":"<a class=\"paginate\" title=\"Go to page $i of $this->num_pages\" href=\"".$this-> url_next.$i."\">$i</a> "; } if($this->range[$this->mid_range-1] < $this->num_pages-1 And $i == $this->range[$this->mid_range-1]) $this->return .= " ... "; } $this->return .= (($this->current_page != $this->num_pages And $this->items_total >= 10) And ($_GET['Page'] != 'All')) ? "<a class=\"paginate\" href=\"".$this->url_next.$next_page."\">หน้าต่อไป »</a>\n":"<span class=\"inactive\" href=\"#\">» Next</span>\n"; } else { for($i=1;$i<=$this->num_pages;$i++) { $this->return .= ($i == $this->current_page) ? "<a class=\"current\" href=\"#\">$i</a> ":"<a class=\"paginate\" href=\"".$this-> url_next.$i."\">$i</a> "; } } $this->low = ($this->current_page-1) * $this->items_per_page; $this->high = ($_GET['ipp'] == 'All') ? $this->items_total:($this->current_page * $this->items_per_page)-1; $this->limit = ($_GET['ipp'] == 'All') ? "":" LIMIT $this->low,$this->items_per_page"; } function display_pages() { return $this->return; } } ?> <? include('connect.php'); $strSQL = "SELECT * FROM c_money "; <----------------------------------------------เรียงภาษาไทย ส่วนนี้นะครับ จาก ก มาก่อน $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]"); $Num_Rows = mysql_num_rows($objQuery); $Per_Page = 10; // Per Page $Page = $_GET["Page"]; if(!$_GET["Page"]) { $Page=1; } $Prev_Page = $Page-1; $Next_Page = $Page+1; $Page_Start = (($Per_Page*$Page)-$Per_Page); if($Num_Rows<=$Per_Page) { $Num_Pages =1; } else if(($Num_Rows % $Per_Page)==0) { $Num_Pages =($Num_Rows/$Per_Page) ; } else { $Num_Pages =($Num_Rows/$Per_Page)+1; $Num_Pages = (int)$Num_Pages; } $strSQL .=" order by id ASC LIMIT $Page_Start , $Per_Page"; $objQuery = mysql_query($strSQL); ?> </div> <div id="tb_3"> <table width="791" border="1" cellspacing="0" height="128"> <tr bgcolor="#FFCC99"> <td width="49" height="39" bgcolor="#999999" rowspan="2"><div align="center" class="style77 style30"><strong>ลำดับ</strong></div></td> <td width="267" height="39" bgcolor="#999999" rowspan="2"><div align="center" class="style77 style30"><strong>ชื่อโครงการ</strong></div></td> <td height="39" bgcolor="#999999" colspan="4"><div align="center" class="style30 style77"><strong>งบประมาณที่ได้รับจัดสรร</strong></div></td> <td width="50" height="39" bgcolor="#999999" rowspan="2"><div align="center" class="style77 style30"><strong>ลบ</strong></div></td> <td width="55" height="39" bgcolor="#999999" rowspan="2"><div align="center" class="style77 style30"><strong>เเก้ไข</strong></div></td> </tr> <tr> <td width="83" height="39" bgcolor="#CCCCCC"><div align="center" class="style30 style77">อุดหนุน</div></td> <td width="88" height="39" bgcolor="#CCCCCC"><div align="center" class="style30 style77">ระดมทรัพย์</div></td> <td width="82" height="39" bgcolor="#CCCCCC"><div align="center" class="style30 style77">เรียนฟรี</div></td> <td width="83" height="39" bgcolor="#CCCCCC"><div align="center" class="style30 style77">อื่นๆ</div></td> </tr> <? while($objResult = mysql_fetch_array($objQuery)) { ?> <tr bgcolor="#CCFFFF"> <div id=""> <td height="47" bgcolor="#E0E5CE"><div align="center" class="style70" width="20" height=" 20"> <?=$objResult["id"];?> </div></td> <td bgcolor="#E0E5CE" width="267"><div height=" 20" > <div align="center"><a href="b_resources_m.php?activities=<?=$objResult["activities"]?>" class="style10" > <?=$objResult["activities"]?> </a></div> </div></td> <td height="47" bgcolor="#E0E5CE"><div align="center" class="style10" width="20" height=" 20"> <?=$objResult["b_headcount"];?> </div></td> <td height="47" bgcolor="#E0E5CE"><div align="center" class="style10" width="20" height=" 20"> <?=$objResult["b_resources_m"];?> </div></td> <td height="47" bgcolor="#E0E5CE"><div align="center" class="style10" width="20" height=" 20"> <?=$objResult["b_study_free"];?> </div></td> <td height="47" bgcolor="#E0E5CE"><div align="center" class="style10" width="20" height=" 20"> <?=$objResult["b_other"];?> </div></td> <td bgcolor="#E0E5CE" width="50"><div height=" 20" > <div align="center"><a href="delete_c_budget.php?id=<?=$objResult["id"]?>" class="style10"submit="DEL&id_delete=1"" onclick="return confirm('กรุณายืนยันการลบอีกครั้ง !!!')"><img src="images/delect.png" width="39" height="38" /></a></div> </div></td> <td bgcolor="#E0E5CE" width="55"><div height=" 20" > <div align="center"><a href="edit_budget.php?id=<?=$objResult["id"]?>" class="style10" ><img src="images/edit.png" width="41" height="39" /></a></div> </div></td> </div> </tr> <? } ?> </table> <br/> <span class="style33">มีโครงการทั้งหมด <?= $Num_Rows;?> คน หน้า <? $pages = new Paginator; $pages->items_total = $Num_Rows; $pages->mid_range = 5; $pages->current_page = $Page; $pages->default_ipp = $Per_Page; $pages->url_next = $_SERVER["PHP_SELF"]."?class=$class&room=$room&QueryString=value&Page="; $pages->paginate(); echo $pages->display_pages() ?> <? mysql_close($objConnect); ?>
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง
