EVENT MANAGEMENT SYSTEM

Introduction

The Event Management System is a comprehensive web platform that enables organizers to create and manage events of all types, and allows attendees to discover, register, and participate in events. The system supports various event categories including conferences, workshops, concerts, seminars, webinars, and social gatherings. Features include event creation, ticketing, attendee management, payment processing, schedule management, and real-time notifications. The platform includes both user and admin interfaces with comprehensive event management capabilities.

Project Features

User Features:

• User Registration and Email Verification
• User Login with Social Media Integration (Google/Facebook)
• Profile Management with Avatar Upload
• Browse Events by Categories
• Advanced Search with Filters (Date, Location, Category, Price)
• View Event Details with Map Integration
• Event Registration and Ticketing
• Multiple Ticket Types (Early Bird, VIP, Regular, Group)
• Secure Payment Processing (PayPal, Stripe, Credit Card)
• Download E-Tickets as PDF
• Add Events to Personal Calendar (Google Calendar, iCal)
• Event Reminders and Notifications
• Rate and Review Events
• Share Events on Social Media
• Create and Manage Personal Events (for organizers)
• Track Registered Events
• View Event Schedule/Sessions
• Speaker and Sponsor Information
• Venue Details with Maps
• Chat/Message System for Event Communication
• Save Favorite Events
• Event Recommendations Based on Interests
• Refund and Cancellation Requests

Organizer Features:

• Create Events with Detailed Information
• Manage Event Settings and Privacy
• Set Ticket Types and Pricing
• Manage Attendee List and Check-in
• QR Code Generation for Tickets
• Send Bulk Emails to Attendees
• Create Event Schedule/Agenda
• Add Speakers and Sponsors
• Track Sales and Revenue Reports
• Export Attendee Data (CSV/Excel)
• Manage Refund Requests
• Event Analytics Dashboard
• Promote Events with Discount Codes
• Create Multiple Organizer Accounts
• Venue Management

Admin Features:

• Admin Dashboard with Analytics
• User Management (View, Edit, Suspend)
• Event Management (Approve, Reject, Feature)
• Category Management
• Payment Monitoring and Reconciliation
• Commission and Fee Management
• Site Settings Configuration
• Report Generation (Sales, Users, Events)
• Banner and Promotion Management
• Email Template Management
• System Logs and Audit Trails
• Backup and Restore
• Fraud Detection and Prevention
• Refund Management

---

Project File Structure

event-management-system/
│
├── assets/
│   ├── css/
│   │   ├── style.css
│   │   ├── admin-style.css
│   │   ├── responsive.css
│   │   ├── bootstrap.min.css
│   │   └── font-awesome.min.css
│   ├── js/
│   │   ├── main.js
│   │   ├── event.js
│   │   ├── registration.js
│   │   ├── calendar.js
│   │   ├── map.js
│   │   ├── qrcode.js
│   │   └── admin.js
│   └── images/
│       ├── events/
│       ├── categories/
│       ├── avatars/
│       ├── venues/
│       └── banners/
│
├── uploads/
│   ├── event_images/
│   ├── category_images/
│   ├── venue_images/
│   ├── speaker_images/
│   ├── sponsor_logos/
│   ├── tickets/
│   └── temp/
│
├── database/
│   └── event_management.sql
│
├── includes/
│   ├── config.php
│   ├── db_connection.php
│   ├── functions.php
│   ├── auth.php
│   ├── event_functions.php
│   ├── ticket_functions.php
│   ├── payment_functions.php
│   ├── email_functions.php
│   └── notification_functions.php
│
├── admin/
│   ├── index.php
│   ├── login.php
│   ├── logout.php
│   ├── dashboard.php
│   ├── users.php
│   ├── user-details.php
│   ├── organizers.php
│   ├── events.php
│   ├── event-details.php
│   ├── approve-event.php
│   ├── categories.php
│   ├── add-category.php
│   ├── edit-category.php
│   ├── delete-category.php
│   ├── venues.php
│   ├── add-venue.php
│   ├── edit-venue.php
│   ├── tickets.php
│   ├── transactions.php
│   ├── refunds.php
│   ├── reports.php
│   ├── reports/
│   │   ├── sales-report.php
│   │   ├── users-report.php
│   │   ├── events-report.php
│   │   └── revenue-report.php
│   ├── settings.php
│   ├── email-templates.php
│   ├── featured-events.php
│   ├── coupons.php
│   ├── add-coupon.php
│   ├── system-logs.php
│   ├── backup.php
│   └── profile.php
│
├── organizer/
│   ├── index.php
│   ├── login.php
│   ├── register.php
│   ├── logout.php
│   ├── dashboard.php
│   ├── profile.php
│   ├── events.php
│   ├── create-event.php
│   ├── edit-event.php
│   ├── event-details.php
│   ├── tickets.php
│   ├── ticket-types.php
│   ├── add-ticket-type.php
│   ├── edit-ticket-type.php
│   ├── attendees.php
│   ├── attendee-details.php
│   ├── check-in.php
│   ├── schedule.php
│   ├── add-session.php
│   ├── edit-session.php
│   ├── speakers.php
│   ├── add-speaker.php
│   ├── edit-speaker.php
│   ├── sponsors.php
│   ├── add-sponsor.php
│   ├── sales.php
│   ├── coupons.php
│   ├── add-coupon.php
│   ├── messages.php
│   ├── analytics.php
│   ├── export-attendees.php
│   └── settings.php
│
├── user/
│   ├── index.php
│   ├── register.php
│   ├── login.php
│   ├── logout.php
│   ├── verify-email.php
│   ├── forgot-password.php
│   ├── reset-password.php
│   ├── dashboard.php
│   ├── profile.php
│   ├── my-events.php
│   ├── registered-events.php
│   ├── saved-events.php
│   ├── ticket-details.php
│   ├── download-ticket.php
│   ├── calendar-sync.php
│   ├── reviews.php
│   ├── write-review.php
│   ├── messages.php
│   ├── notifications.php
│   └── settings.php
│
├── api/
│   ├── get-events.php
│   ├── search-events.php
│   ├── register-event.php
│   ├── check-availability.php
│   ├── process-payment.php
│   ├── generate-ticket.php
│   ├── validate-ticket.php
│   ├── check-in.php
│   ├── get-map.php
│   ├── upload-image.php
│   └── notifications.php
│
├── vendor/
│   ├── phpmailer/
│   ├── qrcode/
│   ├── stripe/
│   └── dompdf/
│
├── index.php
├── events.php
├── event.php
├── categories.php
├── category.php
├── search.php
├── calendar.php
├── map.php
├── about.php
├── contact.php
├── faq.php
├── terms.php
├── privacy.php
├── sitemap.php
├── 404.php
├── .htaccess
└── robots.txt

---

Database Schema (event_management.sql)

