got sick while with boyfriend and i feel horrible/guilty

ladies, i need help :( my boyfriend (of a month) and i live about 40 minutes from each other so he came down today to grab lunch and hang out for a bit before going to his friend's tonight. i'm on antibiotics at the moment so before he came to pick me up, i took them with some yogurt and a banana. i've never felt sick from antibiotics before so i didn't think anything of it. anyway, i was feeling good, we went out to lunch and got a bunch of different appetizers and a glass of sangria, so i ate a bit and drank, and towards the end of lunch i started to feel really sick. my stomach was cramping really badly and i asked him if we could go stop by my house real quick so i could run in and get medicine. i ended up running in to go to the bathroom instead and good lord (TMI i'm so sorry) i had the shits from hell. i finished up as quickly as i could and went back out to his car and told him i wasn't really feeling well enough to continue to hang out, and he was very understanding and said it wasn't a problem. i feel horrible that he drove like 2 hours round trip just to grab an hour-long lunch with me. i didn't tell him that i have the shits, just that i have a really bad stomach ache. he's supposed to be driving down here again tomorrow to see me and i want to make it up to him somehow. how would you ladies handle this situation?