Need to create a simple form / database application. We have an EVENTS table with the following fields: Event ID, Event
Name, Event Description, Event Time, Event Date, Event Location, Event Address, Event Capacity (number of people we can
fit), Gender Split (Yes/No where yes means we can only book half men and half women), Event City, Event State Province.
We have a PERSON table with the following fields: Person ID, Person First Name, Person Last Name, Person Birth Date,
Person Phone Number, Person E-mail, Person Profile (URL to a profile they may have on MySpace or Facebook), Person
Address, Person City, Person State Province, Person Zip Postal Code, Person Gender (Male/Female), Person IP Address,
Person TimeDate stamp (Ip and stamp so we know when they signed up and what IP). We have a BOOKINGS table with the
following: Event ID, Person ID, Deposit (Yes/No), Paid (Yes/No), Attended (Yes/No).
When someone comes to the page, there is a simple four element form. One is a pulldown for State/Province. The other is
a text box for City. The third is a math equation (captcha to make sure they are human). The fourth is a submit button.
When they hit submit, we check if their city and state/province show up in our event database. If it doesn’t we say “So
far we don’t have enough people in that city to start booking events. The best thing you can do is tell people about
this website. If you’d like us to contact you when we have enough people in your area, give us your name and whatever
ways you want us to contact you. Under that would be a form with 4 elements – First Name, E-mail, Phone and Math Captcha
(asks math question to show human).
If we check their city and state / province and there are events in the database, we show them a list of all events in
their area from the current date forward sorted by date (oldest to newest). It also says “We’ve already had ### events
and you missed ## dates in your area alone” which we pull from the database. The list has the Event Name, the Event
Location, Event Date and CLICK FOR INFO button. Following the button we put the following text – if we’re less than half
capacity (count bookings for event, is it less than half of the capacity?), then we put Space Available. If we’re over
half capacity, we say Almost Full. If it’s equal to or above capacity, we then say Event Full and we also change the
displayed location to SECRET and take away the CLICK FOR INFO button.
If they click on the CLICK FOR INFO button, they’re taken to a page which shows the database information in a nice
format for that specific event (time, location, address, etc). On the bottom of that page is a “CLICK HERE TO JOIN THIS
EVENT” button. When they click on that button, they’re given a form that asks them all their Person info. Of course, the
state/province and the city should be auto-filled since they entered that before. There should be a math captcha and a
scrolling text box that pulls text from a file called Rules.txt” – it enables me to change the file Rules.txt and then
the scroll box is updated. Once they enter their personal information and hit submit, we go to a page that gives them
two options. One is “Place Deposit” and the other is “Pay in Full (10% Discount)”. There is a paypal link for both of
them set to $10 (for the deposit) and $44.99. When they do the paypal, then we update the database for them to Deposit
Yes/No, Paid Yes/No and give them a confirmation page.
The simple admin panel would allow us to search/list/modify/create records in each table. It’s important that we can set
the capacity of certain events to ZERO. That way those events would come up as “Full” automatically.