patients/get_allergies.php

   1 <?php
   2  // Copyright (C) 2011 Cassian LUP <cassi.lup@gmail.com>
   3  //
   4  // This program is free software; you can redistribute it and/or
   5  // modify it under the terms of the GNU General Public License
   6  // as published by the Free Software Foundation; either version 2
   7  // of the License, or (at your option) any later version.
   8
   9         require_once("verify_session.php");
  10
  11         $sql = "SELECT * FROM lists WHERE pid = ? AND type = 'allergy' ORDER BY begdate";
  12
  13         $res = sqlStatement($sql, array($pid));
  14
  15 if (sqlNumRows($res)>0) {
  16     ?>
  17     <table class="class1">
  18         <tr class="header">
  19     <th><?php echo htmlspecialchars(xl('Title'), ENT_NOQUOTES); ?></th>
  20     <th><?php echo htmlspecialchars(xl('Reported Date'), ENT_NOQUOTES); ?></th>
  21     <th><?php echo htmlspecialchars(xl('Start Date'), ENT_NOQUOTES); ?></th>
  22     <th><?php echo htmlspecialchars(xl('End Date'), ENT_NOQUOTES); ?></th>
  23     <th><?php echo htmlspecialchars(xl('Referrer'), ENT_NOQUOTES); ?></th>
  24         </tr>
  25     <?php
  26     $even=false;
  27     while ($row = sqlFetchArray($res)) {
  28         if ($even) {
  29             $class="class1_even";
  30             $even=false;
  31         } else {
  32             $class="class1_odd";
  33             $even=true;
  34         }
  35
  36         echo "<tr class='".$class."'>";
  37         echo "<td>".htmlspecialchars($row['title'], ENT_NOQUOTES)."</td>";
  38         echo "<td>".htmlspecialchars($row['date'], ENT_NOQUOTES)."</td>";
  39         echo "<td>".htmlspecialchars($row['begdate'], ENT_NOQUOTES)."</td>";
  40         echo "<td>".htmlspecialchars($row['enddate'], ENT_NOQUOTES)."</td>";
  41         echo "<td>".htmlspecialchars($row['referredby'], ENT_NOQUOTES)."</td>";
  42         echo "</tr>";
  43     }
  44
  45     echo "</table>";
  46 } else {
  47     echo htmlspecialchars(xl("No Results"), ENT_NOQUOTES);
  48 }
  49 ?>