<?php
/**
 * Created by PhpStorm.
 * User: Rochevski
 * Date: 31.10.2017
 * Time: 19:08
 */

class Doctor{
    public $id;
    public $name;
    public $specialty;
    public $institution;
    public $is_active;

    public function __get($name)
    {
        return $this->name;
    }
}

try{
    $dsn = "mysql:host=localhost; dbname=db_random";
    $login = "root";
    $pass = "";
    $pdo = new PDO($dsn,$login,$pass);
    $sql = <<<SQL
SELECT
      *
FROM
      `doctors`;
SQL;

    $ps = $pdo->prepare($sql);
    #$ps->bindValue("indeks", "143029", PDO::PARAM_STR);
    $ps->execute();
    #$ps->setFetchMode(PDO::FETCH_COLUMN,1);
    $ps->setFetchMode(PDO::FETCH_CLASS, "Doctor");

    echo "<p>Lista na dostapni lekari:</p>";
    echo "<ul>";
    foreach($ps as $doctor){
        if($doctor->is_active != 0){
            echo "<li>Lekar: d-r " . $doctor->name . " - " . $doctor->specialty . " - " . $doctor->institution . ".</li>";
        }
    }
    echo "</ul>";
}
catch(Exception $e){
    echo "<p> Sorry we have a problem</p>";
}
?>