bladder spasms (not CP related, but yall are smart! Need some advice)

So I have had a raging UTI for about 10 days(well dx"ed 10 days ago, pain long before that).
I have had now 2 antibiotic shots, a dose of Keflex(sp?), and 2 different anti-spasm meds. (who knew your pee could be so blue and orange lol).

Problem is the bladder spasms. They are horrible and will not go away. The only thing that has helped is some suppository I was given in ER. I had to go to ER bc I could not empty my bladder for over 20 hours. Urine is still "full of infection" (drs words) so got more abx and another shot of rocephin.

Only wondering why it says not to take this spasm med longer than 3 days? bc they just tell me to keep taking it (it really only reduces the spasms severity, as they never seem to stop).
The other day I passed out while voiding bc the spasm pain was so intense.

I drink water with Lemon Essential oil, cranberry juice, epson salt baths, use other antibiotic oils, take the meds, and still no relief.

Don't want to be dealing with this during surgery recovery too....

(also, will having this infection effect infection risk with surgery??)

thanks for any advice! I know its not really CP related, but you guys often seem smarter than most of my DRs as far as advice you give.

i am literally sceaming in pain right this moment...nothing is helping. I can't just keep going to ER. I just want it to go away....this is like labor that just won't stop.
Now my kidneys are really hurting in my back, and bladder.