EVOLUTION-MANAGER

Edit File: get_medications.php

<?php
/**
 *
 * Copyright (C) 2016-2017 Jerry Padgett <sjpadgett@gmail.com>
 * Copyright (C) 2011 Cassian LUP <cassi.lup@gmail.com>
 *
 * LICENSE: This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU General Public License
 * as published by the Free Software Foundation; either version 3
 * of the License, or (at your option) any later version.
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
 * GNU General Public License for more details.
 * You should have received a copy of the GNU General Public License
 * along with this program. If not, see <http://opensource.org/licenses/gpl-license.php>;.
 *
 * @package OpenEMR
 * @author Cassian LUP <cassi.lup@gmail.com>
 * @author Jerry Padgett <sjpadgett@gmail.com>
 * @link http://www.open-emr.org
 *
 */
        require_once("verify_session.php");

$sql = "SELECT * FROM lists WHERE pid = ? AND type = 'medication' ORDER BY begdate";

$res = sqlStatement($sql, array($pid));

if (sqlNumRows($res)>0) {
    ?>
    <table class="table table-striped">
        <tr>
        <th><?php echo xlt('Drug'); ?></th>
        <th><?php echo xlt('Start Date'); ?></th>
        <th><?php echo xlt('End Date'); ?></th>
        <th><?php echo xlt('Referrer'); ?></th>
        </tr>
    <?php
    $even=false;
    while ($row = sqlFetchArray($res)) {
        echo "<tr class='".text($class)."'>";
        echo "<td>".text($row['title'])."</td>";
        echo "<td>".text($row['begdate'])."</td>";
        echo "<td>".text($row['enddate'])."</td>";
        echo "<td>".text($row['referredby'])."</td>";
        echo "</tr>";
    }

echo "</table>";
} else {
    echo xlt("No Results");
}
?>