<?php
/* -----------------------------------------------------------------*/
/* Mural de Recados By Adenilson Tozeski */
/* Todos os Direitos Reservados */
/* -----------------------------------------------------------------*/
require_once('Connections/local.php'); ?>
<?php
$currentPage = $HTTP_SERVER_VARS["PHP_SELF"];
$maxRows_result = 10;
$pageNum_result = 0;
if (isset($HTTP_GET_VARS['pageNum_result'])) {
$pageNum_result = $HTTP_GET_VARS['pageNum_result'];
}
$startRow_result = $pageNum_result * $maxRows_result;
mysql_select_db($database_local, $local);
$query_result = "SELECT * FROM recados ORDER BY `id` desc";
$query_limit_result = sprintf("%s LIMIT %d, %d", $query_result, $startRow_result, $maxRows_result);
$result = mysql_query($query_limit_result, $local) or die("A query falhou: " . mysql_error());
$row_result = mysql_fetch_array($result);
if (isset($HTTP_GET_VARS['totalRows_result'])) {
$totalRows_result = $HTTP_GET_VARS['totalRows_result'];
} else {
$all_result = mysql_query($query_result);
$totalRows_result = mysql_num_rows($all_result);
}
$totalPages_result = ceil($totalRows_result/$maxRows_result)-1;
$queryString_result = "";
if (!empty($HTTP_SERVER_VARS['QUERY_STRING'])) {
$params = explode("&", $HTTP_SERVER_VARS['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_result") == false &&
stristr($param, "totalRows_result") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_result = "&" . implode("&", $newParams);
}
}
$queryString_result = sprintf("&totalRows_result=%d%s", $totalRows_result, $queryString_result);
?>
<html>
<head>
<title>LordSonic.com - Recados</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="stl.css" rel="stylesheet" type="text/css">
<link href="stilo" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#FFFFFF" topmargin="0" >
<div align="left"></div>
<table width="600" border="0" align="center" >
<tr align="center" valign="top">
<td height="265" colspan="4" nowrap class="rodape" > <p align="center"><img src="imagens/recados.gif" width="132" height="28">
<p align="center" class="text">
<table width="100%" border="0">
<tr>
<td height="124">
<p align="center">
<?php do { ?>
<table width="100%" border="0">
<tr>
<td height="20" class="text"><b>Mensagem N° <?php echo $row_result['id']; ?></b></td>
<td class="text"><div align="right"><b><?php echo $row_result['data']; ?> </b></div></td>
</tr>
<tr>
<td height="9" class="text"><b>De:</b> <?php echo $row_result['de']; ?></td>
<td class="text"> </td>
</tr>
<tr>
<td height="20" class="text"><b>Para:</b> <?php echo $row_result['para']; ?></td>
<td> </td>
</tr>
<tr>
<td height="21" colspan="2" valign="bottom" class="text"><?php echo nl2br ($row_result['msg']);?> </td>
</tr>
<tr>
<td height="21" colspan="2" valign="bottom" class="text"><hr></td>
</tr>
</table></div>
<div align="center">
<?php } while ($row_result = mysql_fetch_assoc($result)); ?> </td>
</tr>
</table>
<p align="center"> </td>
</tr>
<tr>
<td width="291" class="style">
<div align="right"><span class="text"> <b>Páginas: </b> </span></div></td>
<td width="2" class="style"> </td>
<td width="300" class="style"><span class="text">
<a href="<?php printf("%s?pageNum_result=%d%s", $currentPage, 0, $queryString_result); ?>">Primeira</a>
<a href="<?php printf("%s?pageNum_result=%d%s", $currentPage, max(0, $pageNum_result - 1), $queryString_result); ?>"><</a>
<a href="<?php printf("%s?pageNum_result=%d%s", $currentPage, min($totalPages_result, $pageNum_result + 1), $queryString_result); ?>">></a>
<a href="<?php printf("%s?pageNum_result=%d%s", $currentPage, $totalPages_result, $queryString_result); ?>">
Última</a></span></td>
</tr>
<tr>
<td height="10" colspan="3" class="rodape"> </td>
</tr>
<tr>
<td height="14" colspan="3" class="text">
<div align="center"></div></td>
</tr>
</table>
<div align="left">
<p align="left"> </p>
</div>
</body>
</html>
<?php
mysql_free_result($result);
?>
O que devo fazer no código para deixar a paginação como eu quero??