-- Create Database
CREATE DATABASE IF NOT EXISTS event_management_system;
USE event_management_system;
-- Table: users
CREATE TABLE users (
user_id INT PRIMARY KEY AUTO_INCREMENT,
username VARCHAR(50) UNIQUE NOT NULL,
email VARCHAR(100) UNIQUE NOT NULL,
password VARCHAR(255) NOT NULL,
full_name VARCHAR(100),
phone VARCHAR(20),
address TEXT,
city VARCHAR(50),
state VARCHAR(50),
country VARCHAR(50),
postal_code VARCHAR(20),
avatar VARCHAR(255),
role ENUM('user', 'organizer', 'admin') DEFAULT 'user',
status ENUM('active', 'suspended', 'banned') DEFAULT 'active',
email_verified BOOLEAN DEFAULT FALSE,
verification_token VARCHAR(100),
reset_token VARCHAR(100),
reset_expiry DATETIME,
google_id VARCHAR(100),
facebook_id VARCHAR(100),
last_login DATETIME,
last_ip VARCHAR(45),
registered_events INT DEFAULT 0,
created_events INT DEFAULT 0,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
INDEX idx_email (email),
INDEX idx_status (status),
INDEX idx_role (role)
);
-- Insert default admin
INSERT INTO users (username, email, password, full_name, role, email_verified) 
VALUES ('admin', '[email protected]', MD5('Admin@123'), 'System Administrator', 'admin', TRUE);
-- Insert sample organizer
INSERT INTO users (username, email, password, full_name, role, email_verified) 
VALUES ('eventpro', '[email protected]', MD5('Organizer@123'), 'Event Pro', 'organizer', TRUE);
-- Table: organizer_profiles
CREATE TABLE organizer_profiles (
profile_id INT PRIMARY KEY AUTO_INCREMENT,
user_id INT UNIQUE NOT NULL,
organization_name VARCHAR(200),
organization_type ENUM('company', 'nonprofit', 'individual', 'other') DEFAULT 'individual',
tax_id VARCHAR(50),
website VARCHAR(255),
bio TEXT,
logo VARCHAR(255),
cover_image VARCHAR(255),
social_media JSON,
payment_email VARCHAR(100),
payment_method VARCHAR(50),
commission_rate DECIMAL(5,2) DEFAULT 0.00,
verified BOOLEAN DEFAULT FALSE,
verified_at DATETIME,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE
);
-- Table: categories
CREATE TABLE categories (
category_id INT PRIMARY KEY AUTO_INCREMENT,
category_name VARCHAR(100) NOT NULL,
category_slug VARCHAR(100) UNIQUE NOT NULL,
category_description TEXT,
parent_category_id INT,
category_image VARCHAR(255),
icon VARCHAR(50),
color VARCHAR(20),
is_active BOOLEAN DEFAULT TRUE,
display_order INT DEFAULT 0,
event_count INT DEFAULT 0,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
FOREIGN KEY (parent_category_id) REFERENCES categories(category_id) ON DELETE CASCADE,
INDEX idx_parent (parent_category_id)
);
-- Insert default categories
INSERT INTO categories (category_name, category_slug, icon, color, display_order) VALUES
('Conferences', 'conferences', 'fa-users', '#4361ee', 1),
('Workshops', 'workshops', 'fa-chalkboard-teacher', '#3f37c9', 2),
('Concerts', 'concerts', 'fa-music', '#f72585', 3),
('Festivals', 'festivals', 'fa-glass-cheers', '#4cc9f0', 4),
('Sports', 'sports', 'fa-futbol', '#f8961e', 5),
('Networking', 'networking', 'fa-handshake', '#43aa8b', 6),
('Seminars', 'seminars', 'fa-microphone-alt', '#577590', 7),
('Webinars', 'webinars', 'fa-video', '#9c89b8', 8),
('Exhibitions', 'exhibitions', 'fa-palette', '#f94144', 9),
('Charity', 'charity', 'fa-heart', '#f9844a', 10),
('Food & Drink', 'food-drink', 'fa-utensils', '#f9c74f', 11),
('Business', 'business', 'fa-briefcase', '#90be6d', 12);
-- Table: venues
CREATE TABLE venues (
venue_id INT PRIMARY KEY AUTO_INCREMENT,
venue_name VARCHAR(200) NOT NULL,
venue_slug VARCHAR(250) UNIQUE NOT NULL,
description TEXT,
address TEXT NOT NULL,
city VARCHAR(100) NOT NULL,
state VARCHAR(100),
country VARCHAR(100) NOT NULL,
postal_code VARCHAR(20),
latitude DECIMAL(10,8),
longitude DECIMAL(11,8),
capacity INT,
facilities JSON,
contact_name VARCHAR(100),
contact_email VARCHAR(100),
contact_phone VARCHAR(20),
website VARCHAR(255),
images JSON,
is_active BOOLEAN DEFAULT TRUE,
created_by INT,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
FOREIGN KEY (created_by) REFERENCES users(user_id) ON DELETE SET NULL,
INDEX idx_location (city, country),
INDEX idx_capacity (capacity),
FULLTEXT INDEX ft_venue (venue_name, description, address)
);
-- Table: events
CREATE TABLE events (
event_id INT PRIMARY KEY AUTO_INCREMENT,
organizer_id INT NOT NULL,
category_id INT NOT NULL,
venue_id INT,
title VARCHAR(200) NOT NULL,
slug VARCHAR(250) UNIQUE NOT NULL,
description TEXT NOT NULL,
short_description VARCHAR(500),
summary TEXT,
type ENUM('physical', 'virtual', 'hybrid') DEFAULT 'physical',
format ENUM('single', 'multi-day', 'series') DEFAULT 'single',
start_date DATE NOT NULL,
end_date DATE NOT NULL,
start_time TIME,
end_time TIME,
timezone VARCHAR(50) DEFAULT 'UTC',
featured BOOLEAN DEFAULT FALSE,
featured_until DATETIME,
status ENUM('draft', 'pending', 'published', 'cancelled', 'completed', 'rejected') DEFAULT 'pending',
visibility ENUM('public', 'private', 'unlisted') DEFAULT 'public',
max_attendees INT,
current_attendees INT DEFAULT 0,
waiting_list_capacity INT,
registration_deadline DATETIME,
early_bird_deadline DATETIME,
refund_policy TEXT,
terms_conditions TEXT,
banner_image VARCHAR(255),
gallery_images JSON,
video_url VARCHAR(255),
social_links JSON,
tags JSON,
views_count INT DEFAULT 0,
likes_count INT DEFAULT 0,
shares_count INT DEFAULT 0,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
FOREIGN KEY (organizer_id) REFERENCES users(user_id) ON DELETE CASCADE,
FOREIGN KEY (category_id) REFERENCES categories(category_id),
FOREIGN KEY (venue_id) REFERENCES venues(venue_id) ON DELETE SET NULL,
INDEX idx_status (status),
INDEX idx_dates (start_date, end_date),
INDEX idx_category (category_id),
INDEX idx_organizer (organizer_id),
INDEX_idx_featured (featured),
FULLTEXT INDEX ft_event (title, description, short_description)
);
-- Table: event_sessions
CREATE TABLE event_sessions (
session_id INT PRIMARY KEY AUTO_INCREMENT,
event_id INT NOT NULL,
title VARCHAR(200) NOT NULL,
description TEXT,
speaker_id INT,
room VARCHAR(100),
start_time DATETIME NOT NULL,
end_time DATETIME NOT NULL,
capacity INT,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (event_id) REFERENCES events(event_id) ON DELETE CASCADE,
FOREIGN KEY (speaker_id) REFERENCES users(user_id) ON DELETE SET NULL,
INDEX idx_event_time (event_id, start_time)
);
-- Table: speakers
CREATE TABLE speakers (
speaker_id INT PRIMARY KEY AUTO_INCREMENT,
event_id INT NOT NULL,
name VARCHAR(100) NOT NULL,
title VARCHAR(100),
company VARCHAR(100),
bio TEXT,
photo VARCHAR(255),
email VARCHAR(100),
social_links JSON,
display_order INT DEFAULT 0,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (event_id) REFERENCES events(event_id) ON DELETE CASCADE,
INDEX idx_event (event_id)
);
-- Table: sponsors
CREATE TABLE sponsors (
sponsor_id INT PRIMARY KEY AUTO_INCREMENT,
event_id INT NOT NULL,
name VARCHAR(100) NOT NULL,
level ENUM('platinum', 'gold', 'silver', 'bronze', 'media') DEFAULT 'bronze',
logo VARCHAR(255),
website VARCHAR(255),
description TEXT,
display_order INT DEFAULT 0,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (event_id) REFERENCES events(event_id) ON DELETE CASCADE,
INDEX idx_event (event_id)
);
-- Table: ticket_types
CREATE TABLE ticket_types (
ticket_type_id INT PRIMARY KEY AUTO_INCREMENT,
event_id INT NOT NULL,
name VARCHAR(100) NOT NULL,
description TEXT,
price DECIMAL(10,2) NOT NULL,
quantity INT NOT NULL,
quantity_sold INT DEFAULT 0,
max_per_order INT DEFAULT 10,
min_per_order INT DEFAULT 1,
start_date DATETIME NOT NULL,
end_date DATETIME NOT NULL,
is_active BOOLEAN DEFAULT TRUE,
fees_type ENUM('include', 'exclude') DEFAULT 'include',
features JSON,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
FOREIGN KEY (event_id) REFERENCES events(event_id) ON DELETE CASCADE,
INDEX idx_event (event_id),
INDEX idx_dates (start_date, end_date)
);
-- Table: tickets
CREATE TABLE tickets (
ticket_id INT PRIMARY KEY AUTO_INCREMENT,
ticket_number VARCHAR(50) UNIQUE NOT NULL,
event_id INT NOT NULL,
ticket_type_id INT NOT NULL,
user_id INT NOT NULL,
order_id VARCHAR(100),
quantity INT NOT NULL,
unit_price DECIMAL(10,2) NOT NULL,
total_price DECIMAL(10,2) NOT NULL,
fees DECIMAL(10,2) DEFAULT 0.00,
status ENUM('reserved', 'confirmed', 'cancelled', 'refunded', 'used') DEFAULT 'reserved',
payment_status ENUM('pending', 'paid', 'failed', 'refunded') DEFAULT 'pending',
payment_method VARCHAR(50),
transaction_id VARCHAR(100),
qr_code VARCHAR(255),
checked_in BOOLEAN DEFAULT FALSE,
checked_in_at DATETIME,
checked_in_by INT,
special_requirements TEXT,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
FOREIGN KEY (event_id) REFERENCES events(event_id) ON DELETE CASCADE,
FOREIGN KEY (ticket_type_id) REFERENCES ticket_types(ticket_type_id),
FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE,
FOREIGN KEY (checked_in_by) REFERENCES users(user_id) ON DELETE SET NULL,
INDEX idx_event (event_id),
INDEX_idx_user (user_id),
INDEX_idx_status (status),
INDEX_idx_payment (payment_status),
UNIQUE INDEX idx_ticket_number (ticket_number)
);
-- Table: bookings
CREATE TABLE bookings (
booking_id INT PRIMARY KEY AUTO_INCREMENT,
booking_number VARCHAR(50) UNIQUE NOT NULL,
event_id INT NOT NULL,
user_id INT NOT NULL,
ticket_type_id INT,
quantity INT NOT NULL,
total_amount DECIMAL(10,2) NOT NULL,
fees DECIMAL(10,2) DEFAULT 0.00,
discount_amount DECIMAL(10,2) DEFAULT 0.00,
coupon_code VARCHAR(50),
status ENUM('pending', 'confirmed', 'cancelled', 'refunded') DEFAULT 'pending',
payment_status ENUM('pending', 'paid', 'failed', 'refunded') DEFAULT 'pending',
payment_method VARCHAR(50),
transaction_id VARCHAR(100),
payment_details JSON,
attendee_details JSON,
special_requests TEXT,
notes TEXT,
ip_address VARCHAR(45),
user_agent TEXT,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
FOREIGN KEY (event_id) REFERENCES events(event_id) ON DELETE CASCADE,
FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE,
FOREIGN KEY (ticket_type_id) REFERENCES ticket_types(ticket_type_id) ON DELETE SET NULL,
INDEX idx_event (event_id),
INDEX_idx_user (user_id),
INDEX_idx_status (status),
INDEX_idx_payment (payment_status)
);
-- Table: attendees
CREATE TABLE attendees (
attendee_id INT PRIMARY KEY AUTO_INCREMENT,
booking_id INT NOT NULL,
ticket_id INT,
event_id INT NOT NULL,
user_id INT,
first_name VARCHAR(50) NOT NULL,
last_name VARCHAR(50) NOT NULL,
email VARCHAR(100) NOT NULL,
phone VARCHAR(20),
company VARCHAR(100),
job_title VARCHAR(100),
dietary_requirements TEXT,
accessibility_needs TEXT,
checked_in BOOLEAN DEFAULT FALSE,
checked_in_at DATETIME,
checked_in_by INT,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (booking_id) REFERENCES bookings(booking_id) ON DELETE CASCADE,
FOREIGN KEY (ticket_id) REFERENCES tickets(ticket_id) ON DELETE SET NULL,
FOREIGN KEY (event_id) REFERENCES events(event_id) ON DELETE CASCADE,
FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE SET NULL,
FOREIGN KEY (checked_in_by) REFERENCES users(user_id) ON DELETE SET NULL,
INDEX idx_event (event_id),
INDEX_idx_email (email)
);
-- Table: coupons
CREATE TABLE coupons (
coupon_id INT PRIMARY KEY AUTO_INCREMENT,
event_id INT,
code VARCHAR(50) UNIQUE NOT NULL,
description TEXT,
discount_type ENUM('percentage', 'fixed') NOT NULL,
discount_value DECIMAL(10,2) NOT NULL,
min_order_amount DECIMAL(10,2),
max_discount_amount DECIMAL(10,2),
usage_limit INT,
usage_count INT DEFAULT 0,
per_user_limit INT DEFAULT 1,
start_date DATETIME NOT NULL,
end_date DATETIME NOT NULL,
is_active BOOLEAN DEFAULT TRUE,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (event_id) REFERENCES events(event_id) ON DELETE CASCADE,
INDEX idx_code (code),
INDEX_idx_dates (start_date, end_date)
);
-- Table: saved_events
CREATE TABLE saved_events (
save_id INT PRIMARY KEY AUTO_INCREMENT,
user_id INT NOT NULL,
event_id INT NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE,
FOREIGN KEY (event_id) REFERENCES events(event_id) ON DELETE CASCADE,
UNIQUE KEY unique_save (user_id, event_id)
);
-- Table: reviews
CREATE TABLE reviews (
review_id INT PRIMARY KEY AUTO_INCREMENT,
event_id INT NOT NULL,
user_id INT NOT NULL,
rating INT NOT NULL CHECK (rating >= 1 AND rating <= 5),
title VARCHAR(200),
comment TEXT,
pros TEXT,
cons TEXT,
helpful_count INT DEFAULT 0,
reported BOOLEAN DEFAULT FALSE,
status ENUM('pending', 'approved', 'rejected') DEFAULT 'pending',
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
FOREIGN KEY (event_id) REFERENCES events(event_id) ON DELETE CASCADE,
FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE,
UNIQUE KEY unique_review (event_id, user_id),
INDEX idx_event (event_id),
INDEX_idx_rating (rating)
);
-- Table: review_helpful
CREATE TABLE review_helpful (
helpful_id INT PRIMARY KEY AUTO_INCREMENT,
review_id INT NOT NULL,
user_id INT NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (review_id) REFERENCES reviews(review_id) ON DELETE CASCADE,
FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE,
UNIQUE KEY unique_helpful (review_id, user_id)
);
-- Table: messages
CREATE TABLE messages (
message_id INT PRIMARY KEY AUTO_INCREMENT,
sender_id INT NOT NULL,
receiver_id INT NOT NULL,
event_id INT,
subject VARCHAR(200),
message TEXT NOT NULL,
is_read BOOLEAN DEFAULT FALSE,
parent_message_id INT,
attachments JSON,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (sender_id) REFERENCES users(user_id) ON DELETE CASCADE,
FOREIGN KEY (receiver_id) REFERENCES users(user_id) ON DELETE CASCADE,
FOREIGN KEY (event_id) REFERENCES events(event_id) ON DELETE SET NULL,
FOREIGN KEY (parent_message_id) REFERENCES messages(message_id) ON DELETE CASCADE,
INDEX idx_conversation (sender_id, receiver_id),
INDEX_idx_read (is_read)
);
-- Table: notifications
CREATE TABLE notifications (
notification_id INT PRIMARY KEY AUTO_INCREMENT,
user_id INT NOT NULL,
type ENUM('booking', 'reminder', 'update', 'message', 'review', 'promo', 'system') NOT NULL,
title VARCHAR(200),
message TEXT,
link VARCHAR(500),
is_read BOOLEAN DEFAULT FALSE,
is_archived BOOLEAN DEFAULT FALSE,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE,
INDEX idx_user (user_id),
INDEX_idx_read (is_read)
);
-- Table: transactions
CREATE TABLE transactions (
transaction_id INT PRIMARY KEY AUTO_INCREMENT,
booking_id INT,
user_id INT NOT NULL,
event_id INT,
amount DECIMAL(10,2) NOT NULL,
fees DECIMAL(10,2) DEFAULT 0.00,
commission DECIMAL(10,2) DEFAULT 0.00,
payment_method VARCHAR(50) NOT NULL,
transaction_type ENUM('payment', 'refund', 'payout') DEFAULT 'payment',
status ENUM('pending', 'completed', 'failed', 'refunded') DEFAULT 'pending',
gateway VARCHAR(50),
gateway_transaction_id VARCHAR(100),
payment_details JSON,
ip_address VARCHAR(45),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
FOREIGN KEY (booking_id) REFERENCES bookings(booking_id) ON DELETE SET NULL,
FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE,
FOREIGN KEY (event_id) REFERENCES events(event_id) ON DELETE SET NULL,
INDEX_idx_user (user_id),
INDEX_idx_booking (booking_id),
INDEX_idx_status (status)
);
-- Table: waitlist
CREATE TABLE waitlist (
waitlist_id INT PRIMARY KEY AUTO_INCREMENT,
event_id INT NOT NULL,
user_id INT NOT NULL,
ticket_type_id INT,
quantity INT DEFAULT 1,
status ENUM('waiting', 'notified', 'expired', 'cancelled') DEFAULT 'waiting',
notified_at DATETIME,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (event_id) REFERENCES events(event_id) ON DELETE CASCADE,
FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE,
FOREIGN KEY (ticket_type_id) REFERENCES ticket_types(ticket_type_id) ON DELETE SET NULL,
UNIQUE KEY unique_waitlist (event_id, user_id, ticket_type_id)
);
-- Table: event_analytics
CREATE TABLE event_analytics (
analytics_id INT PRIMARY KEY AUTO_INCREMENT,
event_id INT NOT NULL,
date DATE NOT NULL,
views INT DEFAULT 0,
unique_views INT DEFAULT 0,
clicks INT DEFAULT 0,
shares INT DEFAULT 0,
saves INT DEFAULT 0,
registrations INT DEFAULT 0,
revenue DECIMAL(10,2) DEFAULT 0.00,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (event_id) REFERENCES events(event_id) ON DELETE CASCADE,
UNIQUE KEY unique_event_date (event_id, date)
);
-- Table: site_settings
CREATE TABLE site_settings (
setting_id INT PRIMARY KEY AUTO_INCREMENT,
setting_key VARCHAR(100) UNIQUE NOT NULL,
setting_value TEXT,
setting_type ENUM('text', 'number', 'boolean', 'json', 'email') DEFAULT 'text',
setting_description TEXT,
updated_by INT,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
FOREIGN KEY (updated_by) REFERENCES users(user_id) ON DELETE SET NULL
);
-- Insert default settings
INSERT INTO site_settings (setting_key, setting_value, setting_type, setting_description) VALUES
('site_name', 'EventHub', 'text', 'Website name'),
('site_url', 'http://localhost/event-management-system/', 'text', 'Website URL'),
('admin_email', '[email protected]', 'email', 'Administrator email'),
('commission_rate', '5.00', 'number', 'Commission rate for ticket sales (%)'),
('currency', 'USD', 'text', 'Default currency'),
('currency_symbol', '$', 'text', 'Currency symbol'),
('timezone', 'America/New_York', 'text', 'Default timezone'),
('date_format', 'M d, Y', 'text', 'Date format'),
('time_format', 'H:i', 'text', 'Time format'),
('enable_paypal', '1', 'boolean', 'Enable PayPal payment'),
('enable_stripe', '1', 'boolean', 'Enable Stripe payment'),
('paypal_mode', 'sandbox', 'text', 'PayPal mode (sandbox/live)'),
('paypal_client_id', '', 'text', 'PayPal client ID'),
('paypal_secret', '', 'text', 'PayPal secret'),
('stripe_publishable_key', '', 'text', 'Stripe publishable key'),
('stripe_secret_key', '', 'text', 'Stripe secret key'),
('google_maps_api_key', '', 'text', 'Google Maps API key'),
('facebook_app_id', '', 'text', 'Facebook App ID'),
('google_client_id', '', 'text', 'Google Client ID'),
('max_upload_size', '5242880', 'number', 'Maximum file upload size (bytes)'),
('allowed_image_types', 'jpg,jpeg,png,gif,webp', 'text', 'Allowed image types'),
('events_per_page', '12', 'number', 'Events per page'),
('registration_enabled', '1', 'boolean', 'Enable user registration'),
('email_verification', '1', 'boolean', 'Require email verification'),
('auto_approve_events', '0', 'boolean', 'Automatically approve new events'),
('maintenance_mode', '0', 'boolean', 'Maintenance mode status');
-- Table: activity_logs
CREATE TABLE activity_logs (
log_id INT PRIMARY KEY AUTO_INCREMENT,
user_id INT,
action VARCHAR(100) NOT NULL,
details TEXT,
ip_address VARCHAR(45),
user_agent TEXT,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE SET NULL,
INDEX idx_user (user_id),
INDEX_idx_action (action),
INDEX_idx_created (created_at)
);
-- Table: email_templates
CREATE TABLE email_templates (
template_id INT PRIMARY KEY AUTO_INCREMENT,
template_key VARCHAR(100) UNIQUE NOT NULL,
template_name VARCHAR(200) NOT NULL,
subject VARCHAR(200) NOT NULL,
body TEXT NOT NULL,
variables TEXT,
is_active BOOLEAN DEFAULT TRUE,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);
-- Insert default email templates
INSERT INTO email_templates (template_key, template_name, subject, body) VALUES
('welcome_email', 'Welcome Email', 'Welcome to {site_name}!', '<h1>Welcome, {full_name}!</h1><p>Thank you for registering at {site_name}. We\'re excited to have you on board!</p>'),
('booking_confirmation', 'Booking Confirmation', 'Booking Confirmation - {event_title}', '<h1>Booking Confirmed!</h1><p>Your booking for {event_title} is confirmed. Booking number: {booking_number}</p>'),
('ticket_reminder', 'Event Reminder', 'Reminder: {event_title} is tomorrow!', '<h1>Event Reminder</h1><p>This is a reminder that {event_title} is happening tomorrow. We look forward to seeing you!</p>'),
('payment_received', 'Payment Received', 'Payment Received for {event_title}', '<h1>Payment Confirmed</h1><p>We have received your payment of {amount} for {event_title}.</p>'),
('event_cancelled', 'Event Cancelled', 'Event Cancelled: {event_title}', '<h1>Event Cancellation Notice</h1><p>We regret to inform you that the event "{event_title}" has been cancelled.</p>');

