Travel Booking Full-Stack Using PHP

Travel Booking System is a comprehensive web-based travel agency solution built using PHP. Designed to streamline the management of tour and travel packages, the system offers a smooth and intuitive experience for both users and administrators.Key features include real-time package browsing, secure booking functionality, user reviews, purchase validations, and automated PDF report generation. The platform supports efficient travel management while enhancing user engagement and administrative control, making it ideal for tourism businesses and academic use cases.

Key Features

For Users:

1. Account Management:
   • Unique username and email validation during sign-up.
   • Email notifications sent to users upon successful registration.
2. Tour Package Management:
   • Users can browse and search for various travel packages.
   • Purchase validation ensures:
     • No duplicate purchases of the same package.
     • Users cannot book after the package has started or if capacity is full.
   • Email confirmation upon successful package purchase.
3. Post-Purchase Actions:
   • Users can write reviews for purchased packages.
   • PDF reports of purchased packages can be generated.

For Admins:

1. User Management:
   • View and manage user accounts.
   • Toggle user activity status (Active/Inactive).
2. Package Management:
   • Add, modify, and delete travel packages.
   • Manage package details like capacity, pricing, and description.
3. Sales and Reporting:
   • View detailed sales records.
   • Generate PDF reports of sales data for analysis.

Technology Stack

• Backend: Raw PHP for scripting and server-side logic.
• Frontend: HTML, CSS, and JavaScript for dynamic and responsive interfaces.
• Database: MySQL for managing users, packages, and transactions.

Prerequisites

1. Server Setup:
   • PHP-enabled Apache server with MySQL database installed.
   • Recommended tools:
     • XAMPP
     • Laragon
2. Code Editor:
   • VS Code or PhpStorm for code editing and debugging.

File Structure

1. dbConnection.php:
   • Contains all SQL codes for database connections and queries.
2. components Folder:
   • Modular HTML components such as head.php, header.php, and footer.php.
3. Payment Gateway:
   • Uses SSL Commerz sandbox for payment processing.
   • Requires modifications in _checkout.php and success.php for proper setup.
4. Email Functionality:
   • Utilizes PHPMailer to send email notifications for user registration and package purchases.
   • Configure $mail->Username and $mail->Password with your email credentials.

How to Set Up the Project

1. Install Prerequisites:
   • Set up XAMPP or Laragon on your local system.
2. Database Configuration:
   • Import the SQL script from dbConnection.php to set up the database.
   • Update database credentials in dbConnection.php to match your environment.
3. Configure Email and Payment:
   • Update PHPMailer credentials for email notifications in success.php.
   • Configure SSL Commerz sandbox settings for payment gateway in _checkout.php.
4. Start the Server:
   • Place the project in the htdocs folder (XAMPP) or the root directory of your server.
   • Start Apache and MySQL services.
   • Navigate to http://localhost/project-folder-name.

Tips for Customization

• Theme Updates: Modify the CSS files for a personalized UI theme.
• New Features: Extend the functionality to include real-time chat between users and admins or integrate social media sharing.

Please note

• All the SQL codes are written in dbConnection.php file.
• The file structure is modular. You will get components folder containing the common HTML for all pages like head, header, and footer.
• This project uses SSL Commerz sandbox as payment gateway. Change the required code in _checkout.php and success.php to set up your sandbox. Visit SSL Commerz to know more.
• This project uses PHPMailer to send emails to user on various occasions. Change the $mail->Username and $mail->Password according your mail address to start sending emails. Checkout PHPMailer to know more.