Event Tracker

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Event Tracker

Event Tracker is a web based application which has been developed over PHP and MySQL and runs on WAMP, XAMP or Apache2 server.. The main modules of the project is Event,Tracking,Party,Images,Video. Admin user can manage all the operations of Images,Video,Event,Venue,Tracking and their details. Admin can create different type of reports of Event,Tracking,Party,Images,Video according to their choise and filters. You can Download PHP and MySQL Project Event Tracker with source code and database from this site. We also provide Project Report of Event Tracker.

Functionalities and their descriptions of Event Tracker are as follows:

  • You can search records on various criterias. Such as Event, Party, Images, Video
  • Create, read, update and delete (CRUD) application has been implemented on Event,Tracking,Party,Images,Video
  • Keep the track logs of Tracking, Venue, Images ect
  • Advance search has been implemented on Tracking,Venue, Images
  • You can see all the details of the Event, Party, Venue, Images
  • All the modules Venue, Images, Tracking,Video, Event are inter related and tightly coupled
  • It deals with monitoring the information and transactions of Images.
  • All the Tracking,Venue, Images modules has their unique record ID for fast transactions and searching
  • Editing, adding and updating of Records is improved which results in proper resource management of Event data.

Modules of Event Tracker and their descriptions:

  • Event Module : Manage all the operations of Event
  • Tracking Module : Manage all the operations of Tracking
  • Venue Module : Manage all the operations of Venue
  • Party Module : Manage all the operations of Party
  • Images Module : Manage all the operations of Images
  • Video Module : Manage all the operations of Video

Classes and their methods of Event Tracker:

  • Event Methods : addEvent(), editEvent(), deleteEvent(), updateEvent(), saveEvent(), searchEvent()
  • Tracking Methods : addTracking(), editTracking(), deleteTracking(), updateTracking(), saveTracking(), searchTracking()
  • Venue Methods : addVenue(), editVenue(), deleteVenue(), updateVenue(), saveVenue(), searchVenue()
  • Party Methods : addParty(), editParty(), deleteParty(), updateParty(), saveParty(), searchParty()
  • Images Methods : addImages(), editImages(), deleteImages(), updateImages(), saveImages(), searchImages()
  • Video Methods : addVideo(), editVideo(), deleteVideo(), updateVideo(), saveVideo(), searchVideo()

Database tables and attributes of the Event Tracker:

  • Event Entity : Attributes of Event are event_id, event_name, event_organizer_id, event_theme, event_date, event_type, event_description
  • Tracking Entity : Attributes of Tracking are track_id, track_event_id, track_date, track_place track_type, track_description
  • Venue Entity : Attributes of Venue are venue_id, venue_name, venue_type, venue_description, venue_address
  • Party Entity : Attributes of Party are party_id, party_event_id, party_organizer_id, party_theme, party_date, party_type, party_description
  • Images Entity : Attributes of Images are image_id, image_name, image_type, image_description
  • Video Entity : Attributes of Video are video_id, video_name, video_type, video_description

Database definition of Event Tracker:

  • The details of Event is store into the Event tables respective with all tables
  • Each entity (Video, Venue, Images, Tracking, Event) contains primary key and unique keys.
  • The entity Venue, Images has binded with Event, Tracking entities with foreign key
  • There is one-to-one and one-to-many relationships available between Images, Party, Video, Event
  • All the entities Event, Images, Venue, Video are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Event Tracker tables for fast query execution.

Super admin functionality of Event Tracker:

  • Admin can add, edit, delete and view the records of Event, Images, Venue, Video
  • Admin can manage all the details of Tracking, Venue, Party, Images
  • Admin can also generate reports of Event, Tracking, Venue, Party
  • Admin can search the details of Event, Images, Venue, Video
  • Admin can apply different level of filters on report of Event, Venue, Video
  • Admin can tracks the detailed information of Images, Video, Event, Tracking

Report of Event Tracker:

  • Generates the report on Venue,Party,Event,Tracking,Images,Video,
  • Party,Images,Video has been integrated with the dynamic filter. So you can filter the records run time
  • You can also import the report data into PDF of Party,Images,Video
  • Excel Sheet report has also been integrated for Tracking,Party,Video
  • You can create the CSV reports for Event,Images,Venue

Limitation of Event Tracker

  • Run time report generation is not available in Event Tracker.
  • We have not implemented the dynamic report for Event,Party,Images,Tracking,Venue,Video
  • This project Event Tracker has not been developed on Model View Controller architecture, so its very complex to manage
  • Batch mode execution for Off-line reports of Event, Party, Video cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Event Tracker

  • We have added all the validations for input value on the modules Event,Tracking,Venue
  • Party,Images,Video can not be submited without filling all the inout fields
  • Duplicate values testing has been implemented on Event,Venue,Video
  • CSRF token has also been implemented on Party,Tracking,Event, Images,Video
  • All the Event,Party,Images,Tracking,Venue,Video has integrated with captcha for spam protections
  • Access level validation has been implemented on Video,Images,Party
  • Number and character validation has also been implemented on Venue,Images,Event

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database