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 65
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Document sans titre</title>
</head>
<body>
<?php
if (isset($_POST['pseudo']) AND isset($_POST['message'])){
if($_POST['pseudo']!=$donnees['pseudo'] AND $_POST['message']!=$donnees['message']){
$pseudo=htmlentities($_POST['pseudo']);
$message=htmlentities($_POST['message']);
mysql_connect("mysql5-2","thomascatest","7ws6xjjt");
mysql_select_db("thomascatest");
mysql_query("INSERT INTO livreor(ID, pseudo, message) VALUES('', '$pseudo', '$message')");
mysql_close();
}
}
?>
<p>
Mon site vous plait ? Laissez-moi un message !
</p>
<form method="post" action="test.php">
pseudo : <br/><input type="text" name="pseudo" /><br/>
Message :<br/>
<textarea name="message" rows="8" cols="45">
</textarea>
<br/>
<input type="submit" value="envoyer" />
</form>
<?php
mysql_connect("mysql5-2","thomascatest","7ws6xjjt");
mysql_select_db("thomascatest");
$retour = mysql_query('SELECT COUNT(*) AS nbr_entrees FROM livreor');
$donnees = mysql_fetch_array($retour);
$totalDesMessages=$donnees['nbr_entrees'];
$nombreDeMessagesParPage=10;
$nombreDePages=ceil($totalDesMessages/$nombreDeMessagesParPage);
echo "le nombre total de message est :".$totalDesMessages."<br/>";
echo "le nombre total de page est :".$nombreDePages."<br/>";
for($i=1;$i<=$nombreDePages;$i++){
echo '<a href="test.php?page='.$i.'">'.$i.'</a>'." ";
}
?>
Pages <br/>
<?php
if (isset($_GET['page'])){
$page=$_GET['page'];
}
else
{
$page=1;
}
$premierMessage=($page-1)*$nombreDeMessagesParPage;
$reponse=mysql_query("SELECT * FROM livreor ORDER BY ID DESC LIMIT $premierMessage,$nombreDeMessagesParPage");
while ($donnees = mysql_fetch_array($reponse))
{
echo $donnees['pseudo']."<br/>";
}
mysql_close();
?>
</body>
</html> |
Partager