-
Notifications
You must be signed in to change notification settings - Fork 0
/
u_search.php
72 lines (54 loc) · 1.85 KB
/
u_search.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
<?php //include("include/config.php");?>
<?php include("include/u_header.php");?>
<link rel="stylesheet" href="css/bootstrap.min.css" />
<script src="js/bootstrap.min.js"></script>
<a href="u_index.php"><li> Home </li> </a>
<a href="u_donor.php"><li> Donors </li></a>
<a href="u_profile.php"><li> Edit Profile </li> </a>
<a href="u_gallery.php"><li> Gallery </li> </a>
<a href="u_rules.php"><li> Rules </li> </a>
<a href="logout.php"><li> Logout </li></a>
</ul>
</div>
<div id="body">
<h2 style="margin-top:50px;color:#0000ff; text-align:center;">Searched Donor List</h2>
<div style="height:500px;width:700px;border:1px solid black;overflow-y:scroll;margin:0 auto;margin-top:50px;padding:10px;">
<?php
$sql="select * from user where blood_group='$_REQUEST[blood_group]' and status='active' ";
$res=mysql_query($sql);
?>
<table width="690px" style="border: 2px solid purple;font-size:12px;" align="center" >
<tr style="background:purple;color:white;height:30px;text-align:center;">
<td><b>SL.</b></td>
<td><b>Name</b></td>
<td><b>Phone</b></td>
<td><b>Blood Group</b></td>
<td><b>Status</b></td>
</tr>
<?php
$fl=0;
?>
<?php
$c=1;
while($arr=mysql_fetch_array($res))
{
//echo $arr['full_name'];
//echo '</br>';
$fl=1;
?>
<tr style="text-align:center;height:25px;">
<td><?php echo $c;?></td>
<td><?php echo $arr['full_name'];?></td>
<td><?php echo $arr['phone'];?></td>
<td><?php echo $arr['blood_group'];?></td>
<td><?php echo $arr['status'];?></td>
</tr>
<?php
$c++;}
?>
</table>
<?php if($fl==0){?>
<h2 style="margin-top:50px;color:red; text-align:center;">"No Donors Founded"</h2>
<?php }?>
</div>
<?php include("include/footer.php");?>