How is the Night Prayer (Qiyam al-Layl) performed?
Praise be to Allah, and peace and blessings be upon our Master, the Messenger of Allah.
Night Prayer (Qiyam al-Layl) refers to the voluntary (Nafl) prayers performed by a person after the Sunset prayer (Maghrib) and before the Dawn prayer (Fajr). As for Tahajjud, it is the voluntary prayer performed during the night specifically after waking up from sleep, as an act of devotion to Allah. Allah the Exalted says {what means}: "And from [part of] the night, pray with it [i.e., recitation] as additional worship for you." (Al-Isra/79). Thus, in terms of reward,Tahajjud is superior to voluntary prayers performed before sleeping. And Allah the Exalted knows best.
When is Istikharah (guidance prayer) Du`a offered, before Tasleem (saying asalamu alikum warahmatu allah wa barakatuh to end the prayer), or after it?
It is offered after Tasleem.
What do you say about someone who stays up all night on Laylat al-Qadr but misses Fajr prayer?
Such a person has deprived themselves of a great reward. Performing obligatory acts is more beloved to Allah than voluntary acts. Fajr prayer is an obligation, and performing it in congregation is equivalent to worshiping for the entire night. So how can someone neglect it while striving for voluntary prayers?!
What are the valid excuses for abstaining from congregational prayer in the mosque?
Praise be to Allah, and peace and blessings be upon our Master, the Messenger of Allah.
Concessions (Rukhsah) are granted to abstain from congregational prayer in the mosque due to general excuses, such as: rain that causes hardship in going out, strong winds at night, heavy mud that cannot be traversed without the risk of soiling oneself, hot winds, and extreme heat or cold. There are also specific individual excuses, such as: illness that makes walking as difficult as walking in the rain, severe drowsiness, evident hunger or thirst, the suppression of bodily wastes (urine, stool, or gas), and fear for one's life, limb, physical faculty, wealth, or honor, among other valid excuses. And Allah the Exalted knows best.