---

Core PHP Files

1. includes/config.php

<?php
// Database configuration
define('DB_HOST', 'localhost');
define('DB_USER', 'root');
define('DB_PASS', '');
define('DB_NAME', 'event_management_system');
// Application configuration
define('SITE_NAME', 'EventHub');
define('SITE_URL', 'http://localhost/event-management-system/');
define('ADMIN_URL', SITE_URL . 'admin/');
define('ORGANIZER_URL', SITE_URL . 'organizer/');
define('USER_URL', SITE_URL . 'user/');
define('UPLOAD_DIR', $_SERVER['DOCUMENT_ROOT'] . '/event-management-system/uploads/');
define('EVENT_IMG_DIR', UPLOAD_DIR . 'event_images/');
define('CATEGORY_IMG_DIR', UPLOAD_DIR . 'category_images/');
define('VENUE_IMG_DIR', UPLOAD_DIR . 'venue_images/');
define('SPEAKER_IMG_DIR', UPLOAD_DIR . 'speaker_images/');
define('SPONSOR_IMG_DIR', UPLOAD_DIR . 'sponsor_logos/');
define('TICKET_DIR', UPLOAD_DIR . 'tickets/');
define('TEMP_DIR', UPLOAD_DIR . 'temp/');
// Pagination settings
define('EVENTS_PER_PAGE', 12);
define('USERS_PER_PAGE', 20);
define('TICKETS_PER_PAGE', 30);
// Upload settings
define('MAX_FILE_SIZE', 5242880); // 5MB
define('ALLOWED_IMAGE_TYPES', 'jpg,jpeg,png,gif,webp');
// Event settings
define('MIN_EVENT_DURATION', 1); // hours
define('MAX_EVENT_DURATION', 30); // days
define('MIN_TICKET_PRICE', 0);
define('MAX_TICKET_QUANTITY', 1000);
define('DEFAULT_COMMISSION_RATE', 5.00); // percentage
// Payment settings
define('PAYPAL_MODE', 'sandbox'); // sandbox or live
define('PAYPAL_CLIENT_ID', '');
define('PAYPAL_SECRET', '');
define('STRIPE_PUBLISHABLE_KEY', '');
define('STRIPE_SECRET_KEY', '');
define('CURRENCY', 'USD');
define('CURRENCY_SYMBOL', '$');
// API Keys
define('GOOGLE_MAPS_API_KEY', '');
define('FACEBOOK_APP_ID', '');
define('GOOGLE_CLIENT_ID', '');
// Email settings
define('SMTP_HOST', 'smtp.gmail.com');
define('SMTP_PORT', 587);
define('SMTP_USER', '[email protected]');
define('SMTP_PASS', 'your-password');
define('SMTP_ENCRYPTION', 'tls');
define('FROM_EMAIL', '[email protected]');
define('FROM_NAME', SITE_NAME);
// Security settings
define('SESSION_TIMEOUT', 7200); // 2 hours
define('ENABLE_SSL', false);
define('HASH_COST', 10);
define('CSRF_TOKEN_NAME', 'csrf_token');
define('ENABLE_CAPTCHA', true);
define('CAPTCHA_SITE_KEY', '');
define('CAPTCHA_SECRET_KEY', '');
// Timezone
date_default_timezone_set('America/New_York');
// Error reporting (disable in production)
error_reporting(E_ALL);
ini_set('display_errors', 1);
// Start session if not started
if (session_status() == PHP_SESSION_NONE) {
session_start();
}
// Set default locale
setlocale(LC_ALL, 'en_US.UTF-8');
?>

2. includes/db_connection.php

<?php
require_once 'config.php';
class Database {
private $connection;
private static $instance = null;
private $stmt;
private $transaction_count = 0;
private function __construct() {
$this->connect();
}
public static function getInstance() {
if (self::$instance === null) {
self::$instance = new Database();
}
return self::$instance;
}
private function connect() {
$this->connection = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
if ($this->connection->connect_error) {
error_log("Database connection failed: " . $this->connection->connect_error);
die("Connection failed. Please try again later.");
}
$this->connection->set_charset("utf8mb4");
// Set timezone for connection
$timezone = date_default_timezone_get();
$offset = date('P');
$this->connection->query("SET time_zone = '$offset'");
}
public function getConnection() {
return $this->connection;
}
public function escape($string) {
return $this->connection->real_escape_string(trim($string));
}
public function query($sql) {
$result = $this->connection->query($sql);
if (!$result) {
error_log("Query failed: " . $this->connection->error);
}
return $result;
}
public function prepare($sql) {
$this->stmt = $this->connection->prepare($sql);
if (!$this->stmt) {
error_log("Prepare failed: " . $this->connection->error);
}
return $this->stmt;
}
public function execute($params = []) {
if (!empty($params) && $this->stmt) {
$types = '';
$values = [];
foreach ($params as $param) {
if (is_int($param)) {
$types .= 'i';
} elseif (is_float($param)) {
$types .= 'd';
} elseif (is_string($param)) {
$types .= 's';
} else {
$types .= 'b';
}
$values[] = $param;
}
$this->stmt->bind_param($types, ...$values);
}
$result = $this->stmt->execute();
if (!$result) {
error_log("Execute failed: " . $this->stmt->error);
}
return $result;
}
public function getResult() {
return $this->stmt->get_result();
}
public function fetchAssoc() {
$result = $this->stmt->get_result();
return $result->fetch_assoc();
}
public function fetchAll() {
$result = $this->stmt->get_result();
return $result->fetch_all(MYSQLI_ASSOC);
}
public function fetchOne() {
$result = $this->stmt->get_result();
return $result->fetch_assoc();
}
public function fetchColumn() {
$result = $this->stmt->get_result();
if ($row = $result->fetch_array()) {
return $row[0];
}
return null;
}
public function lastInsertId() {
return $this->connection->insert_id;
}
public function affectedRows() {
return $this->connection->affected_rows;
}
public function numRows($result) {
return $result->num_rows;
}
public function beginTransaction() {
if ($this->transaction_count === 0) {
$this->connection->begin_transaction();
}
$this->transaction_count++;
}
public function commit() {
if ($this->transaction_count === 1) {
$this->connection->commit();
}
$this->transaction_count = max(0, $this->transaction_count - 1);
}
public function rollback() {
if ($this->transaction_count === 1) {
$this->connection->rollback();
}
$this->transaction_count = max(0, $this->transaction_count - 1);
}
public function inTransaction() {
return $this->transaction_count > 0;
}
public function error() {
return $this->connection->error;
}
public function errno() {
return $this->connection->errno;
}
public function __destruct() {
if ($this->stmt) {
$this->stmt->close();
}
if ($this->connection) {
$this->connection->close();
}
}
}
// Global database instance
$db = Database::getInstance();
$conn = $db->getConnection();
?>

3. includes/functions.php

