Session 2 Routing & Database

This video explains the router and database architecture in PHPTRAVELS Version 10, focusing on how requests are handled, how data flows through the system, and why this architecture is fast, secure, and easy to maintain for large scale travel platforms.

It is intended for developers, technical founders, and teams who want a clear understanding of how PHPTRAVELS v10 is structured internally.

What you will learn in this video

Routing system overview How PHPTRAVELS v10 uses a lightweight custom routing system inspired by Laravel to handle all incoming requests through a single entry point.

Single entry architecture Every request passes through index.php, where routes are matched, handlers are executed, and responses are returned securely.

Router benefits SEO friendly URLs, clean structure, REST API readiness, URL parameter handling, better security, and easier long term maintenance.

Lightweight and dependency free router The router is a small standalone library with zero dependencies, supporting all HTTP methods and closure based callbacks.

Route definition and structure Routes are defined clearly using method based syntax and organized inside the app/routes directory for clean separation.

404 handling and error control How undefined routes are handled safely using a centralized 404 handler.

Database architecture overview PHPTRAVELS v10 uses MySQL or MariaDB with a lightweight ORM layer for fast and secure database operations.

Midu ORM framework A compact ORM inspired by Laravel that provides SQL injection protection, clean syntax, error handling, and multi database support.

Environment based configuration Database credentials are stored securely in the .env file and loaded centrally into the application.

Global database access A shared database instance is available across the system for consistent and efficient data access.

Schema overview Core tables include users, bookings, payments, content, notifications, and system logs.