include("databaseconnection.php");?>
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
?>
if(isset($_GET['hospitalid'])){
$hospitalid=$_GET['hospitalid'];
}else{
$hospitalid=1;
}
?>
$sql="SELECT * from hospital where username='$hospitalid'";
$result=$conn->query($sql);
if ($result->num_rows > 0) {
while($row=$result->fetch_assoc()) {
$name=$row['name'];
$address=$row['address'];
$contact=$row['contact'];
$discription=$row['discription'];
$profilepicid=$row['profilepicid'];
}
}
?>
$filename="images/profilepic.png";
$sql="SELECT * from images where id=$profilepicid";
$result=$conn->query($sql);
if ($result->num_rows > 0) {
while($row=$result->fetch_assoc()) {
$filename=$row['filename'];
}
}
?>
echo "$address";?>
",$discription);?>
Select Disease