<?php
require_once 'db_connection.php';
// Redirect to specified page
function redirect($url) {
header("Location: $url");
exit();
}
// Check if user is logged in
function isLoggedIn() {
return isset($_SESSION['user_id']) && !empty($_SESSION['user_id']);
}
// Check if user is admin
function isAdmin() {
return isset($_SESSION['user_role']) && $_SESSION['user_role'] === 'admin';
}
// Check if user is organizer
function isOrganizer() {
return isset($_SESSION['user_role']) && $_SESSION['user_role'] === 'organizer';
}
// Check if user has specific role
function hasRole($role) {
return isset($_SESSION['user_role']) && $_SESSION['user_role'] === $role;
}
// Get current user ID
function getCurrentUserId() {
return $_SESSION['user_id'] ?? 0;
}
// Get current user role
function getCurrentUserRole() {
return $_SESSION['user_role'] ?? 'guest';
}
// Get current user data
function getCurrentUser() {
if (!isLoggedIn()) {
return null;
}
return getUserById(getCurrentUserId());
}
// Sanitize input
function sanitize($input) {
if (is_array($input)) {
return array_map('sanitize', $input);
}
global $conn;
return $conn->real_escape_string(trim(htmlspecialchars($input, ENT_QUOTES, 'UTF-8')));
}
// Generate CSRF token
function generateCSRFToken() {
if (!isset($_SESSION[CSRF_TOKEN_NAME])) {
$_SESSION[CSRF_TOKEN_NAME] = bin2hex(random_bytes(32));
}
return $_SESSION[CSRF_TOKEN_NAME];
}
// Verify CSRF token
function verifyCSRFToken($token) {
if (!isset($_SESSION[CSRF_TOKEN_NAME])) {
return false;
}
return hash_equals($_SESSION[CSRF_TOKEN_NAME], $token);
}
// Format currency
function formatCurrency($amount) {
return CURRENCY_SYMBOL . number_format($amount, 2);
}
// Format date
function formatDate($date, $format = null) {
if (!$format) {
$format = getSetting('date_format', 'M d, Y');
}
return date($format, strtotime($date));
}
// Format time
function formatTime($time, $format = null) {
if (!$format) {
$format = getSetting('time_format', 'H:i');
}
return date($format, strtotime($time));
}
// Format datetime
function formatDateTime($datetime, $format = 'M d, Y H:i') {
return date($format, strtotime($datetime));
}
// Time ago function
function timeAgo($datetime) {
$time = strtotime($datetime);
$now = time();
$diff = $now - $time;
if ($diff < 60) {
return $diff . ' seconds ago';
} elseif ($diff < 3600) {
$mins = floor($diff / 60);
return $mins . ' minute' . ($mins > 1 ? 's' : '') . ' ago';
} elseif ($diff < 86400) {
$hours = floor($diff / 3600);
return $hours . ' hour' . ($hours > 1 ? 's' : '') . ' ago';
} elseif ($diff < 2592000) {
$days = floor($diff / 86400);
return $days . ' day' . ($days > 1 ? 's' : '') . ' ago';
} elseif ($diff < 31536000) {
$months = floor($diff / 2592000);
return $months . ' month' . ($months > 1 ? 's' : '') . ' ago';
} else {
$years = floor($diff / 31536000);
return $years . ' year' . ($years > 1 ? 's' : '') . ' ago';
}
}
// Generate slug
function generateSlug($string) {
$string = strtolower($string);
$string = preg_replace('/[^a-z0-9-]/', '-', $string);
$string = preg_replace('/-+/', '-', $string);
return trim($string, '-');
}
// Validate email
function validateEmail($email) {
return filter_var($email, FILTER_VALIDATE_EMAIL) !== false;
}
// Validate phone number
function validatePhone($phone) {
return preg_match('/^[0-9+\-\s()]+$/', $phone);
}
// Generate random string
function generateRandomString($length = 32) {
return bin2hex(random_bytes($length / 2));
}
// Get client IP address
function getClientIP() {
$ipaddress = '';
if (isset($_SERVER['HTTP_CLIENT_IP']))
$ipaddress = $_SERVER['HTTP_CLIENT_IP'];
else if(isset($_SERVER['HTTP_X_FORWARDED_FOR']))
$ipaddress = $_SERVER['HTTP_X_FORWARDED_FOR'];
else if(isset($_SERVER['HTTP_X_FORWARDED']))
$ipaddress = $_SERVER['HTTP_X_FORWARDED'];
else if(isset($_SERVER['HTTP_FORWARDED_FOR']))
$ipaddress = $_SERVER['HTTP_FORWARDED_FOR'];
else if(isset($_SERVER['HTTP_FORWARDED']))
$ipaddress = $_SERVER['HTTP_FORWARDED'];
else if(isset($_SERVER['REMOTE_ADDR']))
$ipaddress = $_SERVER['REMOTE_ADDR'];
else
$ipaddress = 'UNKNOWN';
return $ipaddress;
}
// Get user agent
function getUserAgent() {
return $_SERVER['HTTP_USER_AGENT'] ?? '';
}
// Upload image
function uploadImage($file, $target_dir, $max_size = null, $allowed_types = null) {
$errors = [];
$success = false;
$filename = '';
if (!$max_size) {
$max_size = MAX_FILE_SIZE;
}
if (!$allowed_types) {
$allowed_types = explode(',', ALLOWED_IMAGE_TYPES);
}
// Check if file is uploaded
if (!isset($file) || $file['error'] !== UPLOAD_ERR_OK) {
$errors[] = 'No file uploaded or upload error';
return ['success' => false, 'errors' => $errors];
}
// Check file size
if ($file['size'] > $max_size) {
$errors[] = 'File size must be less than ' . ($max_size / 1048576) . 'MB';
return ['success' => false, 'errors' => $errors];
}
// Check file type
$finfo = finfo_open(FILEINFO_MIME_TYPE);
$mime_type = finfo_file($finfo, $file['tmp_name']);
finfo_close($finfo);
$extension = strtolower(pathinfo($file['name'], PATHINFO_EXTENSION));
if (!in_array($extension, $allowed_types)) {
$errors[] = 'File type not allowed. Allowed types: ' . implode(', ', $allowed_types);
return ['success' => false, 'errors' => $errors];
}
// Generate unique filename
$filename = uniqid() . '_' . time() . '.' . $extension;
$target_path = $target_dir . $filename;
// Create directory if not exists
if (!file_exists($target_dir)) {
mkdir($target_dir, 0755, true);
}
// Move uploaded file
if (move_uploaded_file($file['tmp_name'], $target_path)) {
$success = true;
// Create thumbnail for large images
if ($file['size'] > 1048576) { // If larger than 1MB
createThumbnail($target_path, $target_path, 1200, 1200);
}
} else {
$errors[] = 'Failed to upload file';
}
return [
'success' => $success,
'filename' => $filename,
'path' => $target_path,
'errors' => $errors
];
}
// Create thumbnail
function createThumbnail($source, $destination, $max_width, $max_height) {
list($width, $height, $type) = getimagesize($source);
$ratio = min($max_width / $width, $max_height / $height);
$new_width = $width * $ratio;
$new_height = $height * $ratio;
$thumb = imagecreatetruecolor($new_width, $new_height);
switch ($type) {
case IMAGETYPE_JPEG:
$source_img = imagecreatefromjpeg($source);
break;
case IMAGETYPE_PNG:
$source_img = imagecreatefrompng($source);
imagealphablending($thumb, false);
imagesavealpha($thumb, true);
break;
case IMAGETYPE_GIF:
$source_img = imagecreatefromgif($source);
break;
case IMAGETYPE_WEBP:
$source_img = imagecreatefromwebp($source);
break;
default:
return false;
}
imagecopyresampled($thumb, $source_img, 0, 0, 0, 0, $new_width, $new_height, $width, $height);
switch ($type) {
case IMAGETYPE_JPEG:
imagejpeg($thumb, $destination, 85);
break;
case IMAGETYPE_PNG:
imagepng($thumb, $destination, 8);
break;
case IMAGETYPE_GIF:
imagegif($thumb, $destination);
break;
case IMAGETYPE_WEBP:
imagewebp($thumb, $destination, 85);
break;
}
imagedestroy($source_img);
imagedestroy($thumb);
return true;
}
// Get user by ID
function getUserById($user_id) {
global $conn;
$sql = "SELECT * FROM users WHERE user_id = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("i", $user_id);
$stmt->execute();
$result = $stmt->get_result();
return $result->fetch_assoc();
}
// Get user by email
function getUserByEmail($email) {
global $conn;
$sql = "SELECT * FROM users WHERE email = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("s", $email);
$stmt->execute();
$result = $stmt->get_result();
return $result->fetch_assoc();
}
// Get user by username
function getUserByUsername($username) {
global $conn;
$sql = "SELECT * FROM users WHERE username = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("s", $username);
$stmt->execute();
$result = $stmt->get_result();
return $result->fetch_assoc();
}
// Get category by ID
function getCategoryById($category_id) {
global $conn;
$sql = "SELECT * FROM categories WHERE category_id = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("i", $category_id);
$stmt->execute();
$result = $stmt->get_result();
return $result->fetch_assoc();
}
// Get all categories
function getAllCategories($active_only = true, $parent_only = false) {
global $conn;
$sql = "SELECT * FROM categories";
if ($active_only) {
$sql .= " WHERE is_active = 1";
}
if ($parent_only) {
$sql .= " AND parent_category_id IS NULL";
}
$sql .= " ORDER BY display_order, category_name";
$result = $conn->query($sql);
return $result->fetch_all(MYSQLI_ASSOC);
}
// Get venue by ID
function getVenueById($venue_id) {
global $conn;
$sql = "SELECT * FROM venues WHERE venue_id = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("i", $venue_id);
$stmt->execute();
$result = $stmt->get_result();
return $result->fetch_assoc();
}
// Get event by ID
function getEventById($event_id) {
global $conn;
$sql = "SELECT e.*, u.username as organizer_username, u.full_name as organizer_name,
c.category_name, c.category_slug,
v.venue_name, v.address, v.city, v.state, v.country, v.latitude, v.longitude
FROM events e
JOIN users u ON e.organizer_id = u.user_id
JOIN categories c ON e.category_id = c.category_id
LEFT JOIN venues v ON e.venue_id = v.venue_id
WHERE e.event_id = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("i", $event_id);
$stmt->execute();
$result = $stmt->get_result();
return $result->fetch_assoc();
}
// Get event by slug
function getEventBySlug($slug) {
global $conn;
$sql = "SELECT e.*, u.username as organizer_username, u.full_name as organizer_name,
c.category_name, c.category_slug,
v.venue_name, v.address, v.city, v.state, v.country, v.latitude, v.longitude
FROM events e
JOIN users u ON e.organizer_id = u.user_id
JOIN categories c ON e.category_id = c.category_id
LEFT JOIN venues v ON e.venue_id = v.venue_id
WHERE e.slug = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("s", $slug);
$stmt->execute();
$result = $stmt->get_result();
return $result->fetch_assoc();
}
// Get event images
function getEventImages($event_id) {
global $conn;
$sql = "SELECT * FROM event_images WHERE event_id = ? ORDER BY is_primary DESC, display_order";
$stmt = $conn->prepare($sql);
$stmt->bind_param("i", $event_id);
$stmt->execute();
$result = $stmt->get_result();
return $result->fetch_all(MYSQLI_ASSOC);
}
// Get event speakers
function getEventSpeakers($event_id) {
global $conn;
$sql = "SELECT * FROM speakers WHERE event_id = ? ORDER BY display_order";
$stmt = $conn->prepare($sql);
$stmt->bind_param("i", $event_id);
$stmt->execute();
$result = $stmt->get_result();
return $result->fetch_all(MYSQLI_ASSOC);
}
// Get event sponsors
function getEventSponsors($event_id) {
global $conn;
$sql = "SELECT * FROM sponsors WHERE event_id = ? ORDER BY display_order";
$stmt = $conn->prepare($sql);
$stmt->bind_param("i", $event_id);
$stmt->execute();
$result = $stmt->get_result();
return $result->fetch_all(MYSQLI_ASSOC);
}
// Get ticket types for event
function getEventTicketTypes($event_id, $active_only = true) {
global $conn;
$sql = "SELECT * FROM ticket_types WHERE event_id = ?";
if ($active_only) {
$sql .= " AND is_active = 1 AND start_date <= NOW() AND end_date >= NOW()";
}
$sql .= " ORDER BY price";
$stmt = $conn->prepare($sql);
$stmt->bind_param("i", $event_id);
$stmt->execute();
$result = $stmt->get_result();
return $result->fetch_all(MYSQLI_ASSOC);
}
// Get available tickets count for ticket type
function getAvailableTickets($ticket_type_id) {
global $conn;
$sql = "SELECT quantity - quantity_sold as available FROM ticket_types WHERE ticket_type_id = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("i", $ticket_type_id);
$stmt->execute();
$result = $stmt->get_result();
$row = $result->fetch_assoc();
return $row['available'] ?? 0;
}
// Check if event is saved by user
function isEventSaved($user_id, $event_id) {
global $conn;
$sql = "SELECT * FROM saved_events WHERE user_id = ? AND event_id = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("ii", $user_id, $event_id);
$stmt->execute();
$result = $stmt->get_result();
return $result->num_rows > 0;
}
// Save event to user's list
function saveEvent($user_id, $event_id) {
global $conn;
if (isEventSaved($user_id, $event_id)) {
return false;
}
$sql = "INSERT INTO saved_events (user_id, event_id) VALUES (?, ?)";
$stmt = $conn->prepare($sql);
$stmt->bind_param("ii", $user_id, $event_id);
if ($stmt->execute()) {
// Increment saves count
$conn->query("UPDATE events SET saves_count = saves_count + 1 WHERE event_id = $event_id");
return true;
}
return false;
}
// Remove saved event
function unsaveEvent($user_id, $event_id) {
global $conn;
$sql = "DELETE FROM saved_events WHERE user_id = ? AND event_id = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("ii", $user_id, $event_id);
if ($stmt->execute() && $stmt->affected_rows > 0) {
// Decrement saves count
$conn->query("UPDATE events SET saves_count = saves_count - 1 WHERE event_id = $event_id");
return true;
}
return false;
}
// Create notification
function createNotification($user_id, $type, $title, $message, $link = null) {
global $conn;
$sql = "INSERT INTO notifications (user_id, type, title, message, link) VALUES (?, ?, ?, ?, ?)";
$stmt = $conn->prepare($sql);
$stmt->bind_param("issss", $user_id, $type, $title, $message, $link);
return $stmt->execute();
}
// Get user notifications
function getUserNotifications($user_id, $unread_only = false, $limit = 20) {
global $conn;
$sql = "SELECT * FROM notifications WHERE user_id = ?";
if ($unread_only) {
$sql .= " AND is_read = 0";
}
$sql .= " ORDER BY created_at DESC LIMIT ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("ii", $user_id, $limit);
$stmt->execute();
$result = $stmt->get_result();
return $result->fetch_all(MYSQLI_ASSOC);
}
// Mark notification as read
function markNotificationRead($notification_id, $user_id) {
global $conn;
$sql = "UPDATE notifications SET is_read = 1 WHERE notification_id = ? AND user_id = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("ii", $notification_id, $user_id);
return $stmt->execute();
}
// Mark all notifications as read
function markAllNotificationsRead($user_id) {
global $conn;
$sql = "UPDATE notifications SET is_read = 1 WHERE user_id = ? AND is_read = 0";
$stmt = $conn->prepare($sql);
$stmt->bind_param("i", $user_id);
return $stmt->execute();
}
// Get unread notification count
function getUnreadNotificationCount($user_id) {
global $conn;
$sql = "SELECT COUNT(*) as count FROM notifications WHERE user_id = ? AND is_read = 0";
$stmt = $conn->prepare($sql);
$stmt->bind_param("i", $user_id);
$stmt->execute();
$result = $stmt->get_result();
$row = $result->fetch_assoc();
return $row['count'];
}
// Get site setting
function getSetting($key, $default = null) {
static $settings_cache = [];
if (isset($settings_cache[$key])) {
return $settings_cache[$key];
}
global $conn;
$sql = "SELECT setting_value FROM site_settings WHERE setting_key = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("s", $key);
$stmt->execute();
$result = $stmt->get_result();
if ($row = $result->fetch_assoc()) {
$value = $row['setting_value'];
$settings_cache[$key] = $value;
return $value;
}
return $default;
}
// Update site setting
function updateSetting($key, $value, $user_id = null) {
global $conn;
if (!$user_id && isLoggedIn()) {
$user_id = getCurrentUserId();
}
$sql = "UPDATE site_settings SET setting_value = ?, updated_by = ?, updated_at = NOW() WHERE setting_key = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("sis", $value, $user_id, $key);
return $stmt->execute();
}
// Log activity
function logActivity($user_id, $action, $details = null) {
global $conn;
$ip = getClientIP();
$user_agent = getUserAgent();
$sql = "INSERT INTO activity_logs (user_id, action, details, ip_address, user_agent) 
VALUES (?, ?, ?, ?, ?)";
$stmt = $conn->prepare($sql);
$stmt->bind_param("issss", $user_id, $action, $details, $ip, $user_agent);
return $stmt->execute();
}
// Send email using template
function sendEmail($to, $template_key, $data = []) {
global $conn;
// Get template
$sql = "SELECT * FROM email_templates WHERE template_key = ? AND is_active = 1";
$stmt = $conn->prepare($sql);
$stmt->bind_param("s", $template_key);
$stmt->execute();
$result = $stmt->get_result();
$template = $result->fetch_assoc();
if (!$template) {
error_log("Email template not found: $template_key");
return false;
}
// Replace variables
$subject = $template['subject'];
$body = $template['body'];
$default_data = [
'site_name' => SITE_NAME,
'site_url' => SITE_URL,
'current_year' => date('Y')
];
$data = array_merge($default_data, $data);
foreach ($data as $key => $value) {
$subject = str_replace('{' . $key . '}', $value, $subject);
$body = str_replace('{' . $key . '}', $value, $body);
}
// In production, use PHPMailer
// mail($to, $subject, $body, "From: " . FROM_EMAIL);
// For now, just log
error_log("Email sent to $to: $subject");
return true;
}
// Generate QR code
function generateQRCode($data, $size = 200) {
// In production, use a QR code library
// For now, return a placeholder
return 'https://api.qrserver.com/v1/create-qr-code/?size=' . $size . 'x' . $size . '&data=' . urlencode($data);
}
// Pagination function
function paginate($current_page, $total_pages, $url_pattern) {
if ($total_pages <= 1) {
return '';
}
$html = '<ul class="pagination">';
// Previous button
if ($current_page > 1) {
$html .= '<li class="page-item"><a class="page-link" href="' . str_replace('{page}', $current_page - 1, $url_pattern) . '">Previous</a></li>';
} else {
$html .= '<li class="page-item disabled"><span class="page-link">Previous</span></li>';
}
// Page numbers
$start = max(1, $current_page - 2);
$end = min($total_pages, $current_page + 2);
if ($start > 1) {
$html .= '<li class="page-item"><a class="page-link" href="' . str_replace('{page}', 1, $url_pattern) . '">1</a></li>';
if ($start > 2) {
$html .= '<li class="page-item disabled"><span class="page-link">...</span></li>';
}
}
for ($i = $start; $i <= $end; $i++) {
if ($i == $current_page) {
$html .= '<li class="page-item active"><span class="page-link">' . $i . '</span></li>';
} else {
$html .= '<li class="page-item"><a class="page-link" href="' . str_replace('{page}', $i, $url_pattern) . '">' . $i . '</a></li>';
}
}
if ($end < $total_pages) {
if ($end < $total_pages - 1) {
$html .= '<li class="page-item disabled"><span class="page-link">...</span></li>';
}
$html .= '<li class="page-item"><a class="page-link" href="' . str_replace('{page}', $total_pages, $url_pattern) . '">' . $total_pages . '</a></li>';
}
// Next button
if ($current_page < $total_pages) {
$html .= '<li class="page-item"><a class="page-link" href="' . str_replace('{page}', $current_page + 1, $url_pattern) . '">Next</a></li>';
} else {
$html .= '<li class="page-item disabled"><span class="page-link">Next</span></li>';
}
$html .= '</ul>';
return $html;
}
// Validate date range
function validateDateRange($start_date, $end_date) {
$start = strtotime($start_date);
$end = strtotime($end_date);
if (!$start || !$end) {
return false;
}
return $end >= $start;
}
// Calculate event duration in days
function getEventDuration($start_date, $end_date) {
$start = strtotime($start_date);
$end = strtotime($end_date);
return ceil(($end - $start) / 86400);
}
// Check if event is ongoing
function isEventOngoing($event) {
$now = time();
$start = strtotime($event['start_date'] . ' ' . ($event['start_time'] ?? '00:00:00'));
$end = strtotime($event['end_date'] . ' ' . ($event['end_time'] ?? '23:59:59'));
return $now >= $start && $now <= $end;
}
// Check if event is upcoming
function isEventUpcoming($event) {
$now = time();
$start = strtotime($event['start_date'] . ' ' . ($event['start_time'] ?? '00:00:00'));
return $now < $start;
}
// Check if event has ended
function hasEventEnded($event) {
$now = time();
$end = strtotime($event['end_date'] . ' ' . ($event['end_time'] ?? '23:59:59'));
return $now > $end;
}
?>

