Server IP : 162.240.98.243 / Your IP : 18.221.126.56 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/ |
Upload File : |
<?php session_start(); include("headers.php"); include("menu.php"); include("dbconnection.php"); require_once("../patientmanager.php"); require_once("../DBManager.php"); if(isset($_POST[submit])) { PatientManager::updateaddbedward("$_POST[wardid]","$_POST[bedname]","$_POST[price]","$_POST[status]","$_POST[prescriptionid]"); } if(isset($_GET[delid])) { $sql ="DELETE FROM bedindex WHERE bedid='$_GET[delid]'"; $qsql=mysqli_query($con,$sql); if(mysqli_affected_rows($con) == 1) { echo "<script>alert('Delete Successfully..');</script><script>window.location='addbedindex.php?wardid=$_GET[wardid]'</script>"; } } ?> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <ul> <li class="first">Ward</li></ul> </div> </div> <div class="wrapper col4"> <div id="container"> <div class="content-wrapper"> <!-- Content Header (Page header) --> <section class="content-header"> <table id="example2" class="table table-bordered table-hover"> <thead> <tr> <div class='card-header d-flex p-0'> <ul class='nav nav-pills ml-auto p-2'> <th><strong>Ward</strong></th> <th><strong>Type</strong></th> <th><strong>Bed Details </strong></th> <th><strong>Action</strong></th> </tr> </thead> <?php $sql ="SELECT * FROM ward WHERE wardid='$_GET[wardid]'"; $qsql = mysqli_query($con,$sql); while($rs = mysqli_fetch_array($qsql)) { $sql1 ="SELECT * FROM bedindex WHERE wardid='$rs[wardid]'"; $qsql1 = mysqli_query($con,$sql1); while($rs1 = mysqli_fetch_array($qsql1)) { echo " <tbody> <tr> "; if($rs[ward_department]=='1') { echo"<td> Incentive Unit</td>"; }else{ echo"<td>Ward</td>"; } echo"<td> $rs[ward_type]</td> <td> $rs[ward_name]-"; if(3==$rs[ward_department]) { echo" Table no: "; } else{ echo"Bed no :"; } echo"$rs1[bedname]</td> <td> <a href='addbedindex.php?wardid=$rs[wardid]&delid=$rs1[bedid]'> <i class='fa fa-trash-o' style='font-size:20px;color:red'></i></a></td>"; } } ?> </tr> </thead> </tbody> <tfoot> </tfoot> </table> <form method="post" action="" name="submit"> <table width="532" border="3"> <table id="example2" class="table table-bordered table-hover"> <tbody> <?php $sqlpatient= "SELECT * FROM ward WHERE wardid='$_GET[wardid]'"; $qsqlpatient = mysqli_query($con,$sqlpatient); while($rspatient=mysqli_fetch_array($qsqlpatient)) { echo" <input type='hidden' name='status' value='Active'> <input type='hidden' name='wardid' value='$rspatient[wardid]'> "; } ?> <?php $sql="SELECT count('wardid') FROM bedindex WHERE wardid='$_GET[wardid]'"; $result=mysqli_query($con,$sql); $row=mysqli_fetch_array($result); { $bedtry=$row[0]; $Bedno=$bedtry+1; echo" <input type='hidden' name='bedname' value='$Bedno'> "; } ?> <?PHP $sql ="select * from ward where wardid='$_GET[wardid]'"; $qsql = mysqli_query($con,$sql); if($qsql2=mysqli_fetch_array($qsql)) { if(3==$qsql2[ward_department]) { echo" <tr> <td colspan='2' align='center'><input type='submit' name='submit' id='submit' value='Add-Table' /></td> </tr>"; } else { echo" <tr> <td colspan='2' align='center'><input type='submit' name='submit' id='submit' value='Add-Bed' /></td> </tr>"; } } ?> </tbody> </table> </form> <p> </p> </div> </div> </div> <div class="clear"></div> </div> </div> <?php include("footer.php"); ?>