1 / 13

ECE 3553 Final Project by Brian Robl

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.

urbana
Download Presentation

ECE 3553 Final Project by Brian Robl

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

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?

More Related