PHP mysql Pagination

[mithrandix]

Hello, i'm new around here.

I have a error with my pagination that has a limit and I have a First, Previous, Next, Last button.

I have a query, and when I click on the Next button to show my other results.
The thing is, they query works at a 1º time because it shows me 6results ( witch is correct ), but after I press Next button they 6 results become 7 :S ( I wont want that, I want still to show the next results ( in the first 6 found ) ) .

Notice: Undefined index: Familia in C:\xampp\htdocs*****\paginacaotest.php on line 11

I simply used a where in the query so I can get the info from the $_POST but after I press Next it is like it simply ignore the Where :S.

Can I get a help on this plz =S rly impp..

<?php

$host = "localhost";
$username = "root";
$senha= "";
$banco_dados = "******"; // I have a rly db name d/w
$tabela = "artigos";
$numero_links = "4";
$total_reg = "2";



if(!$pagina) {
$pc = "1";
} else {
$pc = $pagina;
}

$intervalo = $numero_links;
$inicio = $pc-1;
$inicio = $inicio*$total_reg;
mysql_connect($host,$username,$senha);
mysql_select_db($banco_dados);

$search = mysql_escape_string($_POST["Familia"]);
$sql = mysql_query("SELECT * FROM $tabela where Familia LIKE '%".$search."%' ");
$tr = mysql_num_rows($sql);
$sql2 = mysql_query("SELECT * FROM $tabela where Familia LIKE '%".$search."%' LIMIT $inicio,$total_reg");
$tp = ceil($tr/$total_reg);

echo "<font size='1' face='Verdana'>";
echo "Página $pc de $tp<br> Total de registros: $tr<br><br>";
echo "</font>";
echo "<hr>";
while($dados=mysql_fetch_array($sql2)) {
$id = $dados["Nome"];
$nome = $dados["CodigoBarras"];
echo "$id - $nome<br>\n";
}

$aux = $tp/$intervalo;
$aux1 = $pc/$intervalo;
$pi = $aux1 * $intervalo;
if ($pi == "0") {
$pi = "1";
}
$pf = $pi + $intervalo -1;
$anterior = $pi-$intervalo;
if($pc<=$intervalo) {
$anterior = 1;
}
$aux2 = $pi + 1;
if($pi>1) {
$aux = $pi - 1;
$aux2 = $pi + 1;
echo "<hr>";
	echo " <<<a href='{$_SERVER['PHP_SELF']}?pagina=1'>Primeiro</a> ";
  	echo "<<a href='paginacaotest.php?pagina=$aux'><b> Anterior </b></a>&nbsp;";
}
else
{
	 echo "<font size='1' face='Verdana'>";
	 echo "<< Primeiro &nbsp;";
	 echo "</font>";
	 echo "<font size='1' face='Verdana'>";
	 echo "<< Anterior &nbsp;&nbsp;";
     echo "</font>";
}

for ($pi;$pi<$pf;$pi++) 
{
      if($pi<=$tp) {
          if($pc==$pi) {
		  	 echo "<strong><font size='1' face='Verdana'>";
             echo "<b>[" . $pi . "]</b>&nbsp;";
			 echo "</font></strong>";
          } else {
		     echo "<a href='paginacaotest.php?pagina=" . $pi . "'>" . $pi . "</a>&nbsp;";
          }
      }
}

 if($pc != $tp){
   	  echo "<strong><font size='1' face='Verdana'>";
      echo "<a href='paginacaotest.php?pagina=$aux2'><b>&nbsp;&nbsp;&nbsp; Próximo</b></a> >";
	  echo " <a href='{$_SERVER['PHP_SELF']}?pagina=$tp'>Ultimo</a> ";
      echo "</font></strong>";
	}
	else
	{ 
	 echo "<font size='1' face='Verdana'>";
	 echo "&nbsp;&nbsp;&nbsp; Próximo >>";
     echo "</font>";
	 echo "<font size='1' face='Verdana'>";
	 echo "&nbsp;&nbsp;&nbsp; Ultimo >>";
     echo "</font>";
	}
?>

sorry if confuse :S

[Undrium]

$search = mysql_escape_string($_POST["Familia"]); 

