LifeLink/displayallpatients.php at main · RayLikesAnime/LifeLink · GitHub

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
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
<?php
if(!isset($_SERVER['HTTP_REFERER'])){
	header("Location: ./Login.php");
	exit;
  }
session_start();
include "dbconnect.php";
if(isset($_SESSION['username']) =="") {
	setcookie(session_name(), '', 100);
	session_unset();
	session_destroy();
	header("Location: ./Login.php");
}
if(isset($_POST['logout'])){
	setcookie(session_name(), '', 100)  ;
	session_unset();
	session_destroy();
	header("Location: ./Login.php");
}
?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <script src="https://cdn.tailwindcss.com"></script>
    <title>Patient</title>
</head>

<body>
    <header>
        <nav class="bg-black text-white p-2 flex justify-between items-center sticky">
            <div class="ml-4 flex items-center">
                <img src="./images/logo.png" alt="">
                <h1 class="text-3xl ml-2 font-semibold">LifeLink</h1>
                <a href="patient.php"><button type="button"
                        class=" ml-5 text-white bg-red-500 hover:bg-red-700 focus:ring-4 rounded-lg text-sm px-4 py-2 text-center inline-flex items-center">Back
                    </button></a>
            </div>
            <ul class="flex justify-evenly mr-8">
                <li class="text-lg font-semibold px-4"><a href="./Userpage.php">Home</a></li>
                <li class="text-lg font-semibold px-4">
                    <form action="./Login.php" method="post">
                        <input type="submit" name="logout" value="Logout">
                    </form>
                </li>
            </ul>
        </nav>
    </header>
	<h1 class="text-3xl font-bold mt-6 flex justify-center">Patients</h1>

	<div class="overflow-x-auto mr-8">
		<?php

			// Establish a connection with the database
			include "dbconnect.php";

			// Execute the SELECT query
			$result = mysqli_query($conn, "SELECT * FROM patient");

			// Create a table with Tailwind CSS classes
			echo '<table class="table-auto w-full border-collapse border border-gray-500 m-8 shadow-lg">';
			echo '<thead>
			<tr>
			<th class="px-4 py-2 bg-gray-200 border border-gray-500">Patient ID</th>
			<th class="px-4 py-2 bg-gray-200 border border-gray-500">First Name</th>
			<th class="px-4 py-2 bg-gray-200 border border-gray-500">Last Name</th>
			<th class="px-4 py-2 bg-gray-200 border border-gray-500">Age</th>
			<th class="px-4 py-2 bg-gray-200 border border-gray-500">Blood Group</th>
			<th class="px-4 py-2 bg-gray-200 border border-gray-500">Medical History</th>
			<th class="px-4 py-2 bg-gray-200 border border-gray-500">Doctor</th>
			<th class="px-4 py-2 bg-gray-200 border border-gray-500">City</th>
			<th class="px-4 py-2 bg-gray-200 border border-gray-500">Phone Number</th>


			</tr>
			</thead>';

			// Fetch rows from the result set and display data in table with Tailwind CSS classes
			// retrieve the list of patient IDs from the transplants table
			$transplant_ids = array();
			$transplants_query = "SELECT patient_id FROM transplants";
			$transplants_result = mysqli_query($conn, $transplants_query);
			while ($transplant_row = mysqli_fetch_array($transplants_result)) {
				$transplant_ids[] = $transplant_row['patient_id'];
			}
			echo '<tbody class="text-center">';
			while($row = mysqli_fetch_array($result)) {
				$row_class = in_array($row['Patient_ID'], $transplant_ids) ? 'bg-green-100' : 'bg-red-200';
				echo '<tr class="border border-gray-500 '.$row_class.'">';
				echo '<td class="px-4 py-2">'.$row['Patient_ID'].'</td>';
				echo '<td class="px-4 py-2">'.$row['first_name'].'</td>';
				echo '<td class="px-4 py-2">'.$row['last_name'].'</td>';
				echo '<td class="px-4 py-2">'.$row['age'].'</td>';
				echo '<td class="px-4 py-2">'.$row['Blood_group'].'</td>';
				echo '<td class="px-4 py-2">'.$row['medical_history'].'</td>';
				echo '<td class="px-4 py-2">'.$row['doctor'].'</td>';
				echo '<td class="px-4 py-2">'.$row['address'].'</td>';
				echo '<td class="px-4 py-2">'.$row['phone'].'</td>';

				echo '</tr>';
			}
			echo '</tbody>';

			echo "</table>";

		?>
	</div>

	<!-- footer -->
	<footer class="flex items-center justify-center h-24 bg-black text-white">
        <div class="container mx-auto flex items-center">
            <span class="mr-2">
                <img src="images/logo.png" alt="Footer Icon" class="h-10 w-10">
            </span>
            <span class="text-lg">© 2023 LifeLink. All rights reserved.</span>
        </div>
        <div class="ml-4">
            <span>
                <a href="https://github.com/RayLikesAnime/LifeLink">
                    <img src="images/github.png" alt="Another Icon" class="h-16 w-16 mx-20">
                </a>
            </span>
        </div>
    </footer>
</body>

</html>