<< Back to Scripts

RSVP Database

Version 1.0.3

Description

This is an rsvp database application that will allow guests to rsvp through a web form, over the phone, or by email. Each entry is stored in a MySQL database. The database has an administrator panel in which the administrator can view and maintain the database entries. This application works well for a wedding website.

Requirements

PHP5
MySQL database
JavaScript enabled browser
PEAR mail classes (Phone voicemail, email, and mass email)
Email piping (Phone voicemail and email)
Cron jobs (Phone voicemail direct FTP and mass email)

Features

RSVP Online Form
  1. Options of RSVP form password, captcha, or no protection.
  2. Form data includes name, optional email, number of guests, optional food choices, and optional comments.
  3. Option to disable Online RSVP form.
  4. Embed form to match the look of your website.
  5. Email notification of new and updated online RSVP entry.
  6. Denies duplicate entries.
  7. Option to make email field required.
  8. Option to allow guests to update current RSVP.
DEMO
RSVP Online Form (This gets embedded in your website)
Password: demo

RSVP Phone Voicemail
  1. Interacts with external voicemail services.
  2. Email notification of new phone RSVP entry.
  3. Option to disable RSVP voicemail.
DEMO
608-406-4107 (Provided by Google Voice)

Need a toll-free number for your wedding voicemail?
Kall8

RSVP Email
  1. Email notification of new email RSVP entry.
  2. Option to disable RSVP email.
  3. Denies duplicate entries.
  4. Email RSVP success notification
DEMO
demo@joeghall.net

Show Database Include File
The show database include file is included in a php/html document and will publicly show the database entries
  1. Control entries per page.
  2. Sort by all/attending/not attending.
  3. Enable/disable showing of guest totals.
  4. Enable/disable showing of total guests attending.
  5. Option to disable include file.
Administrator Panel
  1. Keeps database totals.
  2. Search feature.
  3. Control entries per page.
  4. Manually add entry and option to disable.
  5. Online/phone/email verification feature.
  6. Edit/delete existing entries.
  7. Username/password protected.
  8. Sort by all/attending/not attending/verified/not verified.
  9. Print database view.
  10. Date added feature with time zone selection.
  11. Send emails to guests using admin panel email form.
  12. Download database/voicemail backups and restore database.
  13. Import database to excel spreadsheet.
  14. Listen to voicemails.
  15. Checks for duplicate entries.
  16. Mass email feature.
  17. Option to make email field required.
  18. Shows IP address for online entries.
DEMO
Administrator Panel
Username: admin
Password: demo

License

This application is free to use and is released under the creative commons attribution 3.0 unported license.
Creative Commons License

Download

Latest Version
Version 1.0.3 (Released March 29, 2012)
rsvp_database_v1.0.3.zip

Changes in Version 1.0.3
  1. Shows IP address for online entries
  2. Miscellaneous programming changes
  3. Search by IP address
  4. Some design features changed
Version 1.0.2 sql files are NOT compatible with RSVP Database version 1.0.3 or any future versions.

Bugs/Suggestions

Did you find any bugs, have any suggestions, or need any help? Let me know on the contact page.

Donations