4. includes/event_functions.php

<?php
require_once 'functions.php';
class EventManager {
private $conn;
private $user_id;
public function __construct($user_id = null) {
global $conn;
$this->conn = $conn;
$this->user_id = $user_id ?: getCurrentUserId();
}
// Create new event
public function createEvent($data, $images = []) {
// Validate required fields
$required = ['title', 'description', 'category_id', 'start_date', 'end_date'];
foreach ($required as $field) {
if (empty($data[$field])) {
return ['success' => false, 'message' => ucfirst(str_replace('_', ' ', $field)) . ' is required'];
}
}
// Validate dates
if (!validateDateRange($data['start_date'], $data['end_date'])) {
return ['success' => false, 'message' => 'End date must be after start date'];
}
// Validate event duration
$duration = getEventDuration($data['start_date'], $data['end_date']);
$max_duration = getSetting('max_event_duration', MAX_EVENT_DURATION);
if ($duration > $max_duration) {
return ['success' => false, 'message' => "Event duration cannot exceed $max_duration days"];
}
// Generate slug
$slug = generateSlug($data['title']);
$slug = $this->makeSlugUnique($slug);
// Begin transaction
$this->conn->begin_transaction();
try {
// Insert event
$sql = "INSERT INTO events (
organizer_id, category_id, venue_id, title, slug, description,
short_description, type, format, start_date, end_date,
start_time, end_time, timezone, max_attendees, registration_deadline,
refund_policy, terms_conditions, banner_image, status
) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
$stmt = $this->conn->prepare($sql);
$short_desc = substr($data['description'], 0, 200) . '...';
$status = getSetting('auto_approve_events', false) ? 'published' : 'pending';
$stmt->bind_param(
"iiisssssssssssisssss",
$this->user_id,
$data['category_id'],
$data['venue_id'] ?? null,
$data['title'],
$slug,
$data['description'],
$short_desc,
$data['type'] ?? 'physical',
$data['format'] ?? 'single',
$data['start_date'],
$data['end_date'],
$data['start_time'] ?? null,
$data['end_time'] ?? null,
$data['timezone'] ?? 'UTC',
$data['max_attendees'] ?? null,
$data['registration_deadline'] ?? null,
$data['refund_policy'] ?? null,
$data['terms_conditions'] ?? null,
$data['banner_image'] ?? null,
$status
);
$stmt->execute();
$event_id = $this->conn->insert_id;
// Upload images
if (!empty($images)) {
$this->uploadEventImages($event_id, $images);
}
// Create event sessions if provided
if (!empty($data['sessions'])) {
$this->createSessions($event_id, $data['sessions']);
}
// Add speakers if provided
if (!empty($data['speakers'])) {
$this->addSpeakers($event_id, $data['speakers']);
}
// Add sponsors if provided
if (!empty($data['sponsors'])) {
$this->addSponsors($event_id, $data['sponsors']);
}
// Create ticket types if provided
if (!empty($data['ticket_types'])) {
$this->createTicketTypes($event_id, $data['ticket_types']);
}
// Update organizer's event count
$this->conn->query("UPDATE users SET created_events = created_events + 1 WHERE user_id = $this->user_id");
// Update category event count
$this->conn->query("UPDATE categories SET event_count = event_count + 1 WHERE category_id = {$data['category_id']}");
// Log activity
logActivity($this->user_id, 'create_event', "Created event: {$data['title']}");
// Send notification to admin for approval
if ($status == 'pending') {
$this->notifyAdminNewEvent($event_id, $data['title']);
}
// Commit transaction
$this->conn->commit();
return [
'success' => true,
'event_id' => $event_id,
'slug' => $slug,
'message' => 'Event created successfully' . ($status == 'pending' ? ' and pending approval' : '')
];
} catch (Exception $e) {
$this->conn->rollback();
error_log("Event creation failed: " . $e->getMessage());
return ['success' => false, 'message' => 'Failed to create event: ' . $e->getMessage()];
}
}
// Upload event images
private function uploadEventImages($event_id, $images) {
$max_images = 10;
$count = 0;
$primary_set = false;
foreach ($images as $index => $image) {
if ($count >= $max_images) break;
$result = uploadImage($image, EVENT_IMG_DIR);
if ($result['success']) {
$is_primary = (!$primary_set) ? 1 : 0;
if ($is_primary) $primary_set = true;
$sql = "INSERT INTO event_images (event_id, image_path, is_primary, display_order) 
VALUES (?, ?, ?, ?)";
$stmt = $this->conn->prepare($sql);
$stmt->bind_param("isii", $event_id, $result['filename'], $is_primary, $index);
$stmt->execute();
$count++;
}
}
}
// Create event sessions
private function createSessions($event_id, $sessions) {
foreach ($sessions as $session) {
$sql = "INSERT INTO event_sessions (event_id, title, description, speaker_id, room, start_time, end_time, capacity) 
VALUES (?, ?, ?, ?, ?, ?, ?, ?)";
$stmt = $this->conn->prepare($sql);
$stmt->bind_param(
"ississsi",
$event_id,
$session['title'],
$session['description'] ?? null,
$session['speaker_id'] ?? null,
$session['room'] ?? null,
$session['start_time'],
$session['end_time'],
$session['capacity'] ?? null
);
$stmt->execute();
}
}
// Add speakers
private function addSpeakers($event_id, $speakers) {
foreach ($speakers as $index => $speaker) {
$sql = "INSERT INTO speakers (event_id, name, title, company, bio, photo, email, social_links, display_order) 
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)";
$stmt = $this->conn->prepare($sql);
$social_links = json_encode($speaker['social_links'] ?? []);
$stmt->bind_param(
"isssssssi",
$event_id,
$speaker['name'],
$speaker['title'] ?? null,
$speaker['company'] ?? null,
$speaker['bio'] ?? null,
$speaker['photo'] ?? null,
$speaker['email'] ?? null,
$social_links,
$index
);
$stmt->execute();
}
}
// Add sponsors
private function addSponsors($event_id, $sponsors) {
foreach ($sponsors as $index => $sponsor) {
$sql = "INSERT INTO sponsors (event_id, name, level, logo, website, description, display_order) 
VALUES (?, ?, ?, ?, ?, ?, ?)";
$stmt = $this->conn->prepare($sql);
$stmt->bind_param(
"isssssi",
$event_id,
$sponsor['name'],
$sponsor['level'] ?? 'bronze',
$sponsor['logo'] ?? null,
$sponsor['website'] ?? null,
$sponsor['description'] ?? null,
$index
);
$stmt->execute();
}
}
// Create ticket types
private function createTicketTypes($event_id, $ticket_types) {
foreach ($ticket_types as $ticket) {
$sql = "INSERT INTO ticket_types (event_id, name, description, price, quantity, max_per_order, start_date, end_date, features) 
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)";
$stmt = $this->conn->prepare($sql);
$features = json_encode($ticket['features'] ?? []);
$stmt->bind_param(
"issdiisss",
$event_id,
$ticket['name'],
$ticket['description'] ?? null,
$ticket['price'],
$ticket['quantity'],
$ticket['max_per_order'] ?? 10,
$ticket['start_date'],
$ticket['end_date'],
$features
);
$stmt->execute();
}
}
// Make slug unique
private function makeSlugUnique($slug) {
$original = $slug;
$counter = 1;
while ($this->slugExists($slug)) {
$slug = $original . '-' . $counter;
$counter++;
}
return $slug;
}
// Check if slug exists
private function slugExists($slug) {
$sql = "SELECT event_id FROM events WHERE slug = ?";
$stmt = $this->conn->prepare($sql);
$stmt->bind_param("s", $slug);
$stmt->execute();
$result = $stmt->get_result();
return $result->num_rows > 0;
}
// Get organizer's events
public function getOrganizerEvents($status = null, $limit = null, $offset = 0) {
$sql = "SELECT e.*, c.category_name,
(SELECT COUNT(*) FROM tickets WHERE event_id = e.event_id) as ticket_count,
(SELECT COUNT(*) FROM attendees WHERE event_id = e.event_id) as attendee_count
FROM events e
JOIN categories c ON e.category_id = c.category_id
WHERE e.organizer_id = ?";
if ($status) {
if (is_array($status)) {
$placeholders = implode(',', array_fill(0, count($status), '?'));
$sql .= " AND e.status IN ($placeholders)";
} else {
$sql .= " AND e.status = ?";
}
}
$sql .= " ORDER BY e.created_at DESC";
if ($limit) {
$sql .= " LIMIT ? OFFSET ?";
}
$stmt = $this->conn->prepare($sql);
// Build parameters array
$params = [$this->user_id];
$types = "i";
if ($status) {
if (is_array($status)) {
$params = array_merge($params, $status);
$types .= str_repeat('s', count($status));
} else {
$params[] = $status;
$types .= "s";
}
}
if ($limit) {
$params[] = $limit;
$params[] = $offset;
$types .= "ii";
}
$stmt->bind_param($types, ...$params);
$stmt->execute();
$result = $stmt->get_result();
return $result->fetch_all(MYSQLI_ASSOC);
}
// Get event statistics
public function getEventStats($event_id) {
// Check ownership
if (!$this->isOrganizer($event_id) && !isAdmin()) {
return null;
}
$stats = [];
// Ticket sales
$sql = "SELECT 
COUNT(DISTINCT ticket_id) as total_tickets,
SUM(quantity) as total_quantity,
SUM(total_price) as total_revenue,
SUM(fees) as total_fees,
SUM(CASE WHEN payment_status = 'paid' THEN total_price ELSE 0 END) as paid_revenue
FROM tickets 
WHERE event_id = ? AND status != 'cancelled'";
$stmt = $this->conn->prepare($sql);
$stmt->bind_param("i", $event_id);
$stmt->execute();
$stats['sales'] = $stmt->get_result()->fetch_assoc();
// Attendees
$sql = "SELECT 
COUNT(*) as total_attendees,
SUM(checked_in) as checked_in
FROM attendees 
WHERE event_id = ?";
$stmt = $this->conn->prepare($sql);
$stmt->bind_param("i", $event_id);
$stmt->execute();
$stats['attendees'] = $stmt->get_result()->fetch_assoc();
// Ticket types breakdown
$sql = "SELECT 
tt.name,
tt.price,
tt.quantity as total,
tt.quantity_sold as sold,
(tt.quantity - tt.quantity_sold) as available
FROM ticket_types tt
WHERE tt.event_id = ?";
$stmt = $this->conn->prepare($sql);
$stmt->bind_param("i", $event_id);
$stmt->execute();
$stats['ticket_types'] = $stmt->get_result()->fetch_all(MYSQLI_ASSOC);
// Daily sales
$sql = "SELECT 
DATE(created_at) as date,
COUNT(*) as tickets,
SUM(total_price) as revenue
FROM tickets 
WHERE event_id = ? AND status != 'cancelled'
GROUP BY DATE(created_at)
ORDER BY date DESC
LIMIT 30";
$stmt = $this->conn->prepare($sql);
$stmt->bind_param("i", $event_id);
$stmt->execute();
$stats['daily_sales'] = $stmt->get_result()->fetch_all(MYSQLI_ASSOC);
return $stats;
}
// Update event
public function updateEvent($event_id, $data) {
// Check ownership
if (!$this->isOrganizer($event_id) && !isAdmin()) {
return ['success' => false, 'message' => 'You do not have permission to update this event'];
}
// Check if event can be edited
$event = getEventById($event_id);
if ($event['status'] == 'cancelled' || $event['status'] == 'completed') {
return ['success' => false, 'message' => 'Event cannot be edited in its current state'];
}
// Build update query
$updates = [];
$params = [];
$types = "";
$allowed = ['title', 'description', 'category_id', 'venue_id', 'type', 'format',
'start_date', 'end_date', 'start_time', 'end_time', 'timezone',
'max_attendees', 'registration_deadline', 'refund_policy',
'terms_conditions', 'status'];
foreach ($allowed as $field) {
if (isset($data[$field])) {
$updates[] = "$field = ?";
$params[] = $data[$field];
$types .= is_numeric($data[$field]) ? "i" : "s";
}
}
if (empty($updates)) {
return ['success' => false, 'message' => 'No fields to update'];
}
// Add event_id to params
$params[] = $event_id;
$types .= "i";
$sql = "UPDATE events SET " . implode(', ', $updates) . " WHERE event_id = ?";
$stmt = $this->conn->prepare($sql);
$stmt->bind_param($types, ...$params);
if ($stmt->execute()) {
logActivity($this->user_id, 'update_event', "Updated event ID: $event_id");
// If status changed to published, notify attendees if any
if (isset($data['status']) && $data['status'] == 'published' && $event['status'] != 'published') {
$this->notifyAttendeesEventPublished($event_id);
}
return ['success' => true, 'message' => 'Event updated successfully'];
}
return ['success' => false, 'message' => 'Failed to update event'];
}
// Cancel event
public function cancelEvent($event_id, $reason = null) {
// Check ownership
if (!$this->isOrganizer($event_id) && !isAdmin()) {
return ['success' => false, 'message' => 'You do not have permission to cancel this event'];
}
$event = getEventById($event_id);
if ($event['status'] == 'cancelled') {
return ['success' => false, 'message' => 'Event is already cancelled'];
}
if ($event['status'] == 'completed') {
return ['success' => false, 'message' => 'Completed events cannot be cancelled'];
}
// Begin transaction
$this->conn->begin_transaction();
try {
// Update event status
$sql = "UPDATE events SET status = 'cancelled' WHERE event_id = ?";
$stmt = $this->conn->prepare($sql);
$stmt->bind_param("i", $event_id);
$stmt->execute();
// Get all ticket holders
$sql = "SELECT DISTINCT user_id FROM tickets WHERE event_id = ? AND status = 'confirmed'";
$stmt = $this->conn->prepare($sql);
$stmt->bind_param("i", $event_id);
$stmt->execute();
$result = $stmt->get_result();
// Notify attendees
while ($row = $result->fetch_assoc()) {
createNotification(
$row['user_id'],
'event',
'Event Cancelled',
"The event '{$event['title']}' has been cancelled." . ($reason ? " Reason: $reason" : ""),
SITE_URL . 'event.php?slug=' . $event['slug']
);
// Process refunds if applicable
$this->processRefunds($event_id, $row['user_id']);
}
// Log activity
logActivity($this->user_id, 'cancel_event', "Cancelled event ID: $event_id" . ($reason ? " - $reason" : ""));
$this->conn->commit();
return ['success' => true, 'message' => 'Event cancelled successfully'];
} catch (Exception $e) {
$this->conn->rollback();
return ['success' => false, 'message' => 'Failed to cancel event: ' . $e->getMessage()];
}
}
// Process refunds for cancelled event
private function processRefunds($event_id, $user_id) {
$sql = "UPDATE tickets SET status = 'refunded', payment_status = 'refunded' 
WHERE event_id = ? AND user_id = ? AND status = 'confirmed'";
$stmt = $this->conn->prepare($sql);
$stmt->bind_param("ii", $event_id, $user_id);
$stmt->execute();
}
// Check if user is organizer of event
private function isOrganizer($event_id) {
$sql = "SELECT organizer_id FROM events WHERE event_id = ?";
$stmt = $this->conn->prepare($sql);
$stmt->bind_param("i", $event_id);
$stmt->execute();
$result = $stmt->get_result();
$event = $result->fetch_assoc();
return $event && $event['organizer_id'] == $this->user_id;
}
// Notify admin about new event
private function notifyAdminNewEvent($event_id, $title) {
$admins = $this->getAdminUsers();
foreach ($admins as $admin) {
createNotification(
$admin['user_id'],
'system',
'New Event Pending Approval',
"A new event '$title' requires your approval",
ADMIN_URL . 'event-details.php?id=' . $event_id
);
}
}
// Notify attendees event published
private function notifyAttendeesEventPublished($event_id) {
$event = getEventById($event_id);
$sql = "SELECT DISTINCT user_id FROM saved_events WHERE event_id = ?";
$stmt = $this->conn->prepare($sql);
$stmt->bind_param("i", $event_id);
$stmt->execute();
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
createNotification(
$row['user_id'],
'event',
'Event Published',
"The event '{$event['title']}' you were interested in is now available!",
SITE_URL . 'event.php?slug=' . $event['slug']
);
}
}
// Get admin users
private function getAdminUsers() {
$sql = "SELECT user_id FROM users WHERE role = 'admin' AND status = 'active'";
$result = $this->conn->query($sql);
return $result->fetch_all(MYSQLI_ASSOC);
}
// Get upcoming events (static method)
public static function getUpcomingEvents($limit = 6) {
global $conn;
$sql = "SELECT e.*, u.username as organizer_username,
c.category_name, c.category_slug,
(SELECT image_path FROM event_images WHERE event_id = e.event_id AND is_primary = 1 LIMIT 1) as primary_image
FROM events e
JOIN users u ON e.organizer_id = u.user_id
JOIN categories c ON e.category_id = c.category_id
WHERE e.status = 'published' AND e.start_date >= CURDATE()
ORDER BY e.start_date ASC
LIMIT ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("i", $limit);
$stmt->execute();
$result = $stmt->get_result();
return $result->fetch_all(MYSQLI_ASSOC);
}
// Get featured events
public static function getFeaturedEvents($limit = 4) {
global $conn;
$sql = "SELECT e.*, u.username as organizer_username,
c.category_name, c.category_slug,
(SELECT image_path FROM event_images WHERE event_id = e.event_id AND is_primary = 1 LIMIT 1) as primary_image
FROM events e
JOIN users u ON e.organizer_id = u.user_id
JOIN categories c ON e.category_id = c.category_id
WHERE e.status = 'published' AND e.featured = 1
ORDER BY e.featured_until DESC
LIMIT ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("i", $limit);
$stmt->execute();
$result = $stmt->get_result();
return $result->fetch_all(MYSQLI_ASSOC);
}
// Search events with filters
public static function searchEvents($filters = [], $page = 1, $per_page = EVENTS_PER_PAGE) {
global $conn;
$where = ["e.status = 'published'"];
$params = [];
$types = "";
// Category filter
if (!empty($filters['category'])) {
$where[] = "e.category_id = ?";
$params[] = $filters['category'];
$types .= "i";
}
// Date range
if (!empty($filters['start_date'])) {
$where[] = "e.start_date >= ?";
$params[] = $filters['start_date'];
$types .= "s";
}
if (!empty($filters['end_date'])) {
$where[] = "e.end_date <= ?";
$params[] = $filters['end_date'];
$types .= "s";
}
// Location
if (!empty($filters['city'])) {
$where[] = "v.city LIKE ?";
$params[] = "%{$filters['city']}%";
$types .= "s";
}
if (!empty($filters['country'])) {
$where[] = "v.country = ?";
$params[] = $filters['country'];
$types .= "s";
}
// Event type
if (!empty($filters['type'])) {
$where[] = "e.type = ?";
$params[] = $filters['type'];
$types .= "s";
}
// Price range
if (!empty($filters['min_price']) || !empty($filters['max_price'])) {
$price_subquery = "SELECT event_id FROM ticket_types WHERE 1=1";
if (!empty($filters['min_price'])) {
$price_subquery .= " AND price >= ?";
$params[] = $filters['min_price'];
$types .= "d";
}
if (!empty($filters['max_price'])) {
$price_subquery .= " AND price <= ?";
$params[] = $filters['max_price'];
$types .= "d";
}
$where[] = "e.event_id IN ($price_subquery)";
}
// Search query
if (!empty($filters['search'])) {
$where[] = "(e.title LIKE ? OR e.description LIKE ?)";
$search_term = "%{$filters['search']}%";
$params[] = $search_term;
$params[] = $search_term;
$types .= "ss";
}
// Featured only
if (!empty($filters['featured'])) {
$where[] = "e.featured = 1";
}
// Free events only
if (!empty($filters['free'])) {
$where[] = "e.event_id IN (SELECT event_id FROM ticket_types WHERE price = 0)";
}
$where_clause = implode(' AND ', $where);
// Count total records
$count_sql = "SELECT COUNT(DISTINCT e.event_id) as total 
FROM events e
LEFT JOIN venues v ON e.venue_id = v.venue_id
WHERE $where_clause";
$count_stmt = $conn->prepare($count_sql);
if (!empty($params)) {
$count_stmt->bind_param($types, ...$params);
}
$count_stmt->execute();
$count_result = $count_stmt->get_result();
$total_records = $count_result->fetch_assoc()['total'];
$total_pages = ceil($total_records / $per_page);
// Get records for current page
$offset = ($page - 1) * $per_page;
$sql = "SELECT e.*, u.username as organizer_username, u.full_name as organizer_name,
c.category_name, c.category_slug,
v.venue_name, v.city, v.country,
(SELECT image_path FROM event_images WHERE event_id = e.event_id AND is_primary = 1 LIMIT 1) as primary_image,
(SELECT MIN(price) FROM ticket_types WHERE event_id = e.event_id) as min_price,
(SELECT MAX(price) FROM ticket_types WHERE event_id = e.event_id) as max_price
FROM events e
JOIN users u ON e.organizer_id = u.user_id
JOIN categories c ON e.category_id = c.category_id
LEFT JOIN venues v ON e.venue_id = v.venue_id
WHERE $where_clause
ORDER BY ";
// Sorting
if (!empty($filters['sort'])) {
switch ($filters['sort']) {
case 'price_asc':
$sql .= "min_price ASC";
break;
case 'price_desc':
$sql .= "min_price DESC";
break;
case 'date_asc':
$sql .= "e.start_date ASC";
break;
case 'date_desc':
$sql .= "e.start_date DESC";
break;
case 'popular':
$sql .= "e.views_count DESC";
break;
default:
$sql .= "e.featured DESC, e.start_date ASC";
}
} else {
$sql .= "e.featured DESC, e.start_date ASC";
}
$sql .= " LIMIT ? OFFSET ?";
$stmt = $conn->prepare($sql);
// Add pagination parameters
$all_params = array_merge($params, [$per_page, $offset]);
$all_types = $types . "ii";
if (!empty($all_params)) {
$stmt->bind_param($all_types, ...$all_params);
}
$stmt->execute();
$result = $stmt->get_result();
return [
'events' => $result->fetch_all(MYSQLI_ASSOC),
'total' => $total_records,
'pages' => $total_pages,
'current_page' => $page,
'per_page' => $per_page
];
}
}
?>

