-
Notifications
You must be signed in to change notification settings - Fork 0
/
pat.php
93 lines (81 loc) · 3.22 KB
/
pat.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
<?php
session_start();
include "pdo/connection.php";
$sql = "SELECT * from patient";
$result = mysqli_query($conn, $sql);
?>
<!DOCTYPE html>
<html>
<head>
<title>Patients</title>
<?php include 'pdo/headers.php'; ?>
<link rel="stylesheet" href="pdo/style.css">
</head>
<body id="view">
<div class="container">
<div class="container h-100" id="login">
<img src="pdo/pic.png" alt="Assam Police Logo"><br>
<p id="login"></p>
<script src="pdo/script.js"></script>
</div>
<h1>List of Covid-19 Affected Patients</h1><br>
<div class="col-12">
<div class="row justify-content-center">
<table class="table table-striped table-hover">
<thead class="thead-dark">
<th>Patient-ID</th>
<th>Containment Zone-ID</th>
<th>Hospital-ID</th>
<th>First Name</th>
<th>Last Name</th>
<th>Aadhar NO</th>
<th>Address</th>
<th>Profession</th>
<th>Phone</th>
<th>Age</th>
<th>Gender</th>
<th>DOB</th>
<th>DOA</th>
<th>No of Family members</th>
<th>Medical History</th>
<th>Action</th>
</thead>
<?php
if (mysqli_num_rows($result) > 0) {
while ($row = mysqli_fetch_array($result)) {
?>
<tr>
<td><?php echo $row["pat_id"]; ?> </td>
<td><?php echo $row["cz_id"]; ?> </td>
<td><?php echo $row["hsp_id"]; ?> </td>
<td><?php echo $row["fname"]; ?></td>
<td><?php echo $row["lname"]; ?></td>
<td><?php echo $row["aadhar_no"]; ?></td>
<td><?php echo $row["address"]; ?></td>
<td><?php echo $row["proffession"]; ?></td>
<td><?php echo $row["phone"]; ?></td>
<td><?php echo $row["age"]; ?></td>
<td><?php echo $row["gender"]; ?></td>
<td><?php echo $row["dob"]; ?></td>
<td><?php echo $row["doa"]; ?></td>
<td><?php echo $row["no_flymem"]; ?></td>
<td><?php echo $row["medic_hist"]; ?></td>
<td><a href="editpat.php?pat_id=<?php echo $row['pat_id']; ?>"> Edit</a>
</tr>
<?php
}
}
?>
</table>
</div>
</div>
<br>
<p><a href="addpat.php">
<h3>Add Data</h3>
</a><br>
<a href="index.php">
<h3>Done</h3>
</a></p>
</div>
</body>
</html>