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` = '59' ORDER BY `user`.`view_order` ASC Universal Medical College Hospital ltd.

Psychiatry Department

Psychiatry is the branch of medicine focused on the diagnosis, treatment and prevention of mental, emotional and behavioral disorders.

Doctors :


Array
(
    [0] => stdClass Object
        (
            [user_id] => 53
            [dpId] => 0
            [firstname] => Prof. Brig. Gen. Dr. Habibur
            [lastname] => Rahman (Retd)
            [email] => patientcare@umchltd.com
            [password] => d41d8cd98f00b204e9800998ecf8427e
            [user_role] => 2
            [department_id] => 59
            [view_order] => 13
            [picture] => assets/images/doctor/f922803d88d32bc06487fe476e0ac02e.png
            [date_of_birth] => 1970-01-01
            [sex] => Male
            [blood_group] => 
            [vacation] => 
            [facebook] => https://www.facebook.com/umchltd
            [twitter] => 
            [youtube] => https://www.youtube.com/channel/UC5LBDsiyCXYgBqYYLj6Mr8Q
            [dribbble] => 
            [behance] => 
            [created_by] => 3
            [create_date] => 2021-07-24
            [update_date] => 
            [status] => 1
            [name] => Psychiatry
            [id] => 51
            [language] => english
            [designation] =>  Professor
            [address] => 74G/75,Peacock Square
Dhaka-1215, Bangladesh
            [phone] => 09612808080
            [mobile] => 01841480000
            [career_title] => Psychiatrist
            [short_biography] => 
            [specialist] => Psychiatry
            [degree] => MBBS,FCPS (psychiatry)
        )

)

Psychiatry

Prof. Brig. Gen. Dr. Habibur Rahman (Retd)
author01

Make an appointment! Go there