Codelyokodd

<?php 

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

        <p>Que pensez-vous de Simsophiles? Exprimez-vous ici en laissant un petit message.</p>
        <p>
            <center><h3>Pseudo :</h3> <input name="pseudo" /></center><br />
			 <center><h3>Message :</h3><br />
            <textarea name="message" rows="8" cols="35"></textarea></center><br />
			<center><script type="text/javascript" src="http://api.recaptcha.net/challenge?k=6LcZKgcAAAAAAG3DrfByjni9nZXFoR-vj9im2lR7  "></script>

	<noscript>
  		<iframe src="http://api.recaptcha.net/noscript?k=6LcZKgcAAAAAAG3DrfByjni9nZXFoR-vj9im2lR7  " height="300" width="500" frameborder="0"></iframe><br/>
  		<textarea name="recaptcha_challenge_field" rows="3" cols="40"></textarea>
  		<input type="hidden" name="recaptcha_response_field" value="manual_challenge"/>
	</noscript>			<em>Type the two words = Recopiez les deux mots</em></center><br /><br />
			
            <center><input type="reset" value="Tout Effacer" /><input type="submit" value="Envoyer" /></center>
        </p>
    </form>
 
    <p class="pages">
 

 
 <?php
mysql_connect("???", "????", "????");
mysql_select_db("?????");
 
 
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); 

$privatekey = "6LcZKgcAAAAAAHeC40a0lHva-wOINuw_wv_TpE8X";
$resp = recaptcha_check_answer ($privatekey,$_SERVER["REMOTE_ADDR"], $_POST["recaptcha_challenge_field"], $_POST["recaptcha_response_field"]);

if (!$resp->is_valid)
{
die("Le captcha entré est invalide. Veuillez-recommencer" . "(Captcha : " . $resp->error . ")");
}

else
{

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

 $nombreDeMessagesParPage = 10; 

$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 livreor ORDER BY id DESC LIMIT ' . $premierMessageAafficher . ', ' . $nombreDeMessagesParPage);
 
while ($donnees = mysql_fetch_array($reponse))
{
        echo '<p><strong>' . $donnees['pseudo'] . '</strong> a &eacute;crit :<br />'  . $donnees['message'] . '</p>';
}
 
mysql_close(); 

 ?>