What is the ruling on performing the standing (qiyām) and bowing (rukū‘) portions of the prayer normally, while performing the prostration (sujūd) seated due to knee pain?
All praise is due to Allah, and peace and blessings be upon our master, the Messenger of Allah ﷺ.
If performing sujūd (prostration) in prayer causes the worshipper pain in the knees, then it is permissible for him to perform it through gesture (īmā') while seated, since Allah, Glorified and Exalted is He, has lifted hardship from His servants. On the authority of ‘Imrān ibn Ḥuṣayn (raḍiyallāhu ‘anh), he said: "I suffered from hemorrhoids, so I asked the Prophet ﷺ about [how to perform] the prayer, and he said: 'Pray standing; if you are unable, then sitting; and if you are unable, then on your side.'" [Ṣaḥīḥ al-Bukhārī]
If the valid excuse later subsides, the worshipper is then obligated to perform the prayer with all its pillars and conditions fully observed — including standing, rukū‘ (bowing), and sujūd (prostration). And Allah, the Exalted, knows best.
How many prostrations of Quranic recital are there, and is it permissible not to offer them while reciting?
There is one prostration for the Quranic recital, and it is a Sunnah for which one is rewarded upon offering it. However, one who doesn`t isn`t punished. Therefore, those who fail to offer it aren`t considered sinful, rather they deprive themselves from the reward.
Should a person feel pleased, or have a virtuous vision after offering Istikhara (guidance prayer) in order to do what he/she had offered it for?
The result of the Istikhaarah is not necessarily that a person sees something (in his dream), or feels pleased, but the most important result of the Istikhaarah is whether a person is enabled to do a given matter or not.
Is it permissible to offer mandatory prayer while sitting?
All perfect praise be to Allah, The Lord of The Worlds, and may His Peace and Blessings be upon our Prophet Muhammad and upon all of his family and companions. Standing up is a pillar in the mandatory prayer and the prayer is not valid without it unless one cannot do it. As for Nafila (supererogatory prayer), one can perform it in the state of sitting even if he/she can stand, but his/her reward is half the reward of the person who prays while standing if he/sh has no legal excuse for such an act. And Allah Knows Best.