-
Notifications
You must be signed in to change notification settings - Fork 103
/
appsearch.php
executable file
·85 lines (80 loc) · 3.43 KB
/
appsearch.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
<!DOCTYPE html>
<?php #include("func.php");?>
<html>
<head>
<title>Patient Details</title>
<link rel="shortcut icon" type="image/x-icon" href="images/favicon.png" />
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta/css/bootstrap.min.css" integrity="sha384-/Y6pD6FV/Vv2HJnA6t+vslU6fwYXjCFtcEpHbNJ0lyAFsXTsjBbfaDjzALeQsN6M" crossorigin="anonymous">
</head>
<body>
<?php
include("newfunc.php");
if(isset($_POST['app_search_submit']))
{
$contact=$_POST['app_contact'];
$query = "select * from appointmenttb where contact= '$contact';";
$result = mysqli_query($con,$query);
$row=mysqli_fetch_array($result);
if($row['fname']=="" & $row['lname']=="" & $row['email']=="" & $row['contact']=="" & $row['doctor']=="" & $row['docFees']=="" & $row['appdate']=="" & $row['apptime']==""){
echo "<script> alert('No entries found! Please enter valid details');
window.location.href = 'admin-panel1.php#list-doc';</script>";
}
else {
echo "<div class='container-fluid' style='margin-top:50px;'>
<div class='card'>
<div class='card-body' style='background-color:#342ac1;color:#ffffff;'>
<table class='table table-hover'>
<thead>
<tr>
<th scope='col'>First Name</th>
<th scope='col'>Last Name</th>
<th scope='col'>Email</th>
<th scope='col'>Contact</th>
<th scope='col'>Doctor Name</th>
<th scope='col'>Consultancy Fees</th>
<th scope='col'>Appointment Date</th>
<th scope='col'>Appointment Time</th>
<th scope='col'>Appointment Status</th>
</tr>
</thead>
<tbody>";
$fname = $row['fname'];
$lname = $row['lname'];
$email = $row['email'];
$contact = $row['contact'];
$doctor = $row['doctor'];
$docFees= $row['docFees'];
$appdate= $row['appdate'];
$apptime = $row['apptime'];
if(($row['userStatus']==1) && ($row['doctorStatus']==1))
{
$appstatus = "Active";
}
if(($row['userStatus']==0) && ($row['doctorStatus']==1))
{
$appstatus = "Cancelled by You";
}
if(($row['userStatus']==1) && ($row['doctorStatus']==0))
{
$appstatus = "Cancelled by Doctor";
}
echo "<tr>
<td>$fname</td>
<td>$lname</td>
<td>$email</td>
<td>$contact</td>
<td>$doctor</td>
<td>$docFees</td>
<td>$appdate</td>
<td>$apptime</td>
<td>$appstatus</td>
</tr>";
echo "</tbody></table><center><a href='admin-panel1.php' class='btn btn-light'>Back to your Dashboard</a></div></center></div></div></div>";
}
}
?>
<script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.11.0/umd/popper.min.js" integrity="sha384-b/U6ypiBEHpOf/4+1nzFpr53nxSS+GLCkfwBdFNTxtclqqenISfwAzpKaMNFNmj4" crossorigin="anonymous"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta/js/bootstrap.min.js" integrity="sha384-h0AbiXch4ZDo7tp9hKZ4TsHbi047NrKGLO3SEJAg45jXxnGIfYzk4Si90RDIqNm1" crossorigin="anonymous"></script>
</body>
</html>