Jump to content

filter erases after click in link


mrbitsinfo

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.