5. index.php (Homepage)

<?php
require_once 'includes/config.php';
require_once 'includes/functions.php';
require_once 'includes/event_functions.php';
// Get featured events
$featured_events = EventManager::getFeaturedEvents(4);
// Get upcoming events
$upcoming_events = EventManager::getUpcomingEvents(6);
// Get categories
$categories = getAllCategories(true, true);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title><?php echo SITE_NAME; ?> - Discover & Book Amazing Events</title>
<meta name="description" content="Find and book tickets for the best events in your city. Concerts, conferences, workshops, and more.">
<link rel="stylesheet" href="assets/css/bootstrap.min.css">
<link rel="stylesheet" href="assets/css/font-awesome.min.css">
<link rel="stylesheet" href="assets/css/style.css">
</head>
<body>
<!-- Navigation -->
<nav class="navbar navbar-expand-lg navbar-light bg-white fixed-top shadow-sm">
<div class="container">
<a class="navbar-brand" href="index.php">
<i class="fas fa-calendar-alt text-primary"></i>
<?php echo SITE_NAME; ?>
</a>
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarNav">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarNav">
<ul class="navbar-nav mx-auto">
<li class="nav-item">
<a class="nav-link" href="events.php">Browse Events</a>
</li>
<li class="nav-item">
<a class="nav-link" href="categories.php">Categories</a>
</li>
<li class="nav-item">
<a class="nav-link" href="calendar.php">Calendar</a>
</li>
<li class="nav-item">
<a class="nav-link" href="how-it-works.php">How It Works</a>
</li>
</ul>
<div class="navbar-nav ml-auto">
<?php if (isLoggedIn()): ?>
<div class="dropdown">
<button class="btn btn-outline-primary dropdown-toggle" type="button" data-toggle="dropdown">
<i class="fas fa-user-circle"></i>
<?php echo htmlspecialchars($_SESSION['username']); ?>
<?php $unread_count = getUnreadNotificationCount(getCurrentUserId()); ?>
<?php if ($unread_count > 0): ?>
<span class="badge badge-danger"><?php echo $unread_count; ?></span>
<?php endif; ?>
</button>
<div class="dropdown-menu dropdown-menu-right">
<a class="dropdown-item" href="user/dashboard.php">
<i class="fas fa-tachometer-alt"></i> Dashboard
</a>
<a class="dropdown-item" href="user/my-events.php">
<i class="fas fa-ticket-alt"></i> My Events
</a>
<a class="dropdown-item" href="user/saved-events.php">
<i class="fas fa-heart"></i> Saved Events
</a>
<a class="dropdown-item" href="user/messages.php">
<i class="fas fa-envelope"></i> Messages
<?php if ($unread_count > 0): ?>
<span class="badge badge-danger float-right"><?php echo $unread_count; ?></span>
<?php endif; ?>
</a>
<div class="dropdown-divider"></div>
<a class="dropdown-item" href="user/profile.php">
<i class="fas fa-user-cog"></i> Profile
</a>
<?php if (isOrganizer()): ?>
<a class="dropdown-item" href="organizer/dashboard.php">
<i class="fas fa-chart-line"></i> Organizer Dashboard
</a>
<?php endif; ?>
<?php if (isAdmin()): ?>
<a class="dropdown-item" href="admin/dashboard.php">
<i class="fas fa-lock"></i> Admin Panel
</a>
<?php endif; ?>
<div class="dropdown-divider"></div>
<a class="dropdown-item" href="user/logout.php">
<i class="fas fa-sign-out-alt"></i> Logout
</a>
</div>
</div>
<?php else: ?>
<a href="user/login.php" class="btn btn-outline-primary mr-2">Login</a>
<a href="user/register.php" class="btn btn-primary">Sign Up</a>
<?php endif; ?>
</div>
</div>
</div>
</nav>
<!-- Hero Section -->
<section class="hero-section">
<div class="container">
<div class="row align-items-center">
<div class="col-lg-6">
<h1 class="display-4 font-weight-bold mb-4">
Discover Amazing <span class="text-primary">Events</span> Near You
</h1>
<p class="lead mb-4">
Find and book tickets for concerts, conferences, workshops, and more. 
Join millions of event enthusiasts worldwide.
</p>
<!-- Search Form -->
<form action="search.php" method="GET" class="search-form mb-4">
<div class="input-group input-group-lg">
<input type="text" name="q" class="form-control" 
placeholder="Search for events, categories, or venues..." 
required>
<div class="input-group-append">
<button class="btn btn-primary" type="submit">
<i class="fas fa-search"></i> Search
</button>
</div>
</div>
</form>
<!-- Popular Searches -->
<div class="popular-searches">
<span class="text-muted mr-2">Popular:</span>
<a href="search.php?q=music" class="badge badge-light mr-2">Music</a>
<a href="search.php?q=tech" class="badge badge-light mr-2">Tech</a>
<a href="search.php?q=workshop" class="badge badge-light mr-2">Workshops</a>
<a href="search.php?q=food" class="badge badge-light mr-2">Food</a>
<a href="search.php?q=sports" class="badge badge-light mr-2">Sports</a>
</div>
</div>
<div class="col-lg-6">
<img src="assets/images/hero-illustration.svg" alt="Events" class="img-fluid">
</div>
</div>
</div>
</section>
<!-- Categories Section -->
<section class="categories-section py-5">
<div class="container">
<h2 class="text-center mb-5">Browse by Category</h2>
<div class="row">
<?php foreach ($categories as $category): ?>
<div class="col-md-3 col-sm-6 mb-4">
<a href="events.php?category=<?php echo $category['category_id']; ?>" 
class="category-card text-decoration-none">
<div class="card h-100 text-center border-0 shadow-sm">
<div class="card-body">
<i class="fas <?php echo $category['icon']; ?> fa-3x text-primary mb-3"></i>
<h5 class="card-title"><?php echo $category['category_name']; ?></h5>
<p class="card-text text-muted">
<?php echo $category['event_count']; ?> Events
</p>
</div>
</div>
</a>
</div>
<?php endforeach; ?>
</div>
</div>
</section>
<!-- Featured Events -->
<?php if (!empty($featured_events)): ?>
<section class="featured-section py-5 bg-light">
<div class="container">
<h2 class="text-center mb-5">Featured Events</h2>
<div class="row">
<?php foreach ($featured_events as $event): ?>
<div class="col-md-3 mb-4">
<div class="card event-card h-100 border-0 shadow-sm">
<img src="uploads/event_images/<?php echo $event['primary_image'] ?? 'default-event.jpg'; ?>" 
class="card-img-top" alt="<?php echo htmlspecialchars($event['title']); ?>"
style="height: 200px; object-fit: cover;">
<div class="card-body">
<span class="badge badge-primary mb-2"><?php echo $event['category_name']; ?></span>
<h5 class="card-title">
<a href="event.php?slug=<?php echo $event['slug']; ?>" class="text-dark">
<?php echo htmlspecialchars($event['title']); ?>
</a>
</h5>
<p class="card-text text-muted small">
<i class="fas fa-map-marker-alt"></i> 
<?php echo $event['venue_name'] ?? 'Online Event'; ?>
</p>
<div class="d-flex justify-content-between align-items-center">
<span class="text-primary font-weight-bold">
<?php echo formatCurrency($event['min_price'] ?? 0); ?>+
</span>
<span class="text-muted small">
<i class="far fa-calendar"></i> 
<?php echo formatDate($event['start_date']); ?>
</span>
</div>
</div>
</div>
</div>
<?php endforeach; ?>
</div>
</div>
</section>
<?php endif; ?>
<!-- Upcoming Events -->
<section class="upcoming-section py-5">
<div class="container">
<h2 class="text-center mb-5">Upcoming Events</h2>
<div class="row">
<?php foreach ($upcoming_events as $event): ?>
<div class="col-md-4 mb-4">
<div class="card event-card h-100 border-0 shadow-sm">
<img src="uploads/event_images/<?php echo $event['primary_image'] ?? 'default-event.jpg'; ?>" 
class="card-img-top" alt="<?php echo htmlspecialchars($event['title']); ?>"
style="height: 200px; object-fit: cover;">
<div class="card-body">
<div class="d-flex justify-content-between mb-2">
<span class="badge badge-primary"><?php echo $event['category_name']; ?></span>
<span class="badge badge-light">
<i class="far fa-clock"></i> 
<?php echo timeAgo($event['start_date']); ?>
</span>
</div>
<h5 class="card-title">
<a href="event.php?slug=<?php echo $event['slug']; ?>" class="text-dark">
<?php echo htmlspecialchars($event['title']); ?>
</a>
</h5>
<p class="card-text text-muted small">
<i class="fas fa-user"></i> by <?php echo $event['organizer_username']; ?><br>
<i class="fas fa-map-marker-alt"></i> 
<?php echo $event['city'] ?? 'Online Event'; ?>, <?php echo $event['country'] ?? ''; ?>
</p>
<div class="d-flex justify-content-between align-items-center">
<span class="text-primary font-weight-bold">
<?php 
if ($event['min_price'] == 0 && $event['max_price'] == 0) {
echo 'Free';
} else {
echo formatCurrency($event['min_price'] ?? 0);
}
?>
</span>
<a href="event.php?slug=<?php echo $event['slug']; ?>" 
class="btn btn-outline-primary btn-sm">
View Details
</a>
</div>
</div>
</div>
</div>
<?php endforeach; ?>
</div>
<div class="text-center mt-4">
<a href="events.php" class="btn btn-primary btn-lg">
Browse All Events <i class="fas fa-arrow-right ml-2"></i>
</a>
</div>
</div>
</section>
<!-- How It Works -->
<section class="how-it-works py-5 bg-light">
<div class="container">
<h2 class="text-center mb-5">How It Works</h2>
<div class="row">
<div class="col-md-3 text-center mb-4">
<div class="step-icon bg-primary text-white rounded-circle mx-auto mb-3">
<i class="fas fa-user-plus fa-2x"></i>
</div>
<h5>Create Account</h5>
<p class="text-muted">Sign up for free and start exploring events</p>
</div>
<div class="col-md-3 text-center mb-4">
<div class="step-icon bg-primary text-white rounded-circle mx-auto mb-3">
<i class="fas fa-search fa-2x"></i>
</div>
<h5>Find Events</h5>
<p class="text-muted">Browse by category, location, or date</p>
</div>
<div class="col-md-3 text-center mb-4">
<div class="step-icon bg-primary text-white rounded-circle mx-auto mb-3">
<i class="fas fa-ticket-alt fa-2x"></i>
</div>
<h5>Book Tickets</h5>
<p class="text-muted">Secure your spot with easy booking</p>
</div>
<div class="col-md-3 text-center mb-4">
<div class="step-icon bg-primary text-white rounded-circle mx-auto mb-3">
<i class="fas fa-smile fa-2x"></i>
</div>
<h5>Enjoy the Event</h5>
<p class="text-muted">Have a great time and make memories</p>
</div>
</div>
</div>
</section>
<!-- CTA Section -->
<section class="cta-section py-5 bg-primary text-white">
<div class="container text-center">
<h2 class="mb-4">Want to Host Your Own Event?</h2>
<p class="lead mb-4">Join thousands of organizers and reach millions of attendees</p>
<?php if (isLoggedIn()): ?>
<a href="organizer/create-event.php" class="btn btn-light btn-lg">
Create an Event <i class="fas fa-arrow-right ml-2"></i>
</a>
<?php else: ?>
<a href="organizer/register.php" class="btn btn-light btn-lg">
Become an Organizer <i class="fas fa-arrow-right ml-2"></i>
</a>
<?php endif; ?>
</div>
</section>
<!-- Footer -->
<footer class="footer bg-dark text-white py-5">
<div class="container">
<div class="row">
<div class="col-md-4 mb-4">
<h5><?php echo SITE_NAME; ?></h5>
<p class="text-muted">Your one-stop platform for discovering and booking amazing events.</p>
<div class="social-links">
<a href="#" class="text-white mr-3"><i class="fab fa-facebook fa-lg"></i></a>
<a href="#" class="text-white mr-3"><i class="fab fa-twitter fa-lg"></i></a>
<a href="#" class="text-white mr-3"><i class="fab fa-instagram fa-lg"></i></a>
<a href="#" class="text-white mr-3"><i class="fab fa-linkedin fa-lg"></i></a>
</div>
</div>
<div class="col-md-2 mb-4">
<h6>Quick Links</h6>
<ul class="list-unstyled">
<li><a href="about.php" class="text-muted">About Us</a></li>
<li><a href="contact.php" class="text-muted">Contact</a></li>
<li><a href="faq.php" class="text-muted">FAQ</a></li>
<li><a href="blog.php" class="text-muted">Blog</a></li>
</ul>
</div>
<div class="col-md-2 mb-4">
<h6>For Organizers</h6>
<ul class="list-unstyled">
<li><a href="organizer/register.php" class="text-muted">Become an Organizer</a></li>
<li><a href="pricing.php" class="text-muted">Pricing</a></li>
<li><a href="resources.php" class="text-muted">Resources</a></li>
<li><a href="support.php" class="text-muted">Support</a></li>
</ul>
</div>
<div class="col-md-4 mb-4">
<h6>Subscribe to Newsletter</h6>
<p class="text-muted">Get the latest events and offers</p>
<form action="subscribe.php" method="POST" class="form-inline">
<div class="input-group">
<input type="email" name="email" class="form-control" placeholder="Your email" required>
<div class="input-group-append">
<button class="btn btn-primary" type="submit">Subscribe</button>
</div>
</div>
</form>
</div>
</div>
<hr class="bg-secondary">
<div class="row">
<div class="col-md-6">
<p class="text-muted small">&copy; <?php echo date('Y'); ?> <?php echo SITE_NAME; ?>. All rights reserved.</p>
</div>
<div class="col-md-6 text-md-right">
<a href="terms.php" class="text-muted small mr-3">Terms of Service</a>
<a href="privacy.php" class="text-muted small mr-3">Privacy Policy</a>
<a href="cookies.php" class="text-muted small">Cookie Policy</a>
</div>
</div>
</div>
</footer>
<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/bootstrap.bundle.min.js"></script>
<script src="assets/js/main.js"></script>
</body>
</html>

