<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR...nsitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
<!--
a { text-decoration: none; }
a.classe1:hover { text-decoration: underline; color: #006600; }
a.classe1 { color: #006600; }
a.classe2 { text-decoration: underline overline; }
a.classe2:hover {text-decoration: underline; color: #006600; }
.style5 {font-size: 10px; font-family: Verdana, Arial, Helvetica, sans-serif; }
.style9 {font-size: 10px; font-family: Verdana, Arial, Helvetica, sans-serif; color: #000000; }
-->
</style>
</head>
<body>
<?
$conn= mysql_connect('localhost','sitecli_portal','123123') or die ("Erro na conexão");
$db=mysql_select_db('sitecli_portal') or die ("Erro no banco");
$max=10;
if ($pagina == "")
$pagina=1;
$inicio = $pagina - 1;
$inicio = $max * $inicio;
$sql="select * from galeria";
$res=mysql_query($sql);
$total=mysql_num_rows($res);
if ($total == 0)
echo "Nenhum registro encontrado!";
else{echo "Quantidade de registros encontrados: ".$total.'<br><br>';
$sql="select * from galeria LIMIT $inicio,$max";
$res=mysql_query($sql);
?>
<?php while ($row=mysql_fetch_array($res)){ ?>
<table width="100%" border="0">
<tr>
<td width="6%" valign="top"><img src="http://site.clickana...s/galeria/<?php echo $res[8] ?>/<?php echo $res[9] ?>" alt=""width="100" height="100" border="0" /></td>
<td width="94%" valign="top"><table width="100%" border="0">
<tr>
<td><span class="style5"><strong>Evento:</strong> <?php echo $res[1] ?></span></td>
</tr>
<tr>
<td><span class="style5"><strong>Local:</strong> <?php echo $res[6] ?></span></td>
</tr>
<tr>
<td><span class="style5"><strong>Data:</strong>
<? $dia = $res['2']; $mes = $res['3']; $ano = $res['ano']; echo "$dia/$mes/$ano"; ?>
</span></td>
</tr>
<tr>
<td><span class="style9"><strong>Fotografo:</strong> <?php echo $res[7] ?></span></td>
</tr>
<tr>
<td><a href="mostrarfotos.php?id=<?php echo $res[0] ?>" class="classe1 style5">Veja as fotos</a></td>
</tr>
</table></td>
</tr>
</table>
<?php
}
}
// Calculando pagina anterior
$menos = $pagina - 1;
// Calculando pagina posterior
$mais = $pagina + 1;
$pgs = ceil($total / $max);if($pgs > 1 ) {
if($menos>0)
echo "<a href=\"?pagina=$menos\" class='texto_paginacao'>Anterior</a> ";
if (($pagina-4) < 1 )
$anterior = 1;
else
$anterior = $pagina-4;
if (($pagina+4) >
$pgs
)
$posterior = $pgs;
else
$posterior = $pagina + 4;
for($i=$anterior;$i <= $posterior;$i++)
if($i != $pagina)
echo " <a href=\"?pagina=".($i)."\" class='texto_paginacao'>$i</a>";
else
echo " <strong class='texto_paginacao_pgatual'>".$i."</strong>";
if($mais <= $pgs)
echo " <a href=\"?pagina=$mais\" class='texto_paginacao'>Proxima</a>";
}
?>
</body>
</html>
veja o erro:
http://site.clickana...s.com/teste.php
