<?php
  $username="";
  $password="";

  $conn = mysqli_connect('localhost', 'root', '', 'mydatabase');

  if($conn->connect_error){
    die("Connection Failed:" . $conn->connect_error);
  }

  $sql = "SELECT DoctorID, Images, DoctorName, gender, speciality FROM tb_doctor";
  $result =$conn->query($sql);

  if ($result->num_rows >0){
    while($row = $result->fetch_assoc()){
        echo "<div class ='col-sm-4 text-center'>";
      echo "<img src='images/"  .$row['Images']."'class='center-block'>";
        echo "<p style='color:white; align='center''>" .$row['DoctorID']. "</p>";
        echo "<p style='font-size: 20px; text-align:center'>" .$row['DoctorName']. "</p>";
        echo "<p style='text-align:center'>" .$row['gender']. "</p>";
        echo "<p style='text-align:center'>" .$row['speciality']. "</p>";

        echo "<a class='btn btn-info btn-lg 'class='center-block'' href='doctor_schedules.php?>' style='font-size:15px; margin-bottom: 25px; margin-top:10px; margin-left:20px; margin-right:20px;'><span class='glyphicon glyphicon-pencil'>Book Appointment</span></a>  ";
        echo "</div>";

    }
  }else{
    echo "0 results";
  }
  $conn->close();