---

How to Use This Project - Step by Step Guide

Step 1: System Requirements

• XAMPP/WAMP/MAMP (PHP 7.4+)
• MySQL 5.7+ or MariaDB 10.2+
• Web server (Apache/Nginx)
• Web browser (Chrome, Firefox, Edge)
• 2GB RAM minimum
• 1GB free disk space

Step 2: Installation Process

2.1 Download and Setup

1. Install XAMPP/WAMP

• Download from official websites
• Install with default settings
• Start Apache and MySQL services

1. Create Project Folder

   # Navigate to htdocs (XAMPP) or www (WAMP)
cd C:\xampp\htdocs\
# Create project folder
mkdir event-management-system
# Extract all files into this folder

2.2 Database Configuration

1. Open phpMyAdmin

• Navigate to http://localhost/phpmyadmin
• Login with default credentials (root, no password)

1. Create Database

• Click "New" on left sidebar
• Enter database name: event_management_system
• Choose utf8mb4_general_ci collation
• Click "Create"

1. Import Database

• Select the newly created database
• Click "Import" tab
• Choose file: database/event_management.sql
• Click "Go" to import

1. Verify Import

• Check if all tables are created (users, events, tickets, etc.)
• Default admin user should be created

2.3 Configure Project

1. Update Configuration

• Open includes/config.php
• Update database credentials if needed:

   define('DB_HOST', 'localhost');
define('DB_USER', 'root');
define('DB_PASS', ''); // Add password if set
define('DB_NAME', 'event_management_system');

2. Set Folder Permissions

   # Create upload directories
mkdir uploads
mkdir uploads/event_images
mkdir uploads/category_images
mkdir uploads/venue_images
mkdir uploads/speaker_images
mkdir uploads/sponsor_logos
mkdir uploads/tickets
mkdir uploads/temp
# Set permissions (Linux/Mac)
chmod -R 755 uploads/
chmod -R 755 assets/images/
# Windows: Right-click folders -> Properties -> Security -> Give write permissions

3. Configure Email Settings (Optional)

• Update SMTP settings in includes/config.php
• Set your email credentials for notifications

3. Configure Payment Gateways (Optional)

• Add PayPal and Stripe API keys in config
• Test with sandbox mode first

3. Configure Google Maps (Optional)

• Add Google Maps API key for venue maps
• Enable required APIs in Google Cloud Console

Step 3: Access the System

3.1 Frontend Access

• Open browser and go to: http://localhost/event-management-system/
• You should see the homepage with:
• Navigation menu
• Hero section with search
• Categories grid
• Featured events
• Upcoming events

3.2 Admin Access

• Admin login: http://localhost/event-management-system/admin/login.php
• Default credentials:
• Username: admin
• Password: Admin@123

3.3 Organizer Access

• Organizer login: http://localhost/event-management-system/organizer/login.php
• Sample credentials:
• Username: eventpro
• Password: Organizer@123

Step 4: Test User Features

4.1 User Registration

1. Click "Sign Up" in navigation
2. Fill registration form:

• Username (unique)
• Email address
• Password (min 8 characters)
• Full name (optional)

1. Submit form
2. Check email for verification link (if enabled)
3. Click verification link to activate account

4.2 User Login

1. Click "Login" in navigation
2. Enter credentials
3. Verify redirect to dashboard

4.3 Browse Events

1. Click "Browse Events" in navigation
2. View all published events
3. Use filters:

• Category
• Date range
• Location
• Price range

1. Sort by:

• Date (upcoming)
• Price (low to high)
• Popularity

4.4 Search Events

1. Use search bar on homepage
2. Enter keywords (event name, category, venue)
3. View search results
4. Apply filters to refine results

4.5 View Event Details

1. Click on any event card
2. View:

• Event images gallery
• Full description
• Date and time
• Venue with map
• Ticket types and prices
• Speakers/performers
• Schedule/sessions
• Organizer information
• Reviews and ratings

1. Save event to wishlist
2. Share on social media

4.6 Book Tickets

1. On event details page
2. Select ticket type(s)
3. Enter quantity (respecting limits)
4. Apply discount code if any
5. Review booking summary
6. Click "Book Now"
7. Choose payment method:

• Credit/Debit Card
• PayPal
• Bank Transfer (if enabled)

1. Complete payment
2. Receive confirmation email
3. Download e-tickets (PDF with QR code)

4.7 View Booked Events

1. Go to Dashboard > My Events
2. View:

• Upcoming events
• Past events
• Cancelled events

1. Download tickets again
2. Add to calendar (Google/iCal)
3. Leave reviews for attended events

4.8 Manage Profile

1. Go to Dashboard > Profile
2. Update personal information
3. Change profile picture
4. Change password
5. Manage notification settings
6. View booking history

4.9 Save Events

1. Browse events
2. Click heart icon to save
3. Go to Dashboard > Saved Events
4. View all saved events
5. Remove from saved list

4.10 Leave Reviews

1. After event ends
2. Go to My Events > Past Events
3. Click "Write Review"
4. Rate event (1-5 stars)
5. Write review comment
6. Submit review

Step 5: Test Organizer Features

5.1 Become an Organizer

1. Register as regular user
2. Go to "Become an Organizer"
3. Fill organizer application:

• Organization name
• Organization type
• Tax ID (optional)
• Website
• Bio/Description

1. Submit for approval
2. Wait for admin approval

5.2 Create an Event

1. Login as organizer
2. Go to Organizer Dashboard
3. Click "Create New Event"
4. Fill event details:

• Title (required)
• Category (required)
• Event type (Physical/Virtual/Hybrid)
• Description (required)
• Short description
• Venue (select from list or add new)
• Start and end dates (required)
• Start and end times
• Timezone
• Max attendees
• Registration deadline
• Banner image
• Gallery images
• Video URL
• Tags

1. Add ticket types:

• Name (e.g., Early Bird, VIP, Regular)
• Description
• Price
• Quantity available
• Max per order
• Sales start/end dates

1. Add schedule/sessions:

• Session title
• Description
• Speaker
• Room/Location
• Start and end time
• Capacity

1. Add speakers:

• Name
• Title/Role
• Company
• Bio
• Photo
• Social links

1. Add sponsors:

• Name
• Level (Platinum/Gold/Silver/Bronze)
• Logo
• Website

1. Set refund policy
2. Set terms and conditions
3. Submit for approval

5.3 Manage Events

1. Go to Organizer Dashboard > My Events
2. View all events with status:

• Draft
• Pending approval
• Published
• Ongoing
• Ended
• Cancelled

1. Edit event details (if allowed)
2. Cancel event (with reason)
3. Duplicate event for quick creation
4. View analytics for each event

5.4 Manage Attendees

1. Select event from list
2. Go to "Attendees" tab
3. View all registered attendees
4. Search/filter attendees
5. Export attendee list (CSV/Excel)
6. Send bulk emails to attendees
7. Check-in attendees using QR code scanner
8. View check-in statistics

5.5 Manage Tickets

1. Go to "Tickets" section
2. View ticket sales by type
3. Track available tickets
4. Generate new ticket types
5. Update ticket prices/quantities
6. View revenue reports

5.6 View Analytics

1. Go to "Analytics" dashboard
2. View:

