Smart Tourist Guide Final Year PHP Project

• Admin login for this final year project
• Admin dashboard with total users, trips, and cached places
• Latest trips table with traveller name and place count
• Interest category management
• Category display name management
• api_kind mapping for OSM/Overpass place discovery
• Mood keyword management for planner matching
• User catalogue with name, email, trip count, and join date
• Trip overview with city, owner, pace, place count, and created time
• Admin logout

• Traveller registration and login
• Optional email verification when SMTP is configured
• Resend verification email
• Remember-me login support
• Traveller dashboard with trip count and recent trips
• Profile update with display name and mobile
• Password change with old password verification
• Smart trip planner with popular city or custom city input
• Start location from city center, GPS, or manual address
• Interest category selection
• Mood text converted into category matches using keywords
• Budget level and optional ₹ budget amount
• Pace selection and max places slider
• Avoid long travel option
• Smart POI discovery from OpenStreetMap/Overpass
• Time-based itinerary generation
• Interactive Leaflet map with markers and route polyline
• Place details page for each trip stop
• Google Maps navigation links
• Email itinerary option
• Shareable read-only itinerary link
• Rotate share link to revoke old URL
• My Trips listing and delete option

• Public landing page included in this final year project
• OpenStreetMap / Nominatim / Overpass integration
• Optional OpenRouteService matrix routing
• Haversine fallback when routing API is unavailable
• TSP dynamic programming for small route sets
• Nearest-neighbor fallback for larger routes
• Feasibility logic that drops low-scoring stops if the trip exceeds available time
• Places cache using places_master
• Persisted trip preferences, route, places, and schedule JSON
• Leaflet map visualization
• SMTP itinerary email or PHP mail() fallback
• Separate admin and traveller sessions
• Bcrypt password hashing
• PDO prepared statements
• Share token based public itinerary view
• Suitable for final year project demo, viva, source code review, and report preparation

1. Create a MySQL database:

   CREATE DATABASE smart_tourist_guide CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

2. Import schema and seed data:

   mysql -u root -p smart_tourist_guide < database.sql

3. For older installs, apply migration:

   mysql -u root -p smart_tourist_guide < database_migration_2026_features.sql

4. Edit config.php:
   • DB_HOST
   • DB_NAME
   • DB_USER
   • DB_PASS
   • BASE_URL
   • optional OPENROUTESERVICE_API_KEY
   • optional SMTP constants

5. Run locally:

   php -S localhost:8000

6. Open:
   http://localhost:8000/
7. Set BASE_URL to:
   http://localhost:8000/

Admin

• Email: [email protected]
• Suggested password: admin123

Travellers

• [email protected] / suggested password alice123
• [email protected] / suggested password bob123