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
|
$sql = 'SELECT *
FROM
(
-- Commentaires reçus par le user 57
SELECT c.id, c.sender,c.reference, c.opinion, c.commentaire, c.date,
u.login
FROM commentaires AS c
INNER JOIN user AS u ON u.id = c.sender
WHERE c.target = :idConsultedProfile
UNION
-- Commentaires envoyés par le user 57
SELECT c.id, c.sender,c.reference, c.opinion, c.commentaire, c.date,
u.login
FROM commentaires AS c
INNER JOIN user AS u ON u.id = c.sender
WHERE c.sender = :idConsultedProfile
) AS tmp
ORDER BY reference DESC, date DESC
';
$req = $dbh->prepare($sql);
$valeurs = array(':idConsultedProfile'=>$idProfile);
$req->execute($valeurs);
while($data = $req->fetch(PDO::FETCH_OBJ)):
//Récupération des statuts statut1/statut2 pour chaque commentaire posté
$reference = $data->reference;
$sql = 'SELECT statut1, statut2
FROM listing AS l
WHERE l.id=:reference
UNION
SELECT statut1, statut2
FROM listing_archive AS l_arch
WHERE l_arch.id=:reference
LIMIT 1
';
$req = $dbh->prepare($sql);
$valeurs = array(':reference'=>$reference);
$req->execute($valeurs);
$donnees = $req->fetch(PDO::FETCH_OBJ);
$donnees->statut1;
endwhile; |
Partager