public function get_by_ambulatory($amb)
{
$conn = $this->db->conn;
try {
$query = $conn->prepare("\n\t\t\t\t\t\t\t\t\t\tSELECT D.ID, D.FirstName , D.LastName , D.Curriculum, D.Birthday, D.Gender, D.Image\n\t\t\t\t\t\t\t\t\t\tFROM Ambulatories as A \n\t\t\t\t\t\t\t\t\t\tINNER JOIN AmbulatoriesDoctors as AD ON A.ID = AD.AmbulatoryID\n\t\t\t\t\t\t\t\t\t\tINNER JOIN Doctors as D ON AD.DoctorID = D.ID\n\t\t\t\t\t\t\t\t\t\tINNER JOIN Contents as C ON A.NameContentID = C.ID \n\t\t\t\t\t\t\t\t\t\tWHERE A.ID = ? AND C.Lang = ? AND D.Active = 1\n\t\t\t\t\t\t\t\t\t");
$query->execute(array($amb, $this->db->lang));
} catch (PDOException $e) {
echo "Error: " . $e;
}
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
$doctor = new Doctor($this->db);
$doctor->update_class($row);
array_push($this->doctors, $doctor);
}
}
