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
|
$target = (int)$_GET['id'];
//Tous les commentaires postés sur le profil de Jean
$sql = 'SELECT c.opinion,c.commentaire,c.date,c.sender,user.login
FROM comment_profile AS c
LEFT JOIN user ON user.id=c.sender
WHERE target=:target
ORDER BY date DESC';
$req = $dbh->prepare($sql);
$valeurs = array(':target'=>$target);
$req->execute($valeurs);
while($data = $req->fetch(PDO::FETCH_OBJ)):?>
<div class="com">
<span class="auteur"><a href="profile.php?id=<?php echo $data->sender; ?>"><?php echo $data->login;?></a></span>
<span class="opinion">
<?php
$opinion = $data->opinion;
if($opinion==3) $opinion = "Positif";
elseif($opinion==2) $opinion = "Neutre";
elseif($opinion==1) $opinion = "Négatif";
echo $opinion;
?>
</span>
<p><?php echo htmlentities($data->commentaire,ENT_QUOTES,'UTF-8');?></p>
<span class="date"><?php echo $data->date;?></span>
<?php
//Si Marc écrit un commentaire C sur le profil de Jean, il faut que les //commentaires de Jean sur le profil de Marc apparaissent également sur son //propre profil sous le commentaire C.
$myTarget = $data->sender;
$sql = 'SELECT c.opinion,c.commentaire,c.date,c.sender,user.login
FROM comment_profile AS c
LEFT JOIN user ON user.id=c.sender
WHERE target=:target AND sender=:sender
ORDER BY date DESC';
$req = $dbh->prepare($sql);
$valeurs = array(':target'=>$myTarget,
':sender'=>$target);
//$target est Jean: tous les messages que Jean à envoyé sur le profil de Marc
//on affiche ces messages sur le profil de Jean (en-dessous du commentaire de Marc)
while($data_trust = $req->fetch(PDO::FETCH_OBJ)):?>
<span class="auteur"><a href="profile.php?id=<?php echo $data_trust->sender; ?>"><?php echo $data_trust->login;?></a></span>
<span class="opinion">
<?php
$opinion = $data_trust->opinion;
if($opinion==3) $opinion = "Positif";
elseif($opinion==2) $opinion = "Neutre";
elseif($opinion==1) $opinion = "Négatif";
echo $opinion;
?>
</span>
<p><?php echo htmlentities($data_trust->commentaire,ENT_QUOTES,'UTF-8');?></p>
<span class="date"><?php echo $data_trust->date;?></span>
<?php endwhile;?>
</div>
<?php endwhile;?> |
Partager