cé bon ou pas ? :
< !DOCTYPE html PUBLIC " -//W3C//DTD XHTML 1.1//EN" " http://www.w3.org/TR/xhtmml11/DTD/xhtml11.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">
< ?
mysql_connect("localhost", " sdz", " mot_de_passe");
mysql_select_db("coursphp");
if ( isset($_POST[´pseudo´]) AND isset($_POST[´message´]))
{
$pseudo = htmlentities($_POST[´pseudo´], ENT_QUOTES);
$message = htmlentities($_POST[´message´], ENT_QUOTES);
$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>
< ?
if ( isset($_GET[´page´]))
{
$page = $_GET[´page´];
}
else
{
$page = 1;
}
$premierMessageAafficher = ( $page - 1) * $nombreDeMessagesParPage;
$reponse = mysql_query(´SELECT * FROM livreor ORDER BY id DESC LIMIT ´ . $premierMessageAafficher . ´, ´ . $nombreDeMessagesParPage);
while ( $donnees = mysql_fetch_array($reponse))
{
echo ´<p><strong>´ . $donnees[´pseudo´] . ´</strong> a écrit :<br / >´ . $donnees[´message´] . ´</p>´;
}
mysql_close();
? >
< /body>
< /html>