SELECT `user`.*, `department`.`name`, `lang`.* FROM `user_lang` as `lang` LEFT JOIN `user` ON `user`.`user_id` = `lang`.`user_id` LEFT JOIN `department` ON `department`.`dprt_id` = `user`.`department_id` WHERE `lang`.`language` = 'english' AND `user`.`user_role` = 2 AND `user`.`status` = 1 AND `user`.`department_id` = '56' ORDER BY `user`.`view_order` ASC Universal Medical College Hospital ltd.

Ophthalmology Department

Ophthalmology is a branch of medicine dealing with the diagnosis, treatment and prevention of diseases of the eye and visual system. The eye, its surrounding structures and the visual system can be affected by a number of clinical conditions.

Doctors :


Array
(
    [0] => stdClass Object
        (
            [user_id] => 93
            [dpId] => 0
            [firstname] => Dr. Faouzia 
            [lastname] => Sultana
            [email] => abc_@gmail.com
            [password] => d9a3c02781e57f57f08a573323b5aa61
            [user_role] => 2
            [department_id] => 56
            [view_order] => 20
            [picture] => assets/images/doctor/a0d6a9eb3a0e5dbdbe146655c6463d14.png
            [date_of_birth] => 2021-06-16
            [sex] => Female
            [blood_group] => 
            [vacation] => 
            [facebook] => https://www.facebook.com/umchltd
            [twitter] => 
            [youtube] => https://www.youtube.com/channel/UC5LBDsiyCXYgBqYYLj6Mr8Q
            [dribbble] => 
            [behance] => 
            [created_by] => 81
            [create_date] => 2021-06-16
            [update_date] => 
            [status] => 1
            [name] => Ophthalmology
            [id] => 92
            [language] => english
            [designation] => Assistant Professor
            [address] => 74G/75,New Airport Road
(Beside Mohakhali Flyover), Mohakali
(Opposite of RAOWA)
Dhaka 1215
            [phone] => 019612808080
            [mobile] => 01841480000
            [career_title] => Ophthalmologist
            [short_biography] => 
            [specialist] => Ophthalmologist
            [degree] => 

MBBS, MS(Ophthalmology)

) )

Ophthalmology

Dr. Faouzia Sultana
author01

Make an appointment! Go there