<? $strSQL = "SELECT * FROM M_movies where class = 'non' "; $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]"); $Num_Rows = mysql_num_rows($objQuery); $Per_Page = 48; // 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_movie DESC LIMIT $Page_Start , $Per_Page"; $objQuery = mysql_query($strSQL); echo "<table width='80%' border='0'><tr>"; $i=0; while($objResult = mysql_fetch_array($objQuery)){ echo "<td>"; $i++; ?> <a href="ViewMovie.php?id_movie=<?=$objResult["id_movie"];?>" target=_blank> <img src="<?=$objResult["m_pic"];?>" width="200" height="300"> <br/> <?=$objResult["name"];?> </a> <br/> คนเข้าชม : <?=$objResult["view"];?><br/>คุณภาพ : <?=$objResult["quality"];?> <br/><br/> </td> <? if(($i%4)==0){ // แสดงผลแต่ละบรรทัด echo "<tr>"; }else{ echo "<td>"; } } echo "</table>"; ?> <? if($Prev_Page) { echo " <a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page'> ย้อนกลับ</a> "; } for($i=1; $i<=$Num_Pages; $i++){ if($i != $Page) { echo "[ <a href='$_SERVER[SCRIPT_NAME]?Page=$i'> $i </a> ]"; } else { echo "<b> $i </b>"; } } if($Page!=$Num_Pages) { echo " <a href ='$_SERVER[SCRIPT_NAME]?Page=$Next_Page'> หน้าต่อไป </a> "; } ?>
<?php 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 >= 10) ? "<a class=\"paginate\" href=\"".$this->url_next.$this->$prev_page."\">« Previous</a> ":"<span class=\"inactive\" href=\"#\">« Previous</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."\">Next »</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; } } ?> <html> <head> <title>test</title> </head> <body> <?php $objConnect = mysql_connect("localhost","..............","........") or die("Error Connect to Database"); $objDB = mysql_select_db("moviescity_dlast"); mysql_query("SET NAMES UTF8"); $strSQL = "SELECT * FROM M_movies where class = 'non' "; $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_movie DESC LIMIT $Page_Start , $Per_Page"; $objQuery = mysql_query($strSQL); echo "<table width='80%' border='0'><tr>"; $i=0; while($objResult = mysql_fetch_array($objQuery)){ echo "<td>"; $i++; ?> <a href="ViewMovie.php?id_movie=<?=$objResult["id_movie"];?>" target=_blank> <img src="<?=$objResult["m_pic"];?>" width="200" height="300"> <br/> <?=$objResult["name"];?> </a> <br/> คนเข้าชม : <?=$objResult["view"];?><br/>คุณภาพ : <?=$objResult["quality"];?> <br/><br/> </td> <?php if(($i%4)==0){ // แสดงผลแต่ละบรรทัด echo "<tr>"; }else{ echo "<td>"; } } echo "</table>"; ?> <?php } ?> <br> Total <?php echo $Num_Rows;?> Record <?php $pages = new Paginator; $pages->items_total = $Num_Rows; $pages->mid_range = 10; $pages->current_page = $Page; $pages->default_ipp = $Per_Page; $pages->url_next = $_SERVER["PHP_SELF"]."?QueryString=value&Page="; $pages->paginate(); echo $pages->display_pages() ?> <?php mysql_close($objConnect); ?> </body> </html>
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง