[Résolu] problème livre d'or - Version imprimable

Code PHP :
<?php 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

 

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang=fr">

   <head>

       <title>Livre d'or</title>

        <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

 

        <style type="text/css">

        form, .pages

        {

            text-align:center;

        }

        </style>

    </head>

    <body>

 

    <form method="post" action="livreor.php">

        <p>Mon site vous plaît ? Laissez-moi un message !</p>

        <p>

            Pseudo : <input name="pseudo" /><br />

            Message :<br />

            <textarea name="message" rows="8" cols="35"></textarea><br />

            <input type="submit" value="Envoyer" />

        </p>

    </form>

 

    <p class="pages">

 

<?php

mysql_connect("localhost", "root", "");

mysql_select_db("test");

 

 

if (isset($_POST['pseudo']) AND isset($_POST['message']))

{

    $pseudo = mysql_real_escape_string(htmlspecialchars($_POST['pseudo'])); 

    $message = mysql_real_escape_string(htmlspecialchars($_POST['message'])); 

    $message = nl2br($message); 

 

    

    mysql_query("INSERT INTO livreor VALUES('', '" . $pseudo . "', '" . $message . "')");

}

 



 



$nombreDeMessagesParPage = 20; 



$retour = mysql_query('SELECT COUNT(*) AS nb_messages FROM livreor');

$donnees = mysql_fetch_array($retour);$totalDesMessages = $donnees['nb_messages'];



$nombreDePages  = ceil($totalDesMessages / $nombreDeMessagesParPage);



echo 'Page : ';

for ($i = 1 ; $i <= $nombreDePages ; $i++)

{

    echo '<a href="livreor.php?page=' . $i . '">' . $i . '</a> ';

}

?>

 

</p>

 

<?php

 

if (isset($_GET['page']))

{

        $page = $_GET['page']; 

}

else 

{

        $page = 1; 

}

 



$premierMessageAafficher = ($page - 1) * $nombreDeMessagesParPage;

 

$reponse = mysql_query('SELECT * FROM tutos.livreor ORDER BY id DESC LIMIT ' . $premierMessageAafficher . ', ' . $nombreDeMessagesParPage);

 

while ($donnees = mysql_fetch_array($reponse))

{

        echo '<p><gras>' . $donnees['pseudo'] . '</gras> a écrit :<br />' . $donnees['message'] . '</p>';

}

 

mysql_close(); 

?>

 

</body>

</html>