I'm looking to build an RSVP page for a wedding website. I'm slightly familiar with php and mysql, so that would be best, but open to whatever works. The following is a general description, but not set in stone if you have ideas you think would work better.
I'd like to be able to import a csv file that has fields for first_name, last_name, allowed_adult_guests, allowed_children_guests, address, phone, email, notes, RSVP_ID, status
RSVP_ID will be a unique alphanumeric string in the form of xxxx-xxxx
The webpage will display a page prompting for the RSVP_ID. When a valid RSVP is entered a page will display two buttons and the users first and last name. One button declining the invitation and the other accepting it. If declined, status field will be updated to DECLINED, and a page with some TBD text will display and an email will fire off to me with this update.
If accepted, a page with dropdown boxes from 0 to allowed_adult_guests and 0 to allowed_children_guests, a box to put an email in, a box to add a phone number, a box to add notes(food allergies..), and a submit buton will be viewable. The only required field will be an email. When submit is clicked the status will be updated to ACCEPTED and the corresponding field will be updated, a confirmation page will show up with some TBD text and an email will fire off to me with the information.
I don't need anything pretty as I'm planning on inserting this into an existing site.