mrbitsinfo Posted December 15, 2010 Share Posted December 15, 2010 i have this simple table browse get me the filter let say 15 items of a table of 74 but after i click in the link forward the filter erase and disply me the all records... waht im doing wrong.... TNX in advance <img src="images/misc/search.JPG" width="367" height="100" /> <br /> <?php $strng = $_POST['search:strng']; $separa = "%"; $all = $separa.$strng.$separa; $mensaj="U Look for : "; $mensaj2=$mensaj.$stng; $regis=" u search get :"; $regis2=" Items"; $conn = mysql_connect('localhost','zerocctv_Admin','password') or trigger_error("almacen", E_USER_ERROR); $db = mysql_select_db('zerocctv_almacen',$conn) or trigger_error("almacenz", E_USER_ERROR); $sql = "SELECT COUNT(*) FROM modelos where descrip like '$all'"; $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR); $r = mysql_fetch_row($result); $numrows = $r[0]; $rowsperpage = 10; $totalpages = ceil($numrows / $rowsperpage); // get the current page or set a default if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) { $currentpage = (int) $_GET['currentpage']; } else { $currentpage = 1; } if ($currentpage > $totalpages) { $currentpage = $totalpages; } if ($currentpage < 1) { $currentpage = 1; } $offset = ($currentpage - 1) * $rowsperpage; $sql = "SELECT modelo, paginal,precio,foto FROM modelos where descrip like '$all' LIMIT $offset, $rowsperpage"; $result = mysql_query($sql, $conn) or trigger_error("SQLkk2", E_USER_ERROR); echo $Mensaj2 ; echo $regis. $numrows . $regis2 ; echo "<table width=\50%\ border=\1\ bordercolor=\#0033FF\ cellspacing=\1\">" ; while ($list = mysql_fetch_assoc($result)) { echo "<tr>"; echo "<td>><font color='red'>" . $list['model'] . "</font></td>"; echo "<td><font color='black'>" . $list['pagl'] . "</font></td>"; echo "<td><font color='black'>" . $list['prize'] . "</font></td>"; echo "<td><font color='black'>" . $list['pict'] . "</font></td>"; echo "<tr></tr>"; echo "</tr>"; } echo "</table>"; //****** build the pagination links ******/ $range = 3; if ($currentpage > 1) { echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=1'><<</a> "; $prevpage = $currentpage - 1; echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'><</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']}?currentpage=$x'>$x</a> "; } } } if ($currentpage != $totalpages) { $nextpage = $currentpage + 1; echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>></a> "; echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>>></a> "; } ?> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.