98 lines
3.2 KiB
PHP
98 lines
3.2 KiB
PHP
<!-- BEGIN PHP CODE PATIENT STAT PER DAY -->
|
|
<?php
|
|
//require("connect_web.php");
|
|
//require("connect_hosxp.php");
|
|
//require("date_format.php");
|
|
|
|
$sql_news2 = "select * from news order by date_add desc limit 10 "; // Download data
|
|
$result_news2 = mysqli_query($conn2, $sql_news2);
|
|
|
|
$sql_drug = "select * from drugitems order by name asc"; // Download data
|
|
$result_news2 = mysqli_query($conn2, $sql_news2);
|
|
$result_drug = mysqli_query($conn1, $sql_drug);
|
|
|
|
?>
|
|
|
|
<div class="headerpanel"> <a href="" class="showmenu"></a>
|
|
<div class="headerright">
|
|
<?php require("right_header.php"); ?>
|
|
</div>
|
|
<!--headerpanel-->
|
|
<div class="breadcrumbwidget">
|
|
<?php require("breadcrumb.php"); ?>
|
|
<div class="row-fluid">
|
|
<div class="span12">
|
|
<?php require("icon_shortcut.php"); ?>
|
|
<!-- Content -->
|
|
<h4 class="widgettitle nomargin">ข้อมูลรายการยา</span></h4>
|
|
<table class="table table-bordered" id="dyntable2" style="font-size: small;">
|
|
<colgroup>
|
|
<col class="con0" />
|
|
<col class="con1" />
|
|
<col class="con0" />
|
|
<col class="con1" />
|
|
</colgroup>
|
|
<thead>
|
|
<tr>
|
|
<!-- <th class="head0"><center>ลำดับ</center></th> -->
|
|
<th class="head0">
|
|
<center>
|
|
รหัส 24 หลัก
|
|
</center>
|
|
</th>
|
|
<th class="head0">
|
|
<center>
|
|
ชื่อยา
|
|
</center>
|
|
</th>
|
|
<th class="head0">
|
|
<center>
|
|
ความแรง
|
|
</center>
|
|
</th>
|
|
<th class="head1">
|
|
<center>
|
|
คำอธิบาย
|
|
</center>
|
|
</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php
|
|
//$i4=0;
|
|
while ($rs_drug = mysqli_fetch_array($result_drug)) {
|
|
?>
|
|
<tr class="gradeX">
|
|
<!-- <td><center><?php //echo ($i4 + 1);
|
|
?></center></td> -->
|
|
<td><?php echo $rs_drug["did"]; ?></td>
|
|
<td><?php echo $rs_drug["name"]; ?></td>
|
|
<td><?php echo $rs_drug["strength"]; ?></td>
|
|
<td><?php echo $rs_drug["therapeutic"]; ?></td>
|
|
</tr>
|
|
<?php
|
|
//$i4++;
|
|
}
|
|
?>
|
|
</tbody>
|
|
</table>
|
|
<!--widgetcontent-->
|
|
|
|
</div>
|
|
<!--span8-->
|
|
<!-- <div class="span4">
|
|
<h4 class="widgettitle nomargin">ข่าวประชาสัมพันธ์</h4>
|
|
<div class="widgetcontent bordered" style="height: 385px">
|
|
<?php while ($row_news2 = mysqli_fetch_array($result_news2)) { ?>
|
|
<p><font size="" color="#0000ff"><?php echo datetime_to_date($row_news2['date_add']); ?></font> : <?php echo $row_news2['title']; ?></p>
|
|
<?php } ?>
|
|
</div>
|
|
<!--widgetcontent
|
|
</div> -->
|
|
<!--span4-->
|
|
</div>
|
|
<!--row-fluid-->
|
|
</div>
|
|
<!--contentinner-->
|
|
</div>
|
|
<!--maincontent-->
|