-
Notifications
You must be signed in to change notification settings - Fork 0
/
APP.php
67 lines (64 loc) · 1.87 KB
/
APP.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
<?php require('connection.php');?>
<html>
<head>
<title>Add Appointments</title>
<link rel="stylesheet" href="css/bootstrap.css"/>
</head>
<body>
<table class="table table-bordered">
<tr bgcolor=blue><td align=center><font SIZE=6 color=white>HOSPITAL
MANAGEMENT SYSTEM</font></td></tr>
<tr><td><table align=center width=750 cellspacing=0 cellpadding=5>
<tr><td align=center><a href=dlist.php>Doctors</td><td align=center><a
href=plist.php>Patients</td><td align=center><a
href=alist.php>Appointments</td>
</table></td></tr>
<tr bgcolor=red><td ><font size=4 color=white>Add Appointments</font></td></tr>
<form name=fdadd method=post action=asave.php>
<tr><td><table width=750 cellspacing=0 cellpadding=5>
<tr><td>Patient Id</td><td><select name=pat style="width:230px">
<?php
$rs1=mysql_query("SELECT * from patient where pshow='Y' order by
pname;");
$sno=1;
?>
<option selected="selected" disabled="disabled">Patient Id</option>
<?php
while( $row=mysql_fetch_array($rs1)) {
$patient_id=$row[0];
$patient=$row[1];
?>
<option value="<?php echo $patient_id ?>"><?php echo $patient_id." : ".$patient ?></option>
<?php
$sno++;
}
?>
</select>
</td></tr>
<tr><td>Doctor Id</td><td><select name=doc style="width:230px">
<option selected="selected" disabled="disabled">Doctor Id</option>
<?php
$rs2=mysql_query("SELECT * from doct where dshow='Y' order by
dname;");
$sno=1;
while($row1=mysql_fetch_array($rs2)) {
$doctor_id=$row1[0];
$doctor=$row1[1];
?>
<option value="<?php echo $doctor_id ?>"><?php echo $doctor_id." : ".$doctor ?></option>
<?php
$sno++;
}
?>
</select>
</td></tr>
<tr><td>Time</td><td><input type=text name=tim placeholder="hh:mm" size=30
maxlength=30></td></tr>
<tr><td>Date</td><td><input type=text name=dat placeholder="yy/dd/mm" size=30
maxlength=30></td></tr>
</table></td></tr>
<tr><td align=center><input type=submit value=Submit></td></tr>
</form>
</table>
</body>
</html>