Smart Tourist Guide Final Year Project Using PHP and MySQL

• Admin login for this final year project
• Dashboard with users, trips, completed trips, places, feedback, and support query counts
• User management with search and activate/deactivate
• City CRUD with active/inactive status
• Category CRUD with active/inactive status
• Tourist place CRUD with image upload
• Place details: city, category, address, timings, entry fee, duration, rating, and budget type
• Distance matrix management for route optimization
• Trip monitoring with filters
• Mark trips as completed
• Feedback management and delete option
• Support query reply and status update
• Email logs with resend option
• Reports for popular places, selected categories, trip counts, and CSV user export
• Admin profile and password change

• User registration, login, and logout
• Profile update with photo upload and city preference
• Change password
• Create new trip with city, date, start/end time, budget, travel mode, and break duration
• Select interests/preferences
• Browse places with city, category, rating, and budget filters
• Suggested places based on selected interests
• Add places to trip itinerary
• Reorder itinerary places
• Remove places from itinerary
• Update visit duration
• Generate time-based schedule
• Optimize route using nearest-neighbor algorithm and stored distances
• View trip summary with total time, distance, and entry fees
• Email itinerary
• Download printable itinerary export
• Trip history with view, edit draft, delete, and duplicate options
• Submit feedback
• Submit support query and view admin replies

• Public landing page included in this final year project
• No Laravel, Composer, or npm required
• No external AI or Google Maps API required
• Local database-based recommendations
• Local distance-table route optimization
• Bootstrap CDN frontend
• BCRYPT password hashing
• PHP session authentication
• MySQLi prepared statements
• Printable HTML itinerary export saved to exports/
• Upload folders for profile photos and place images
• PHP mail() email support
• Demo OTP shown on-screen for password reset
• Suitable for final year project demo, viva, source code review, and report preparation

• Copy the final year project folder to your web root:

  C:\xampp\htdocs\Smart Tourist Guide V2\

• Import database:

  mysql -u root -p < database.sql

• Edit config.php:

  define('DB_HOST', 'localhost');
  define('DB_USER', 'root');
  define('DB_PASS', '');
  define('DB_NAME', 'smart_tourist_guide');

• Set BASE_URL according to your folder path.

• Run seed script once:

  http://localhost/<your-folder>/seed/seed.php

• Ensure these folders are writable:
  • uploads/profile_photos/
  • uploads/place_images/
  • exports/

• Open:

  http://localhost/<your-folder>/index.php

Admin

• Username: admin
• Password: Admin@123
• Email: [email protected]

Demo Users

• [email protected] / User@123
• [email protected] / User@123