uma query boba:
[codebox]
select * from comentarios order by id limit 10
[/codebox]
um sistema de enquete dinamica que eu fiz:
se baseia nele para fazer paginacao:
[codebox]
include "conecta_mysql_enquete.php";
$_BS['PorPagina'] = 10;
$sql_pergunta = "SELECT * FROM pergunta";
$sql_lojas = "SELECT * FROM lojas";
$sql_respostas = "select * from respostas";
$result = mysql_query($sql_pergunta);
$result2 = mysql_query($sql_lojas);
$result3 = mysql_query($sql_respostas);
$teste = mysql_num_rows($result);
//$total = mysql_result($result3, 0, 'id');
$total = mysql_num_rows($result3);
$paginas = (($total % $_BS['PorPagina']) > 0) ? (int)($total / $_BS['PorPagina']) + 1 : ($total / $_BS['PorPagina']);
if (isset($_GET['pagina'])) {
$pagina = (int)$_GET['pagina'];
} else {
$pagina = 1;
}
$pagina = max(min($paginas, $pagina), 1);
$inicio = ($pagina - 1) * $_BS['PorPagina'];
$sql = "SELECT * FROM `respostas` ORDER BY `id` DESC LIMIT ".$inicio.", ".$_BS['PorPagina'];
$query = mysql_query($sql);
if($teste >= 1){
?>
<form action="env_form.php" method="post">
<br>
<table width="323" height="24" border="0" align="center">
<tr>
<?
while($dados = mysql_fetch_array($result))
{?>
<td width="317" height="20"><input name="pergunta" id="pergunta" type="hidden" value="<?php echo $dados['id']; ?>" />
<?
echo "<strong>PERGUNTA: </strong>".$dados['pergunta']."";
}
?></td>
</tr>
</table>
<hr>
<table width="395" border="0" align="center">
<tr>
<td width="92"> </td>
<td width="287"><strong><a href="java script:void()"onclick="showHide('responda');" style="cursor: pointer;">CLIQUE AQUI PARA RESPONDER!</a></strong></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table>
<div id=responda style="display: none">
<table width="395" border="0" align="center">
<tr>
<td><strong>Nome:</strong></td>
<td><input type="text" name="nome" id="nome" /></td>
</tr>
<tr>
<td height="23"><strong>Loja:</strong></td>
<td><select name="loja" id="loja">
<?
while($dados = mysql_fetch_array($result2))
{
echo "<option value='".$dados['desc_lojas']."'>".$dados['desc_lojas']."</option>";
}
?>
</select>
</td>
</tr>
<tr>
<td><strong>Resposta:</strong></td>
<td><textarea name="resposta" id="resposta" cols="45" rows="5"></textarea></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="button" id="button" value="Enviar Resposta" /></td>
</tr>
</table>
</form>
<hr>
</div>
<?
}
else
{
echo '<table width="60%" border="1" align="center">';
echo '<tr><td bgcolor="#FF0000"><div align="center"><font face="Verdana, Arial, Helvetica, sans-serif"><strong><font size="4">ATENÇÃO!</font></strong></font></div></td></tr>';
echo '<tr><td><font size="3" face="Verdana, Arial, Helvetica, sans-serif"><strong>Nenhuma enquete ativa!</strong></font></td></tr>';
echo '<tr><td><font size="3" face="Verdana, Arial, Helvetica, sans-serif"><a href="index.php"><strong>Ir para Pagina de Login</strong></a></font></td></tr>';
echo '</table>';
}
?>
<?
while($dados = mysql_fetch_array($query))
{
?>
<table width="395" border="0" align="center">
<tr>
<td width="68"> </td>
<td width="317"> </td>
</tr>
<tr>
<td><strong>Nome:</strong></td>
<td><? echo $dados['autor']; ?></td>
</tr>
<tr>
<td height="23"><strong>Loja:</strong></td>
<td><? echo $dados['loja']; ?>
</td>
</tr>
<tr>
<td><strong>Resposta:</strong></td>
<td><? echo $dados['respostas']; ?></td>
</tr>
</table><hr>
<?
}
$prev = $pagina - 1;
$next = $pagina + 1;
// se página maior que 1 (um), então temos link para a página anterior
if ($pagina > 1) {
$prev_link = "<input class=\"style2\" onclick=\"java script:window.location='$PHP_SELF?pagina=".$prev."'\" type=\"button\" value=\"Anterior\" name=\"btnAnterior1\">";
}else{
$prev_link = "<input class=\"style2\" type=\"button\" value=\"Anterior\" disabled>";
}
if ($paginas > $pagina) {
$next_link = "<input class=\"style2\" onclick=\"java script:window.location='$PHP_SELF?pagina=".$next."'\" type=\"button\" value=\"Próximo\" name=\"btnAnterior1\">";
}else{
$next_link = "<input class=\"style2\" type=\"button\" value=\"Próximo\" disabled>";
}
$painel = "";
for($x = 1; $x <= $paginas; $x++) {
$di = $pagina == $x ? 'disabled' : NULL;
$painel .= "<input class=\"style2\" ".$di." onclick=\"java script:window.location='$PHP_SELF?pagina=". $x ."';\" type=\"button\" value=\"".$x."\"> ";
}
echo "<p align=center>$prev_link $painel $next_link</p>";
?>
[/codebox]
Edição feita por: Fábio Web Arts, 17/09/2009, 17:37.
