ProjectsWeb Development
PesonaBali — Tourism Information & Tour Booking System
A full PHP-native tourism portal for Bali with a public site — destination catalog, gallery, tour guides, and online booking — plus an admin backoffice with complete CRUD, booking recap filters, and PDF report export.

My Role
- 01Designed and built the complete tourism portal from scratch: public site plus admin backoffice, as a first full website project.
- 02Modeled the relational MySQL/MariaDB schema with an ERD linking categories, destinations, tour packages, guides, and bookings.
- 03Developed the public side: interactive landing page, destination catalog with category grouping and detail modals, photo gallery, tour guide profiles, online booking form, and FAQ.
- 04Developed the admin backoffice with session-based authentication and full CRUD for categories, destinations, gallery, tour packages, and guides.
- 05Built the booking recap module with date, month, and year filters plus PDF report export using FPDF.
- 06Handled image uploads, database migrations, and the initial SQL dump for easy local setup with Laragon or XAMPP.
Features
- 01Public side: interactive landing page, destination catalog grouped by category (mountains, culture, water, waterfalls) with detail modals and ticket prices, photo gallery, licensed tour guide profiles with languages, online booking form, and FAQ.
- 02Admin backoffice protected by PHP session authentication.
- 03Full CRUD management for tourism categories, destinations (with image uploads), gallery, tour packages, and tour guides.
- 04Booking recap module with filters by date, month, and year, plus PDF report export using FPDF.
- 05Relational MySQL/MariaDB schema with an ERD linking categories, destinations, packages, guides, and bookings.
- 06Ships with an initial SQL dump and a database update script for easy local setup on Laragon or XAMPP.
Impact
- First complete website built from scratch — from database design to public pages and admin panel.
- Covers the full cycle of a booking business: content management, reservations, filtering, and reporting.
- Learned foundational full-stack skills: relational schema design, session authentication, file uploads, and PDF generation.
Stack
PHPMySQLBootstrap 5CSS3FPDFMariaDB

