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
|
<?php
function Tronquer_Texte($str, $longueurMax = 150, $suffixe = '...'){
$subString = substr(trim($str), 0, $longueurMax);
if(strlen($subString) < strlen($str)){
$pos = strrpos($subString, ' ');
if($pos !== false){
$str = substr($subString, 0, $pos);
$disallowed = array(',', '.', ':');
$last_char = substr($str, -1, 1);
if(in_array($last_char, $disallowed)){
$str = substr($str, 0, -1);
}
$str .= $suffixe;
}
else{
$str = $subString;
}
}
return $str;
}
$dossier = 'images/';
$sql="SELECT n.`id`, n.`titre`, n.`contenu`, n.`date`, n.`image`, COUNT(c.`id`) AS nb_comments
FROM `news` AS n
LEFT JOIN `comment` AS c ON n.`id` = c.`news_id`
GROUP BY n.`id`
ORDER BY n.`date` DESC ;";
$req = mysql_query($sql) or die(mysql_error());
while($data=mysql_fetch_assoc($req))
{
$id=$data["id"];
$filename=$dossier.$data['image'];
echo '<img src="'.$filename.'" alt="" />';
echo "<p>{$data["titre"]} -- ";
echo "<p>".Tronquer_Texte($data["contenu"], 50)."<br><a href='adresse.html'>Suite de l'article</a></p>";
echo "<p align=\"right\">".date("j/n/Y G:i",strtotime($data["date"]))."</p>";
echo "<p><a href=\"formcom.php?id={$data["id"]}\"> Cliquez ici pour ajouter un commentaire </a></p>";
echo" Commentaire(s) ({$data["nb_comments"]})<br><br><br><br><br>";
}
?> |
Partager