This is probably your error, the "Familia" does not exist, I recommend you make a check (for instance isset($_POST["Familia"]) before asking after the global variabel.

[mithrandix]

($_POST["Familia"]); exist's.

Because on the 1º results, it shows the correct stuff, because on where he gets the post from the prev page ( where I have a form ).

But after I press NEXT it shows that error

Notice: Undefined index: Familia in C:\xampp\htdocs*****\paginacaotest.php on line 11

so :S I already tryd the isset but nothing :S same thing appens

[Undrium]

What I mean is that you need to check so that your $_POST["Familia"] is set before you can do that query. Something like this:

if(isset($_POST["Familia"])){
   $search = mysql_escape_string($_POST["Familia"]); 
}

Remember, though, that if your Familia-variable isn't set, you'll get other problems. Once this check fails, the $search variable will be empty, so you might want to consider putting in a dummy value.

[mithrandix]

if(isset($_POST["Familia"])){ 
   $search = mysql_escape_string($_POST["Familia"]); 
} 

Now after I put this I got

Notice: Undefined variable: search in C:\xampp\htdocs*****\paginacaotest.php on line 29

Notice: Undefined variable: search in C:\xampp\htdocs*****\paginacaotest.php on line 31

<?php

$host = "localhost";
$username = "root";
$senha= "";
$banco_dados = "*****";
$tabela = "artigos";
$numero_links = "4";
$total_reg = "2";



if(!$pagina) {
$pc = "1";
} else {
$pc = $pagina;
}

$intervalo = $numero_links;
$inicio = $pc-1;
$inicio = $inicio*$total_reg;
mysql_connect($host,$username,$senha);
mysql_select_db($banco_dados);

if(isset($_POST["Familia"])){ 
   $search = mysql_escape_string($_POST["Familia"]); 
} 

$sql = mysql_query("SELECT * FROM $tabela where Familia LIKE '%".$search."%' ");
$tr = mysql_num_rows($sql);
$sql2 = mysql_query("SELECT * FROM $tabela where Familia LIKE '%".$search."%' LIMIT $inicio,$total_reg");
$tp = ceil($tr/$total_reg);

echo "<font size='1' face='Verdana'>";
echo "Página $pc de $tp<br> Total de registros: $tr<br><br>";
echo "</font>";
echo "<hr>";
while($dados=mysql_fetch_array($sql2)) {
$id = $dados["Nome"];
$nome = $dados["CodigoBarras"];
echo "$id - $nome<br>\n";
}

$aux = $tp/$intervalo;
$aux1 = $pc/$intervalo;
$pi = $aux1 * $intervalo;
if ($pi == "0") {
$pi = "1";
}
$pf = $pi + $intervalo -1;
$anterior = $pi-$intervalo;
if($pc<=$intervalo) {
$anterior = 1;
}
$aux2 = $pi + 1;
if($pi>1) {
$aux = $pi - 1;
$aux2 = $pi + 1;
echo "<hr>";
	echo " <<<a href='{$_SERVER['PHP_SELF']}?pagina=1'>Primeiro</a> ";
  	echo "<<a href='paginacaotest.php?pagina=$aux'><b> Anterior </b></a>&nbsp;";
}
else
{
	 echo "<font size='1' face='Verdana'>";
	 echo "<< Primeiro &nbsp;";
	 echo "</font>";
	 echo "<font size='1' face='Verdana'>";
	 echo "<< Anterior &nbsp;&nbsp;";
     echo "</font>";
}

for ($pi;$pi<$pf;$pi++) 
{
      if($pi<=$tp) {
          if($pc==$pi) {
		  	 echo "<strong><font size='1' face='Verdana'>";
             echo "<b>[" . $pi . "]</b>&nbsp;";
			 echo "</font></strong>";
          } else {
		     echo "<a href='paginacaotest.php?pagina=" . $pi . "'>" . $pi . "</a>&nbsp;";
          }
      }
}

 if($pc != $tp){
   	  echo "<strong><font size='1' face='Verdana'>";
      echo "<a href='paginacaotest.php?pagina=$aux2'><b>&nbsp;&nbsp;&nbsp; Próximo</b></a> >";
	  echo " <a href='{$_SERVER['PHP_SELF']}?pagina=$tp'>Ultimo</a> ";
      echo "</font></strong>";
	}
	else
	{ 
	 echo "<font size='1' face='Verdana'>";
	 echo "&nbsp;&nbsp;&nbsp; Próximo >>";
     echo "</font>";
	 echo "<font size='1' face='Verdana'>";
	 echo "&nbsp;&nbsp;&nbsp; Ultimo >>";
     echo "</font>";
	}
?>

:S

[mithrandix]

Can someone assist ? please its rly imp :S

[Derokorian]

you have to set it to a default value if its empty... IE

<?php
if(isset($_POST["Familia"])){
   $search = mysql_escape_string($_POST["Familia"]);
} else {
   $search = "";
}

[bradgrafelman]

Also note that you can shorten the amount of code down to one line for convenience:

$search = (isset($_POST['Familia']) ? mysql_real_escape_string($_POST['Familia']) : '');

[Derokorian]

Can I ask why you put the whole terniary in parens?

[mithrandix]

😃DDDD

Thanks all 🙂 It works fine now 😉 <333

Keep up the good work 🙂 you guys R rly super 😉

[mithrandix]

Thanks all 🙂 It works fine now 😉 <333

Keep up the good work 🙂 you guys R rly super 😉[/QUOTE]

Kinda false alarm, I notice something :S

When I 1º do the display, it shows 6 results that are correct and after I do next, no error are displayed but the displayed data go from 6 to 7 :S

<?php

$host = "localhost";
$username = "root";
$senha= "";
$banco_dados = "bdknology2";
$tabela = "artigos";
$numero_links = "4";
$total_reg = "2";

$search = (isset($_POST['Familia']) ? mysql_real_escape_string($_POST['Familia']) : ''); 

if(!$pagina) {
$pc = "1";
} else {
$pc = $pagina;
}

$intervalo = $numero_links;
$inicio = $pc-1;
$inicio = $inicio*$total_reg;
mysql_connect($host,$username,$senha);
mysql_select_db($banco_dados);


$sql = mysql_query("SELECT * FROM $tabela where Familia LIKE '%".$search."%' ");
$tr = mysql_num_rows($sql);
$sql2 = mysql_query("SELECT * FROM $tabela where Familia LIKE '%".$search."%' LIMIT $inicio,$total_reg");
$tp = ceil($tr/$total_reg);

echo "<font size='1' face='Verdana'>";
echo "Página $pc de $tp<br> Total de registros: $tr<br><br>";
echo "</font>";
echo "<hr>";
while($dados=mysql_fetch_array($sql2)) {
$id = $dados["Nome"];
$nome = $dados["CodigoBarras"];
echo "$id - $nome<br>\n";
}

$aux = $tp/$intervalo;
$aux1 = $pc/$intervalo;
$pi = $aux1 * $intervalo;
if ($pi == "0") {
$pi = "1";
}
$pf = $pi + $intervalo -1;
$anterior = $pi-$intervalo;
if($pc<=$intervalo) {
$anterior = 1;
}
$aux2 = $pi + 1;
if($pi>1) {
$aux = $pi - 1;
$aux2 = $pi + 1;
echo "<hr>";
	echo " <<<a href='{$_SERVER['PHP_SELF']}?pagina=1'>Primeiro</a> ";
  	echo "<<a href='paginacaotest.php?pagina=$aux'><b> Anterior </b></a>&nbsp;";
}
else
{
	 echo "<font size='1' face='Verdana'>";
	 echo "<< Primeiro &nbsp;";
	 echo "</font>";
	 echo "<font size='1' face='Verdana'>";
	 echo "<< Anterior &nbsp;&nbsp;";
     echo "</font>";
}

for ($pi;$pi<$pf;$pi++) 
{
      if($pi<=$tp) {
          if($pc==$pi) {
		  	 echo "<strong><font size='1' face='Verdana'>";
             echo "<b>[" . $pi . "]</b>&nbsp;";
			 echo "</font></strong>";
          } else {
		     echo "<a href='paginacaotest.php?pagina=" . $pi . "'>" . $pi . "</a>&nbsp;";
          }
      }
}

 if($pc != $tp){
   	  echo "<strong><font size='1' face='Verdana'>";
      echo "<a href='paginacaotest.php?pagina=$aux2'><b>&nbsp;&nbsp;&nbsp; Próximo</b></a> >";
	  echo " <a href='{$_SERVER['PHP_SELF']}?pagina=$tp'>Ultimo</a> ";
      echo "</font></strong>";
	}
	else
	{ 
	 echo "<font size='1' face='Verdana'>";
	 echo "&nbsp;&nbsp;&nbsp; Próximo >>";
     echo "</font>";
	 echo "<font size='1' face='Verdana'>";
	 echo "&nbsp;&nbsp;&nbsp; Ultimo >>";
     echo "</font>";
	}
?>