-
Notifications
You must be signed in to change notification settings - Fork 0
/
PUPDATE.php
54 lines (53 loc) · 1.95 KB
/
PUPDATE.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
<?php require('connection.php');?>
<html>
<head>
<title>Update Doctor</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>Update
patient</font></td></tr>
<?php
$rno=trim($_POST["rno"]);
$name=trim($_POST["name"]);
$addr=trim($_POST["addr"]);
$sex=trim($_POST["sex"]);
$error=0; if ($name=="") { $error=1; echo "<tr><td><font color=red size=4>Name
can't empty</font></td></tr>"; }
if ($addr=="") { $error=1; echo "<tr><td><font color=red
size=4>Address can't empty</font></td></tr>"; }
if ($sex=="") { $error=1; echo "<tr><td><font color=red
size=4>Sex can't empty</font></td></tr>"; }
if ($error==0)
{
mysql_query("update patient set pname='".$name."',psex='".$sex."',paddr='".$addr."'
where pno='".$rno."'");
echo "<tr><td align=center><font size=4 color=green>Successfully
Records Updated</font></td></tr>";
}
else {
echo "<form name=fdadd method=post action=pupdate.php>";
echo "<tr><td><table width=750 cellspacing=0 cellpadding=5>";
echo "<tr><td>Doctor Name</td><td><input type=text name=name
size=30 maxlength=30 value='".$name."'></td></tr>";
echo "<tr><td>Address</td><td><input type=text name=spec
size=30 maxlength=30 value='".$addr."'></td></tr>";
echo "<tr><td>sex</td><td><input type=text name=spec
size=30 maxlength=30 value='".$sex."'></td></tr>";
echo "</table></td></tr>";
echo "<tr><td align=center><input type=hidden name=rno
value=".$rno."><input type=submit value=Submit></td></tr>";
echo "</form>";
}
echo "<tr><td align=center><a
href=plist.php>Continue...</a></td></tr>";
echo "</table>";
echo "</body></html>";