statAnimal.php 2.1 KB
Newer Older
Osvaldo Valdivia Salas's avatar
Osvaldo Valdivia Salas committed
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
<html>
<head>
  <title>Exercice</title>
  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  <link rel="stylesheet" type="text/css" href="style.css">
  </head>
<body>
  <?php
    $vHost = 'tuxa.sme.utc';
    $vPort = '5432';
    $vData = 'dbbdd0p117';
    $vUser = 'bdd0p117';
    $vPass = 'LpIHl1sZ';
    try{
      $vConn = new PDO("pgsql:host=$vHost;port=$vPort;dbname=$vData", $vUser, $vPass);
    } catch(PDOException $e){
      echo "Erreur de connection '$e'";
    }
    $idAnimal = $_POST['idAnimal'];

    if($idAnimal == ""){
        echo "Il faut dire quel animal";
        header('Location: http://tuxa.sme.utc/~bdd0p117/animal.php');
      }
  ?>

  <h1>Quantité de médicament prescrite à un animal</h1>
  <table border="1">
    <tr>
      <th>Medicament</th>
      <th>Somme</th>
    </tr>
    <?php

    try{
      $vSql ="SELECT P.nomMolec as medicament, COUNT(*) as quantite_prescrite
        FROM Posologie P JOIN Traitement T on P.traitement=T.idTraitement
        WHERE T.idAnimal=' $idAnimal'
        GROUP BY P.nomMolec;
      ";


      $vSt = $vConn->prepare($vSql);
      $vSt->execute();
      while ($vResult = $vSt->fetch(PDO::FETCH_BOTH)) {
        echo '<tr>';
        echo "<td>$vResult[0]</td>";
        echo "<td>$vResult[1]</td>";
        echo '</tr>';
      }
    } catch(PDOException $e){
      echo "Erreur de requete '$e'";
    }
    ?>
  </table>


  <h1>Nombre des comprimés prescrit à un animal
  </h1>
  <table border="1">
    <tr>
      <th>Medicament</th>
      <th>Somme</th>
    </tr>
    <?php

    try{
        $vSql ="SELECT P.nomMolec,SUM(P.duree*P.nbJourna) FROM Posologie P
          JOIN Traitement T ON P.traitement=T.idTraitement WHERE
          T.idAnimal='$idAnimal'  group by P.nomMolec;
        ";


        $vSt = $vConn->prepare($vSql);
        $vSt->execute();
        while ($vResult = $vSt->fetch(PDO::FETCH_BOTH)) {
          echo '<tr>';
          echo "<td>$vResult[0]</td>";
          echo "<td>$vResult[1]</td>";
          echo '</tr>';
        }
    } catch(PDOException $e){
      echo "Erreur de requete '$e'";
    }

    ?>
  </table>
</body>
</html>