DADD.PHP
<html>
<head>
<meta name="spm" content="Hosita Management System">
<title>Add New Doctor</title>
</head>
<body>
<table align=center width=750 cellspacing=0 cellpadding=5>
<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=app.php>Appointments</td>
</table></td></tr>
<tr bgcolor=red><td ><font size=4 color=white>New Doctor</font></td></tr>
<form name=fdadd method=post action=dsave.php>
<tr><td><table width=750 cellspacing=0 cellpadding=5>
<tr><td>Doctor Name</td><td><input type=text name=name size=30 maxlength=30></td></tr>
<tr><td>Specilization</td><td><input type=text name=spec size=30
Page 38 maxlength=30></td></tr>
</table></td></tr>
<tr><td align=center><input type=submit value=Submit></td></tr>
</form>
<meta name="spm" content="Hosital Management System">
<title>Save Doctor</title>
</head>
<body>
<table align=center width=750 cellspacing=0 cellpadding=5>
<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=app.php>Appointments</td>
</table></td></tr>
<tr bgcolor=red><td ><font size=4 color=white>Save Doctor</font></td></tr>
<?php
$name=trim($_POST["name"]);
Page 39
$spec=trim($_POST["spec"]);
$error=0;
if ($name=="") { $error=1; echo "<tr><td><font color=red size=4>Name can't empty</font></td></tr>"; }
if ($spec=="") { $error=1; echo "<tr><td><font color=red size=4>Specilization can't empty</font></td></tr>"; } if ($error==0) {
if(!mysql_connect("localhost","root","")) {
echo "<tr><td><font color=red size=4>Connection Error</font></td></tr>";
die();
}
mysql_select_db("hospital");
mysql_query("insert into doct(dname,dspec,dshow) values('".$name."','".$spec."','Y')");
echo "<tr><td align=center><font size=4 color=green>Successfully
Records Inserted</font></td></tr>";
} else {
echo "<form name=fdadd method=post action=dsave.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>Specilization</td><td><input type=text name=spec size=30 maxlength=30 value='".$spec."'></td></tr>";
echo "</table></td></tr>";
Page 40 echo "<tr><td align=center><input type=submit
value=Submit></td></tr>";
echo "</form>";
}
echo "<tr><td align=center><a
href=dlist.php>Continue...</a></td></tr>";
echo "</table>";
echo "</body></html>";
DLIST.PHP
<html>
<head>
<meta name="spm" content="Hosital Management System">
<title></title>
</head>
<body>
<table align=center width=750 cellspacing=0 cellpadding=5>
<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=app.php>Appointments</td>
</table></td></tr>
<tr bgcolor=red><td ><font size=4 color=white>Doctors List</font></td></tr>
<tr><td><a href=dadd.php>Add New Record</a></td></tr>
Page 41
<tr><td><table width=750 cellspacing=0 cellpadding=5>
<tr bgcolor=#ccccc><td align=center>S No</td><td align=center>Doctor Name</td><td align=center>Specialization</td><td
align=center>Options</td></tr>
<?php
if(!mysql_connect("localhost","root","")) {
echo "<tr><td><font color=red size=4>Connection Error</font></td></tr>";
die();
}
mysql_select_db("hospital");
$rs1=mysql_query("SELECT * from doct where dshow='Y' order by dname;");
$sno=1;
while( $row=mysql_fetch_array($rs1)) {
echo "<tr><td>$sno</td><td>$row[1]</td><td>$row[2]</td><td><a href=dmod.php?rno=".$row[0].">Modify</a> | <a
href=ddel.php?rno=".$row[0].">Delete</a></td></tr>";
$sno++;
}
if ($sno==1) echo "<tr><td align=center><font size=4 color=red>Records
Not Found</font></td></tr>";
?>
</table></td></tr>
<tr><td align=center><hr></td></tr>
<tr bgcolor=red><td><font size=4 color=white>Deleted
Page 42 Records</font></td></tr>
<tr><td><table width=750 cellspacing=0 cellpadding=5>
<tr bgcolor=#ccccc><td align=center>S No</td><td align=center>Doctor Name</td><td align=center>Specialization</td><td
align=center>Options</td></tr>
<?php
$rs2=mysql_query("SELECT * from doct where dshow='N' order by dname;");
$sno=1;
while( $row=mysql_fetch_array($rs2)) {
echo "<tr><td>$sno</td><td>$row[1]</td><td>$row[2]</td><td><a href=dundel.php?rno=".$row[0].">Undelete</a></td></tr>";
$sno++;
}
if ($sno==1) echo "<tr><td align=center><font size=4 color=red>Records
Not Found</font></td></tr>";
?>
<meta name="spm" content="Hosital Management System">
<title>Modify Doctor Profile</title>
Page 43
</head>
<body>
<table align=center width=750 cellspacing=0 cellpadding=5>
<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=app.php>Appointments</td>
echo "<tr><td><font color=red size=4>Connection Error</font></td></tr>";
die();
}
mysql_select_db("hospital");
$rs1=mysql_query("SELECT * from doct where dno='".$rno."'");
$sno=1;
while( $row=mysql_fetch_array($rs1)) {
echo "<tr bgcolor=red><td ><font size=4 color=white>Edit Doctor
Details</font></td></tr>";
echo "<form name=fdmod method=post action=dupdate.php>";
echo "<tr><td><table width=750 cellspacing=0 cellpadding=5>";
Page 44 echo "<tr><td>Doctor Name</td><td><input type=text name=name size=30 maxlength=30 value='".$row[1]."'></td></tr>";
echo "<tr><td>Specilization</td><td><input type=text name=spec size=30 maxlength=30 value='".$row[2]."'></td></tr>";
echo "</table></td></tr>";
echo "<tr><td colspan=2 align=center><input type=hidden name=rno
value=".$rno."><input type=submit value=Submit></td></tr>";
echo "</form>";
$sno++;
}
if ($sno==1) echo "<tr><td align=center><font size=4 color=red>Records
Not Found</font></td></tr>";
?>
<meta name="spm" content="Hosital Management System">
<title>Update Doctor</title>
</head>
<body>
<table align=center width=750 cellspacing=0 cellpadding=5>
<tr bgcolor=blue><td align=center><font SIZE=6 color=white>HOSPITAL
Page 45 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=app.php>Appointments</td>
</table></td></tr>
<tr bgcolor=red><td ><font size=4 color=white>Update Doctor</font></td></tr>
if ($name=="") { $error=1; echo "<tr><td><font color=red size=4>Name can't empty</font></td></tr>"; }
if ($spec=="") { $error=1; echo "<tr><td><font color=red size=4>Specilization can't empty</font></td></tr>"; } if ($error==0) {
if(!mysql_connect("localhost","root","")) {
echo "<tr><td><font color=red size=4>Connection Error</font></td></tr>";
die();
}
mysql_connect("localhost","root","");
mysql_select_db("hospital");
Page 46 mysql_query("update doct set
dname='".$name."',dspec='".$spec."' where dno='".$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=dupdate.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>Specilization</td><td><input type=text name=spec size=30 maxlength=30 value='".$spec."'></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=dlist.php>Continue...</a></td></tr>";
echo "</table>";
echo "</body></html>";
DDEL.PHP
<html>
<head>
<meta name="spm" content="Hosital Management System">
Page 47
<title></title>
</head>
<body>
<table align=center width=750 cellspacing=0 cellpadding=5>
<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=app.php>Appointments</td>
</table></td></tr>
<tr bgcolor=red><td ><font size=4 color=white>Doctors List</font></td></tr>
<tr><td><a href=dadd.php>Add New Record</a></td></tr>
<tr><td><table width=750 cellspacing=0 cellpadding=5>
<tr bgcolor=#ccccc><td align=center>S No</td><td align=center>Doctor Name</td><td align=center>Specialization</td><td
align=center>Options</td></tr>
<?php
if(!mysql_connect("localhost","root","")) {
echo "<tr><td><font color=red size=4>Connection Error</font></td></tr>";
die();
}
mysql_select_db("hospital");
$rs1=mysql_query("SELECT * from doct where dshow='Y' order by
Page 48 dname;");
$sno=1;
while( $row=mysql_fetch_array($rs1)) {
echo "<tr><td>$sno</td><td>$row[1]</td><td>$row[2]</td><td><a href=dmod.php?rno=".$row[0].">Modify</a> | <a
href=ddel.php?rno=".$row[0].">Delete</a></td></tr>";
$sno++;
}
if ($sno==1) echo "<tr><td align=center><font size=4 color=red>Records
Not Found</font></td></tr>";
?>
</table></td></tr>
<tr><td align=center><hr></td></tr>
<tr bgcolor=red><td><font size=4 color=white>Deleted Records</font></td></tr>
<tr><td><table width=750 cellspacing=0 cellpadding=5>
<tr bgcolor=#ccccc><td align=center>S No</td><td align=center>Doctor Name</td><td align=center>Specialization</td><td
align=center>Options</td></tr>
<?php
$rs2=mysql_query("SELECT * from doct where dshow='N' order by dname;");
$sno=1;
while( $row=mysql_fetch_array($rs2)) {
echo "<tr><td>$sno</td><td>$row[1]</td><td>$row[2]</td><td><a href=dundel.php?rno=".$row[0].">Undelete</a></td></tr>";
$sno++;
Page 49 }
if ($sno==1) echo "<tr><td align=center><font size=4 color=red>Records
Not Found</font></td></tr>";
?>
<meta name="spm" content="Hosital Management System">
<title>Recover Doctor</title>
</head>
<body>
<table align=center width=750 cellspacing=0 cellpadding=5>
<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=app.php>Appointments</td>
</table></td></tr>
<tr bgcolor=red><td ><font size=4 color=white>Recover Doctor</font></td></tr>
Page 50
<?php
$rno=$_GET["rno"];
if(!mysql_connect("localhost","root","")) {
echo "<tr><td><font color=red size=4>Connection Error</font></td></tr>";
die();
}
mysql_select_db("hospital");
mysql_query("update doct set dshow='Y' where dno='$rno'");
echo "<tr><td align=center><font size=4 color=green>Successfully
Records Recovered</font></td></tr>";
echo "<tr><td align=center><a
href=dlist.php>Continue...</a></td></tr>";
echo "</table>";
echo "</body></html>";
Page 51