活动页面 - 出席或不出席 - 我将如何实施？

Question

I need to add these two buttons to the events pages of my website.

Basically, just like any other event page you might come across online, for example Facebook, you get the option to say whether you are attending or not attending the event.

And there is a section on the page with a number of people attending etc.

I would like to know the best solution to tackle this.

I'm not asking you to code it for me, just to point me in the right direction. I was thinking of something like, if the user clicks attending, their username or id is put into the database where the event exists and is added to an attending field in some kind of array format. Same for if they choose to not attend but in a notAttending field.

Answer 1

You're half way there, at least having the concept of a user and event entities - the only step of the puzzle that you're missing is the concept of an attendance entity that stores if the user has declined/is required/is attending/failed to turn up/etc. - so each user has an attendance for each event they're invited to; in database terms this is a many to many relationship (a user can be invited to many events, and an event can be attended by many users), so would typically live in a dedicated table.