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> "; } ?> Link to comment https://forums.phpfreaks.com/topic/221782-filter-erases-after-click-in-link/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.