amnarii Posted June 12, 2007 Share Posted June 12, 2007 I wish to make a site specifically to allow certain members (admin level) set up a party; i.e. use an event type calendar to add an event to a certain date and time. This doesn't even need to look like a calendar; as long as the date and time can be specified and displayed, I would actually prefer only showing the parties in a list, soonest on top and the last on the bottom... I then want a mass email (an 'evite' of sorts) sent to all members, notifying them about this new event. Obviously this requires member registration (and two levels of members - one or more admins, and 'regular' members If the members can attend a specific party, I want them to be able to RSVP by clicking some button or posting/replying to a brief message, etc. I also want all members to be able to see a list in the party's description of all of the members who have RSVP'd (as above) up to this point for that party, which may help them decide if they will be attending. For non-members, I want a brief intro page describing the parties we have, and explaining the benefits of being a member (reduced cover charge, advance notice of parties, etc.) I am fairly certain php (and SQL) can handle all of this, but I have no idea where to start. What is the best solution for me to get this going? Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/55222-party-planning-site/ Share on other sites More sharing options...
Caesar Posted June 12, 2007 Share Posted June 12, 2007 http://www.php.net What you described can definitely be done with PHP/MySQL...but it will require some effort frm you to learn. I suggest starting with the basics. Quote Link to comment https://forums.phpfreaks.com/topic/55222-party-planning-site/#findComment-272961 Share on other sites More sharing options...
amnarii Posted June 12, 2007 Author Share Posted June 12, 2007 I do know some rudimentary PHP, and MySQL - I've done basic coding on my own, and modified a ton of codes others have made... this is just the grandest (by far) project I have decided to take on. I suppose I should have been a bit more specific in my post as to what I am thinking of doing, to see if it is the smartest and/or easiest way to go about things... then take it from there. First, I have in mind 3 SQL tables to start; Parties, Users, and Attendance... Party Table; PID - auto unique ID used to reference the party entry Date_Start - the date the party starts Date_End - the date the party ends (typically same day it starts, unless passing midnight) Time_Start - the time the party starts Time_End - the time the party ends Party - the 'name' of the party Location - the location of the party Description - a full description of the party User Table; UID - auto unique ID used to reference the user Username - unique username Password - MD5 hash Gender - male, female, couple... used to determine the total ratio of men to women RSVP'd Email - email address, used for 'evites' Attendance Table; AID - auto unique ID used to reference the attendance chart PartyID - PID for party in question UserID - array of all UID's who have RSVP'd ------------------------------------ From there, I can set up a table style list of parties, hyperlinked to a page to show the full description of each party, displayed as follows; DATE, PARTY, (# of RSVPs), (Male:Female ratio) First sentence (or N words) of DESCRIPTION example list: May 01, 2007 | Summer Bash '07 | 27 (16:11) We're hoping to make this one of the best ... May 19, 2007 | Hawaiian Shirt luau | 12 (9:3) Make sure you wear your best Hawaiian Shirt to ... June 02, 2007 | Pervert's Pajama Party | 64 (39:25) This is absolutely going to be the biggest and ... ------------------------------------ Then, on the hyperlinked details page, it would be set up with full details as follows; (Party) (Date_Start), (Time_Start) till (Date_End), (Time_End) (Location) ---------------------------------------- (Description) ---------------------------------------- ### RSVP's, (Gender=='Male' + Gender=='Couple') men : (Gender=='Female' + Gender=='Couple') (List the [username]s from the UserID array) ---------------------------------------- [if current user is not in the UserID array for this party, display button, "RSVP" . . . else display button "Remove me from Guest List"] okay - I know all of that is overly simplified and probably crude, but it is my initial concept. Any help/advice/suggestions on making it better, or actually making some code to handle the tough bits? (I know I can handle reading from and writing to the tables, everything else is a bit iffy at this point, lol) Quote Link to comment https://forums.phpfreaks.com/topic/55222-party-planning-site/#findComment-272970 Share on other sites More sharing options...
amnarii Posted June 12, 2007 Author Share Posted June 12, 2007 Just a bump, trying to get some input before I get started on writing my own code... don't want to waste time in the wrong direction! Quote Link to comment https://forums.phpfreaks.com/topic/55222-party-planning-site/#findComment-273477 Share on other sites More sharing options...
Caesar Posted June 12, 2007 Share Posted June 12, 2007 First, I would suggest storing dates in an INT table as timestamps. You can reformat them any way you like for display purposes...but timestamps are much much easier to work with in so many different ways, and can be compared easily. Quote Link to comment https://forums.phpfreaks.com/topic/55222-party-planning-site/#findComment-273506 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.