| Server IP : 162.240.98.243 / Your IP : 3.145.177.39 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();
require_once("../dbconnection.php");
require_once('../DBManager.php');
$sql51 ="SELECT * FROM Oxygen WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id=$rsp[pagetype]";
$qsql51 = mysqli_query($con,$sql51);
while($rt51 = mysqli_fetch_array($qsql51)){
$duration= $rt51['duration'];
if($rsp['discription']=='Oxygen' || $rsp['pagetype']==$rt51[id]){
$p=$rsp[pricetotal] ;
$h=$duration;
$z=$p*$h;
echo $p.' * '.$h.' hour<br>';
echo $z. ' ';
}else{
$pricedue=$rsp[pricetotal];
}
}
$BIPAP ="SELECT * FROM BIPAP WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id=$rsp[pagetype]";
$qBIPAP = mysqli_query($con,$BIPAP);
if($rBIPAP = mysqli_fetch_array($qBIPAP)){
$d_BIPAP= $rBIPAP['duration'];
if($rsp['discription']=='BIPAP' || $rsp['pagetype']==$rBIPAP[id]){
$p=$rsp[pricetotal] ;
$h=$d_BIPAP;
$z=$p*$h;
echo $p.' * '.$h.' hour<br>';
echo $z. ' ';
}else{
$pricedue=$rsp[pricetotal];
}
}
$Ventilator ="SELECT * FROM Ventilator WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id=$rsp[pagetype]";
$qVentilator = mysqli_query($con,$Ventilator);
while($rVentilator = mysqli_fetch_array($qVentilator)){
$d_Ventilator= $rVentilator['duration'];
if($rsp['discription']=='BIPAP' || $rsp['pagetype']==$rVentilator[id]){
$p=$rsp[pricetotal] ;
$h=$d_Ventilator;
$z=$p*$h;
echo $p.' * '.$h.' hour<br>';
echo $z. ' ';
}else{
$pricedue=$rsp[pricetotal];
}
}
$CPAP ="SELECT * FROM CPAP WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id=$rsp[pagetype]";
$qCPAP = mysqli_query($con,$CPAP);
while($rCPAP = mysqli_fetch_array($qCPAP)){
$d_CPAP= $rCPAP['duration'];
if($rsp['discription']=='CPAP' || $rsp['pagetype']==$rCPAP[id]){
$p=$rsp[pricetotal] ;
$h=$d_CPAP;
$z=$p*$h;
echo $p.' * '.$h.' hour<br>';
echo $z. ' ';
}else{
$pricedue=$rsp[pricetotal];
}
}
$tableName='Dressing';
$Discription='Dressing Small';
$Discription='Dressing Medium';
$Discription='Dressing Large';
$Dressing ="SELECT * FROM $tableName WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id=$rsp[pagetype]";
$qDressing = mysqli_query($con,$Dressing);
while($rDressing = mysqli_fetch_array($qDressing)){
$d_Dressing= $rDressing['duration'];
if($rsp['discription']=='$Discription' || $rsp['pagetype']==$rDressing[id]){
$p=$rsp[pricetotal] ;
$h=$d_Dressing;
$z=$p*$h;
echo $p.' * '.$h.' <br>';
echo $z. ' ';
}else{
$pricedue=$rsp[pricetotal];
}
}
$Catheterization ="SELECT * FROM Catheterization WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id=$rsp[pagetype]";
$qCatheterization = mysqli_query($con,$Catheterization);
while($rCatheterization = mysqli_fetch_array($qCatheterization)){
$d_Catheterization= $rCatheterization['duration'];
if($rsp['discription']=='Catheterization' || $rsp['pagetype']==$rCatheterization[id]){
$p=$rsp[pricetotal] ;
$h=$d_Dressing;
$z=$p*$h;
echo $p.' * '.$h.' <br>';
echo $z. ' ';
}else{
$pricedue=$rsp[pricetotal];
}
}
// -------------------------- Physiotherapy-------------------------------
$Physiotherapy ="SELECT * FROM Physiotherapy WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id=$rsp[pagetype]";
$qPhysiotherapy = mysqli_query($con,$Physiotherapy);
while($rPhysiotherapy = mysqli_fetch_array($qPhysiotherapy)){
$d_Physiotherapy= $rPhysiotherapy['duration'];
if($rsp['discription']=='Physiotherapy' || $rsp['pagetype']==$rPhysiotherapy[id]){
$p1=$rsp[pricetotal] ;
$h1=$d_Physiotherapy;
$z=$p1*$h1;
echo $p.' * '.$h1.' <br>';
echo $z. ' ';
}else{
$pricedue=$rsp[pricetotal];
}
}
$Dietician ="SELECT * FROM Dietician WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id=$rsp[pagetype]";
$qDietician = mysqli_query($con,$Dietician);
while($rDietician = mysqli_fetch_array($qDietician)){
$d_Dietician= $rDietician['duration'];
if($rsp['discription']=='Dietician' || $rsp['pagetype']==$rDietician[id]){
$p=$rsp[pricetotal] ;
$h=$d_Dietician;
$z=$p*$h;
echo $p.' * '.$h.' <br>';
echo $z. ' ';
}else{
$pricedue=$rsp[pricetotal];
}
}
$bloodtransfusion ="SELECT * FROM bloodtransfusion WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id=$rsp[pagetype]";
$qbloodtransfusion = mysqli_query($con,$bloodtransfusion);
while($rbloodtransfusion = mysqli_fetch_array($qbloodtransfusion)){
$d_bloodtransfusion= $rbloodtransfusion['duration'];
if($rsp['discription']=='Blood Tranfusion' || $rsp['pagetype']==$rbloodtransfusion[id]){
$p=$rsp[pricetotal] ;
$h=$d_bloodtransfusion;
$z=$p*$h;
echo $p.' * '.$h.' <br>';
echo $z. ' ';
}else{
$pricedue=$rsp[pricetotal];
}
}
// -------------------------- Dailysis-------------------------------
$Dialysis ="SELECT * FROM Dialysis WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id=$rsp[pagetype]";
$qDialysis = mysqli_query($con,$Dialysis);
while($rDialysis = mysqli_fetch_array($qDialysis)){
$d_Dialysis= $rDialysis['duration'];
if($rsp['discription']=='Dialysis' || $rsp['pagetype']==$rDialysis[id]){
$p=$rsp[pricetotal] ;
$h=$d_Dialysis;
$z=$p*$h;
echo $p.' * '.$h.' <br>';
echo $z. ' ';
}else{
$pricedue=$rsp[pricetotal];
}
}
// -------------------------- Section-------------------------------
$Suction ="SELECT * FROM Suction WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id=$rsp[pagetype]";
$qSuction = mysqli_query($con,$Suction);
while($rSuctions = mysqli_fetch_array($qSuction)){
$d_Suction= $rSuctions['duration'];
if($rsp['discription']=='Suction' || $rsp['pagetype']==$rSuctions[id]){
$p=$rsp[pricetotal] ;
$h=$d_Suction;
$z=$p*$h;
echo $p.' * '.$h.' <br>';
echo $z. ' ';
}else{
$pricedue=$rsp[pricetotal];
}
}
// -------------------------- Nebulization-------------------------------
$Nebulization ="SELECT * FROM Nebulization WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id=$rsp[pagetype]";
$qNebulization = mysqli_query($con,$Nebulization);
while($rNebulization = mysqli_fetch_array($qNebulization)){
$d_Nebulization= $rNebulization['duration'];
if($rsp['discription']=='Nebulization' || $rsp['pagetype']==$rNebulization[id]){
$p=$rsp[pricetotal] ;
$h=$d_Nebulization;
$z=$p*$h;
echo $p.' * '.$h.' <br>';
echo $z. ' ';
}else{
$pricedue=$rsp[pricetotal];
}
}
//-------------------------ivpcentralline-------------------------------
$ivpcentralline ="SELECT * FROM ivpcentralline WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id=$rsp[pagetype]";
$qivpcentralline = mysqli_query($con,$ivpcentralline);
while($rivpcentralline = mysqli_fetch_array($qivpcentralline)){
$d_ivpcentralline= $rivpcentralline['duration'];
if($rsp['discription']=='IVP' || $rsp['pagetype']==$rivpcentralline[id]){
$p=$rsp[pricetotal] ;
$h=$d_ivpcentralline;
$z=$p*$h;
echo $p.' * '.$h.' <br>';
echo $z. ' ';
}else{
$pricedue=$rsp[pricetotal];
}}
//-------------------------echoc-------------------------------
$echoc ="SELECT * FROM echoc WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id=$rsp[pagetype]";
$qechoc = mysqli_query($con,$echoc);
while($rechoc = mysqli_fetch_array($qechoc)){
$d_echoc= $rechoc['duration'];
if($rsp['discription']=='Echo Charges' || $rsp['pagetype']==$rechoc[id]){
$p=$rsp[pricetotal] ;
$h=$d_echoc;
$z=$p*$h;
echo $p.' * '.$h.' <br>';
echo $z. ' ';
}else{
$pricedue=$rsp[pricetotal];
}}
//-------------------------ECT-------------------------------
$etc ="SELECT * FROM etc WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id=$rsp[pagetype]";
$qetc = mysqli_query($con,$etc);
while($retc = mysqli_fetch_array($qetc)){
$d_etc= $retc['duration'];
if($rsp['discription']=='ECT' || $rsp['pagetype']==$retc[id]){
$p=$rsp[pricetotal] ;
$h=$d_etc;
$z=$p*$h;
echo $p.' * '.$h.' <br>';
echo $z. ' ';
}else{
$pricedue=$rsp[pricetotal];
}}
//-------------------------Electrotherapy-------------------------------
$Electrotherapy ="SELECT * FROM Electrotherapy WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id=$rsp[pagetype]";
$qElectrotherapy = mysqli_query($con,$Electrotherapy);
while($rElectrotherapy = mysqli_fetch_array($qElectrotherapy)){
$d_Electrotherapy= $rElectrotherapy['duration'];
if($rsp['discription']=='Electrotherapy' || $rsp['pagetype']==$rElectrotherapy[id]){
$p=$rsp[pricetotal] ;
$h=$d_Electrotherapy;
$z=$p*$h;
echo $p.' * '.$h.' <br>';
echo $z. ' ';
}else{
$pricedue=$rsp[pricetotal];
}}
//-------------------------Electrotherapylaser-------------------------------
$Electrotherapylaser ="SELECT * FROM Electrotherapylaser WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id=$rsp[pagetype]";
$qElectrotherapylaser = mysqli_query($con,$Electrotherapylaser);
while($rElectrotherapylaser = mysqli_fetch_array($qElectrotherapylaser)){
$d_Electrotherapylaser= $rElectrotherapylaser['duration'];
if($rsp['discription']=='Electrotherapy laser' || $rsp['pagetype']==$rElectrotherapylaser[id]){
$p=$rsp[pricetotal] ;
$h=$d_Electrotherapylaser;
$z=$p*$h;
echo $p.' * '.$h.' <br>';
echo $z. ' ';
}else{
$pricedue=$rsp[pricetotal];
}}
//-------------------------FFT Transfusion-------------------------------
$FFPTransfusion ="SELECT * FROM FFPTransfusion WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id=$rsp[pagetype]";
$qFFPTransfusion = mysqli_query($con,$FFPTransfusion);
while($rFFPTransfusion = mysqli_fetch_array($qFFPTransfusion)){
$d_FFPTransfusion= $rFFPTransfusion['duration'];
if($rsp['discription']=='FFP Transfusion' || $rsp['pagetype']==$rFFPTransfusion[id]){
$p=$rsp[pricetotal] ;
$h=$d_FFPTransfusion;
$z=$p*$h;
echo $p.' * '.$h.' <br>';
echo $z. ' ';
}else{
$pricedue=$rsp[pricetotal];
}}
//-------------------------Intubation-------------------------------
$Intubation ="SELECT * FROM Intubation WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id=$rsp[pagetype]";
$qIntubation = mysqli_query($con,$Intubation);
while($rIntubation = mysqli_fetch_array($qIntubation)){
$d_Intubation= $rIntubation['duration'];
if($rsp['discription']=='Intubation' || $rsp['pagetype']==$rIntubation[id]){
$p=$rsp[pricetotal] ;
$h=$d_Intubation;
$z=$p*$h;
echo $p.' * '.$h.' <br>';
echo $z. ' ';
}else{
$pricedue=$rsp[pricetotal];
}}
//-------------------------pac-------------------------------
$pac ="SELECT * FROM pac WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id=$rsp[pagetype]";
$qpac = mysqli_query($con,$pac);
while($rpac = mysqli_fetch_array($qpac)){
$d_pac= $rpac['duration'];
if($rsp['discription']=='PAC' || $rsp['pagetype']==$rpac[id]){
$p=$rsp[pricetotal] ;
$h=$d_pac;
$z=$p*$h;
// echo $p.' * '.$h.' <br>';
// echo $z. ' ';
}else{
$pricedue=$rsp[pricetotal];
}}
//-------------------------RBS-------------------------------
$RBS ="SELECT * FROM RBS WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id=$rsp[pagetype]";
$qRBS = mysqli_query($con,$RBS);
while($rRBS = mysqli_fetch_array($qRBS)){
$d_RBS= $rRBS['duration'];
if($rsp['discription']=='RBS Records' || $rsp['pagetype']==$rRBS[id]){
$p=$rsp[pricetotal] ;
$h=$d_RBS;
$z=$p*$h;
echo $p.' * '.$h.' <br>';
echo $z. ' ';
}else{
$pricedue=$rsp[pricetotal];
}}
//-------------------------Ryles_tube-------------------------------
$Ryles_tube ="SELECT * FROM Ryles_tube WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id=$rsp[pagetype]";
$qRyles_tube = mysqli_query($con,$Ryles_tube);
while($rRyles_tube = mysqli_fetch_array($qRyles_tube)){
$d_Ryles_tube= $rRyles_tube['duration'];
if($rsp['discription']=='Ryles tube' || $rsp['pagetype']==$rRyles_tube[id]){
$p=$rsp[pricetotal] ;
$h=$d_Ryles_tube;
$z=$p*$h;
echo $p.' * '.$h.' <br>';
echo $z. ' ';
}else{
$pricedue=$rsp[pricetotal];
}}
?>