ECE 3553 Final Project by Brian Robl - PowerPoint PPT Presentation

urbana
ece 3553 final project by brian robl n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
ECE 3553 Final Project by Brian Robl PowerPoint Presentation
Download Presentation
ECE 3553 Final Project by Brian Robl

Loading in 2 Seconds...

play fullscreen
1 / 13
Download Presentation
ECE 3553 Final Project by Brian Robl
90 Views
Download Presentation

ECE 3553 Final Project by Brian Robl

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. ECE 3553 Final Project by Brian Robl

  2. 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.

  3. 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'

  4. 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"); • }

  5. 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.

  6. 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.

  7. XML & PHP • PHP 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 '/>'; }

  8. 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>

  9. 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.

  10. 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.

  11. 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

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

  13. Thank You for Listening Questions?