nhojeinnor Posted May 5, 2010 Share Posted May 5, 2010 i have a problem with my search pagination. when i click the pages. nothing happen.it just refresh the page. help pls. public function viewSearch($form) { $affid = $form['affid']; $site_id = $form['site_id']; if($affid==""){ $where1 =""; } else { $where1 = "affid = '$affid'" ; } if($site_id==""){ $where2 =""; } elseif($affid=="" || site_id==""){ $where2= "site_id = $site_id"; }else { $where2 ="AND site_id = $site_id"; } $where_condition = $where1 . $where2; $data = array(); if ($affid=="" && $site_id=="") { $count = mysql_query("SELECT * FROM link ORDER BY site_id"); $numrows = mysql_num_rows($count); $rowsperpage = 30; $totalpages = ceil($numrows / $rowsperpage); if (isset($_GET['page']) && is_numeric($_GET['page'])) { $currentpage = (int) $_GET['page']; } else { $currentpage = 1; } if ($currentpage > $totalpages) { $currentpage = $totalpages; } if ($currentpage < 1) { $currentpage = 1; } $offset = ($currentpage - 1) * $rowsperpage; $data = array(); $sql = "SELECT * FROM link ORDER BY site_id LIMIT $offset, $rowsperpage"; $result = mysql_query($sql) or die(mysql_error()); while(($rows = mysql_fetch_array($result))) { $data[] = $rows; } echo ' <b>Pages:</b> '; $range = 4; if ($currentpage > 1) { echo " <a href='{$_SERVER['PHP_SELF']}?page=1'>First</a> "; $prevpage = $currentpage - 1; echo " <a href='{$_SERVER['PHP_SELF']}?page=$prevpage'>Prev</a> "; } for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) { if (($x > 0) && ($x <= $totalpages)) { if ($x == $currentpage) { echo " [<b>$x</b>] "; } else { echo " <a href='{$_SERVER['PHP_SELF']}?page=$x'>$x</a> "; } } } if ($currentpage != $totalpages) { $nextpage = $currentpage + 1; echo " <a href='{$_SERVER['PHP_SELF']}?page=$nextpage'>Next</a> "; echo " <a href='{$_SERVER['PHP_SELF']}?page=$totalpages'>Last</a> <br /><br /><br />"; } } else { $count = mysql_query("SELECT * FROM link WHERE $where_condition ORDER BY site_id"); $numrows = mysql_num_rows($count); $rowsperpage = 30; $totalpages = ceil($numrows / $rowsperpage); if (isset($_GET['page']) && is_numeric($_GET['page'])) { $currentpage = (int) $_GET['page']; } else { $currentpage = 1; } if ($currentpage > $totalpages) { $currentpage = $totalpages; } if ($currentpage < 1) { $currentpage = 1; } $offset = ($currentpage - 1) * $rowsperpage; $data = array(); $sql = "SELECT * FROM link WHERE $where_condition ORDER BY site_id LIMIT $offset, $rowsperpage"; $result = mysql_query($sql) or die(mysql_error()); while(($rows = mysql_fetch_array($result))) { $data[] = $rows; } echo ' <b>Pages:</b> '; $range = 3; if ($currentpage > 1) { echo " <a href='?page=1'>First</a> "; $prevpage = $currentpage - 1; echo " <a href='?page=$prevpage'>Prev</a> "; } for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) { if (($x > 0) && ($x <= $totalpages)) { if ($x == $currentpage) { echo " [<b>$x</b>] "; } else { echo " <a href='?page=$x'>$x</a> "; } } } if ($currentpage != $totalpages) { $nextpage = $currentpage + 1; echo " <a href='?page=$nextpage'>Next</a> "; echo " <a href='?page=$totalpages'>Last</a> <br /><br /><br />"; } } Link to comment https://forums.phpfreaks.com/topic/200762-pagination-search-help-pls/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.