<? |
02 | // Include de la connexion sql |
03 | include('sql.php') ; |
04 | // Requete sql pour récupérer les news |
05 | $requete_news = mysql_query("SELECT * FROM news ORDER BY id DESC",$connexion); |
06 | $news = mysql_num_rows($requete_news); |
07 | ?> |
08 | <u>Toutes les news du site</u> |
09 |
10 | <? |
11 | $i = 0; |
12 | while ($i < $news) { |
13 | // Variables date |
14 | $date = mysql_result($requete_news,$i,"date"); |
15 | $annee = date("Y", $date); |
16 | $mois = date("m", $date); |
17 | $jour = date("d", $date); |
18 | $heure = date("H", $date); |
19 | $minute = date("i", $date); |
20 | $date = $jour."/".$mois."/".$annee." à ".$heure."h".$minute; |
21 | // Autres variables |
22 | $titre = mysql_result($requete_news,$i,"titre"); |
23 | $source = mysql_result($requete_news,$i,"source"); |
24 | $texte = mysql_result($requete_news,$i,"texte"); |
25 | // Affichage de la news // |
26 | // Titre |
27 | echo '<table border="0" bgcolor="#000000" width="550"><tr><td width="50%" colspan="2" bgcolor="#FFFFFF"><center>'.$titre.'</center></td></tr>'; |
28 | // Date |
29 | echo '<tr><td width="50%" bgcolor="#FFFFFF">News ajoutée le '.$date.'</td>'; |
30 | // Source |
31 | echo '<td width="50%" bgcolor="#FFFFFF"><center><u>Source :</u> '.$source.'<center></td></tr>'; |
32 | // Texte |
33 | echo '<tr><td colspan ="2" bgcolor="#FFFFFF">'.nl2br($texte).'</td></tr></table>'; |
34 | $i++; } |
35 | ?> |