patients/get_medications.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 = 'medication' 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('Drug'), ENT_NOQUOTES); ?></th>
  20         <th><?php echo htmlspecialchars(xl('Start Date'), ENT_NOQUOTES); ?></th>
  21         <th><?php echo htmlspecialchars(xl('End Date'), ENT_NOQUOTES); ?></th>
  22         <th><?php echo htmlspecialchars(xl('Referrer'), ENT_NOQUOTES); ?></th>
  23         </tr>
  24     <?php
  25     $even=false;
  26     while ($row = sqlFetchArray($res)) {
  27         if ($even) {
  28             $class="class1_even";
  29             $even=false;
  30         } else {
  31             $class="class1_odd";
  32             $even=true;
  33         }
  34
  35         echo "<tr class='".htmlspecialchars($class, ENT_QUOTES)."'>";
  36         echo "<td>".htmlspecialchars($row['title'], ENT_NOQUOTES)."</td>";
  37         echo "<td>".htmlspecialchars($row['begdate'], ENT_NOQUOTES)."</td>";
  38         echo "<td>".htmlspecialchars($row['enddate'], ENT_NOQUOTES)."</td>";
  39         echo "<td>".htmlspecialchars($row['referredby'], ENT_NOQUOTES)."</td>";
  40         echo "</tr>";
  41     }
  42
  43     echo "</table>";
  44 } else {
  45     echo htmlspecialchars(xl("No Results"), ENT_NOQUOTES);
  46 }
  47 ?>