| Server IP : 162.240.98.243 / Your IP : 3.144.15.43 Web Server : Apache System : Linux server.bti.yaw.mybluehostin.me 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : btiyawmy ( 1003) PHP Version : 7.2.34 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/btiyawmy/public_html/login.easenup.in/FrontOffice/ |
Upload File : |
<! –– General ward ––>
<?php
$sql ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$sql2 ="SELECT * FROM ward WHERE ward_type='General ward' AND adminid='$rs[entered_by]'";
$qsql2 = mysqli_query($con,$sql2);
if($rh2 = mysqli_fetch_array($qsql2))
{
echo"
<h2 align='center'>General Ward </b> </h2>";
}
}
?>
<?php
$sql ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$sql2 ="SELECT * FROM ward WHERE ward_type='General ward' AND adminid='$rs[entered_by]'";
$qsql2 = mysqli_query($con,$sql2);
while($rh2 = mysqli_fetch_array($qsql2))
{
$sql="select count('bedid') from bedindex WHERE wardid='$rh2[wardid]' AND status='Active'";
$result=mysqli_query($con,$sql);
$row=mysqli_fetch_array($result);
$i=0;
$bed=$row[0];
while($i < $bed)
{
$sql21 ="SELECT * FROM bedindex WHERE wardid='$rh2[wardid]' AND status='Active'";
$qsql21 = mysqli_query($con,$sql21);
while($rh21 = mysqli_fetch_array($qsql21))
{
if($i % 5 == 0)
{
echo"<br>";
}
echo"<span><b>$rh2[ward_name]-$rh21[bedname]</b> <i class='fa far fa-bed' style='font-size:60px;color:green;'></i></span> ";
$i++;
}
}
}
}
?>
<?php
$sql ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$sql2 ="SELECT * FROM ward WHERE ward_type='General ward' AND adminid='$rs[entered_by]'";
$qsql2 = mysqli_query($con,$sql2);
while($rh2 = mysqli_fetch_array($qsql2))
{
$sqlp="select count('bedid') from bedindex WHERE wardid='$rh2[wardid]' AND status='Inactive'";
$resultp=mysqli_query($con,$sqlp);
$row=mysqli_fetch_array($resultp);
$i=0;
$bed=$row[0];
while($i < $bed)
{
$sql21p ="SELECT * FROM bedindex WHERE wardid='$rh2[wardid]' AND status='Inactive'";
$qsql21p = mysqli_query($con,$sql21p);
while($rh21p = mysqli_fetch_array($qsql21p))
{
if($i % 5 == 0)
{
echo"<br>";
}
if(is_numeric($rh21p[prescriptionid]))
{
$sql21pv ="SELECT * FROM addaspatient WHERE prescriptionid='$rh21p[prescriptionid]' ";
$qsql21pv = mysqli_query($con,$sql21pv);
while($rh21pv = mysqli_fetch_array($qsql21pv))
$sql21pvp ="SELECT * FROM patient WHERE patientid='$rh21pv[patientid]' ";
$qsql21pvp = mysqli_query($con,$sql21pvp);
while($rh21pvp = mysqli_fetch_array($qsql21pvp))
{
echo" <a href='Patient/treatment_timline.php?prescriptionid=$rh21p[prescriptionid]&patientid=$rh21pvp[patientid]' title='$rh21pvp[patientid]-$rh21pvp[patientname]'><span><b>$rh2[ward_name]-$rh21p[bedname]</b> <i class='fa far fa-bed' style='font-size:60px;color:red;'></i></span></a> ";
}
$i++;
}
}
}
}
}
?>
<! –– Burn Unit ––>
<?php
$sql ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$sql2 ="SELECT * FROM ward WHERE ward_type='Burn Unit' AND adminid='$rs[entered_by]'";
$qsql2 = mysqli_query($con,$sql2);
if($rh2 = mysqli_fetch_array($qsql2))
{
echo"
<h2 align='center'>Burn Unit </b> </h2>";
}
}
?>
<?php
$sql ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$sql2 ="SELECT * FROM ward WHERE ward_type='Burn Unit' AND adminid='$rs[entered_by]'";
$qsql2 = mysqli_query($con,$sql2);
while($rh2 = mysqli_fetch_array($qsql2))
{
$sql="select count('bedid') from bedindex WHERE wardid='$rh2[wardid]' AND status='Active'";
$result=mysqli_query($con,$sql);
$row=mysqli_fetch_array($result);
$i=0;
$bed=$row[0];
while($i < $bed)
{
$sql21 ="SELECT * FROM bedindex WHERE wardid='$rh2[wardid]' AND status='Active'";
$qsql21 = mysqli_query($con,$sql21);
while($rh21 = mysqli_fetch_array($qsql21))
{
if($i % 5 == 0)
{
echo"<br>";
}
echo"<span><b>$rh2[ward_name]-$rh21[bedname]</b> <i class='fa far fa-bed' style='font-size:60px;color:green;'></i></span> ";
$i++;
}
}
}
}
?>
<?php
$sql ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$sql2 ="SELECT * FROM ward WHERE ward_type='Burn Unit' AND adminid='$rs[entered_by]'";
$qsql2 = mysqli_query($con,$sql2);
while($rh2 = mysqli_fetch_array($qsql2))
{
$sqlp="select count('bedid') from bedindex WHERE wardid='$rh2[wardid]' AND status='Inactive'";
$resultp=mysqli_query($con,$sqlp);
$row=mysqli_fetch_array($resultp);
$i=0;
$bed=$row[0];
while($i < $bed)
{
$sql21p ="SELECT * FROM bedindex WHERE wardid='$rh2[wardid]' AND status='Inactive'";
$qsql21p = mysqli_query($con,$sql21p);
while($rh21p = mysqli_fetch_array($qsql21p))
{
if($i % 5 == 0)
{
echo"<br>";
}
if(is_numeric($rh21p[prescriptionid]))
{
$sql21pv ="SELECT * FROM addaspatient WHERE prescriptionid='$rh21p[prescriptionid]' ";
$qsql21pv = mysqli_query($con,$sql21pv);
while($rh21pv = mysqli_fetch_array($qsql21pv))
$sql21pvp ="SELECT * FROM patient WHERE patientid='$rh21pv[patientid]' ";
$qsql21pvp = mysqli_query($con,$sql21pvp);
while($rh21pvp = mysqli_fetch_array($qsql21pvp))
{
echo" <a href='Patient/treatment_timline.php?prescriptionid=$rh21p[prescriptionid]&patientid=$rh21pvp[patientid]' title='$rh21pvp[patientid]-$rh21pvp[patientname]'><span><b>$rh2[ward_name]-$rh21p[bedname]</b> <i class='fa far fa-bed' style='font-size:60px;color:red;'></i></span></a> ";
}
$i++;
}
}
}
}
}
?>
<! –– Pvt. Ward ––>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='Pvt. Ward' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
if($rh2p = mysqli_fetch_array($qsql2p))
{
echo"
<h2 align='center'>Pvt. Ward </b> </h2>";
}
}
?>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='Pvt. Ward' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
while($rh2p = mysqli_fetch_array($qsql2p))
{
$sqlp="select count('bedid') from bedindex WHERE wardid='$rh2p[wardid]' AND status='Active'";
$resultp=mysqli_query($con,$sqlp);
$row=mysqli_fetch_array($resultp);
$i=0;
$bed=$row[0];
while($i < $bed)
{
$sql21p ="SELECT * FROM bedindex WHERE wardid='$rh2p[wardid]' AND status='Active'";
$qsql21p = mysqli_query($con,$sql21p);
while($rh21p = mysqli_fetch_array($qsql21p))
{
if($i % 5 == 0)
{
echo"<br>";
}
echo"<span><b>$rh2p[ward_name]</b> <i class='fa far fa-bed' style='font-size:60px;color:green;'></i></span> ";
$i++;
}
}
}
}
?>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='Pvt. Ward' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
while($rh2p = mysqli_fetch_array($qsql2p))
{
$sqlp="select count('bedid') from bedindex WHERE wardid='$rh2p[wardid]' AND status='Inactive'";
$resultp=mysqli_query($con,$sqlp);
$row=mysqli_fetch_array($resultp);
$i=0;
$bed=$row[0];
while($i < $bed)
{
$sql21p ="SELECT * FROM bedindex WHERE wardid='$rh2p[wardid]' AND status='Inactive'";
$qsql21p = mysqli_query($con,$sql21p);
while($rh21p = mysqli_fetch_array($qsql21p))
{
if($i % 5 == 0)
{
echo"<br>";
}
if(is_numeric($rh21p[prescriptionid]))
{
$sql21pv ="SELECT * FROM addaspatient WHERE prescriptionid='$rh21p[prescriptionid]' ";
$qsql21pv = mysqli_query($con,$sql21pv);
while($rh21pv = mysqli_fetch_array($qsql21pv))
$sql21pvp ="SELECT * FROM patient WHERE patientid='$rh21pv[patientid]' ";
$qsql21pvp = mysqli_query($con,$sql21pvp);
while($rh21pvp = mysqli_fetch_array($qsql21pvp))
{
echo" <a href='Patient/treatment_timline.php?prescriptionid=$rh21p[prescriptionid]&patientid=$rh21pvp[patientid]' title='$rh21pvp[patientid]-$rh21pvp[patientname]'><span><b>$rh2p[ward_name]-$rh21p[bedname]</b> <i class='fa far fa-bed' style='font-size:60px;color:red;'></i></span></a> ";
}
$i++;
}
}
}
}
}
?>
<! –– Semi Pvt. Ward ––>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='Semi Pvt. Ward' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
if($rh2p = mysqli_fetch_array($qsql2p))
{
echo"
<h2 align='center'>Semi Pvt. Ward</b> </h2>";
}
}
?>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='Semi Pvt. Ward' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
while($rh2p = mysqli_fetch_array($qsql2p))
{
$sqlp="select count('bedid') from bedindex WHERE wardid='$rh2p[wardid]' AND status='Active'";
$resultp=mysqli_query($con,$sqlp);
$row=mysqli_fetch_array($resultp);
$i=0;
$bed=$row[0];
while($i < $bed)
{
$sql21p ="SELECT * FROM bedindex WHERE wardid='$rh2p[wardid]' AND status='Active'";
$qsql21p = mysqli_query($con,$sql21p);
while($rh21p = mysqli_fetch_array($qsql21p))
{
if($i % 5 == 0)
{
echo"<br>";
}
echo"<span><b>$rh2p[ward_name]-$rh21p[bedname]</b> <i class='fa far fa-bed' style='font-size:60px;color:green;'></i></span> ";
$i++;
}
}
}
}
?>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='Semi Pvt. Ward' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
while($rh2p = mysqli_fetch_array($qsql2p))
{
$sqlp="select count('bedid') from bedindex WHERE wardid='$rh2p[wardid]' AND status='Inactive'";
$resultp=mysqli_query($con,$sqlp);
$row=mysqli_fetch_array($resultp);
$i=0;
$bed=$row[0];
while($i < $bed)
{
$sql21p ="SELECT * FROM bedindex WHERE wardid='$rh2p[wardid]' AND status='Inactive'";
$qsql21p = mysqli_query($con,$sql21p);
while($rh21p = mysqli_fetch_array($qsql21p))
{
if($i % 5 == 0)
{
echo"<br>";
}
if(is_numeric($rh21p[prescriptionid]))
{
$sql21pv ="SELECT * FROM addaspatient WHERE prescriptionid='$rh21p[prescriptionid]' ";
$qsql21pv = mysqli_query($con,$sql21pv);
while($rh21pv = mysqli_fetch_array($qsql21pv))
$sql21pvp ="SELECT * FROM patient WHERE patientid='$rh21pv[patientid]' ";
$qsql21pvp = mysqli_query($con,$sql21pvp);
while($rh21pvp = mysqli_fetch_array($qsql21pvp))
{
echo" <a href='Patient/treatment_timline.php?prescriptionid=$rh21p[prescriptionid]&patientid=$rh21pvp[patientid]' title='$rh21pvp[patientid]-$rh21pvp[patientname]'><span><b>$rh2p[ward_name]-$rh21p[bedname]</b> <i class='fa far fa-bed' style='font-size:60px;color:red;'></i></span></a> ";
}
$i++;
}
}
}
}
}
?>
<! –– Neonatal intensive care unit ––>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='Neonatal intensive care unit' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
if($rh2p = mysqli_fetch_array($qsql2p))
{
echo"
<h2 align='center'>Neonatal intensive care unit</b> </h2>";
}
}
?>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='Neonatal intensive care unit' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
while($rh2p = mysqli_fetch_array($qsql2p))
{
$sqlp="select count('bedid') from bedindex WHERE wardid='$rh2p[wardid]' AND status='Active'";
$resultp=mysqli_query($con,$sqlp);
$row=mysqli_fetch_array($resultp);
$i=0;
$bed=$row[0];
while($i < $bed)
{
$sql21p ="SELECT * FROM bedindex WHERE wardid='$rh2p[wardid]' AND status='Active'";
$qsql21p = mysqli_query($con,$sql21p);
while($rh21p = mysqli_fetch_array($qsql21p))
{
if($i % 5 == 0)
{
echo"<br>";
}
echo"<span><b>$rh2p[ward_name]-$rh21p[bedname]</b> <i class='fa far fa-bed' style='font-size:60px;color:green;'></i></span> ";
$i++;
}
}
}
}
?>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='Neonatal intensive care unit' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
while($rh2p = mysqli_fetch_array($qsql2p))
{
$sqlp="select count('bedid') from bedindex WHERE wardid='$rh2p[wardid]' AND status='Inactive'";
$resultp=mysqli_query($con,$sqlp);
$row=mysqli_fetch_array($resultp);
$i=0;
$bed=$row[0];
while($i < $bed)
{
$sql21p ="SELECT * FROM bedindex WHERE wardid='$rh2p[wardid]' AND status='Inactive'";
$qsql21p = mysqli_query($con,$sql21p);
while($rh21p = mysqli_fetch_array($qsql21p))
{
if($i % 5 == 0)
{
echo"<br>";
}
if(is_numeric($rh21p[prescriptionid]))
{
$sql21pv ="SELECT * FROM addaspatient WHERE prescriptionid='$rh21p[prescriptionid]' ";
$qsql21pv = mysqli_query($con,$sql21pv);
while($rh21pv = mysqli_fetch_array($qsql21pv))
$sql21pvp ="SELECT * FROM patient WHERE patientid='$rh21pv[patientid]' ";
$qsql21pvp = mysqli_query($con,$sql21pvp);
while($rh21pvp = mysqli_fetch_array($qsql21pvp))
{
echo" <a href='Patient/treatment_timline.php?prescriptionid=$rh21p[prescriptionid]&patientid=$rh21pvp[patientid]' title='$rh21pvp[patientid]-$rh21pvp[patientname]'><span><b>$rh2p[ward_name]-$rh21p[bedname]</b> <i class='fa far fa-bed' style='font-size:60px;color:red;'></i></span></a> ";
}
$i++;
}
}
}
}
}
?>
<! ––Pediatric intensive care unit ––>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='Pediatric intensive care unit' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
if($rh2p = mysqli_fetch_array($qsql2p))
{
echo"
<h2 align='center'>Pediatric intensive care unit</b> </h2>";
}
}
?>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='Pediatric intensive care unit' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
while($rh2p = mysqli_fetch_array($qsql2p))
{
$sqlp="select count('bedid') from bedindex WHERE wardid='$rh2p[wardid]' AND status='Active'";
$resultp=mysqli_query($con,$sqlp);
$row=mysqli_fetch_array($resultp);
$i=0;
$bed=$row[0];
while($i < $bed)
{
$sql21p ="SELECT * FROM bedindex WHERE wardid='$rh2p[wardid]' AND status='Active'";
$qsql21p = mysqli_query($con,$sql21p);
while($rh21p = mysqli_fetch_array($qsql21p))
{
if($i % 5 == 0)
{
echo"<br>";
}
echo"<span><b>$rh2p[ward_name]-$rh21p[bedname]</b> <i class='fa far fa-bed' style='font-size:60px;color:green;'></i></span> ";
$i++;
}
}
}
}
?>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='Pediatric intensive care unit' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
while($rh2p = mysqli_fetch_array($qsql2p))
{
$sqlp="select count('bedid') from bedindex WHERE wardid='$rh2p[wardid]' AND status='Inactive'";
$resultp=mysqli_query($con,$sqlp);
$row=mysqli_fetch_array($resultp);
$i=0;
$bed=$row[0];
while($i < $bed)
{
$sql21p ="SELECT * FROM bedindex WHERE wardid='$rh2p[wardid]' AND status='Inactive'";
$qsql21p = mysqli_query($con,$sql21p);
while($rh21p = mysqli_fetch_array($qsql21p))
{
if($i % 5 == 0)
{
echo"<br>";
}
if(is_numeric($rh21p[prescriptionid]))
{
$sql21pv ="SELECT * FROM addaspatient WHERE prescriptionid='$rh21p[prescriptionid]' ";
$qsql21pv = mysqli_query($con,$sql21pv);
while($rh21pv = mysqli_fetch_array($qsql21pv))
$sql21pvp ="SELECT * FROM patient WHERE patientid='$rh21pv[patientid]' ";
$qsql21pvp = mysqli_query($con,$sql21pvp);
while($rh21pvp = mysqli_fetch_array($qsql21pvp))
{
echo" <a href='Patient/treatment_timline.php?prescriptionid=$rh21p[prescriptionid]&patientid=$rh21pvp[patientid]' title='$rh21pvp[patientid]-$rh21pvp[patientname]'><span><b>$rh2p[ward_name]-$rh21p[bedname]</b> <i class='fa far fa-bed' style='font-size:60px;color:red;'></i></span></a> ";
}
$i++;
}
}
}
}
}
?>
<! ––High-dependency care ––>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='High-dependency care' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
if($rh2p = mysqli_fetch_array($qsql2p))
{
echo"
<h2 align='center'>High-dependency care</b> </h2>";
}
}
?>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='High-dependency care' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
while($rh2p = mysqli_fetch_array($qsql2p))
{
$sqlp="select count('bedid') from bedindex WHERE wardid='$rh2p[wardid]' AND status='Active'";
$resultp=mysqli_query($con,$sqlp);
$row=mysqli_fetch_array($resultp);
$i=0;
$bed=$row[0];
while($i < $bed)
{
$sql21p ="SELECT * FROM bedindex WHERE wardid='$rh2p[wardid]' AND status='Active'";
$qsql21p = mysqli_query($con,$sql21p);
while($rh21p = mysqli_fetch_array($qsql21p))
{
if($i % 5 == 0)
{
echo"<br>";
}
echo"<span><b>$rh2p[ward_name]-$rh21p[bedname]</b> <i class='fa far fa-bed' style='font-size:60px;color:green;'></i></span> ";
$i++;
}
}
}
}
?>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='High-dependency care' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
while($rh2p = mysqli_fetch_array($qsql2p))
{
$sqlp="select count('bedid') from bedindex WHERE wardid='$rh2p[wardid]' AND status='Inactive'";
$resultp=mysqli_query($con,$sqlp);
$row=mysqli_fetch_array($resultp);
$i=0;
$bed=$row[0];
while($i < $bed)
{
$sql21p ="SELECT * FROM bedindex WHERE wardid='$rh2p[wardid]' AND status='Inactive'";
$qsql21p = mysqli_query($con,$sql21p);
while($rh21p = mysqli_fetch_array($qsql21p))
{
if($i % 5 == 0)
{
echo"<br>";
}
if(is_numeric($rh21p[prescriptionid]))
{
$sql21pv ="SELECT * FROM addaspatient WHERE prescriptionid='$rh21p[prescriptionid]' ";
$qsql21pv = mysqli_query($con,$sql21pv);
while($rh21pv = mysqli_fetch_array($qsql21pv))
$sql21pvp ="SELECT * FROM patient WHERE patientid='$rh21pv[patientid]' ";
$qsql21pvp = mysqli_query($con,$sql21pvp);
while($rh21pvp = mysqli_fetch_array($qsql21pvp))
{
echo" <a href='Patient/treatment_timline.php?prescriptionid=$rh21p[prescriptionid]&patientid=$rh21pvp[patientid]' title='$rh21pvp[patientid]-$rh21pvp[patientname]'><span><b>$rh2p[ward_name]-$rh21p[bedname]</b> <i class='fa far fa-bed' style='font-size:60px;color:red;'></i></span></a> ";
}
$i++;
}
}
}
}
}
?>
<! ––Cardiac intensive care unit ––>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='Cardiac intensive care unit' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
if($rh2p = mysqli_fetch_array($qsql2p))
{
echo"
<h2 align='center'>Cardiac intensive care unit</b> </h2>";
}
}
?>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='Cardiac intensive care unit' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
while($rh2p = mysqli_fetch_array($qsql2p))
{
$sqlp="select count('bedid') from bedindex WHERE wardid='$rh2p[wardid]' AND status='Active'";
$resultp=mysqli_query($con,$sqlp);
$row=mysqli_fetch_array($resultp);
$i=0;
$bed=$row[0];
while($i < $bed)
{
$sql21p ="SELECT * FROM bedindex WHERE wardid='$rh2p[wardid]' AND status='Active'";
$qsql21p = mysqli_query($con,$sql21p);
while($rh21p = mysqli_fetch_array($qsql21p))
{
if($i % 5 == 0)
{
echo"<br>";
}
echo"<span><b>$rh2p[ward_name]-$rh21p[bedname]</b> <i class='fa far fa-bed' style='font-size:60px;color:green;'></i></span> ";
$i++;
}
}
}
}
?>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='Cardiac intensive care unit' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
while($rh2p = mysqli_fetch_array($qsql2p))
{
$sqlp="select count('bedid') from bedindex WHERE wardid='$rh2p[wardid]' AND status='Inactive'";
$resultp=mysqli_query($con,$sqlp);
$row=mysqli_fetch_array($resultp);
$i=0;
$bed=$row[0];
while($i < $bed)
{
$sql21p ="SELECT * FROM bedindex WHERE wardid='$rh2p[wardid]' AND status='Inactive'";
$qsql21p = mysqli_query($con,$sql21p);
while($rh21p = mysqli_fetch_array($qsql21p))
{
if($i % 5 == 0)
{
echo"<br>";
}
if(is_numeric($rh21p[prescriptionid]))
{
$sql21pv ="SELECT * FROM addaspatient WHERE prescriptionid='$rh21p[prescriptionid]' ";
$qsql21pv = mysqli_query($con,$sql21pv);
while($rh21pv = mysqli_fetch_array($qsql21pv))
$sql21pvp ="SELECT * FROM patient WHERE patientid='$rh21pv[patientid]' ";
$qsql21pvp = mysqli_query($con,$sql21pvp);
while($rh21pvp = mysqli_fetch_array($qsql21pvp))
{
echo" <a href='Patient/treatment_timline.php?prescriptionid=$rh21p[prescriptionid]&patientid=$rh21pvp[patientid]' title='$rh21pvp[patientid]-$rh21pvp[patientname]'><span><b>$rh2p[ward_name]-$rh21p[bedname]</b> <i class='fa far fa-bed' style='font-size:60px;color:red;'></i></span></a> ";
}
$i++;
}
}
}
}
}
?>
<! ––Incentive care Unit ––>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='Incentive care Unit' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
if($rh2p = mysqli_fetch_array($qsql2p))
{
echo"
<h2 align='center'>Incentive care Unit</b> </h2>";
}
}
?>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='Incentive care Unit' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
while($rh2p = mysqli_fetch_array($qsql2p))
{
$sqlp="select count('bedid') from bedindex WHERE wardid='$rh2p[wardid]' AND status='Active'";
$resultp=mysqli_query($con,$sqlp);
$row=mysqli_fetch_array($resultp);
$i=0;
$bed=$row[0];
while($i < $bed)
{
$sql21p ="SELECT * FROM bedindex WHERE wardid='$rh2p[wardid]' AND status='Active'";
$qsql21p = mysqli_query($con,$sql21p);
while($rh21p = mysqli_fetch_array($qsql21p))
{
if($i % 5 == 0)
{
echo"<br>";
}
echo"<span><b>$rh2p[ward_name]-$rh21p[bedname]</b> <i class='fa far fa-bed' style='font-size:60px;color:green;'></i></span> ";
$i++;
}
}
}
}
?>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='Incentive care Unit' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
while($rh2p = mysqli_fetch_array($qsql2p))
{
$sqlp="select count('bedid') from bedindex WHERE wardid='$rh2p[wardid]' AND status='Inactive'";
$resultp=mysqli_query($con,$sqlp);
$row=mysqli_fetch_array($resultp);
$i=0;
$bed=$row[0];
while($i < $bed)
{
$sql21p ="SELECT * FROM bedindex WHERE wardid='$rh2p[wardid]' AND status='Inactive'";
$qsql21p = mysqli_query($con,$sql21p);
while($rh21p = mysqli_fetch_array($qsql21p))
{
if($i % 5 == 0)
{
echo"<br>";
}
if(is_numeric($rh21p[prescriptionid]))
{
$sql21pv ="SELECT * FROM addaspatient WHERE prescriptionid='$rh21p[prescriptionid]' ";
$qsql21pv = mysqli_query($con,$sql21pv);
while($rh21pv = mysqli_fetch_array($qsql21pv))
$sql21pvp ="SELECT * FROM patient WHERE patientid='$rh21pv[patientid]' ";
$qsql21pvp = mysqli_query($con,$sql21pvp);
while($rh21pvp = mysqli_fetch_array($qsql21pvp))
{
echo" <a href='Patient/treatment_timline.php?prescriptionid=$rh21p[prescriptionid]&patientid=$rh21pvp[patientid]' title='$rh21pvp[patientid]-$rh21pvp[patientname]'><span><b>$rh2p[ward_name]-$rh21p[bedname]</b> <i class='fa far fa-bed' style='font-size:60px;color:red;'></i></span></a> ";
}
$i++;
}
}
}
}
}
?>
<! ––Post-Operative ––>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='Post-Operative' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
if($rh2p = mysqli_fetch_array($qsql2p))
{
echo"
<h2 align='center'>Post-Operative</b> </h2>";
}
}
?>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='Post-Operative' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
while($rh2p = mysqli_fetch_array($qsql2p))
{
$sqlp="select count('bedid') from bedindex WHERE wardid='$rh2p[wardid]' AND status='Active'";
$resultp=mysqli_query($con,$sqlp);
$row=mysqli_fetch_array($resultp);
$i=0;
$bed=$row[0];
while($i < $bed)
{
$sql21p ="SELECT * FROM bedindex WHERE wardid='$rh2p[wardid]' AND status='Active'";
$qsql21p = mysqli_query($con,$sql21p);
while($rh21p = mysqli_fetch_array($qsql21p))
{
if($i % 5 == 0)
{
echo"<br>";
}
echo"<span><b>$rh2p[ward_name]-$rh21p[bedname]</b> <i class='fa far fa-bed' style='font-size:60px;color:green;'></i></span> ";
$i++;
}
}
}
}
?>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='Post-Operative' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
while($rh2p = mysqli_fetch_array($qsql2p))
{
$sqlp="select count('bedid') from bedindex WHERE wardid='$rh2p[wardid]' AND status='Inactive'";
$resultp=mysqli_query($con,$sqlp);
$row=mysqli_fetch_array($resultp);
$i=0;
$bed=$row[0];
while($i < $bed)
{
$sql21p ="SELECT * FROM bedindex WHERE wardid='$rh2p[wardid]' AND status='Inactive'";
$qsql21p = mysqli_query($con,$sql21p);
while($rh21p = mysqli_fetch_array($qsql21p))
{
if($i % 5 == 0)
{
echo"<br>";
}
if(is_numeric($rh21p[prescriptionid]))
{
$sql21pv ="SELECT * FROM addaspatient WHERE prescriptionid='$rh21p[prescriptionid]' ";
$qsql21pv = mysqli_query($con,$sql21pv);
while($rh21pv = mysqli_fetch_array($qsql21pv))
$sql21pvp ="SELECT * FROM patient WHERE patientid='$rh21pv[patientid]' ";
$qsql21pvp = mysqli_query($con,$sql21pvp);
while($rh21pvp = mysqli_fetch_array($qsql21pvp))
{
echo" <a href='Patient/treatment_timline.php?prescriptionid=$rh21p[prescriptionid]&patientid=$rh21pvp[patientid]' title='$rh21pvp[patientid]-$rh21pvp[patientname]'><span><b>$rh2p[ward_name]-$rh21p[bedname]</b> <i class='fa far fa-bed' style='font-size:60px;color:red;'></i></span></a> ";
}
$i++;
}
}
}
}
}
?>
<! ––Pre-Operative ––>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='Pre-Operative' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
if($rh2p = mysqli_fetch_array($qsql2p))
{
echo"
<h2 align='center'>Pre-Operative</b> </h2>";
}
}
?>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='Pre-Operative' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
while($rh2p = mysqli_fetch_array($qsql2p))
{
$sqlp="select count('bedid') from bedindex WHERE wardid='$rh2p[wardid]' AND status='Active'";
$resultp=mysqli_query($con,$sqlp);
$row=mysqli_fetch_array($resultp);
$i=0;
$bed=$row[0];
while($i < $bed)
{
$sql21p ="SELECT * FROM bedindex WHERE wardid='$rh2p[wardid]' AND status='Active'";
$qsql21p = mysqli_query($con,$sql21p);
while($rh21p = mysqli_fetch_array($qsql21p))
{
if($i % 5 == 0)
{
echo"<br>";
}
echo"<span><b>$rh2p[ward_name]-$rh21p[bedname]</b> <i class='fa far fa-bed' style='font-size:60px;color:green;'></i></span> ";
$i++;
}
}
}
}
?>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='Pre-Operative' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
while($rh2p = mysqli_fetch_array($qsql2p))
{
$sqlp="select count('bedid') from bedindex WHERE wardid='$rh2p[wardid]' AND status='Inactive'";
$resultp=mysqli_query($con,$sqlp);
$row=mysqli_fetch_array($resultp);
$i=0;
$bed=$row[0];
while($i < $bed)
{
$sql21p ="SELECT * FROM bedindex WHERE wardid='$rh2p[wardid]' AND status='Inactive'";
$qsql21p = mysqli_query($con,$sql21p);
while($rh21p = mysqli_fetch_array($qsql21p))
{
if($i % 5 == 0)
{
echo"<br>";
}
if(is_numeric($rh21p[prescriptionid]))
{
$sql21pv ="SELECT * FROM addaspatient WHERE prescriptionid='$rh21p[prescriptionid]' ";
$qsql21pv = mysqli_query($con,$sql21pv);
while($rh21pv = mysqli_fetch_array($qsql21pv))
$sql21pvp ="SELECT * FROM patient WHERE patientid='$rh21pv[patientid]' ";
$qsql21pvp = mysqli_query($con,$sql21pvp);
while($rh21pvp = mysqli_fetch_array($qsql21pvp))
{
echo" <a href='Patient/treatment_timline.php?prescriptionid=$rh21p[prescriptionid]&patientid=$rh21pvp[patientid]' title='$rh21pvp[patientid]-$rh21pvp[patientname]'><span><b>$rh2p[ward_name]-$rh21p[bedname]</b> <i class='fa far fa-bed' style='font-size:60px;color:red;'></i></span></a> ";
}
$i++;
}
}
}
}
}
?>
<! ––Pre-Operative ––>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='Emergency and Accidental' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
if($rh2p = mysqli_fetch_array($qsql2p))
{
echo"
<h2 align='center'>Emergency and Accidental</b> </h2>";
}
}
?>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='Emergency and Accidental' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
while($rh2p = mysqli_fetch_array($qsql2p))
{
$sqlp="select count('bedid') from bedindex WHERE wardid='$rh2p[wardid]' AND status='Active'";
$resultp=mysqli_query($con,$sqlp);
$row=mysqli_fetch_array($resultp);
$i=0;
$bed=$row[0];
while($i < $bed)
{
$sql21p ="SELECT * FROM bedindex WHERE wardid='$rh2p[wardid]' AND status='Active'";
$qsql21p = mysqli_query($con,$sql21p);
while($rh21p = mysqli_fetch_array($qsql21p))
{
if($i % 5 == 0)
{
echo"<br>";
}
echo"<span><b>$rh2p[ward_name]-$rh21p[bedname]</b> <i class='fa far fa-bed' style='font-size:60px;color:green;'></i></span> ";
$i++;
}
}
}
}
?>
<?php
$sqlp ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsqlp = mysqli_query($con,$sqlp);
while($rsp = mysqli_fetch_array($qsqlp))
{
$sql2p ="SELECT * FROM ward WHERE ward_type='Emergency and Accidental' AND adminid='$rsp[entered_by]'";
$qsql2p = mysqli_query($con,$sql2p);
while($rh2p = mysqli_fetch_array($qsql2p))
{
$sqlp="select count('bedid') from bedindex WHERE wardid='$rh2p[wardid]' AND status='Inactive'";
$resultp=mysqli_query($con,$sqlp);
$row=mysqli_fetch_array($resultp);
$i=0;
$bed=$row[0];
while($i < $bed)
{
$sql21p ="SELECT * FROM bedindex WHERE wardid='$rh2p[wardid]' AND status='Inactive'";
$qsql21p = mysqli_query($con,$sql21p);
while($rh21p = mysqli_fetch_array($qsql21p))
{
if($i % 5 == 0)
{
echo"<br>";
}
if(is_numeric($rh21p[prescriptionid]))
{
$sql21pv ="SELECT * FROM addaspatient WHERE prescriptionid='$rh21p[prescriptionid]' ";
$qsql21pv = mysqli_query($con,$sql21pv);
while($rh21pv = mysqli_fetch_array($qsql21pv))
$sql21pvp ="SELECT * FROM patient WHERE patientid='$rh21pv[patientid]' ";
$qsql21pvp = mysqli_query($con,$sql21pvp);
while($rh21pvp = mysqli_fetch_array($qsql21pvp))
{
echo" <a href='Patient/treatment_timline.php?prescriptionid=$rh21p[prescriptionid]&patientid=$rh21pvp[patientid]' title='$rh21pvp[patientid]-$rh21pvp[patientname]'><span><b>$rh2p[ward_name]-$rh21p[bedname]</b> <i class='fa far fa-bed' style='font-size:60px;color:red;'></i></span></a> ";
}
$i++;
}
}
}
}
}
?>