Código PHP:
El codigo que utilizo para la página es el siguiente:
<?php require_once('Connections/divXHispano.php'); ?>
<?php import_request_variables("g","row_");?>
<?php
$currentPage = $HTTP_SERVER_VARS["PHP_SELF"];
$maxRows_Peliculas = 25;
$pageNum_Peliculas = 0;
if (isset($HTTP_GET_VARS['pageNum_Peliculas'])) {
$pageNum_Peliculas = $HTTP_GET_VARS['pageNum_Peliculas'];
}
$startRow_Peliculas = $pageNum_Peliculas * $maxRows_Peliculas;
mysql_select_db($database_divXHispano, $divXHispano);
$query_Peliculas = "SELECT * FROM peliculas ORDER BY titulo ASC";
$query_limit_Peliculas = sprintf("%s LIMIT %d, %d", $query_Peliculas, $startRow_Peliculas, $maxRows_Peliculas);
$Peliculas = mysql_query($query_limit_Peliculas, $divXHispano) or die(mysql_error());
$row_Peliculas = mysql_fetch_assoc($Peliculas);
if (isset($HTTP_GET_VARS['totalRows_Peliculas'])) {
$totalRows_Peliculas = $HTTP_GET_VARS['totalRows_Peliculas'];
} else {
$all_Peliculas = mysql_query($query_Peliculas);
$totalRows_Peliculas = mysql_num_rows($all_Peliculas);
}
$totalPages_Peliculas = ceil($totalRows_Peliculas/$maxRows_Peliculas)-1;
$queryString_Peliculas = "";
if (!empty($HTTP_SERVER_VARS['QUERY_STRING'])) {
$params = explode("&", $HTTP_SERVER_VARS['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_Peliculas") == false &&
stristr($param, "totalRows_Peliculas") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_Peliculas = "&" . implode("&", $newParams);
}
}
$queryString_Peliculas = sprintf("&totalRows_Peliculas=%d%s", $totalRows_Peliculas, $queryString_Peliculas);
?>
<p><font face="Book Antiqua, Bookman Old Style, Century Gothic"><strong> Encontradas
<?php echo $totalRows_Peliculas ?> peliculas</strong></font></p>
<p><font face="Book Antiqua, Bookman Old Style, Century Gothic"><strong>
Mostradas de la pelicula <?php echo ($startRow_Peliculas + 1) ?> a la <?php echo min($startRow_Peliculas + $maxRows_Peliculas, $totalRows_Peliculas) ?> </strong></font></p>
<p>
<table border="0" width="50%" align="center">
<tr>
<td width="31%" align="center"> <div align="center">
<?php if ($pageNum_Peliculas > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_Peliculas=%d%s", $currentPage, max(0, $pageNum_Peliculas - 1), $queryString_Peliculas); ?>"><font face="Geneva, Arial, Helvetica, sans-serif"><strong>Página
Anterior</strong></font></a>
<?php } // Show if not first page ?>
</div></td>
<td width="23%" align="center"> <div align="center">
<?php if ($pageNum_Peliculas < $totalPages_Peliculas) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_Peliculas=%d%s", $currentPage, min($totalPages_Peliculas, $pageNum_Peliculas + 1), $queryString_Peliculas); ?>"><font face="Geneva, Arial, Helvetica, sans-serif"><strong>Página
Siguiente</strong></font></a>
<?php } // Show if not last page ?>
</div></td>
</tr>
</table>
<table width="90%" border="1" align="center" cellpadding="0" cellspacing="0">
<tr bgcolor="#FFFFCC">
<td width="72%"><strong><font face="Arial, Helvetica, sans-serif">Titulo</font></strong></td>
<td width="28%">
<div align="center"><strong><font face="Arial, Helvetica, sans-serif">Tamaño</font></strong></div></td>
</tr>
<?php do { ?>
<tr bgcolor="#FFFFCC">
<td><?php echo $row_Peliculas['titulo']; ?></td>
<td>
<div align="center"><?php echo $row_Peliculas['tamano']; ?></div></td>
<td>
<?php
echo "<a href=\"descargar_archivo.php?id=".$row_Peliculas[id]."\">Descargar</a>";
?>
</td>
</tr>
<?php } while ($row_Peliculas = mysql_fetch_assoc($Peliculas)); ?>
</table>
<table border="0" width="50%" align="center">
<tr>
<td width="31%" align="center"> <?php if ($pageNum_Peliculas > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_Peliculas=%d%s", $currentPage, max(0, $pageNum_Peliculas - 1), $queryString_Peliculas); ?>"><font face="Geneva, Arial, Helvetica, sans-serif"><strong>Página
Anterior</strong></font></a>
<?php } // Show if not first page ?> </td>
<td width="23%" align="center"> <?php if ($pageNum_Peliculas < $totalPages_Peliculas) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_Peliculas=%d%s", $currentPage, min($totalPages_Peliculas, $pageNum_Peliculas + 1), $queryString_Peliculas); ?>"><font face="Geneva, Arial, Helvetica, sans-serif"><strong>Página
Siguiente</strong></font></a>
<?php } // Show if not last page ?> </td>
</tr>
</table>
</p>
</body>
</html>
<?php
mysql_free_result($Peliculas);
?>