retourne qu'une seule valeur sur deux
Bonjour,
je traite dans un fichier des datas et les inscrit dans ma base de donnée sur 1 ligne. il y a dans l'enregistrement de la ligne de la base de donnée un champs message et un champ fichier.
je cherche à retourner séparé le champ message et le champ fichier mais ça me retourne que l'un des deux? peut être une erreur dans mon fichier? quand je traite se fichier, la base de donnée est déjà remplie. je soupçonne que ça doit venir du $d['result'], il ne traite qu'une seule donnée je suppose?
Code:
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
| if ($_POST['action'] == 'getMessage')
{
$lastid = floor($lastid);
$sql = "SELECT * FROM messages WHERE mess_id > $lastid AND mess_ann_id = $ann_id";
$req = $bdd->query($sql);
$d['result'] = '';
$d['lastid'] = $lastid;
$requete = $bdd -> query("SELECT * FROM messages ORDER BY mess_id DESC ");
$donnees = $requete -> fetch();
$cote=$donnees['mess_cote'];
$fileoui=$donnees['mess_c_nomfcode'];
$message=$donnees['mess_c_message'];
$nomf=$donnees['mess_c_nomf'];
if($fileoui!='' and $message!=''){ //traite le message à retourner
while ($data = $req->fetch())
{
if($cote=='G')
{
$d['result'] .= ' <br><div style="width:290px; height:auto;background :#ced4e1;border-radius:30px 15px ;margin-auto;word-wrap:break-word;float: left;clear:both; left;text-align:left;margin: 10px;padding:10px;"><span style="color:black"> posté par:</span> <span style="color:black"><strong>'.$data['mess_c_postepar'].'</strong></span><br><span style="color:black">'.htmlentities(utf8_decode($data['mess_c_message'])).'</span><br><font size="2"><span style="color:black">'.$data['mess_c_date'].'</span> <span style="color:black">'.$data['mess_c_heure'].'</span></font><br>';
$d['lastid'] = $data['mess_id'];
}if($cote=='D')
{
$d['result'] .= ' <br><div style="width:290px; height:auto;background :#225bea;border-radius:30px 15px ;margin-auto;word-wrap:break-word;float: right;clear:both; right;text-align:left;margin: 10px;padding:10px;"><span style="color:white"> posté par:</span> <span style="color:white"><strong>'.$data['mess_c_postepar'].'</strong></span><br><span style="color:white">'.htmlentities(utf8_decode($data['mess_c_message'])).'</span><br><font size="2"><span style="color:white">'.$data['mess_c_date'].'</span> <span style="color:white">'.$data['mess_c_heure'].'</span></font><br>';
$d['lastid'] = $data['mess_id'];
}
}
}
$lastid = floor($lastid);
$sql2 = "SELECT * FROM messages WHERE mess_id > $lastid AND mess_ann_id = $ann_id";
$req2 = $bdd->query($sql2);
$d['result'] = '';
$d['lastid'] = $lastid;
if($fileoui!='' and $nomf!=''){ //traite le fichier à retourner
while ($data = $req2->fetch())
{
if($cote=='G')
{
$d['result'] .= '<br><div style="width:290px; height:auto;background :#ced4e1;border-radius:30px 15px ;margin-auto;word-wrap:break-word;float: left;clear:both; left;margin: 10px;text-align:left;padding:10px; "><span style="color:black"> envoyé par:</span> <span style="color:black"><strong>'.$data['mess_c_postepar'].'</strong></span><br><span style="color:black"><strong>fichier</strong></span><br><span style="color:black">nom: <a href="https://trouvezvotrebonheur.com/nouveausite/images/ads/imagesconversation/'.$data['mess_c_nomfcode'].'"style="color:#FF0000;"><strong>'.$data['mess_c_nomf'].'</strong><br>
<div class="text-center mt-3"><img width="200" height="150" src="https://trouvezvotrebonheur.com/nouveausite/images/ads/imagesconversation/'.$data['mess_c_nomfcode'].'"/></div></a><br><span style="color:black">taille: </span><span style="color:black">'.$data['mess_c_taillef'].'</span> <span style="color:black">bytes</span><br></span><font size="2"><span style="color:black">'.$data['mess_c_date'].'</span> <span style="color:black">'.$data2['mess_c_heure'].'</span></font></div><br>';
$d['lastid'] = $data['mess_id'];
}if($cote=='D')
{
$d['result'] .= '<br><div style="width:290px; height:auto;background :#225bea;border-radius:30px 15px ;margin-auto;word-wrap:break-word;float: right;clear:both; right;text-align:left;margin: 10px;padding:10px; "><span style="color:white"> envoyé par:</span> <span style="color:white"><strong>'.$data['mess_c_postepar'].'</strong></span><br><span style="color:white"><strong>fichier</strong></span><br><span style="color:white">nom: <a href="https://trouvezvotrebonheur.com/nouveausite/images/ads/imagesconversation/'.$data['mess_c_nomfcode'].'"style="color:#FF0000;"><strong>'.$data['mess_c_nomf'].'</strong><br>
<div class="text-center mt-3"><img width="200" height="150" src="https://trouvezvotrebonheur.com/nouveausite/images/ads/imagesconversation/'.$data['mess_c_nomfcode'].'"/></div></a><br><span style="color:white">taille: </span><span style="color:white">'.$data['mess_c_taillef'].'</span> <span style="color:white">bytes</span><br></span><font size="2"><span style="color:white">'.$data['mess_c_date'].'</span> <span style="color:white">'.$data['mess_c_heure'].'</span></font></div><br>';
$d['lastid'] = $data['mess_id'];
}
} |
