Скачать или смотреть Episode 03 | Create Databse Tables & Relationships (Hindi) | PHP Tour & Travel Booking System

Welcome to Episode 03 of our PHP Travel Booking System Tutorial Series in Hindi! 🇮🇳
In this episode, we will design and create the complete MySQL database required for our Tour & Travel Booking Website.

You’ll learn how to set up database tables for users, bookings, packages, passengers, billing details, messages, and package variations — with a clean relational structure.

By the end of this video, you’ll have a fully designed database connected to PHP, ready for all upcoming modules such as authentication, admin panel, package management, SCSS, Gulp automation, and more.

🔧 What You’ll Learn in This Episode

✅ Create and manage Git branches for better workflow
✅ Create MySQL database inside AMMPS
✅ Set up database connection file in PHP
✅ Design complete database table structure
✅ Create all core tables for the Travel Booking System:
-- Users
-- Packages
-- Bookings
-- Booking Passengers
-- Billing Details
-- Messages
-- Package Variations

🕒 Timestamps

00:00 – Introduction
02:50 – Git Branch Creation
07:55 – Creating the Database
09:30 – Database Connection Setup
13:15 – Database Tables Structure Overview
17:26 – Creating Users Table
22:55 – Creating Packages Table
28:10 – Creating Bookings Table
31:30 – Creating Booking Passengers Table
34:25 – Creating Billing Details Table
39:00 – Creating Messages Table
41:00 – Creating Package Variations Table
41:50 – Conclusion

🧱 Tutorial Playlist / Modules

Module 1: Setup & Introduction
Module 2: Database Design
Module 3: SCSS + Gulp Automation
Module 4: User Authentication
Module 5: Travel Packages
Module 6: Bookings & Payments
Module 7: Admin Dashboard
Module 8: Search, Filters, Pagination
Module 9: Security & Optimization
Module 10: Hosting & Final Review

🧰 Technologies Used

PHP 8.2+ (Core PHP, no framework)
MySQL Database
HTML5 + SCSS + Bootstrap 5
Gulp (for SCSS automation and live reload)
PHPMailer (for contact form)
XAMPP / WAMP / AMMPS
VS Code as code editor

📁 Download Source Code

🔗 GitHub Repository – https://github.com/crazymodifier/tour...

🚀 Next Episode

➡️ Episode 04 – Gulp Setup & Folder Structure for SCSS and JS

💬 Support the Channel

If this video helped you:
👍 Like — motivates me to make more tutorials
💬 Comment your questions — I reply to everyone!
🔔 Subscribe — stay updated with all future episodes

🏷️ SEO Tags / Hashtags

#PHPProject #TourAndTravelWebsite #TravelBookingSystem #PHPMySQL #WebDevelopment #PHPHindiTutorial #FullStackDevelopment #BookingSystem #PHPProjectForBeginners #TourAndTravelSystem #WebAppDevelopment #CorePHP #PHPProjectHindi #LearnPHP #CodingForBeginners #TravelWebsitePHP