1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| <?php
function afficherCommentaires($id){
/**
*Affiche les commentaires en fonction d'un id
*/
$query = "SELECT * FROM commentaires WHERE news_id='".$id."'";
$req = mysql_query($query);
while($row = mysql_fetch_assoc($req)){
echo '<br /><strong>'.$row['pseudo'].'</strong> A '.date("d-m-Y H:i", $row['date']).'<hr />';
echo htmlentities($row['texte']);
}
}
function ajouterCommentaire($pseudo, $contenu, $news_id){
/**
*Ajoute un commentaire
*/
$pseudo = mysql_real_escape_string($pseudo);
$contenu = mysql_real_escape_string($contenu);
$date = time();
if(!is_int($news_id))die('News ID must be int');
mysql_query("INSERT INTO commentaires VALUES('', ".$news_id.", ".pseudo.", ".$date.", ".$contenu.")")or die(mysql_error());
echo "Commentaire ajouté";
}
?> |
Partager