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
|
mysql_connect("localhost", "$user_db", "$pass_db");
mysql_select_db("$nom_db");
mysql_query("SET NAMES UTF8");
if (isset($_POST['pseudo']) AND isset($_POST['message']))
{
$pseudo = mysql_real_escape_string(htmlspecialchars($_POST['pseudo']));
$message = htmlentities($_POST['message'], ENT_QUOTES, 'UTF-8');
mysql_query("INSERT INTO forum VALUES('', '" . $pseudo . "', '" . $message . "', '".date("Y-m-d H:i:s")."')");
$nombreDeMessagesParPage = 20;
$retour = mysql_query('SELECT COUNT(*) AS nb_messages FROM forum');
$donnees = mysql_fetch_array($retour);
$totalDesMessages = $donnees['nb_messages'];
$nombreDePages = ceil($totalDesMessages / $nombreDeMessagesParPage);
echo 'Aller à la page : ';
for ($i = 1 ; $i <= $nombreDePages ; $i++)
{
echo '<a href="?rep=/forum&page=' . $i . '">' . $i . '</a> ';
}
echo '</p>';
if (isset($_GET['page']))
{
$page = $_GET['page'];
}
else
{
$page = 1;
}
$premierMessageAafficher = ($page - 1) * $nombreDeMessagesParPage;
$reponse = mysql_query('SELECT * FROM forum ORDER BY id DESC LIMIT ' . $premierMessageAafficher . ', ' . $nombreDeMessagesParPage);
while ($donnees = mysql_fetch_array($reponse))
{
sscanf($donnees['date'], "%4s-%2s-%2s %2s:%2s:%2s", $an, $mois, $jour, $heure, $min, $sec);
$pseudo_af = $donnees['pseudo'];
$message_af = nl2br(html_entity_decode($donnees['message'], ENT_QUOTES, 'UTF-8'));
echo "<p style='border-top: 1px solid;'></p><h2 style='margin-left: 0pt;'>$pseudo_af</h2>$message_af<h5 style='text-align: right;'>le : $jour/$mois/$an à $heure:$min:$sec</h5>";
}
echo '<p style="border: 1px solid;"></p>';
mysql_close(); |
Partager