Hi and thanks for the query.
This seems like a Urinary tract infection. You need to have this seen by your GP. Whether this is fungal or bacterial can be ascertained on a swab sent for culture. Since, you have tried over the counter products getting this seen will be more beneficial since antibiotics will be required and they are prescription only.
Mean while, you should drink a lot of water, cranberry juice and disodium sitrate (OTC) sachets thrice a day.
Let me know if you have further questions.
Please do not forget to leave a positive rating by clicking on the stars on top of the screen.
Wish you good health.