1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64
| <?php
$nombreDeMessagesParPage = 30;
$retour = mysql_query("SELECT COUNT(*) AS nb_imagemini FROM news WHERE plateforme='dvdrip' ");
$donnees = mysql_fetch_array($retour);
$totalDesMessages = $donnees['nb_imagemini'];
$nombreDePages = ceil($totalDesMessages / $nombreDeMessagesParPage);
?>
<?php
if (isset($_GET['page']))
{
$page = $_GET['page'];
}
else
{
$page = 1;
}
$premierMessageAafficher = ($page - 1) * $nombreDeMessagesParPage;
$reponse = mysql_query("SELECT * FROM news WHERE plateforme='dvdrip' ORDER BY titre LIMIT " . $premierMessageAafficher . ', ' . $nombreDeMessagesParPage);
?>
<table>
<?php
$uploadeur = nl2br(stripslashes($donnees['uploadeur']));
$i=0;
while ($donnees = mysql_fetch_array($reponse))
{
if ($i%6==0) echo "<tr>";
$imagemini = stripslashes($donnees['imagemini']);
$titre = stripslashes($donnees['titre']);
echo '<td VALIGN="baseline" ALIGN="center">
<a href="upload.php?id='.$donnees['id'].'" title="Posté par '.$uploadeur.'"><img width="120" height="160" src="'.$imagemini.'" /><br />' .$titre. '</a></td>';
if ($i%6==5) echo "</tr>";
$i++;
}
?>
</table>
<br /><br />
<div id="pagination">
<?php
$nombreDeMessagesParPage = 30;
$retour = mysql_query("SELECT COUNT(*) AS nb_imagemini FROM news WHERE plateforme='dvdrip' ");
$donnees = mysql_fetch_array($retour);
$totalDesMessages = $donnees['nb_imagemini'];
$nombreDePages = ceil($totalDesMessages / $nombreDeMessagesParPage);
echo 'Page : ';
for ($i = 1 ; $i <= $nombreDePages ; $i++)
{
echo '<a href="dvdrip.php?page=' . $i . 'class="actif">' . $i . '</a> ';
}
?>
</div> |
Partager