AppInfo/traitMessagerie.php at master · ErwanLP/AppInfo · GitHub

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
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
<?php

session_start();
$date = date("Y-m-d");
$message = $_POST['message'];
$idExp = $_SESSION['ID'];
$typeExp = $_SESSION['SWITCH'];
$bdd = new PDO('mysql:host=localhost;dbname=appinfo', 'root', '');

if (isset($_POST['pseudoAutre'])) {
    $pseudoDes = $_POST['pseudoAutre'];
    $pseudoDes = str_replace(' ', '', $pseudoDes);
} else {

}

$sql = 'SELECT pseudo FROM ' . $typeExp . ' WHERE ID =  "' . $idExp . '"';
echo "<br/>" . $sql;
$result = $bdd->query($sql);
while ($data = $result->fetch()) {
    $pseudoExp = $data['pseudo'];
    $pseudoExp = str_replace(' ', '', $pseudoExp);
}$result->closeCursor();


$sql = '(SELECT pseudo FROM organisateur ) UNION ( SELECT pseudo FROM participant)';
echo "<br/>" . $sql;
$result2 = $bdd->query($sql);
$test = false;
while ($data2 = $result2->fetch()) {
    if ($data2['pseudo'] == $pseudoDes) {
        $test = true;
    }
}$result->closeCursor();

if ($test == true) {
    $sql = 'INSERT INTO messagerie (ID, message, date, pseudo_exp, pseudo_des) VALUES (NULL, "' . $message . '","' . $date . '","' . $pseudoExp . '","' . $pseudoDes . '")';
    $bdd->query($sql);
    echo "<br/>" . $sql;
}


    header('Location:profil.php?target=messagerie#description');

?>


<?php

/* $result = $bdd->query('(SELECT ID FROM organisateur WHERE organisateur.pseudo =  "' . $pseudoAutre . '" ) UNION ( SELECT ID FROM participant WHERE participant.pseudo =  "' . $pseudoAutre . '" )');
  echo '(SELECT ID FROM organisateur WHERE organisateur.pseudo =  "' . $pseudoAutre . '" ) UNION ( SELECT ID FROM participant WHERE participant.pseudo =  "' . $pseudoAutre . '" )';
  $result = $bdd->query('SELECT ID FROM organisateur WHERE organisateur.pseudo =  "' . $pseudoAutre . '" ');
  echo 'SELECT ID FROM organisateur WHERE organisateur.pseudo =  "' . $pseudoAutre . '" ';
  echo "<br/>";
  echo is_array($result);
  echo "<br/>";
  /*if(!empty($result)){

  if (empty($result)) {
  echo "on ne trouve pas un profil organisateur";
  $result2 = $bdd->query('SELECT ID FROM participant WHERE participant.pseudo =  "' . $pseudoAutre . '"');
  if(empty($result2)){
  echo "on ne trouve pas de profil participant";
  echo "pseudo non trouvé";
  header('Location:messagerie.php');
  }else{
  echo "on trouve un profil participant";
  while ($data2 = $result2->fetch()) {
  $idAutre = $data2['ID'];
  }$result2->closeCursor();
  $typeAutre = "participant";
  }
  } else {
  echo "on trouve un profil organisateur";
  while ($data = $result->fetch()) {
  $idAutre = $data['ID'];
  }$result->closeCursor();
  $typeAutre = "organisateur";
  }
  }else{

  } */
?>