-
Notifications
You must be signed in to change notification settings - Fork 0
/
viewpatappointment.php
85 lines (76 loc) · 2.76 KB
/
viewpatappointment.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
<?php
session_start();
include("includes/header.php");
include("includes/conn.php");
$resultpat = mysqli_query($con,"SELECT * FROM patient where pat_id=$_SESSION[pat_id]");
$rowpat = mysqli_fetch_array($resultpat)
?>
<div id="templatemo_main">
<div id="sidebar" class="float_l">
<div class="sidebar_box"><span class="bottom"></span>
<?php
include("sidebar.php");
patienthome();
?>
</div>
</div>
<div id="content" class="faq float_r">
<table width="616" border="0">
<tr bgcolor="#FFFFCC">
<td colspan="2" align="center">Patient Profile</td>
</tr>
<tr>
<td width="284">Name: <?php echo $rowpat[pat_name]; ?></td>
<td width="322"><form id="form1" name="form1" method="post" action="">
<label for="name"></label>
Email-ID: <?php echo $rowpat[email_id]; ?>
</form></td>
</tr>
<tr>
<td>Date Of Birth: <?php echo $rowpat[dob]; ?></td>
<td>Gender: <?php echo $rowpat[gender]; ?></td>
</tr>
<tr>
<td>Address: <?php echo $rowpat[address]; ?></td>
<td>Contact: <?php echo $rowpat[contact]; ?></td>
</tr>
</table>
<br />
<table width="687" border="0">
<tr bgcolor="#FFFFCC">
<td colspan="6" align="center">Appointment Details</td>
</tr>
<tr>
<td width="126"><strong>Appointment ID</strong></td>
<td width="99"><strong>Branch Name</strong></td>
<td width="121"><strong>Doctor Name</strong></td>
<td width="115"><strong>Date</strong></td>
<td width="122"><strong>Time</strong></td>
<td width="78"><strong>Status</strong></td>
</tr>
<?php
$retapp = mysqli_fetch_array($result);
$result = mysqli_query($con,"SELECT * FROM appointment where pat_id=$_SESSION[pat_id]");
while($row = mysqli_fetch_array($result))
{
$result1 = mysqli_query($con,"SELECT * FROM branch where branch_id=$row[branch_id]");
$row1 = mysqli_fetch_array($result1);
$resdoctor= mysqli_query($con,"SELECT * from doctor where doc_id=$row[doc_id]");
$retdoctor= mysqli_fetch_array($resdoctor);
echo "<tr>";
echo "<td>" . $row[app_id] . "</a></td>";
echo "<td>" . $row1[branch_name] . "</td>";
echo "<td>" . $retdoctor[doc_name] . "</td>";
echo "<td>" . $row[app_date] . "</td>";
echo "<td>" . $row[app_time] . "</td>";
echo "<td>" . $row[status] . "</td>";
echo "</tr>";
}
?>
</table>
</div>
<div class="cleaner"></div>
</div>
<?php
include("includes/footer.php");
?>