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                 ?>
  18                 <table class="class1">
  19                         <tr class="header">
  20                                 <th><?php echo htmlspecialchars( xl('Drug'),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                         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                 echo "</table>";
  43         }
  44         else
  45         {
  46                 echo htmlspecialchars( xl("No Results"),ENT_NOQUOTES);
  47         }
  48 ?>