Usamos cookies para medir audiência e melhorar sua experiência. Você pode aceitar ou recusar a qualquer momento. Veja sobre o iMasters.
Criei uma busca com paginação e estou con serta dificuldade para paginação. Quando é feito a primeira busca, aparece os primeiros registros, quando pesso para ir para a outra pagina, ele seleciona todos os arquivos.Segue abaixo o script<?php if(!empty($HTTP_POST_VARS[nome_emp])){ $nome = str_replace(" ", "%", $nome_emp);} include "connect.inc"; $link=mysql_connect("$ip","$db","$pass"); mysql_select_db("SITE",$link);$qr = "SELECT * FROM SITE WHERE TITULO1 LIKE '%".$nome."%' ORDER BY SITE.TIPOINS_NET DESC";$sql = mysql_db_query($db,$qr); $lpp = 4; // Especifique quantos resultados você quer por página$total = mysql_num_rows($sql); // Esta função irá retornar o total de linhas na tabela$paginas = (ceil(($total / $lpp)-1)); // Retorna o total de páginasif(!isset($pagina)){$pagina = 0;} // Especifica uma valor para variavel pagina caso a mesma não esteja setada$inicio = $pagina * $lpp; // Retorna qual será a primeira linha a ser mostrada no MySQL$qr = "SELECT * FROM SITE WHERE TITULO1 LIKE '%".$nome."%'ORDER BY SITE.TIPOINS_NET DESC LIMIT $inicio, $lpp"; // Executa a query no MySQL com o limite de linhas.//$qr = "SELECT * FROM SITE LIMIT $inicio, $lpp"; // Executa a query no MySQL com o limite de linhas.$sql= mysql_db_query($db,$qr);if ($total == 0){ echo "Não foi encontatdo nenhum registro";}while($l = mysql_fetch_array($sql)) { $endereco = $l[ENDERECO]; $bairro = $l[bAIRRO]; $cidade = $l[CIDADE]; $uf = $l[uF]; $cep = $l[CEP]; $tel1 = $l[TEL1]; $tel2 = $l[TEL2]; $tel3 = $l[TEL3]; $fax1 = $l[FAX1]; $fax2 = $l[FAX2]; $fax3 = $l[FAX3]; $http = $l[HTTP]; $email = $l[Email1]; $tipo = $l[TIPOINS_NET]; $empresa = $l[FIGURACAO]; $linha = $l[L_INF1]; If ($tipo == "VIP"){ echo "</center> </div> <div align=\"center\"> <center><table border=\"1\" cellpadding=\"0\" cellspacing=\"0\" width=\"542\" height=\"98\" bordercolor=\"#000000\"> <tr> <td width=\"100%\"> <div align=\"center\"> <center> <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"95%\"> <tr> <td width=\"100%\"><font face=\"Arial\" size=\"1\"><b><span style=\"text-transform: uppercase\">$empresa</span></b></font></td> </tr> <tr> <td width=\"100%\"><font face=\"Arial\" size=\"1\"> <b><span style=\"text-transform: uppercase\">$endereco , $bairro - $cidade - $uf - CEP $cep</span></b></font></td> </tr> <tr> <td width=\"100%\"><font face=\"Arial\" size=\"1\"> <b><span style=\"text-transform: uppercase\">Fone: $tel1 Fax: $fax1</span></b></font></td> </tr> <tr> <td width=\"100%\" valign=\"top\"><font face=\"Arial\" size=\"1\"> <a href=\"http://$http\"> <img border=\"0\" src=\"imagens/internet.gif\" width=\"33\" height=\"29\"></a>website </font><a href=\"mailto:$email\"><img border=\"0\" src=\"imagens/email.gif\" width=\"32\" height=\"20\"></a> <font face=\"Arial\" size=\"1\">e-mail</font></td> </tr> </table> </center> </div> </td> </tr></table> </center> </div> <div align=\"center\"> <center><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"542\" height=\"11\"> <tr> <td width=\"100%\"></td> </tr></table>"; } IF ($tipo == "GR"){ echo "</center> </div> <div align=\"center\"> <center><table border=\"1\" cellpadding=\"0\" cellspacing=\"0\" width=\"542\" height=\"49\" bordercolor=\"#000000\"> <tr> <td width=\"100%\"> <div align=\"center\"> <center> <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"95%\"> <tr> <td width=\"100%\" valign=\"middle\"><font face=\"Arial\" size=\"1\">$empresa</font></td> </tr> <tr> <td width=\"100%\"> <font face=\"Arial\" size=\"1\"> <a href=\"http://$http\"> <img border=\"0\" src=\"imagens/internet.gif\" width=\"33\" height=\"29\"></a>website </font></td> </tr> </table> </center> </div> </td> </tr></table> </center> </div> <div align=\"center\"> <center><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"542\" height=\"11\"> <tr> <td width=\"100%\"></td> </tr></table>"; }IF ($tipo == "IB"){ echo "</center> </div> <div align=\"center\"> <center><table border=\"1\" cellpadding=\"0\" cellspacing=\"0\" width=\"542\" height=\"56\" bordercolor=\"#000000\"> <tr> <td width=\"100%\"> <div align=\"center\"> <center> <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"95%\"> <tr> <td width=\"100%\"><font face=\"Arial\" size=\"1\">$empresa</font></td> </tr> <tr> <td width=\"100%\" valign=\"top\"><font face=\"Arial\" size=\"1\"> <a href=\"http://$http\"> <img border=\"0\" src=\"imagens/internet.gif\" width=\"33\" height=\"29\"></a>website </font><a href=\"mailto:$email\"><img border=\"0\" src=\"imagens/email.gif\" width=\"32\" height=\"20\"></a> <font face=\"Arial\" size=\"1\">e-mail</font></td> </tr> </table> </center> </div> </td> </tr></table></center> </div> <div align=\"center\"> <center><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"542\" height=\"11\"> <tr> <td width=\"100%\"></td> </tr></table>"; }If ($tipo == "NG"){ echo "</center> </div> <div align=\"center\"> <center><table border=\"1\" cellpadding=\"0\" cellspacing=\"0\" width=\"542\" height=\"98\" bordercolor=\"#000000\"> <tr> <td width=\"100%\"> <div align=\"center\"> <center> <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"95%\"> <tr> <td width=\"100%\"><font face=\"Arial\" size=\"1\"><b><span style=\"text-transform: uppercase\">$empresa</span></b></font></td> </tr> <tr> <td width=\"100%\"><font face=\"Arial\" size=\"1\"> $endereco , $bairro - $cidade - $uf - CEP $cep</font></td> </tr> <tr> <td width=\"100%\"><font face=\"Arial\" size=\"1\"> Fone: $tel1 Fax: $fax1</font></td> </tr> <tr> <td width=\"100%\" valign=\"top\"><font face=\"Arial\" size=\"1\"> <a href=\"http://$http\"> <img border=\"0\" src=\"imagens/internet.gif\" width=\"33\" height=\"29\"></a>website </font><a href=\"mailto:$email\"><img border=\"0\" src=\"imagens/email.gif\" width=\"32\" height=\"20\"></a> <font face=\"Arial\" size=\"1\">e-mail</font></td> </tr> </table> </center> </div> </td> </tr></table> </center> </div> <div align=\"center\"> <center><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"542\" height=\"11\"> <tr> <td width=\"100%\"></td> </tr></table>"; } if ($tipo == "DC"){ echo "</center> </div> <div align=\"center\"> <center><table border=\"1\" cellpadding=\"0\" cellspacing=\"0\" width=\"542\" height=\"98\" bordercolor=\"#000000\"> <tr> <td width=\"100%\"> <div align=\"center\"> <center> <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"95%\"> <tr> <td width=\"100%\"><font face=\"Arial\" size=\"1\"><b><span style=\"text-transform: uppercase\">$empresa</span></b></font></td> </tr> <tr> <td width=\"100%\"><font face=\"Arial\" size=\"1\"> <b><span style=\"text-transform: uppercase\">$endereco , $bairro - $cidade - $uf - CEP $cep</span></b></font></td> </tr> <tr> <td width=\"100%\"><font face=\"Arial\" size=\"1\"> <b><span style=\"text-transform: uppercase\">Fone: $tel1 Fax: $fax1</span></b></font></td> </tr> <tr> <td width=\"100%\" valign=\"top\"><font face=\"Arial\" size=\"1\"> <a href=\"http://$http\"> <img border=\"0\" src=\"imagens/internet.gif\" width=\"33\" height=\"29\"></a>website </font><a href=\"mailto:$email\"><img border=\"0\" src=\"imagens/email.gif\" width=\"32\" height=\"20\"></a> <font face=\"Arial\" size=\"1\">e-mail</font></td> </tr> </table> </center> </div> </td> </tr></table> </center> </div> <div align=\"center\"> <center><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"542\" height=\"11\"> <tr> <td width=\"100%\"></td> </tr></table>"; } }if($pagina > 0) { $menos = $pagina - 1; $url = "$PHP_SELF?pagina=$menos&?nome_emp=$nome"; echo "<a href='$url'>Anterior</a>"; // Vai para a página anterior }for($i=0;$i<$paginas;$i++) { // Gera um loop com o link para as páginas $url = "$PHP_SELF?pagina=$i&?nome_emp=$nome"; echo " | <a href='$url'>$i</a>"; echo "$nome"; }if($pagina < $paginas) { $mais = $pagina + 1; $url = "$PHP_SELF?pagina=$mais&?nome_emp=$nome"; echo " | <a href='$url'>Próxima</a>";}?>Carregando comentários...