<?php echo isset($title) ? htmlspecialchars($title, ENT_QUOTES, 'UTF-8') : 'Travel N Tours'; ?>

# Travel N Tours - PHP Quick setup: 1. Create a MySQL database (or update config in `src/config.php`): - Database name: `travel_n_tours` (or change in config) 2. Import schema: mysql -u root -p < migrations/schema.sql 3. Update DB credentials in `src/config.php`. 4. Start built-in PHP server from project root: php -S localhost:8000 5. Open in browser: http://localhost:8000 This small app uses PDO, simple routing via `index.php`, and plain PHP templates. -- Create database (run this or create a database manually) CREATE DATABASE IF NOT EXISTS travel_n_tours DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; USE travel_n_tours; -- Tours table CREATE TABLE IF NOT EXISTS tours ( id INT AUTO_INCREMENT PRIMARY KEY, title VARCHAR(255) NOT NULL, slug VARCHAR(255) NOT NULL UNIQUE, description TEXT NOT NULL, price DECIMAL(10,2) NOT NULL DEFAULT 0.00, duration VARCHAR(100) NOT NULL DEFAULT '1 day', available_seats INT NOT NULL DEFAULT 0, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Bookings table CREATE TABLE IF NOT EXISTS bookings ( id INT AUTO_INCREMENT PRIMARY KEY, tour_id INT NOT NULL, name VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, seats INT NOT NULL DEFAULT 1, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (tour_id) REFERENCES tours(id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Sample data INSERT INTO tours (title, slug, description, price, duration, available_seats) VALUES ('Sunset Beach Escape', 'sunset-beach-escape', 'Relax on a beautiful sunset beach with guided snorkeling and local cuisine tasting.', 199.00, '3 days', 20), ('Mountain Hiking Adventure', 'mountain-hiking-adventure', 'A challenging yet rewarding hiking experience through scenic mountain trails.', 299.00, '4 days', 15), ('City Cultural Tour', 'city-cultural-tour', 'Explore historic landmarks, museums, and local markets with an expert guide.', 99.00, '1 day', 50); /* Simple styles */ body { font-family: Arial, Helvetica, sans-serif; margin: 0; padding: 0; background: #f7f7f7; color: #333; } .container { width: 92%; max-width: 980px; margin: 24px auto; background: #fff; padding: 20px; box-shadow: 0 1px 6px rgba(0,0,0,0.08); border-radius: 6px; } header { margin-bottom: 18px; } h1 { margin: 0 0 6px 0; } .tour { border-bottom: 1px solid #eee; padding: 12px 0; } .tour:last-child { border-bottom: none; } .tour h2 { margin: 0; font-size: 1.1rem; } .tour .meta { color: #666; font-size: 0.9rem; margin-top: 6px; } a.button { display: inline-block; padding: 8px 12px; background: #007bff; color: #fff; text-decoration: none; border-radius: 4px; } form label { display: block; margin-top: 8px; font-weight: bold; } input[type="text"], input[type="email"], input[type="number"], textarea { width: 100%; padding: 8px; border: 1px solid #ddd; border-radius: 4px; box-sizing: border-box; } input[type="submit"] { margin-top: 12px; padding: 10px 14px; background: #28a745; color: #fff; border: none; border-radius: 4px; cursor: pointer; } .notice { padding: 10px; background: #e9ffe6; border: 1px solid #c8f7cc; margin-bottom: 12px; } [ 'driver' => 'mysql', // mysql or sqlite 'host' => '127.0.0.1', 'port' => '3306', 'database' => 'travel_n_tours', 'username' => 'root', 'password' => '', 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', ], ]; pdo = new PDO($dsn); $this->pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); return; } $host = $config['host'] ?? '127.0.0.1'; $port = $config['port'] ?? '3306'; $db = $config['database'] ?? ''; $charset = $config['charset'] ?? 'utf8mb4'; $user = $config['username'] ?? 'root'; $pass = $config['password'] ?? ''; $dsn = "mysql:host={$host};port={$port};dbname={$db};charset={$charset}"; try { $this->pdo = new PDO($dsn, $user, $pass, [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, ]); } catch (PDOException $e) { // Rethrow for caller to handle; do not expose credentials throw $e; } } public static function getInstance(array $config = []): Database { if (self::$instance === null) { self::$instance = new self($config); } return self::$instance; } public function getPdo(): PDO { return $this->pdo; } } pdo = Database::getInstance(require __DIR__ . '/../config.php')['db'] ? Database::getInstance(require __DIR__ . '/../config.php')->getPdo() : Database::getInstance(require __DIR__ . '/../config.php')->getPdo(); } /** * Get all tours * * @return array */ public function getAll(): array { $stmt = $this->pdo->query('SELECT id, title, slug, description, price, duration, available_seats FROM tours ORDER BY created_at DESC'); return $stmt->fetchAll(); } /** * Get a single tour by ID * * @param int $id * @return array|null */ public function getById(int $id): ?array { $stmt = $this->pdo->prepare('SELECT id, title, slug, description, price, duration, available_seats FROM tours WHERE id = :id LIMIT 1'); $stmt->execute([':id' => $id]); $row = $stmt->fetch(); return $row === false ? null : $row; } /** * Reduce available seats atomically * * @param int $tourId * @param int $seats * @return bool */ public function reduceSeats(int $tourId, int $seats): bool { $stmt = $this->pdo->prepare('UPDATE tours SET available_seats = available_seats - :seats WHERE id = :id AND available_seats >= :seats'); return $stmt->execute([':seats' => $seats, ':id' => $tourId]) && $stmt->rowCount() > 0; } } pdo = Database::getInstance(require __DIR__ . '/../config.php')->getPdo(); } /** * Create a booking inside a transaction and reduce seats * * @param int $tourId * @param string $name * @param string $email * @param int $seats * @return bool */ public function create(int $tourId, string $name, string $email, int $seats): bool { try { $this->pdo->beginTransaction(); // Reduce seats $stmt = $this->pdo->prepare('UPDATE tours SET available_seats = available_seats - :seats WHERE id = :id AND available_seats >= :seats'); $stmt->execute([':seats' => $seats, ':id' => $tourId]); if ($stmt->rowCount() === 0) { $this->pdo->rollBack(); return false; } // Insert booking $insert = $this->pdo->prepare('INSERT INTO bookings (tour_id, name, email, seats) VALUES (:tour_id, :name, :email, :seats)'); $insert->execute([ ':tour_id' => $tourId, ':name' => $name, ':email' => $email, ':seats' => $seats, ]); $this->pdo->commit(); return true; } catch (PDOException $e) { if ($this->pdo->inTransaction()) { $this->pdo->rollBack(); } return false; } } } tourModel = new Tour(); } /** * Render home (list of tours) * * @return void */ public function index(): void { $tours = $this->tourModel->getAll(); require __DIR__ . '/../../templates/home.php'; } /** * Render single tour * * @param int $id * @return void */ public function show(int $id): void { $tour = $this->tourModel->getById($id); if ($tour === null) { http_response_code(404); echo 'Tour not found'; return; } require __DIR__ . '/../../templates/tour.php'; } } bookingModel = new Booking(); $this->tourModel = new Tour(); } /** * Handle booking form submission * * @return void */ public function create(): void { $tourId = isset($_POST['tour_id']) ? (int) $_POST['tour_id'] : 0; $name = trim((string) ($_POST['name'] ?? '')); $email = trim((string) ($_POST['email'] ?? '')); $seats = isset($_POST['seats']) ? (int) $_POST['seats'] : 1; $errors = []; if ($tourId <= 0) { $errors[] = 'Invalid tour selected.'; } if ($name === '') { $errors[] = 'Name is required.'; } if ($email === '' || !filter_var($email, FILTER_VALIDATE_EMAIL)) { $errors[] = 'A valid email is required.'; } if ($seats <= 0) { $errors[] = 'At least one seat must be booked.'; } $tour = $this->tourModel->getById($tourId); if ($tour === null) { $errors[] = 'Tour not found.'; } elseif ($seats > (int) $tour['available_seats']) { $errors[] = 'Not enough seats available.'; } if (!empty($errors)) { // Re-render tour page with errors $errorMessages = $errors; require __DIR__ . '/../../templates/tour.php'; return; } $success = $this->bookingModel->create($tourId, $name, $email, $seats); if ($success) { require __DIR__ . '/../../templates/bookings.php'; return; } $errorMessages = ['Booking failed. Please try again.']; require __DIR__ . '/../../templates/tour.php'; } } index(); exit; } if ($route === 'tour') { $id = isset($_GET['id']) ? (int) $_GET['id'] : 0; $controller = new TourController(); $controller->show($id); exit; } if ($route === 'book' && $_SERVER['REQUEST_METHOD'] === 'POST') { $controller = new BookingController(); $controller->create(); exit; } // 404 fallback http_response_code(404); echo 'Page not found'; <?php echo isset($title) ? htmlspecialchars($title, ENT_QUOTES, 'UTF-8') : 'Travel N Tours'; ?>

Explore great tours and book your next adventure.

Duration: | Price: $ | Seats:

View & Book

No tours available.

Duration: | Price: $ | Seats available:

Book this tour

← Back to tours

Thank you! Your booking has been received. A confirmation email will be sent to you shortly.

Back to tours