| Server IP : 162.240.98.243 / Your IP : 3.149.228.138 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/Pharmacy/ |
Upload File : |
<?php
session_start();
require_once('../../DBManager.php');
require_once('../../LoginManager.php');
include 'menu.php';
include 'header.php';
?>
<?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsql = mysqli_query($con,$sql);
if($re = mysqli_fetch_array($qsql))
{
$sql ="SELECT * FROM hco WHERE adminid='$re[entered_by]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo "
<div class='content-wrapper'>
<!-- Content Header (Page header) -->
<section class='content-header'>
<div class='center'>
<table width='100%'>
<fieldset><legend>Basic Profile</legend>
<tr>
<td width='50%'> Organization Phone number: </td>
<td width='50%'>$rs[OrganizationPhonenumber]</td>
</tr>
<tr>
<td width='50%'> Alternative Mobile number : </td>
<td width='50%'>$rs[AlternativeMobilenumber]</td>
</tr>
<tr>
<td width='50%'> Application type: </td>
<td width='50%'>$rs[Applicationtype]</td>
</tr>
<tr>
<td width='50%'> Total Number of Bed Operating: </td>
<td width='50%'>$rs[Bedstrength]</td>
</tr>
<tr>
<td width='50%'> Street: </td>
<td width='50%'>$rs[Street]</td>
</tr>
<tr>
<td width='50%'> Locality : </td>
<td width='50%'>$rs[Locality]</td>
</tr>
<tr>
<td width='50%'> Tahsil : </td>
<td width='50%'>$rs[Tahsil] </td>
</tr>
<tr>
<td width='50%'> District : </td>
<td width='50%'>$rs[District] </td>
</tr>
<tr>
<td width='50%'> State : </td>
<td width='50%'>$rs[State] </td>
</tr>
<tr>
<td width='50%'> Website : </td>
<td width='50%'>$rs[Website] </td>
</tr>
<tr>
<td width='50%'> Location of Hospital : </td>
<td width='50%'>$rs[LocationofHospital] </td>
</tr>
<tr>
<td width='50%'> Head person name : </td>
<td width='50%'>$rs[Headpersonname] </td>
</tr>
<tr>
<td width='50%'> Head person contact number : </td>
<td width='50%'>$rs[Headctnumber] </td>
</tr>
<tr>
<td width='50%'> Other Location : </td>
<td width='50%'>$rs[addressofotherlocation] </td>
</tr>
<tr>
<td width='50%'> Street : </td>
<td width='50%'>$rs[other_Street]] </td>
</tr>
<tr>
<td width='50%'> Block : </td>
<td width='50%'>$rs[other_Locality] </td>
</tr>
<tr>
<td width='50%'> Tahsil :</td>
<td width='50%'>$rs[other_Tahsil] </td>
</tr>
<tr>
<td width='50%'> District :</td>
<td width='50%'>$rs[other_District] </td>
</tr>
</table>
</fieldset>
</div>
";
echo "</td></tr>"; }
}
?>
<br><br><br>
<div class='center'>
<table width='100%'>
<?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM emp WHERE adminid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo "<tr>
<td>
</tr>
</div>
<fieldset><legend>Empanelment and accreditation details</legend>
</div>
<tr>
</td>
</tr>
<tr>
<td width='50%'> Accreditation Level </td>
<td width='50%'>$rs[Accreditationlevel]</td>
</tr>
<tr>
<td width='50%'> Valid Upto : </td>
<td width='50%'>$rs[Validupto]</td>
</tr>
<tr>
<td width='50%'> Identification Number: </td>
<td width='50%'>$rs[identificationnumber]</td>
</tr>
<tr>
<td width='50%'> Accreditationboard: </td>
<td width='50%'>$rs[accreditationboard]</td>
</tr>
<tr>
<td width='50%'> Valid Upto : </td>
<td width='50%'>$rs[othervalidupto]</td>
</tr>
<tr>
<td width='50%'> Other Identification Number </td>
<td width='50%'>$rs[otheridentificationnumber] </td>
</tr>
<tr>
<td width='50%'> Number of
Employee : </td>
<td width='50%'>$rs[Numberofemp] </td>
</tr>
<tr>
<td width='50%'> Name of Empanelled : </td>
<td width='50%'>$rs[Nameofempanelled] </td>
</tr>
<tr>
<td width='50%'> Identification Number : </td>
<td width='50%'>$rs[Identificationno] </td>
</tr>
</table>
</fieldset>
";
}
?>
<div class='center'>
<table width='100%'>
<fieldset><legend>Specialties</legend>
<tr>
<td width='50%'> General Surgery: </td>
<td width='50%'>
<?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM spc WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['GeneralSurgery'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='50%'> ENT: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM spc WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['ENT'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='50%'> Opthalmology: </td>
<td width='50%'>
<?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM spc WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Opthalmology'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='50%'> Obstetrics & Gynaecologyy: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM spc WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Gynaecology'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='50%'> Orthopaedics: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM spc WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Orthopaedics'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='50%'> Cardio Thoracic Surgery: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM spc WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Cardi'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='50%'> Paediatric surgery: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM spc WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Paediatric'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='50%'> Genitourinary Surgery: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM spc WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Genitourinary'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='50%'> Neuro Surgery: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM spc WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Neuro'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='50%'> Surgical Oncology: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM spc WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Surgical'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='50%'> Medical Oncology: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM spc WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Medical'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='50%'> Radiation Oncology: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM spc WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Radiation'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='50%'> Burns,Plastic& reconstructive Surgery: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM spc WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Burns'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='50%'> Polytrauma: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM spc WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Polytrauma'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='50%'> Dental Surgery: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM spc WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Dental'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='50%'> Paediatric Cancer: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM spc WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['paedi'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='50%'> Critical Care Unit: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM spc WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['paedi'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='50%'> General Medicine: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM spc WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['General'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='50%'> Paediatrics: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM spc WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Paediatr'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='50%'> Neonatology: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM spc WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Neonatology'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='50%'> Cardiology: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM spc WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Cardiology'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr><tr>
<td width='50%'> Nephrology: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM spc WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Nephrology'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='50%'> Neurology: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM spc WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Neurology'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='50%'> Chest diseases and respiratory medicine (Pulmonology) </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM spc WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Pulmonology'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
</table>
</fieldset>
<div class='center'>
<table width='100%'>
<fieldset><legend>Services offered</legend>
<tr>
<td width='50%'> Emergency Department: </td>
<td width='50%'>
<?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM services WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Emergency'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='50%'> Physiotherapy: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM services WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Physiotherapy'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='50%'> Pharmacy: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM services WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Pharmacy'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='50%'> Blood bank: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM services WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Blood'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='100%'>Diagnostic centre - radiology (basic)</td>
</tr>
<tr>
<td width='50%'> X-Ray: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM services WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['xray'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
<td width='50%'> ECG: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM services WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['ECG'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='100%'>Diagnostic centre radiology (advance)</td>
</tr>
<tr>
<td width='50%'> CT: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM services WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['CT'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
<td width='50%'> MRI: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM services WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['MRI'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='50%'> Laboratory services: </td>
<td width='50%'>
<?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM services WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Laboratory'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</td>
</tr>
<tr>
<td width='50%'> Ambulance service: </td>
<td width='50%'><?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM dr WHERE drid='$harilal'";
$qsql = mysqli_query($con,$sql);
while($rd = mysqli_fetch_array($qsql))
{
$enterd=$rd['entered_by'];
$sql ="SELECT * FROM services WHERE adminid='$enterd'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Ambulance'];
if($usertype == 'on'){
echo "<i class='fa fa-check' aria-hidden='true'></i>";
} else{
echo "<i class='fa fa-times'></i>";
}
}
}
?>
</table>
</fieldset>
<html>
<head>
<style>
.center {
border: 1px solid grey;
text-align:;
}
table {
border-collapse: separate;
border-spacing: 0 15px;
}
th {
background-color: #4287f5;
color: white;
}
th,
td {
width: 150px;
padding: 5px;
}
h2 {
color: #4287f5;
}
</style>
</head>
<body>
<?php ?>
</body>
</html>