-
Notifications
You must be signed in to change notification settings - Fork 1
/
staff_medicine.php
97 lines (80 loc) · 2.51 KB
/
staff_medicine.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
<?php
include('header_staff.php');
session_start();
if(!isset($_SESSION["id"]) || $_SESSION["status"] != 3){
header("location: logout.php");
} else {
$id = $_SESSION["id"];
}
?>
<div class="jumbotron">
<div class="container">
<h2 class="text-center">Patients waiting for medicine</h2>
</div>
</div>
<div class="container">
<div class="col-md-12">
<div class="table-responsive">
<table class="table table-bordered">
<thead>
<tr>
<th>Student's ID</th>
<th>Name</th>
<th>Age</th>
<th>Blood Group</th>
<th>Weight (kg)</th>
<th>Height (m)</th>
<th>Symptoms</th>
<th>Analysis</th>
<th>Prescription</th>
<th>Status</th>
</tr>
</thead>
<tbody>
<?php
$sql = "select * from patients where status='1' order by status_medicine asc, id asc";
$result=mysql_query($sql);
$count = mysql_num_rows($result);
while( $row =mysql_fetch_assoc( $result )){
$id = $row['id'];
$roll = $row['roll'];
$name = $row['name'];
$age = $row['age'];
$blood_group = $row['blood_group'];
$weight = $row['weight'];
$height = $row['height'];
$symptoms = $row['symptoms'];
$analysis = $row['analysis'];
$rx = $row['rx'];
$status = $row['status_medicine'];
if($status == 0){
$status = "<b><font color='red'><a href=\"staff_medicine_patient.php?id=$id\"><b>Pending</b></a></font></b>";
} else {
$status = "<b><font color='green'>Done</font></b>";
}
echo "<td><b>$roll</b> </td>
<td>$name</td>
<td>$age</td>
<td>$blood_group</td>
<td>$weight</td>
<td>$height</td>
<td><p>$symptoms</p></td>
<td><p>$analysis</p></td>
<td><p>$rx</p></td>
<td>$status</td>
</tr>
";
}
?>
</tbody>
</table>
</div>
</div>
</div>
<?php include('footer.php') ?>
<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
<!-- Include all compiled plugins (below), or include individual files as needed -->
<script src="js/bootstrap.min.js"></script>
</body>
</html>