Problem in paging...!

  • asad_black
  • Graduate
  • Graduate
  • asad_black
  • Posts: 131
  • Loc: pakistan

Post 3+ Months Ago

my problem is i was create the search page in which user enter the key word then shows the record in paging form by using the following the code.

actual problem is that after seraching the record when i click on the NEXT button paging shows also those records which is not match by keywords
this is my site
http://jugnoo.tv

enter Rayed in searh textbox
Code: [ Select ]
?php
$var = @$_GET['q'] ;
$trimmed = trim($var);
// database connection info
$conn = mysql_connect('localhost','asad','asad') or trigger_error("SQL", E_USER_ERROR);
$db = mysql_select_db('asad',$conn) or trigger_error("SQL", E_USER_ERROR);

// find out how many rows are in the table
$sql = "SELECT COUNT(*) FROM links";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
$r = mysql_fetch_row($result);
$numrows = $r[0];

// number of rows to show per page
$rowsperpage = 1;
// find out total pages
$totalpages = ceil($numrows / $rowsperpage);

// get the current page or set a default
if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) {
// cast var as int
$currentpage = (int) $_GET['currentpage'];
} else {
// default page num
$currentpage = 1;
} // end if

// if current page is greater than total pages...
if ($currentpage > $totalpages) {
// set current page to last page
$currentpage = $totalpages;
} // end if
// if current page is less than first page...
if ($currentpage < 1) {
// set current page to first page
$currentpage = 1;
} // end if

// the offset of the list, based on current page
$offset = ($currentpage - 1) * $rowsperpage;

// get the info from the db
$sql = "SELECT * FROM links where kw like \"%$trimmed%\"
LIMIT $offset, $rowsperpage";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);

echo "<table border=0 cellspacing=2 cellpadding=2>";

echo "<tr>";

// while there are rows to be fetched...

// echo data
    echo "<table border='0' cellpadding='5' cellspacing='5'>";



// while there are rows to be fetched...
while ($list = mysql_fetch_assoc($result)) {
// echo data

    {
echo "<tr class=style28>";
echo "<td valign=top>". $list['text'];
echo "<td valign=top><a href=\"" . $list["link"] . "\">
<img src=\"" . $list["image"] . "\" height='80' width='80' border=0 \"" . $list["text"] . "\"></a>";

//echo "<td>" . $list['kw'] . "</td>";
echo "<td valign=top>" . $list['des'] . "</td>";
echo "</tr>";
}



}

echo "</td>";
    echo "</tr>";
echo "</table>";
/****** build the pagination links ******/
// range of num links to show
$range = 3;

// if not on page 1, don't show back links
if ($currentpage > 1) {
// show << link to go back to page 1
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=1'>First</a> ";
// get previous page num
$prevpage = $currentpage - 1;
// show < link to go back to 1 page
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'>Previous</a> ";
} // end if

// loop to show links to range of pages around current page
for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) {
// if it's a valid page number...
if (($x > 0) && ($x <= $totalpages)) {
     // if we're on current page...
     if ($x == $currentpage) {
        // 'highlight' it but don't make a link
        echo " [<b>$x</b>] ";
     // if not current page...
     } else {
        // make it a link
    echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a> ";
     } // end else
} // end if
} // end for
    
// if not on last page, show forward and last page links 
if ($currentpage != $totalpages) {
// get next page
$nextpage = $currentpage + 1;
    // echo forward link for next page
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>Next</a> ";
// echo forward link for lastpage
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>Last</a> ";
} // end if
/****** end build pagination links ******/
?>
  1. ?php
  2. $var = @$_GET['q'] ;
  3. $trimmed = trim($var);
  4. // database connection info
  5. $conn = mysql_connect('localhost','asad','asad') or trigger_error("SQL", E_USER_ERROR);
  6. $db = mysql_select_db('asad',$conn) or trigger_error("SQL", E_USER_ERROR);
  7. // find out how many rows are in the table
  8. $sql = "SELECT COUNT(*) FROM links";
  9. $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
  10. $r = mysql_fetch_row($result);
  11. $numrows = $r[0];
  12. // number of rows to show per page
  13. $rowsperpage = 1;
  14. // find out total pages
  15. $totalpages = ceil($numrows / $rowsperpage);
  16. // get the current page or set a default
  17. if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) {
  18. // cast var as int
  19. $currentpage = (int) $_GET['currentpage'];
  20. } else {
  21. // default page num
  22. $currentpage = 1;
  23. } // end if
  24. // if current page is greater than total pages...
  25. if ($currentpage > $totalpages) {
  26. // set current page to last page
  27. $currentpage = $totalpages;
  28. } // end if
  29. // if current page is less than first page...
  30. if ($currentpage < 1) {
  31. // set current page to first page
  32. $currentpage = 1;
  33. } // end if
  34. // the offset of the list, based on current page
  35. $offset = ($currentpage - 1) * $rowsperpage;
  36. // get the info from the db
  37. $sql = "SELECT * FROM links where kw like \"%$trimmed%\"
  38. LIMIT $offset, $rowsperpage";
  39. $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
  40. echo "<table border=0 cellspacing=2 cellpadding=2>";
  41. echo "<tr>";
  42. // while there are rows to be fetched...
  43. // echo data
  44.     echo "<table border='0' cellpadding='5' cellspacing='5'>";
  45. // while there are rows to be fetched...
  46. while ($list = mysql_fetch_assoc($result)) {
  47. // echo data
  48.     {
  49. echo "<tr class=style28>";
  50. echo "<td valign=top>". $list['text'];
  51. echo "<td valign=top><a href=\"" . $list["link"] . "\">
  52. <img src=\"" . $list["image"] . "\" height='80' width='80' border=0 \"" . $list["text"] . "\"></a>";
  53. //echo "<td>" . $list['kw'] . "</td>";
  54. echo "<td valign=top>" . $list['des'] . "</td>";
  55. echo "</tr>";
  56. }
  57. }
  58. echo "</td>";
  59.     echo "</tr>";
  60. echo "</table>";
  61. /****** build the pagination links ******/
  62. // range of num links to show
  63. $range = 3;
  64. // if not on page 1, don't show back links
  65. if ($currentpage > 1) {
  66. // show << link to go back to page 1
  67. echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=1'>First</a> ";
  68. // get previous page num
  69. $prevpage = $currentpage - 1;
  70. // show < link to go back to 1 page
  71. echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'>Previous</a> ";
  72. } // end if
  73. // loop to show links to range of pages around current page
  74. for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) {
  75. // if it's a valid page number...
  76. if (($x > 0) && ($x <= $totalpages)) {
  77.      // if we're on current page...
  78.      if ($x == $currentpage) {
  79.         // 'highlight' it but don't make a link
  80.         echo " [<b>$x</b>] ";
  81.      // if not current page...
  82.      } else {
  83.         // make it a link
  84.     echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a> ";
  85.      } // end else
  86. } // end if
  87. } // end for
  88.     
  89. // if not on last page, show forward and last page links 
  90. if ($currentpage != $totalpages) {
  91. // get next page
  92. $nextpage = $currentpage + 1;
  93.     // echo forward link for next page
  94. echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>Next</a> ";
  95. // echo forward link for lastpage
  96. echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>Last</a> ";
  97. } // end if
  98. /****** end build pagination links ******/
  99. ?>
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

Post Information

  • Total Posts in this topic: 1 post
  • Users browsing this forum: No registered users and 192 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.