16 replies to this topic

[Diego Bezerra]

Use uma class chamada PS PAGINATION

[rogeriodias]

Amigão, consegui aqui utilizando o seguinte código:

<?php
         $d = 'banco';                           
         $h = 'localhost';                      
         $u = 'user';                   
         $s = ''; 
    $db = mysql_connect($h, $u, $s);
        mysql_select_db($d);

$busca = ("SELECT titulo_musica, artista_musica, musica from `tbl_player`");
$result = mysql_query($query);
$total_reg = "3"; // número de registros por página


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

$inicio = $pc - 1;
$inicio = $inicio * $total_reg;

$limite = mysql_query("$busca LIMIT $inicio,$total_reg");
$todos = mysql_query("$busca");

$tr = mysql_num_rows($todos); // verifica o número total de registros
$tp = $tr / $total_reg; // verifica o número total de páginas


while ($row = mysql_fetch_assoc($limite)) {
?>
<style type="text/css">
body {
	background-color: #fadf9c;
}
</style>
<table width="336" height="90" border="0" align="center" background="/imgs/fund_tabela_musica.jpg">
    <tr>
    <td style="font-family:Verdana, Geneva, sans-serif; font-size:10;">&nbsp;</td>
    <td style="font-family:Verdana, Geneva, sans-serif; font-size:10;"><?php echo $row['artista_musica']?></td>
    </tr>
    <tr>
    <td style="font-family:Verdana, Geneva, sans-serif; font-size:10;">&nbsp;</td>
    <td style="font-family:Verdana, Geneva, sans-serif; font-size:10;"><?php echo $row['titulo_musica']?></td>
    </tr>
    <tr>
    <td style="font-family:Verdana, Geneva, sans-serif; font-size:10;">&nbsp;</td>
    <td style="font-family:Verdana, Geneva, sans-serif; font-size:10;"><object type="application/x-shockwave-flash" data="dewplayer/dewplayer-vol.swf" width="200" height="20" id="dewplayer" name="dewplayer/dewplayer"> 
<param name="wmode" value="transparent" />
<param name="movie" value="dewplayer/dewplayer-vol.swf" /> 
<param name="flashvars" value="mp3=musicas/<?php echo $row['musica']?>" />
 </object></td>
    </tr>
    <tr>
      <td style="font-family:Verdana, Geneva, sans-serif; font-size:10;">&nbsp;</td>
      <td style="font-family:Verdana, Geneva, sans-serif; font-size:10;">&nbsp;</td>
    </tr>
    <tr>
      <td style="font-family:Verdana, Geneva, sans-serif; font-size:10;">&nbsp;</td>
      <td style="font-family:Verdana, Geneva, sans-serif; font-size:10;">&nbsp;</td>
    </tr>
  <?php } ?>
</table>
<table width="200" border="0" align="center" cellpadding="0" cellspacing="0" style="font-family:Verdana, Geneva, sans-serif; font-size:10;">
  <tr>
    <th scope="col">
<?  // agora vamos criar os botões "Anterior e próximo"
$anterior = $pc -1;
$proximo = $pc +1;
if ($pc>1) {
    echo " <a href='?pagina=$anterior' style='outline:none;'><font style='font-size:10;' face='verdana' color='#000000'><- Anterior</a> ";
}
echo "|";
if ($pc<$tp) {
    echo " <a href='?pagina=$proximo' style='outline:none;'><font style='font-size:10;' face='verdana' color='#000000'>Próxima -></a>";
}
?>
</th>
  </tr>
</table>

Abraços a todos!

Edição feita por: rogeriodias, 29/09/2011, 16:55.