ECE 3553 Final Project

by Brian Robl

What is Eventor? A simple, yet effective, website for event

planning and searching. Influence from Facebook Events.

includes social networking features like profiles, commenting, rating, and attendance.

Uses Google Maps Javascript API to show all events on a map and information regarding them.

Tools Used to Create Eventor User side

XHTML and CSS

Stylish layout.

Simple navigation

Javascript

Animation effects

Functionality

Google Maps Prompts

Flash

Animated movie

Server side

PHP

Queries

MySQL server SQL commands

Store variables

Session GET POST

Create XML for Google Maps

Used 'echo'

Log in / Registration$login="SELECT * FROM users WHERE username='$myusername' and password='$mypassword'";

$result=mysql_query($login);

// Mysql_num_row is counting table row

$count=mysql_num_rows($result);

// If result matched $myusername and $mypassword, table row must be 1 row

// Register $myusername, $mypassword and redirect to file "home.php

if($count==1)

{

session_start();

$_SESSION['name']= $myusername;

header("location:home.php");

}

else

{

session_start();

$_SESSION['login']='fail';

header("location:index.php");

}

Security

Eventor uses various functions that protect from code injection.

stripslashes(); mysql_real_escape_string(); strip_tags();

They are used to block hackers from commenting out php code in your website and running their own.

Google Maps API

Javascript API used to display event locations.

Geocoder used to convert address to latitude and longitude values for marking on the map.

Different colored markers used to signify different event types.

Info window displayed after clicking marker.

Created using XHTML.

XML & PHPPHP used to echo XML for <markers> tag.Event locations from the database outputted into the XML.Gxml.parse(data) used to read XML.

while ($row = @mysql_fetch_assoc($resultLoc)){ // ADD TO XML DOCUMENT NODE echo '<marker '; echo 'name="' . parseToXML($row['eventName']) . '"

'; echo 'address="' . parseToXML($row['location']) . '"

'; echo 'type="' . $row['eventType'] . '" '; echo '/>';}

Facebook Comments Application

Used instead of self-made comments system. Saves time and resources Increases popularity of website

Unique xid attribute for unique pages.<fb:comments xid="<?=$row[0]?>"url="http://my.fit.edu/~brobl2008/..."

></fb:comments>

Event Rating System

User gives a rating(1-5) for specific event Queries:

Get current rating sum Update rating sum and increment number

of raters. $newRatingSum = $currentRatingSum +

$eventRate;

Get number of raters. $newRating = $newRatingSum / $currentRaters;

Update rating.

Attendance

User selects how they are inserted into the attendance list.

Attending Maybe attending Not attending

Queries Get attendance from events table. Update attendance with previous attendance

added to new attendance.

The Future of Eventor

RSVP limit if exceeded, event address is hidden

IP address look up for user default location Pictures / File uploading Friends Personal Messages Blacklists/Whitelists

Conclusion

Eventor simply works. Fully utilized Google Map Expand features More error checking is needed.

Thank You for Listening

Questions?