LifeLink/searchDonor.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>Donor</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="Donor.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>
    <!-- my code goes here -->
    <h1 class="text-center decoration-solid text-black text-3xl font-bold mt-10">Search Donor</h1>
    <div class=" my-5 container">
        <form method="post" class="my-10 px-6 flex justify-center">
            <input class="border-2 ml-14 px-4 py-3" type="text" placeholder="Search Organ" name="search">
            <button class=" text-white bg-red-500 hover:bg-red-700 text-l px-4 py-3 " name="submit">Search</button>
        </form>
        <div class="container my-5 px-7 mx-4">
            <table class="table-auto w-full scroll-ml-6">
                <?php
                if(isset($_POST['submit'])){
                    $search=$_POST['search'];
                    $sql="Select * from `donor` NATURAL JOIN `organs` where organ='$search' AND status='YES';";
                    $result=mysqli_query($conn, $sql);
                    if($result){
                        if(mysqli_num_rows($result) > 0){
                            echo'
                            <thead>
                            <tr>
                            <th class="border px-4 py-2">No</th>
                            <th class="border px-4 py-2">First name</th>
                            <th class="border px-4 py-2">Second name</th>
                            <th class="border px-4 py-2">Age</th>
                            <th class="border px-4 py-2">Blood group</th>
                            <th class="border px-4 py-2">Medical history</th>
                            <th class="border px-4 py-2">Doctor operated</th>
                            <th class="border px-4 py-2">Address 1</th>
                            <th class="border px-4 py-2">Address 2</th>
                            <th class="border px-4 py-2">Address 3</th>
                            <th class="border px-4 py-2">Phone number</th>
                            </tr>
                            </thead>
                            ';
                            echo'<tbody>';
                            while($row = mysqli_fetch_array($result)){
                            echo'<tr>
                            <td class="border px-4 py-2">'.$row['Donor_ID'].'</td>
                            <td class="border px-4 py-2">'.$row['first_name'].'</td>
                            <td class="border px-4 py-2">'.$row['last_name'].'</td>
                            <td class="border px-4 py-2">'.$row['age'].'</td>
                            <td class="border px-4 py-2">'.$row['Blood_group'].'</td>
                            <td class="border px-4 py-2">'.$row['medical_history'].'</td>
                            <td class="border px-4 py-2">'.$row['doctor'].'</td>
                            <td class="border px-4 py-2">'.$row['address'].'</td>
                            <td class="border px-4 py-2">'.$row['address2'].'</td>
                            <td class="border px-4 py-2">'.$row['address3'].'</td>
                            <td class="border px-4 py-2">'.$row['phone'].'</td>
                            </tr>';
                            }
                             echo '</tbody>';
                            echo "</table>";
                        }
                        else{
                            echo'
                            <h2 class=text-danger>Data not found</h2>
                            ';
                        }
                    }
                }
                ?>
            </table>
        </div>
    </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>