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
|
if (isset($_POST['page']))
{
$page=$_POST['page'];
}
else {
$page=1;
}
$depart=($page-1)*10;
mysql_connect("localhost", "root", "") or die("probleme connexion");
mysql_select_db("messagerie") or die("probleme bd");
$requete ="select * from message order by id DESC LIMIT ".$depart. ",10";
$reponse = mysql_query ($requete) or die ("pb");
echo '<br/><br/><div>';
while ($donnees = mysql_fetch_array ($reponse))
{
echo '<strong>'.$donnees['id']."/".$donnees['psedo']." : </strong>".$donnees['message']."<br/>";
}
echo '</div><p>';
$reponse = mysql_query('SELECT count(*) AS nb FROM message');
$donnees = mysql_fetch_array($reponse);
$nb_messages = $donnees['nb'];
$nb_pages = ceil($nb_messages/10) ;
for($i=1;$i<=$nb_pages;$i++)
{
echo '<a href="messagerie.php?page='.$i.'">'.$i.'</a> ';
} |
Partager