• Total tickets sold
• Revenue
• Conversion rate
• Attendance rate
• Popular ticket types
• Daily sales chart
• Demographics
• Traffic sources

5.7 Create Discount Codes

1. Go to "Coupons" section
2. Click "Create Coupon"
3. Set:

• Code
• Discount type (% or fixed)
• Discount value
• Min order amount
• Max discount amount
• Usage limit
• Per user limit
• Valid dates

1. Activate coupon
2. Track usage

5.8 Communicate with Attendees

1. Go to "Messages" section
2. Send individual messages
3. Send bulk emails
4. View message history
5. Respond to inquiries

Step 6: Test Admin Features

6.1 Admin Dashboard

1. Login as admin
2. View dashboard statistics:

• Total users
• Total events
• Total revenue
• Active events
• Pending approvals
• Recent activity

6.2 User Management

1. Go to Admin > Users
2. View all users
3. Filter by role (User/Organizer/Admin)
4. Filter by status (Active/Suspended/Banned)
5. Edit user details
6. Suspend/activate users
7. Change user roles
8. Delete users (with caution)
9. View user activity logs

6.3 Organizer Management

1. Go to Admin > Organizers
2. View pending organizer applications
3. Approve/reject applications
4. Set commission rates per organizer
5. View organizer statistics
6. Manage organizer payouts

6.4 Event Management

1. Go to Admin > Events
2. View all events
3. Filter by status (Pending/Published/Cancelled)
4. Approve/reject new events
5. Feature/unfeature events
6. Edit event details (if needed)
7. Cancel events (with reason)
8. View event analytics
9. Handle reported events

6.5 Category Management

1. Go to Admin > Categories
2. Add new categories
3. Edit existing categories
4. Delete categories (check for events)
5. Set category icons and colors
6. Reorder categories

6.6 Venue Management

1. Go to Admin > Venues
2. Add new venues
3. Import venues from file
4. Edit venue details
5. Delete venues
6. View venue usage statistics

6.7 Transaction Management

1. Go to Admin > Transactions
2. View all payments
3. Filter by status
4. Process refunds
5. View commission earned
6. Generate financial reports
7. Export transaction data

6.8 Site Settings

1. Go to Admin > Settings
2. Configure:

• Site name and URL
• Currency settings
• Date/time format
• Commission rates
• Payment gateways
• Email settings
• Social media links
• SEO settings
• Maintenance mode
• Registration settings
• Event approval settings

6.9 Email Templates

1. Go to Admin > Email Templates
2. Edit existing templates
3. Create new templates
4. Test email delivery
5. Set template variables

6.10 Reports

1. Go to Admin > Reports
2. Generate reports:

• Sales report
• Revenue report
• User report
• Event report
• Organizer performance
• Category performance

1. Export reports (PDF/CSV/Excel)
2. Schedule automatic reports

6.11 System Logs

1. Go to Admin > System Logs
2. View activity logs
3. Filter by user/action/date
4. Export logs
5. Clear old logs

6.12 Backup

1. Go to Admin > Backup
2. Create manual backup
3. Schedule automatic backups
4. Restore from backup
5. Download backup files

Step 7: Payment Integration

7.1 Configure PayPal

1. Get PayPal API credentials
2. Set mode (sandbox/live) in config
3. Enter client ID and secret
4. Test with sandbox account

7.2 Configure Stripe

1. Get Stripe API keys
2. Set publishable and secret keys
3. Configure webhook URL
4. Test with test keys

7.3 Test Payments

1. Use sandbox/test mode
2. Test successful payments
3. Test failed payments
4. Test refunds
5. Verify email notifications

Step 8: Advanced Features

8.1 Google Maps Integration

1. Get Google Maps API key
2. Enable required APIs
3. Add key to config
4. Test venue location display
5. Test directions feature

8.2 Social Login

1. Configure Facebook App
2. Configure Google OAuth
3. Test login with social accounts
4. Handle profile data sync

8.3 QR Code Generation

1. Generate QR codes for tickets
2. Test QR code scanning
3. Implement check-in system
4. Test validation

8.4 Calendar Integration

1. Add to Google Calendar
2. Add to iCal/Outlook
3. Test reminders
4. Sync with personal calendar

8.5 Email Notifications

1. Configure SMTP
2. Test all email templates
3. Check spam filtering
4. Monitor delivery rates

Step 9: Security Configuration

9.1 Implemented Security Features

• Password hashing (MD5 - upgrade to password_hash)
• CSRF protection on forms
• SQL injection prevention
• XSS protection
• Session management
• Input validation
• File upload restrictions
• Rate limiting on API

9.2 Additional Security Measures

1. Enable HTTPS/SSL
2. Set secure session cookies
3. Implement 2FA (optional)
4. Add CAPTCHA to forms
5. Set secure file permissions
6. Regular security updates
7. Monitor failed login attempts
8. IP blocking for suspicious activity

9.3 Production Security Checklist

• [ ] Change all default passwords
• [ ] Update password hashing to bcrypt
• [ ] Enable HTTPS with valid certificate
• [ ] Set proper file permissions (755 for directories, 644 for files)
• [ ] Disable error display in production
• [ ] Enable firewall
• [ ] Set up automated backups
• [ ] Configure monitoring alerts
• [ ] Implement rate limiting
• [ ] Add security headers (CSP, X-Frame-Options, etc.)
• [ ] Regular security audits
• [ ] Keep all dependencies updated

Step 10: Performance Optimization

10.1 Database Optimization

• Add indexes to frequently queried columns
• Optimize slow queries
• Use query caching
• Regular database maintenance
• Partition large tables

10.2 Caching Strategy

• Implement Redis/Memcached for sessions
• Cache frequent queries
• Use opcache for PHP
• Browser caching for static assets
• CDN for images and CSS/JS

10.3 Image Optimization

• Compress images on upload
• Create multiple sizes (thumbnails)
• Lazy load images
• Use WebP format where supported
• Implement image CDN

10.4 Code Optimization

• Minify CSS and JavaScript
• Combine files where possible
• Use asynchronous loading
• Implement lazy loading for components
• Optimize database queries

Step 11: Deployment to Production

11.1 Server Requirements

• PHP 7.4 or higher
• MySQL 5.7 or higher
• Apache/Nginx with mod_rewrite
• SSL certificate
• 2GB RAM minimum
• 20GB storage minimum
• Redis/Memcached (optional)
• CDN account (optional)

11.2 Pre-deployment Checklist

• [ ] Update all configuration files
• [ ] Remove debug code and comments
• [ ] Minify all CSS/JS files
• [ ] Optimize all images
• [ ] Test all features in staging
• [ ] Backup database
• [ ] Prepare rollback plan
• [ ] Update .htaccess for production
• [ ] Set proper error reporting
• [ ] Configure cron jobs

11.3 Deployment Steps

1. Prepare Files

   # Create deployment package
tar -czf event-system-deploy.tar.gz \
--exclude=".git" \
--exclude="node_modules" \
--exclude="tests" \
--exclude="*.log" \
.

2. Upload to Server

• Use FTP/SFTP or Git deployment
• Upload to web root directory
• Set correct permissions

2. Database Migration

   # Export local database
mysqldump -u root -p event_management_system > event_system_backup.sql
# Import to production
mysql -u prod_user -p prod_database < event_system_backup.sql

4. Configure Environment

• Update database credentials
• Set correct file paths
• Configure email settings
• Add API keys
• Set timezone

4. Set Up Cron Jobs

   # Add to crontab
# Send event reminders
0 9 * * * php /path/to/cron/send-reminders.php
# Update event statuses
*/15 * * * * php /path/to/cron/update-event-status.php
# Clean up expired sessions
0 2 * * * php /path/to/cron/clean-sessions.php
# Generate daily reports
0 1 * * * php /path/to/cron/generate-reports.php
# Backup database
0 3 * * * php /path/to/cron/backup-database.php

6. Configure Web Server Apache .htaccess:

   RewriteEngine On
# Force HTTPS
RewriteCond %{HTTPS} off
RewriteRule ^(.*)$ https://%{HTTP_HOST}/$1 [R=301,L]
# Remove index.php
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php?/$1 [L]
# Security headers
Header set X-Content-Type-Options "nosniff"
Header set X-Frame-Options "SAMEORIGIN"
Header set X-XSS-Protection "1; mode=block"
# Cache static assets
<FilesMatch "\.(css|js|jpg|jpeg|png|gif|ico)$">
Header set Cache-Control "max-age=2592000, public"
</FilesMatch>
# Protect sensitive files
<FilesMatch "\.(sql|log|ini|bak)$">
Order allow,deny
Deny from all
</FilesMatch>
# Disable directory browsing
Options -Indexes

Nginx configuration:

   server {
listen 80;
server_name yourdomain.com;
return 301 https://$server_name$request_uri;
}
server {
listen 443 ssl http2;
server_name yourdomain.com;
root /var/www/event-management-system;
index index.php;
ssl_certificate /etc/ssl/certs/yourdomain.com.crt;
ssl_certificate_key /etc/ssl/private/yourdomain.com.key;
# Security headers
add_header X-Frame-Options "SAMEORIGIN" always;
add_header X-Content-Type-Options "nosniff" always;
add_header X-XSS-Protection "1; mode=block" always;
# Logs
access_log /var/log/nginx/event-access.log;
error_log /var/log/nginx/event-error.log;
# Static files
location /assets/ {
expires 30d;
add_header Cache-Control "public, immutable";
}
location /uploads/ {
expires 30d;
add_header Cache-Control "public, immutable";
}
# PHP handling
location ~ \.php$ {
fastcgi_pass unix:/var/run/php/php7.4-fpm.sock;
fastcgi_index index.php;
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
include fastcgi_params;
}
# Block access to hidden files
location ~ /\. {
deny all;
}
# Main location
location / {
try_files $uri $uri/ /index.php?$args;
}
}

7. Testing After Deployment

• Test all user-facing pages
• Verify database connections
• Test payment gateways
• Check email delivery
• Verify file uploads
• Test search functionality
• Check mobile responsiveness
• Verify SSL certificate
• Test all forms
• Check cron jobs are running

7. Monitoring Setup

• Set up error logging
• Configure performance monitoring
• Set up uptime monitoring
• Configure alerts for critical issues
• Monitor disk space
• Track user analytics

Step 12: Troubleshooting Common Issues

12.1 Installation Issues

Issue	Solution
Database connection error	Check credentials in config.php
404 errors	Enable mod_rewrite, check .htaccess
File upload fails	Check folder permissions, PHP upload limits
White screen	Enable error display, check error logs
Session issues	Check session save path, cookie settings

12.2 Runtime Issues

Issue	Solution
Payment not processing	Check API keys, test in sandbox
Emails not sending	Verify SMTP settings, check spam folder
Images not loading	Check file paths, permissions
Search not working	Rebuild search index, check MySQL fulltext
Slow page loads	Enable caching, optimize queries
QR codes not scanning	Check URL format, regenerate codes
Map not displaying	Verify API key, check console for errors

12.3 Common Error Messages

"Database connection failed"

• MySQL service not running
• Wrong database credentials
• Database doesn't exist

"File upload failed"

• Upload directory not writable
• File too large
• File type not allowed

"CSRF token validation failed"

• Session expired
• Form submitted from different session
• Token mismatch

"Payment failed"

• Invalid payment details
• Gateway configuration error
• Insufficient funds

Step 13: Maintenance and Updates

13.1 Regular Maintenance Tasks

• Daily: Check error logs
• Weekly: Database optimization
• Monthly: Security updates
• Quarterly: Full system audit
• Yearly: Code review and refactoring

13.2 Backup Strategy

# Database backup script
#!/bin/bash
BACKUP_DIR="/var/backups/event-system"
DATE=$(date +%Y%m%d_%H%M%S)
mysqldump -u root -p event_management_system | gzip > $BACKUP_DIR/db_$DATE.sql.gz
# Files backup
tar -czf $BACKUP_DIR/files_$DATE.tar.gz /var/www/event-management-system/uploads/
# Keep only last 30 days
find $BACKUP_DIR -type f -mtime +30 -delete

13.3 Update Process

1. Backup database and files
2. Put site in maintenance mode
3. Pull latest code changes
4. Run database migrations
5. Clear cache
6. Test functionality
7. Disable maintenance mode

13.4 Version Control

# Git workflow
git checkout -b release/v2.0
git commit -m "Version 2.0 release"
git tag -a v2.0 -m "Version 2.0"
git push origin v2.0

---

System Features Summary

For Users:

• ✅ User registration with email verification
• ✅ Social login (Google/Facebook)
• ✅ Password recovery
• ✅ Browse events by category
• ✅ Advanced search with filters
• ✅ View event details with images
• ✅ Interactive maps for venues
• ✅ Multiple ticket types
• ✅ Secure payment processing
• ✅ Download e-tickets with QR codes
• ✅ Calendar integration
• ✅ Save favorite events
• ✅ Leave reviews and ratings
• ✅ Event reminders
• ✅ Message system
• ✅ Notification center
• ✅ Profile management
• ✅ Booking history

For Organizers:

• ✅ Create and manage events
• ✅ Multiple ticket types
• ✅ Event scheduling
• ✅ Speaker and sponsor management
• ✅ Venue management
• ✅ Attendee management
• ✅ QR code check-in system
• ✅ Sales analytics
• ✅ Revenue reports
• ✅ Discount coupons
• ✅ Bulk email to attendees
• ✅ Export attendee data
• ✅ Event duplication
• ✅ Real-time statistics
• ✅ Payout management

For Admins:

• ✅ Complete dashboard
• ✅ User management
• ✅ Organizer management
• ✅ Event moderation
• ✅ Category management
• ✅ Venue management
• ✅ Transaction monitoring
• ✅ Commission management
• ✅ Site settings
• ✅ Email templates
• ✅ Report generation
• ✅ System logs
• ✅ Backup management
• ✅ Security settings

Technical Features:

• ✅ Responsive design (mobile-friendly)
• ✅ SEO optimized
• ✅ AJAX real-time updates
• ✅ QR code generation
• ✅ Payment gateway integration
• ✅ Email notifications
• ✅ Google Maps integration
• ✅ Calendar sync
• ✅ Search functionality
• ✅ Pagination
• ✅ File upload with validation
• ✅ Session management
• ✅ CSRF protection
• ✅ SQL injection prevention
• ✅ XSS protection
• ✅ Rate limiting
• ✅ Caching system
• ✅ Cron job support

---

This comprehensive Event Management System provides a complete solution for organizing and managing events of all types. The modular architecture allows for easy customization and scaling. Both user and admin interfaces are intuitive and feature-rich, making it suitable for small to large-scale event platforms. The system is production-ready with proper security measures and can be customized further based on specific requirements.