script da aula
<?php
mysql_connect('localhost', 'root', '');
mysql_select_db('videoaulas');
$rowConsulta = mysql_query("SELECT * FROM comentario");
$contaNumRegistros = mysql_num_rows($rowConsulta);
$paginacao = $contaNumRegistros / 10;
$paginacaoConvertida = (int) $paginacao;
if(isset($_GET['pag'])){
$indice = ($_GET['pag'] - 1) * 10;
$rowLimitConsulta = mysql_query("SELECT * FROM comentario ORDER BY comentario_id DESC LIMIT $indice, 10");
}else{
$rowLimitConsulta = mysql_query("SELECT * FROM comentario ORDER BY comentario_id DESC LIMIT 0, 10");
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Sistema de Paginação de Conteudo</title>
<link rel="stylesheet" type="text/css" href="css/style.css" />
</head>
<body>
<div id="box">
<div id="exemplo">
</div>
<span>
<a name="comentarios">
</a>
<?php
for($i=1; $i<=10; $i++){
if(isset($_GET['pag'])){
if($i == $_GET['pag']){
echo " $i ";
}else{
echo '<a href="?pag='.$i.'#comentarios"> '.$i.' </a>';
}
}else{
echo '<a href="?pag='.$i.'#comentarios"> '.$i.' </a>';
}
}
?>
</span>
<?php
while($rowComentario = mysql_fetch_row($rowLimitConsulta)){
?>
<div>
<span><?php echo $rowComentario[1]; ?></span>
<span><?php echo $rowComentario[2]; ?></span>
</div>
<?php } ?>
</div>
</body>
</html>
