Feeling an insane amount of embarrassment after a night of drinking. Please help

Looking for help and advice. I’m dealing with an insane amount of shame and embarrassment from drinking at a bar the other night and this isn’t the first time… I’m starting to really think I need to quit drinking in a bar/party setting. I went out with a guy im seeing and it was he’s leaving party he’s going on a trip for a few months and I met a lot of his friends and coworkers that night and I was a hot mess ! I knew going into the night I didn’t eat enough prior to drinking and that should have been my first clue to SLOW DOWN ! But he works at a bar and he gets free drinks offered to him and because I was with him so did I. The shots and double drinks were flowing and I began to overshare get loud and obnoxious.

When I’m drinking I’m always overly positive and lovey dovey. I was flirting with women telling them how pretty they are (I’m straight) and telling all his friends how much I like them and we should hang out again. I was acting like a 15 year. All over the place and running around like a fool. The flash backs from the night are absolutely haunting me there’s parts of the night I don’t remember at all and I’m worried about what else I said or did that night. I hate myself so much.

I know if I was in his shoes I would have been so embarrassed to be with me. We’ve had a few nights like this I’m actually shocked he still likes me tbh… I would have been so turned off.

My text message to him the next day —> “I honestly just want to apologize for being messy last night I have no idea how those drinks got to me so quickly 🙈

His response—-> “Nah honestly don’t feel bad, I was just happy I got to spend my last night with you. Feel like it was a good to go out aswell. I think it was because u didn’t eat…. Again hahaha”

I need advice on my problem I can go out for dinner and have a few drinks and not over do it I don’t feel the need to drink at home alone but in a party /bar setting I ALWAYS over do it. I’m thinking about trying 30 days sober and going from there. I’m open to harsh constructive feedback. Help