Is Jira useful to use for Desktop Application, PHP based Application or Android based applications?
It does not really need to know any knowledge of what kind of application you are developing. You can define any number of custom fields and or workflow steps you might need to differentiate between platform and or workflows.
I have used Jira extensively and I love it. Be sure to try the trial. For a small team (up to 10 users) it is very cheap, just 10 dollars.
The Jira Capture tool is mainly focused on testing web-based applications, not sure you can use it to record and exploratory test Desktop and or Mobile applications.