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 all
# ?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 ******/
# ?>