Development PHP Events Project

Discussion in 'Software' started by Mary Jo, 17 Mar 2005.

  1. Mary Jo

    Mary Jo oh lolz

    Joined:
    13 Oct 2004
    Posts:
    651
    Likes Received:
    1
    I'm looking for a PHP events calendar to be used by me and my friends to organise nights out and stuff. Just wondering if something like this already exists or if need to write it myself. The idea is simple really:

    It would be an system where users can register and post events with a date, time, location etc. and then other users would be able to 'subscribe' to that event ie. say they'll go along.

    After the event users should be able to upload images and post comments in a forum thread style manner.

    Additionally, after the event has taken place the event organiser would be able to confirm for each user whether or not they attended and some kind of 'reliability' rating would be assigned for users. I understand it's unlikely for this feature to be available in an already existing script.
     
    Last edited: 26 Mar 2005
  2. Atomic

    Atomic Gerwaff

    Joined:
    6 May 2002
    Posts:
    9,646
    Likes Received:
    94
  3. Mary Jo

    Mary Jo oh lolz

    Joined:
    13 Oct 2004
    Posts:
    651
    Likes Received:
    1
    Cheers. Not exactly what I was looking for though.

    Anyone know of any others?
     
  4. Bogomip

    Bogomip ... Yo Momma

    Joined:
    15 Jun 2002
    Posts:
    5,161
    Likes Received:
    39
    why dont you tell us what you are looking for then ? that was a calender, written in php, and it looked, very much to me, like it contained a load of events!
     
  5. Mary Jo

    Mary Jo oh lolz

    Joined:
    13 Oct 2004
    Posts:
    651
    Likes Received:
    1
    Well, actually. After re-looking at that, it seems I could probably use that and adapt it, but I was wondering if there was anything already available that had a "signup" type feature as described.
     
  6. Mary Jo

    Mary Jo oh lolz

    Joined:
    13 Oct 2004
    Posts:
    651
    Likes Received:
    1
    Hell, that'll do fine with some editing. Just gotta integrate a signup script into the deal. Cheers atomic.
     
  7. Hwulex

    Hwulex What's a Dremel?

    Joined:
    1 Feb 2002
    Posts:
    4,007
    Likes Received:
    1
    vBulletin?

    Seriously, it's got a well featured calendar (public, and private) included, with all the forum stuff and signups to boot. Bonza. :thumb:
     
  8. Mary Jo

    Mary Jo oh lolz

    Joined:
    13 Oct 2004
    Posts:
    651
    Likes Received:
    1
    I was thinking about that actually. I've already got a vbulletin running at the location where I was planning to host the events calendar. The majority of people who would be using the calendar are already signed up to this.

    It seems like quite a major task though. I'd like to almost completely lose the entire look of vbulletin. Here's roughly how I'd planned things to look.

    // index.php
    -upcoming events (5 latest)
    --- "pub visit" on "20 March 2004 20:00" at "pub" (link to event.php)
    --- etc.

    -recent events
    --- "pub visit" on "12 March 2004 20:00" at "pub" (link to event.php)
    --- etc.


    // calendar.php
    - graphic calendar like as in vbulletin with listings (linked again to event.php)


    // event.php
    -event title
    -date
    -location
    -organiser
    -list of people signed up + options to sign up
    -comments (vbulletin forum thread style)
    -photos

    Register pages and profile pages would also be required.

    You think it's a realistic task to hack vB this much?
     
  9. Bogomip

    Bogomip ... Yo Momma

    Joined:
    15 Jun 2002
    Posts:
    5,161
    Likes Received:
    39
    my bad, sorry for being so rude :)
     
  10. Hwulex

    Hwulex What's a Dremel?

    Joined:
    1 Feb 2002
    Posts:
    4,007
    Likes Received:
    1
    Hmm, sounds like a bit of an undertaking to modify vBulletin (or anything that doens't do exactly that) tbh.

    I'd offer to write it, but 1) I don't have time 2) I ain't free. ;) :p
     
  11. Hwulex

    Hwulex What's a Dremel?

    Joined:
    1 Feb 2002
    Posts:
    4,007
    Likes Received:
    1
  12. Mary Jo

    Mary Jo oh lolz

    Joined:
    13 Oct 2004
    Posts:
    651
    Likes Received:
    1
    Hehe, don't worry bout it, dude. Nobody reads threads fully. :p


    I know basic PHP and could probably write it myself, I'm just totally unsure of the actual algorithms eg. when trying to write a user membership script I just found myself completely unsure about how secure it was.

    Say, you did manage to find some free time, how much would you be looking at to code this for me? Probably best to keep it to a PM, btw.

    I'd like to have a go at it myself, actually, though. Would help to strengthen my PHP skills. Any of you guys fancy coaching me along the way? :p
     
  13. RTT

    RTT #parp

    Joined:
    12 Mar 2001
    Posts:
    14,120
    Likes Received:
    74
    There are a good few people who will help you with any php questions/problems you have along the way :)
     
  14. Hwulex

    Hwulex What's a Dremel?

    Joined:
    1 Feb 2002
    Posts:
    4,007
    Likes Received:
    1
    It certainly sounds like an interesting little project, and one I'd like to have a crack at, but right now I just really don't have the spare time. However, I'm always here, along with many others, to help out where possible. :)
     
  15. Mary Jo

    Mary Jo oh lolz

    Joined:
    13 Oct 2004
    Posts:
    651
    Likes Received:
    1
    OK well... here goes.

    I've already coded an XHTML/CSS template which I will be using for the site. Now onto the PHP. I'm not quite sure of where to start on this. I want to try and avoid coding a 'quick and dirty' application and try to keep things as proper as possible. I'm thinking about ignorning the user management aspect of the site, initially and just assuming the user is "anon".

    The main tasks within the site then narrow down to:
    - pulling event listings / event details.
    - generating the graphical calendar
    - adding/editing/deleting events.
    - signing up for events.

    Is it a good move to start by a. designing the database structure and then b. writing functions for each of these main tasks as required?

    e.g.
    PHP:
    <?php //functions.php


    function FormatDate($date){

    // this function returns a given mySQL DATETIME in a DD Month YYYY format.

      
    $arr explode("-"$val);
      return 
    date("d M Y"mktime(0,0,0$arr[1], $arr[2], $arr[0]));
    }


    function 
    GetEventList($numberOfEvents$upcomingOrRecent){
    // returns full information for a number of the most recent events given an integer
    // stating how many events are required and a character stating whether upcoming or
    // recent events are required, by 'u' or 'r', respectively. Note: Assumes you are
    // already connected to a database.

      
    if $upcomingOrRecent 'u' {
        
    $sqlQuery "SELECT *
                     FROM events
                     WHERE date > NOW()
                     ORDER BY date DESC
                     LIMIT 0,
    $numberOfEvents";
        }
      if 
    $upcomingOrRecent 'r' {
        
    $sqlQuery "SELECT *
                     FROM events
                     WHERE date < NOW()
                     ORDER BY date DESC
                     LIMIT 0,
    $numberOfEvents";
        }
      
    $sqlResult mysql_query($sqlQuery) or die ("Error in query: $sqlQuery. " mysql_error());
      
    $row mysql_fetch_object($sqlResult);
      if(
    mysql_num_rows($sqlResult) == 0){
        echo(
    "<p>No events have been added yet. Why not <a href="addevent.php">add one yourself?</a></p>");
      }
      while(
    $row mysql_fetch_array($sqlResult)){
    ?>
    <p class="p"><span><a href="event.php?id=<? echo ($_ROW['id']) ?>"><? echo ($_ROW['title']) ?></a> on <? echo (formatDate($_ROW['date'])) ?> @ <? echo ($_ROW['location']) ?></span></p>
    <?
      }
    }

    ?>
    Then once I have all the necessary logic work in the functions, simply include them in my main files. Best way?
     
    Last edited: 27 Mar 2005

Share This Page